[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: postfix + mysql



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: pgpNq5jtF0y3z.pgp
Description: PGP signature


Reply to: