#11  
Old 4th August 2011, 16:43
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

Thanks Falko

I dont know if it's running chrooted, how do I find out? I certainly didn't set anything up that wasn't in the perfect Lenny with courier and mydns guide.

I can only guess I've missed a step out maybe. Everything else works fine. Apache interacts with mysql no problems.
Reply With Quote
Sponsored Links
  #12  
Old 5th August 2011, 11:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Code:
# ================================================== ========================
# service type *private unpriv *chroot *wakeup *maxproc command + args
# * * * * * * * (yes) * (yes) * (yes) * (never) (100)
# ================================================== ========================
smtp * * *inet *n * * * - * * * - * * * - * * * - * * * smtpd
It's not running chrooted, as you can see from your master.cf.

Can you post the contents of one of the /etc/postfix/mysql*.cf files that is throwing errors in your mail log?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #13  
Old 5th August 2011, 12:57
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

badbison:/etc/postfix# cat mysql-virtual_domains.cf
user = ispconfig
password = looks like a hashed pw here
dbname = dbispconfig
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 4
hosts = localhostbadbison:/etc/postfix#*
Reply With Quote
  #14  
Old 5th August 2011, 13:08
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

Aug 5 10:52:23 badbison postfix/trivial-rewrite[9141]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:52:23 badbison postfix/trivial-rewrite[9142]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 5 10:52:23 badbison postfix/trivial-rewrite[9142]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:52:23 badbison pop3d: LOGIN FAILED, user=client, ip=[::ffff:122.71.176.176]
Aug 5 10:52:24 badbison postfix/smtpd[20743]: warning: problem talking to service rewrite: Success
Aug 5 10:52:24 badbison postfix/smtpd[7814]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:52:24 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9141 exit status 1
Aug 5 10:52:24 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug 5 10:52:24 badbison postfix/smtpd[5886]: warning: problem talking to service rewrite: Success
Aug 5 10:52:24 badbison postfix/smtpd[3861]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:52:24 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9142 exit status 1
Aug 5 10:52:28 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:52:29 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:52:30 badbison pop3d: LOGIN FAILED, user=michel, ip=[::ffff:122.71.176.176]
Aug 5 10:52:35 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:52:36 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:52:36 badbison pop3d: LOGIN FAILED, user=coco, ip=[::ffff:122.71.176.176]
Aug 5 10:52:42 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:52:42 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:52:43 badbison pop3d: LOGIN FAILED, user=trac, ip=[::ffff:122.71.176.176]
Aug 5 10:52:49 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:52:50 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:52:50 badbison pop3d: LOGIN FAILED, user=123, ip=[::ffff:122.71.176.176]
Aug 5 10:52:56 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:52:56 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:52:57 badbison pop3d: LOGIN FAILED, user=java, ip=[::ffff:122.71.176.176]
Aug 5 10:53:03 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:03 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:04 badbison pop3d: LOGIN FAILED, user=java, ip=[::ffff:122.71.176.176]
Aug 5 10:53:10 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:15 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:16 badbison pop3d: LOGIN FAILED, user=java, ip=[::ffff:122.71.176.176]
Aug 5 10:53:21 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:22 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:23 badbison pop3d: LOGIN FAILED, user=mailtest, ip=[::ffff:122.71.176.176]
Aug 5 10:53:24 badbison postfix/trivial-rewrite[9165]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 5 10:53:24 badbison postfix/trivial-rewrite[9165]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:53:24 badbison postfix/trivial-rewrite[9166]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 5 10:53:24 badbison postfix/trivial-rewrite[9166]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:53:25 badbison postfix/smtpd[20743]: warning: problem talking to service rewrite: Success
Aug 5 10:53:25 badbison postfix/smtpd[7814]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:53:25 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9165 exit status 1
Aug 5 10:53:25 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug 5 10:53:25 badbison postfix/smtpd[5886]: warning: problem talking to service rewrite: Success
Aug 5 10:53:25 badbison postfix/smtpd[3861]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:53:25 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9166 exit status 1
Aug 5 10:53:28 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:29 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:30 badbison pop3d: LOGIN FAILED, user=clamav, ip=[::ffff:122.71.176.176]
Aug 5 10:53:35 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:36 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:37 badbison pop3d: LOGIN FAILED, user=clamav, ip=[::ffff:122.71.176.176]
Aug 5 10:53:42 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:43 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:44 badbison pop3d: LOGIN FAILED, user=victor, ip=[::ffff:122.71.176.176]
Aug 5 10:53:49 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:53:50 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:53:51 badbison pop3d: LOGIN FAILED, user=victor, ip=[::ffff:122.71.176.176]
Aug 5 10:53:56 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:01 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:02 badbison pop3d: LOGIN FAILED, user=victor, ip=[::ffff:122.71.176.176]
Aug 5 10:54:07 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:08 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:09 badbison pop3d: LOGIN FAILED, user=john, ip=[::ffff:122.71.176.176]
Aug 5 10:54:14 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:15 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:16 badbison pop3d: LOGIN FAILED, user=john, ip=[::ffff:122.71.176.176]
Aug 5 10:54:21 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:22 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:23 badbison pop3d: LOGIN FAILED, user=john, ip=[::ffff:122.71.176.176]
Aug 5 10:54:25 badbison postfix/trivial-rewrite[9189]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 5 10:54:25 badbison postfix/trivial-rewrite[9189]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:54:25 badbison postfix/trivial-rewrite[9190]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aug 5 10:54:25 badbison postfix/trivial-rewrite[9190]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
Aug 5 10:54:26 badbison postfix/smtpd[20743]: warning: problem talking to service rewrite: Success
Aug 5 10:54:26 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9189 exit status 1
Aug 5 10:54:26 badbison postfix/smtpd[7814]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:54:26 badbison postfix/master[3237]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Aug 5 10:54:26 badbison postfix/smtpd[5886]: warning: problem talking to service rewrite: Success
Aug 5 10:54:26 badbison postfix/master[3237]: warning: process /usr/lib/postfix/trivial-rewrite pid 9190 exit status 1
Aug 5 10:54:26 badbison postfix/smtpd[3861]: warning: problem talking to service rewrite: Connection reset by peer
Aug 5 10:54:28 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:29 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:30 badbison pop3d: LOGIN FAILED, user=linux, ip=[::ffff:122.71.176.176]
Aug 5 10:54:35 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:36 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:44 badbison pop3d: LOGIN FAILED, user=linux, ip=[::ffff:122.71.176.176]
Aug 5 10:54:50 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:50 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:51 badbison pop3d: LOGIN FAILED, user=linux, ip=[::ffff:122.71.176.176]
Aug 5 10:54:57 badbison pop3d: Disconnected, ip=[::ffff:122.71.176.176]
Aug 5 10:54:57 badbison pop3d: Connection, ip=[::ffff:122.71.176.176]
Aug 5 10:54:58 badbison pop3d: LOGIN FAILED, user=joanne, ip=[::ffff:122.71.176.176]
Aug 5 10:55:03 badbison pop3d: Connection, ip=[::ffff:127.0.0.1]
Aug 5 10:55:03 badbison pop3d: Disconnected, ip=[::ffff:127.0.0.1]
Aug 5 10:55:03 badbison imapd: Connection, ip=[::ffff:127.0.0.1]
Aug 5 10:55:03 badbison imapd: Disconnected, ip=[::ffff:127.0.0.1], time=0
Reply With Quote
  #15  
