Re: postfix + mysql

From: Pim Bliek (pim.bliek_at_gmail.com)
Date: 07/10/04

  • Next message: Alex Malinovich: "Re: About emacs" 
    Date: Sat, 10 Jul 2004 09:07:46 +0200
To: debian-user@lists.debian.org

    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.
    >
    >
    > 

    -- 
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Alex Malinovich: "Re: About emacs"

    Relevant Pages