Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
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
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 =
postmap: cfg_get_str: /etc/postfix/mysql-virtual-forwardings.cf: table =
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 =
postmap: mysqlname_parse: /etc/postfix/mysql-virtual-forwardings.cf: adding
host '' 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
postmap: warning: connect to mysql server 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
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!

Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 03:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 02:41
virtual users postfix mysql how-to problem Yoblad HOWTO-Related Questions 1 25th February 2006 06:42
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 23:30
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37

All times are GMT +2. The time now is 15:17.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.