postfix - MySQL connection problem

[epo]

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

[falko]

Please post the output of netstat -tap

[epo]

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

[falko]

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

[epo]

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

[b_52globemaster]

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

[falko]

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

[b_52globemaster]

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