I followed this guide: http://www.howtoforge.com/virtual_po..._quota_courier
I reached the end of page 2, but the command "telnet localhost pop3" failed, so I went to check why.
I found the following in my logs:
Sep 10 02:32:40 server postfix/cleanup: warning: connect to mysql server unix:/var/run/mysqld/mysqld.sock: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
server:/etc/postfix# mysql -u mail_admin -p --socket=/var/run/mysqld/mysqld.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28 to server version: 4.0.24_Debian-10sarge2-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
All of my config files are the defaults (except for changing the hosts =, since I only access the server via local socket) e.g.:
server:/etc/postfix# cat mysql-virtual_forwardings.cf
user = mail_admin
password = mail_admin_password
dbname = mail
table = forwardings
select_field = destination
where_field = source
hosts = unix:/var/run/mysqld/mysqld.sock
I can connect via the command-line mysql client and via PHP/Perl with the same socket/user/pass, why isn't Postfix working?
(P.S. this is the first time I've ever encountered a problem with one of your articles. Keep up the good work.