Doesn't help. On Fri, 9 Jul 2004 20:48:04 -0500, Jacob S. <[EMAIL PROTECTED]> wrote: > On Sat, 10 Jul 2004 01:14:09 +0200 > Pim Bliek <[EMAIL PROTECTED]> 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=<[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 > <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 > [EMAIL PROTECTED]; > > HTH, > Jacob > > -- > GnuPG Key: 1024D/16377135 > > Random .signature #24: > Some software money can't buy. For everything else there's Micros~1. > > >
-- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
