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
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
10.0.1.10
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
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 it
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 into
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 up, it
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
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
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
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
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
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:
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
13 matches
Mail list logo
