Which interface for sql connection?

[Peter Hütmannsberger]

Thank you, I do realise that. I would like to know, why it used a different IP address after activating the new network interface. 

Thanks again.

.peter

On 19.09.2011, at 13:28, Florin Portase <portase.florin at medianetork.ro> wrote:

> If you want to allow user amavis to connect from any IPs do
> 
> drop user amavis;
> grant all privileges on database.* to 'amavis'@'%' identified by 'password2122'
> flush privileges;
> 
> On Tue, 20 Sep 2011 10:32:17 +0200 (CEST), Peter Huetmannsberger wrote:
>> Hello,
>> 
>> 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?
>> 
>> Any help would be appreciated,
>> 
>> Thanks,
>> .peter
>