try this.. change the location for mysqld.sock location under [mysqld] and [mysqld_safe] (in /etc/mysql/my.cnf) to /var/spool/postfix/var/run/mysqld/mysqld.sock .. ln /var/spool/postfix/var/run/mysqld/mysqld.sock to /var/run/mysqld/ ... your going to have to create /var/run/mysqld in /var/spool/postfix and make sure ownership's right. restart mysql.
as i understand it, postfix cant access mysqld.sock since it doesn't live in the postfix chroot. ~august * Pim Bliek <[EMAIL PROTECTED]> |__ Sat, Jul 10, 2004 at 01:14:09AM +0200: > 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=<[EMAIL PROTECTED]>, 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 [EMAIL PROTECTED] > 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 > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] -- August MacBeth System Administrator HiP Design 824 N. Victory Blvd Suite 2A Burbank, CA 91502 http://www.hipdesign.com -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
