Re: bind-address by name under 5.0.18

2006-02-28 Thread James Long
>6752 exit(1); >6753} >6754my_bind_addr = (ulong) > ((in_addr*)ent->h_addr_list[0])->s_addr; >6755 } >6756 break; > > > > And with other DBs, I can set 'sql.example.com' to resolve to N > > IPs (N=4 in this example): > > > > 10.0.0.10 > > 1

Re: bind-address by name under 5.0.18

2006-02-28 Thread Jeremy Cole
Hi James, Sort of. If I run the command manually, it does. But my script uses su to run the server as an unprivileged user. What happens if you: su -m mysql -c 'sh -c "/usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/va

Re: bind-address by name under 5.0.18

2006-02-27 Thread James Long
> Hi, > > > Thank you very much! I'm willing to help test if you can provide me a diff > > of your changes. > > Well, that was easy. I checked the code, and it turns out that the > functionality is already there. I just tested it on my laptop (running > 5.0.13) and it does indeed work. > >

Re: bind-address by name under 5.0.18

2006-02-27 Thread Jeremy Cole
Hi, Thank you very much! I'm willing to help test if you can provide me a diff of your changes. Well, that was easy. I checked the code, and it turns out that the functionality is already there. I just tested it on my laptop (running 5.0.13) and it does indeed work. I did: * echo "10.0

Re: bind-address by name under 5.0.18

2006-02-27 Thread James Long
> Hi James, > > >>> I would like to be able to bind to a host name, rather than > >>> an IP number. IP numbers come and go, and are beyond the > >>> control of anyone who doesn't have their own direct allocation. > >>> But since I own my domain, a host name is more permanent. > >> Adding this f

Re: bind-address by name under 5.0.18

2006-02-27 Thread Jeremy Cole
Hi James, I would like to be able to bind to a host name, rather than an IP number. IP numbers come and go, and are beyond the control of anyone who doesn't have their own direct allocation. But since I own my domain, a host name is more permanent. Adding this functionality is fairly trivia

Re: bind-address by name under 5.0.18

2006-02-27 Thread James Long
> Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just > normally not available for reference until you bind your socket library to > at least one socket. Again, it's a cart and horse thing. You see, the > etc/hosts file counts as a "local" DNS server and the DNS protocol > re

Re: bind-address by name under 5.0.18

2006-02-27 Thread SGreen
Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just normally not available for reference until you bind your socket library to at least one socket. Again, it's a cart and horse thing. You see, the etc/hosts file counts as a "local" DNS server and the DNS protocol requires a s

Re: bind-address by name under 5.0.18

2006-02-27 Thread James Long
You seem to be unaware of /etc/hosts. > Yes, there is a very good, not so technical reason to only allow binding > by IP Address. Have you ever heard of "putting the cart before the horse" > ? > > If binding by hostname were allowed, that would mean that every time your > MySQL server started

Re: bind-address by name under 5.0.18

2006-02-27 Thread SGreen
Yes, there is a very good, not so technical reason to only allow binding by IP Address. Have you ever heard of "putting the cart before the horse" ? If binding by hostname were allowed, that would mean that every time your MySQL server started up, it would need to somehow resolve that name int

Re: bind-address by name under 5.0.18

2006-02-27 Thread James Long
> It doesn't allow to bind to a hostname. According to > > http://dev.mysql.com/doc/refman/5.0/en/server-options.html > > you have to specify an IP address, not a hostname. > > -Sheeri Thanks for your reply. Yes, I am aware of that, as stated in my question. Wouldn't it be an improvement if

Re: bind-address by name under 5.0.18

2006-02-27 Thread sheeri kritzer
It doesn't allow to bind to a hostname. According to http://dev.mysql.com/doc/refman/5.0/en/server-options.html you have to specify an IP address, not a hostname. -Sheeri On 2/22/06, James Long <[EMAIL PROTECTED]> wrote: > I would like to be able to bind to a host name, rather than > an IP num

bind-address by name under 5.0.18

2006-02-22 Thread James Long
I would like to be able to bind to a host name, rather than an IP number. IP numbers come and go, and are beyond the control of anyone who doesn't have their own direct allocation. But since I own my domain, a host name is more permanent. When the time comes to change IP numbers, I want to just