HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   HOWTO-Related Questions (
-   -   Quick question about Postfix + MySQL (

asterix 10th September 2006 10:45

Quick question about Postfix + MySQL

I followed this guide:

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[22630]: 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
Enter password:
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
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. :))

asterix 10th September 2006 11:22

Little note I forgot to mention:

My current setup DOES work if I allow MySQL access from localhost via:

iptables -I INPUT 1 -p tcp -s --destination-port 3306 -j ACCEPT

I would like to use it over a socket though!

asterix 10th September 2006 21:33

Still haven't resolved my socket syntax issue, but I have a more pressing concern atm:


Sep 10 13:21:28 server imaplogin: LOGIN,, ip=[::ffff:], protocol=IMAP
Sep 10 13:22:04 server imaplogin: LOGOUT,, ip=[::ffff:], headers=445, body=0, time=36

I have Squirrelmail up and running correctly, but it's taking almost 40 SECONDS to switch between pages in its interface.

Why on EARTH would it take 40 seconds to query a local imap server?

falko 11th September 2006 14:32

Please use instead of the MySQL socket, and also switch off your firewall for now.

asterix 11th September 2006 22:10

Ok, I am using (although socket would be preferred... and faster), and everything seems to work ok.

Aside from viewing the Squirrelmail interface, which takes between 15 and 45 seconds to load a page. Any ideas?

falko 12th September 2006 17:45


Originally Posted by asterix
Aside from viewing the Squirrelmail interface, which takes between 15 and 45 seconds to load a page. Any ideas?

Any errors in your mail log and in Apache's error log?

All times are GMT +2. The time now is 15:35.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.