View Single Post
  #1  
Old 13th March 2006, 23:52
epo epo is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default postfix - MySQL connection problem

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
Reply With Quote
Sponsored Links