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
  #1  
Old 13th March 2006, 22: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
 

Bookmarks

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 02:53
Another Problem: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP bluegrass Installation/Configuration 24 8th March 2006 01:41
virtual users postfix mysql how-to problem Yoblad HOWTO-Related Questions 1 25th February 2006 05:42
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 22:30
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 23:11.


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