Which interface for sql connection?
Mark.Martinec+amavis at ijs.si
Tue Sep 20 17:48:28 CEST 2011
> 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
> 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.
More information about the amavis-users