[Dovecot] mysql authentication problems

[Pedro Vieira]

Hi,

Thanks for your reply :)

Yes, I'm susing both Debian and dovecot 0.99.14

I tried to connect using  tcp and the authentication stills fails.
With the db_unix_socket line comented I still get this error on my mail 
logfile

dovecot-auth: MySQL: Can't connect to database dovecot: Can't connect to local MySQL server through socket '/var/tmp/mysql.sock'

I checked /etc/mysql/my.cnf and the path is correct: /var/run/mysqld/mysqld.sock.


Any ideias? :(

Thanks,

Pedro



Dumitru Negara wrote:
> Hi,
>
> If you are on Debian Sarge with dovecot 0.99.14, example in 
> configuration file dovecot-mysql.conf indeed points to 
> /var/tmp/mysql.sock
> db_unix_socket = /var/tmp/mysql.sock
>
> But on Debian MySQL socket is created as /var/run/mysqld/mysqld.sock
>
> I suppose you can change to:
> db_unix_socket = /var/run/mysqld/mysqld.sock or
>
> use TCP connection to MySQL instead of socket:
> db_host = localhost
> db_port = 3306
>
> I hope this helps.
>
> Regards,
> Dumitru
>
> Jon Baker wrote:
>> That means that mysqld is not running or dovecot is looking in the 
>> wrong place for it.  Can you get to mysql from the command line?  If 
>> so, you'll need to figure out where mysql.sock is located (look in 
>> /etc/my.cnf) and then point dovecot to it.  If you can't run mysql 
>> from the command line then the daemon is not running and you will 
>> need to start it.
>>
>> - Jon
>>
>> On Apr 26, 2006, at 4:01 PM, Pedro Vieira wrote:
>>
>>> Hello all..
>>>
>>>
>>>
>>> I'm trying to configure dovecot do athenticate using mysql, but I?m 
>>> having some troubles...
>>>
>>> After configuring the mysql athentication in dovecot-mysql.conf and 
>>> in dovecot.conf, when I try to login I get this mesage in my logs:
>>>
>>>
>>> Dovecot-auth: MySQL: Can't connect to database dovecot: Can't 
>>> connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)
>>>
>>>
>>>
>>>
>>> Any ideia why this happens and how to fix it?
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>>
>>>
>>> Pedro
>>>
>>
>
>