[Dovecot] mysql authentication problems

[Pedro Vieira]

But I did it, and I still get the same error... :(

where goes my dovecot-mysql.conf:

###################################
db_host = localhost
db_port = 3306
#db_unix_socket = /var/run/mysqld/mysql.sock
db = mydovecotdb
db_user = mydovecotuser
db_passwd = mydbpasswd
db_client_flags = 0

default_pass_scheme = PLAIN
password_query = SELECT password FROM users WHERE userid = '%u'
user_query = SELECT home, uid, gid FROM users WHERE userid = '%u'

######################################



Jon Baker wrote:
> You need to change the db_unix_socket line to 
> reference /var/run/mysqld/mysqld.sock in your dovecot mysql conf file, 
> not just comment it out.  Be sure to restart dovecot when you make the 
> change as well.
>
> On Apr 27, 2006, at 9:07 AM, Pedro Vieira wrote:
>
>> 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
>