Re: postfix + mysql

[Pim Bliek <pim.bliek@gmail.com>]

Doesn't help.

On Fri, 9 Jul 2004 20:48:04 -0500, Jacob S. <stormspotter@6texans.net> wrote:
> 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.
> 
> 
>