Old 6th August 2011, 12:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Quote:
Originally Posted by Toucan View Post
badbison:/etc/postfix# cat mysql-virtual_domains.cf
user = ispconfig
password = looks like a hashed pw here
dbname = dbispconfig
table = mail_domain
select_field = domain
where_field = domain
additional_conditions = and active = 'y' and server_id = 4
hosts = localhostbadbison:/etc/postfix#*
Can you replace
Code:
hosts = localhost
with
Code:
hosts = 127.0.0.1
and restart Postfix?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #16  
Old 6th August 2011, 23:22
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

Quote:
Originally Posted by falko View Post
Can you replace
Code:
hosts = localhost
with
Code:
hosts = 127.0.0.1
and restart Postfix?
I can - and I believe it has fixed it! I had to copy the setting to the other .cf files before the mail started working.

It also gave me a clue as to where I went wrong - Initially mysql server was shown as not working and having retraced the guide I think I'd left a line out here:

Code:
127.0.0.1       localhost.localdomain   localhost
192.168.0.100   server1.example.com     server1
# The following lines are desirable for IPv6 capable hosts
::1     localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
Of course, postfix had already been set up prior to the change. Does that sound logical?

Is this likely to have affected any other steps of the set up that I should deal with?

Thanks

David
Reply With Quote
  #17  
Old 7th August 2011, 13:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

You should check all the other mysql*.cf files as well.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
Toucan (9th August 2011)
  #18  
Old 9th August 2011, 02:00
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

Quote:
Originally Posted by falko View Post
You should check all the other mysql*.cf files as well.
Are you talking about just those in etc/postfix or are there others dotted around I should also find?

Postfix does seem to be working again now. Thanks
Reply With Quote
  #19  
Old 9th August 2011, 12:45
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
 
Default

No, just those in the /etc/postfix/ directory.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

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


All times are GMT +2. The time now is 16:28.


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