Which interface for sql connection?

[Mark Martinec]

Peter,

> yesterday I had a very weird phenomenon. I activated a new 
> network interface, which happened to be eth0.
> 
> After that amavisd didn't work anymore, because the user 
> amavis at newIPadress was not allowed to connect to the mysqlDB.
> 
> I was suprised to see that amavis does not try to connect to the DB via 
> 127.0.0.1
> 
> Is there something wrong with my setup, or is there a place where I can 
> define which IPaddress (it's all running on the same server, which happens 
> to have 3 network interfaces) the daemon uses to connect to the DB?

How are your @lookup_sql_dsn and/or @storage_sql_dsn defined?

The host name (or its IP address) declared there (as part of a data set name)
usually also determines the source IP address, but the exact logic is left
for the kernel or a TCP/IP stack to decide. If the specified host is 127.0.0.1
or 'localhost' or '::1', it is most likely the source IP address will also 
belong to a loopback interface.

Currently there is no way in DBI->connect() to force a source IP address,
but there is rarely any need for that.

  Mark