Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10th September 2006, 09:45
asterix asterix is offline
Junior Member
 
Join Date: Sep 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Quick question about Postfix + MySQL

Hi,

I followed this guide: http://www.howtoforge.com/virtual_po..._quota_courier

I reached the end of page 2, but the command "telnet localhost pop3" failed, so I went to check why.

I found the following in my logs:

Code:
Sep 10 02:32:40 server postfix/cleanup[22630]: warning: connect to mysql server unix:/var/run/mysqld/mysqld.sock: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Code:
server:/etc/postfix# mysql -u mail_admin -p --socket=/var/run/mysqld/mysqld.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28 to server version: 4.0.24_Debian-10sarge2-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
All of my config files are the defaults (except for changing the hosts =, since I only access the server via local socket) e.g.:

Code:
server:/etc/postfix# cat mysql-virtual_forwardings.cf
user = mail_admin
password = mail_admin_password
dbname = mail
table = forwardings
select_field = destination
where_field = source
hosts = unix:/var/run/mysqld/mysqld.sock
I can connect via the command-line mysql client and via PHP/Perl with the same socket/user/pass, why isn't Postfix working?

Thanks!

(P.S. this is the first time I've ever encountered a problem with one of your articles. Keep up the good work. )
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
postfix - MySQL connection problem epo Installation/Configuration 7 4th August 2006 20:49
Forwarding Question For Virtual Users And Domains With Postfix, Courier And MySQL (+ mrjjman HOWTO-Related Questions 3 6th April 2006 11:23
Virtual Users And Domains With Postfix, Courier And MySQL Question neil6179 HOWTO-Related Questions 1 18th March 2006 11:14
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


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


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