Re: bind-address question

[Frank]

Andrew wrote:

> Hi Everyone,
> 
> I have been searching around for a while, but have had no luck as yet
> for this question.
> 
> I am running debian with mysql 4.x on a x86 box. (2.6 series kernel).
> 
> Anyhow, up until now, I have had a single bind-address option passed,
> however I need to add another address (so it binds to two, but not all
> available addresses) - how can I do this in the my.cnf file?
> 
> 
> 
> Thanks,
> 
> ANdrew.

Hi Andrew,

judging by a quick look at the source of 5.0.18, I would say, that this is
not possible. You can either bind to one or all addresses.

Cheers
Frank

see sql/mysqld.cc:

 case (int) OPT_BIND_ADDRESS:
if ((my_bind_addr= (ulong) inet_addr(argument)) == INADDR_NONE)
{
  struct hostent *ent;
  if (argument[0])
ent=gethostbyname(argument);
  else
  {
char myhostname[255];
if (gethostname(myhostname,sizeof(myhostname)) < 0)
{
  sql_perror("Can't start server: cannot get my own hostname!");
  exit(1);
}
ent=gethostbyname(myhostname);
  }
  if (!ent)
  {
sql_perror("Can't start server: cannot resolve hostname!");
exit(1);
  }
  my_bind_addr = (ulong) ((in_addr*)ent->h_addr_list[0])->s_addr;
}
break;



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bind-address question

[Andrew]

Hi Everyone,

I have been searching around for a while, but have had no luck as yet 
for this question.


I am running debian with mysql 4.x on a x86 box. (2.6 series kernel).

Anyhow, up until now, I have had a single bind-address option passed, 
however I need to add another address (so it binds to two, but not all 
available addresses) - how can I do this in the my.cnf file?




Thanks,

ANdrew.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: bind-address question

[Gleb Paharenko]

Hello.



Systems call bind() calls only one time for IP socket and one time

for socket file (from sql/mysqld.cc). So you can specify only one IP

address. Use firewall to suppress undesirable connections.





Cere Davis <[EMAIL PROTECTED]> wrote:

> Hi everyone,

> 

> I would like to bind mysqld  to more than one IP address (localhost and my

> private unrouted interface).  Is there a way to get --bind-address to bind

> to more than one IP?  I have been unsucessfull when trying comma/space

> delimited arguments to bind-address, etc.

> 

> Thanks,

> -Cere

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bind-address question

[Cere Davis]

Hi everyone,

I would like to bind mysqld  to more than one IP address (localhost and my
private unrouted interface).  Is there a way to get --bind-address to bind
to more than one IP?  I have been unsucessfull when trying comma/space
delimited arguments to bind-address, etc.

Thanks,
-Cere


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]