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