postfix - MySQL connection problem

Discussion in 'Installation/Configuration' started by epo, Mar 13, 2006.

  1. epo

    epo New Member

    Hello y'all,

    I'm having some trouble getting postfix to work with mysql. I started out
    using the tutorial at http://workaround.org/articles/ispmail-sarge/.
    To test the MySQL connection I tried:
    postmap -v -q "test" mysql:/etc/postfix/mysql-virtual-forwardings.cf
    Output:
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: user = postfix
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: password = xxx
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: dbname =
    provider
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: table =
    forwardings
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf:
    select_field = destination
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: where_field
    = source
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf:
    additional_conditions =
    postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: hosts =
    127.0.0.1
    postmap: mysqlname_parse: /etc/postfix/mysql-virtual-forwardings.cf: adding
    host '127.0.0.1' to list of mysql server hosts
    postmap: dict_open: mysql:/etc/postfix/mysql-virtual-forwardings.cf
    postmap: dict_mysql_lookup using sql query: select destination from
    forwardings where source = 'test'
    postmap: dict_mysql_get_active: attempting to connect to host 127.0.0.1
    postmap: warning: connect to mysql server 127.0.0.1: Lost connection to
    MySQL server during query

    I've switched on logging on my mysql server, but no relevant logs show up.
    I was surprised that postmap indicates a connection has been made (although
    lost shortly after), but mysql doesn't seem to have recieved (or logged)
    this attempt.

    I'm running Debian 2.6.15.3
    Software packages:
    mysql-server 4.0.24-10sarge1
    postfix 2.1.5-9

    Anyone interested in solving this one? It would shurely make my day!

    Thanks,
    Philip
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Please post the output of
    Code:
    netstat -tap
     
  3. epo

    epo New Member

    Thans for the quick reply.

    # netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
    tcp 0 0 localhost.localdo:mysql *:* LISTEN 1618/mysqld
    tcp 0 0 *:smtp *:* LISTEN 2250/master
    tcp6 0 0 *:imaps *:* LISTEN 1559/couriertcpd
    tcp6 0 0 *:imap2 *:* LISTEN 1524/couriertcpd
    tcp6 0 0 *:ssh *:* LISTEN 1761/sshd
    tcp6 0 0 *:smtp *:* LISTEN 2250/master

    The mysql server is listening to the correct port, but I just noticed I can't telnet to it:
    # telnet 127.0.0.1 3306
    Trying 127.0.0.1...
    Connected to 127.0.0.1.
    Escape character is '^]'.
    Connection closed by foreign host.

    Is there some mysql configuration I've missed?

    Cheers,
    Philip
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's in /etc/hosts and /etc/mysql/my.cnf?
     
  5. epo

    epo New Member

    It looks like I had a misconfiguration in my hosts.allow settings.
    Adding an entry for mysql solved the problem:
    mysqld: 127.0.0.1

    Thanks for your clue to pinpoint the problem.
    Philip
     
  6. b_52globemaster

    b_52globemaster New Member

    hi

    i have nearly the same problem

    in the logs :

    Aug 3 15:24:49 mail postfix/trivial-rewrite[6684]: fatal: mysql:/etc/postfix/mysql-virtual_mailboxes.cf(0,100): table lookup problem
    Aug 3 15:25:50 mail postfix/trivial-rewrite[6690]: fatal: mysql:/etc/postfix/mysql-virtual_mailboxes.cf(0,100): table lookup problem

    i put
    mysqld: 127.0.0.1
    mail:/var/log#

    in my /etc/hosts.allow

    but the problem still here .



    thanks in advance
     
  7. falko

    falko Super Moderator ISPConfig Developer

    What's in /etc/postfix/mysql-virtual_mailboxes.cf?
     
  8. b_52globemaster

    b_52globemaster New Member

    thanks falko

    finally the problem is resolved , and as you suspect it was a grammar syntax error in the sql query in
    /etc/postfix/mysql-virtual_mailboxes.cf

    and thanks
     

Share This Page