On Sat, 10 Jul 2004 01:14:09 +0200 Pim Bliek <pim.bliek@gmail.com> wrote: <snip> > 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 <snip> I had a problem very similar to this recently, trying to get java talking to mysql properly. It turned out that even though I had the login setup properly, I hadn't given it permissions on the right table. Have you tried giving mysql a "USE tablename" command after you login as postfix? You might try something like the following lines in the mysql monitor, when logged in as mysql root: grant CREATE, INSERT, SELECT, DELETE, UPDATE on tablename.* to username; grant CREATE, INSERT, SELECT, DELETE, UPDATE on tablename.* to username@localhost; HTH, Jacob -- GnuPG Key: 1024D/16377135 Random .signature #24: Some software money can't buy. For everything else there's Micros~1.
Attachment:
pgpNG0WamRYAx.pgp
Description: PGP signature