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 Howtoforge Staff Moderator HowtoForge Supporter 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 Howtoforge Staff Moderator HowtoForge Supporter 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 Howtoforge Staff Moderator HowtoForge Supporter 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