postfix + mysql
Hi everybody,
I am struggling with this one for hours now. Google doesn't help me
anymore. I feel like I want to tear the hair out of my head. Maybe
someone might be able to help on this one.
I am trying to setup Postfix + MySQL, according to lots of HOWTO's,
but most closely according to this one because I'd like to use
webbased Postfix admin: http://www.high5.net/howto/
Anyway, all is in place. Databse is up. Postfix admin PHP stuff
connects to MySQL and works. I can login to MySQL from the shell. All
config files are there, in place, etc.
But, when I start postfix I get this in my logs:
Jul 10 00:38:01 srv1 postfix/master[32687]: daemon started -- version 2.1.3
Jul 10 00:38:01 srv1 postfix/qmgr[32691]: B1D3931313:
from=<noreply@srv1.mydomain.tld>, size=333, nrcpt=1 (queue active)
Jul 10 00:38:01 srv1 postfix/pickup[32690]: 1A6B73131D: uid=0 from=<root>
Jul 10 00:38:01 srv1 postfix/cleanup[32692]: 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)
Jul 10 00:38:01 srv1 postfix/cleanup[32692]: warning: 1A6B73131D:
virtual_alias_maps map lookup problem for root@mydomain.tld
Jul 10 00:38:01 srv1 postfix/pickup[32690]: warning:
maildrop/80A2831319: Error writing message file
But, when I try to connect via commandline using this same socket it works
:
srv1:/var/log/mysql# mysql -S /var/run/mysqld/mysqld.sock -u postfix -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 320 to server version: 4.0.20-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Versions used:
ii postfix 2.1.3-0.backpo A high-performance mail transport agent
ii postfix-doc 2.1.3-0.backpo Postfix documentation
ii postfix-mysql 2.1.3-0.backpo MYSQL map support for Postfix
ii postfix-tls 2.1.3-0.backpo TLS and SASL support for Postfix
ii libdbd-mysql-p 1.2216-2 mySQL database interface for Perl
ii libmysqlclient 4.0.20-0.dotde mysql database development files
ii libmysqlclient 3.23.49-8.6 mysql database client library
ii libmysqlclient 4.0.20-0.dotde mysql database client library
ii libpam-mysql 0.4.7-1 PAM module allowing authentication from a My
ii mysql-client 4.0.20-0.dotde mysql database client binaries
ii mysql-common 4.0.20-0.dotde mysql database common files (e.g. /etc/mysql
ii mysql-server 4.0.20-0.dotde mysql database server binaries
ii php4-mysql 4.3.7-1.dotdeb MySQL module for php4
ii postfix-mysql 2.1.3-0.backpo MYSQL map support for Postfix
Got the backports from backports.org ad dotdebs.org for Woody. Maybe
this is an ugly mix? If someone knows a consistent backport source for
postfix + mysql + courier-imap + maildrop (including mysql suppot, I
built my own from source) I will be more than happy.
I am totally lost. Anyone with bright idea's? If you live close to
Amsterdam I will get you a round of beer :) LOL. Damn, I need a beer
myself after this stuff. Or maybe just sleep.
Best regards,
Pim
Reply to: