Hi, I have a problem with postfix and mysql. Postfix is not able to connect to mysql. The error is postfix/cleanup[9788]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' but mysqld.sock exists srwxrwxrwx 1 mysql mysql 0 Oct 17 10:20 /var/run/mysqld/mysqld.sock and when I try to connect like mysql -u mail_admin -p -S /var/run/mysqld/mysqld.sock everything works. what could be the problem? greetings webbies
Your Postfix is probably running chrooted, that's why it can't access the socket. Try to connect to MySQL on 127.0.0.1 instead, as shown in this tutorial: http://www.howtoforge.com/virtual_users_and_domains_with_postfix_debian_etch