[Dovecot] mysql authentication problems

[Dumitru Negara]

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
>>
>