Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th January 2007, 10:42
gabrix gabrix is offline
Senior Member
 
Join Date: Sep 2006
Location: Napoli
Posts: 186
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to gabrix Send a message via Yahoo to gabrix Send a message via Skype™ to gabrix
Question postfix-tls sasl2 mysql courier-authmysql

I'm setting up my existing postfix-tls and courier-pop with mysql and auth-mysql .I'm trying to authenticate but htere is something going weerd.I followed mostly this guide http://workaround.org/articles/ispmail-sarge and checking by telnet everything seemed ok.Configurations are like the guide at workaround i will show you logs:
Code:
Jan 10 10:36:20 mail postfix/smtpd[32081]: fatal: open /etc/postfix/mysql-virtual_: No such file or directory
Jan 10 10:36:21 mail postfix/master[31959]: warning: process /usr/lib/postfix/smtpd pid 32081 exit status 1
Jan 10 10:36:21 mail postfix/master[31959]: warning: /usr/lib/postfix/smtpd: bad command startup -- throttling
Jan 10 10:36:41 mail postfix/postfix-script: stopping the Postfix mail system
Jan 10 10:36:41 mail postfix/master[31959]: terminating on signal 15
Jan 10 10:36:42 mail postfix/postfix-script: starting the Postfix mail system
Jan 10 10:36:42 mail postfix/master[32184]: daemon started -- version 2.1.5
Jan 10 10:37:07 mail courierpop3login: Connection, ip=[::ffff:192.168.1.6]
Jan 10 10:37:07 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=AUTH
Jan 10 10:37:07 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=CAPA
Jan 10 10:37:26 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=USER
Jan 10 10:37:26 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=PASS
Jan 10 10:37:26 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], username=gabrix
Jan 10 10:37:26 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], password=xxxxxxx
Jan 10 10:37:26 mail courierpop3login: authdaemon: starting client module
Jan 10 10:37:27 mail courierpop3login: authdaemon: TEMPFAIL - no more modules will be tried
Jan 10 10:37:32 mail courierpop3login: LOGIN FAILED, ip=[::ffff:192.168.1.6]
Jan 10 10:37:34 mail postfix/smtpd[32215]: connect from 85-18-113-11.ip.fastwebnet.it[85.18.113.11]
Jan 10 10:37:36 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=CAPA
Jan 10 10:37:36 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=USER
Jan 10 10:37:36 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], command=PASS
Jan 10 10:37:36 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], username=gabrix
Jan 10 10:37:36 mail courierpop3login: LOGIN: DEBUG: ip=[::ffff:192.168.1.6], password=xxxxxxxxx
Jan 10 10:37:36 mail courierpop3login: authdaemon: starting client module
Jan 10 10:37:36 mail courierpop3login: authdaemon: TEMPFAIL - no more modules will be tried
Jan 10 10:37:41 mail courierpop3login: LOGIN FAILED, ip=[::ffff:192.168.1.6]
Jan 10 10:37:41 mail postfix/smtpd[32221]: warning: smtpd_peer_init: 192.168.1.1: address not listed for hostname argo
Jan 10 10:37:41 mail postfix/smtpd[32221]: connect from unknown[192.168.1.1]
Jan 10 10:37:42 mail postfix/trivial-rewrite[32222]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jan 10 10:37:42 mail postfix/trivial-rewrite[32222]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Jan 10 10:37:43 mail postfix/master[32184]: warning: process /usr/lib/postfix/trivial-rewrite pid 32222 exit status 1
Jan 10 10:37:43 mail postfix/smtpd[32221]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Jan 10 10:37:43 mail postfix/smtpd[32221]: warning: problem talking to service rewrite: Success
Jan 10 10:37:44 mail postfix/trivial-rewrite[32224]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Jan 10 10:37:44 mail postfix/trivial-rewrite[32224]: fatal: mysql:/etc/postfix/mysql-virtual_domains.cf(0,100): table lookup problem
Jan 10 10:37:45 mail postfix/smtpd[32221]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Jan 10 10:37:45 mail postfix/smtpd[32221]: warning: problem talking to service rewrite: Success
Jan 10 10:37:45 mail postfix/master[32184]: warning: process /usr/lib/postfix/trivial-rewrite pid 32224 exit status 1
Jan 10 10:37:45 mail postfix/master[32184]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
I'm going to check why that lookup problem on
Quote:
mysql:/etc/postfix/mysql-virtual_domains.cf.
Looks really strange that
Quote:
warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
And this other error is one of my classical with postfix
Quote:
postfix/smtpd[32221]: warning: smtpd_peer_init: 192.168.1.1: address not listed for hostname argo
Jan 10 10:37:41 mail postfix/smtpd[32221]: connect from unknown[192.168.1.1]
It's a $mynetworks variable issue but 192.168.1.1 is listed as variable value:
Quote:
mynetworks = 192.168.1.6/32,192.168.1.1/32,192.168.1.0/24,192.168.0.0/16,127.0.0.0/8
__________________
http://www.gabrix.ath.cx

Last edited by gabrix; 10th January 2007 at 10:55.
Reply With Quote
Sponsored Links
  #2  
Old 10th January 2007, 14:19
gabrix gabrix is offline
Senior Member
 
Join Date: Sep 2006
Location: Napoli
Posts: 186
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to gabrix Send a message via Yahoo to gabrix Send a message via Skype™ to gabrix
Default

LOGS UPDATE:
Quote:
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin could not connect to host 127.0.0.1
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin couldn't connect to any host
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin Parse the username gabrix
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin try and connect to a host
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin trying to open db 'gabrix_mail_provider' on host '127.0.0.1'
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin could not connect to host 127.0.0.1
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin couldn't connect to any host
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin Parse the username gabrix
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin try and connect to a host
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin trying to open db 'gabrix_mail_provider' on host '127.0.0.1'
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin could not connect to host 127.0.0.1
Jan 10 13:51:17 mail postfix/smtpd[4230]: sql plugin couldn't connect to any host
Jan 10 13:55:04 mail postfix/smtpd[4447]: sql auxprop plugin using mysql engine
Jan 10 13:55:19 mail postfix/smtpd[4450]: sql auxprop plugin using mysql engine
An this othe logs:
Quote:
Jan 10 13:08:56 mail postfix/smtpd[4230]: sql auxprop plugin using mysql engine
Jan 10 13:08:56 mail postfix/smtpd[4231]: sql auxprop plugin using mysql engine
Jan 10 13:14:50 mail postfix/smtpd[4230]: warning: 102.95.69.82.relays.ordb.org: RBL lookup error: Host or domain name not found. Name service error for name=102.95.69.82.relays.ordb.org type=A: Host not found, try again
Jan 10 13:14:50 mail postfix/smtpd[4230]: warning: 102.95.69.82.relays.ordb.org: RBL lookup error: Host or domain name not found. Name service error for name=102.95.69.82.relays.ordb.org type=A: Host not found, try again
Jan 10 13:24:56 mail postfix/smtpd[4230]: warning: 11.113.18.85.relays.ordb.org: RBL lookup error: Host or domain name not found. Name service error for name=11.113.18.85.relays.ordb.org type=A: Host not found, try again
Jan 10 13:24:56 mail postfix/smtpd[4230]: warning: 11.113.18.85.relays.ordb.org: RBL lookup error: Host or domain name not found. Name service error for name=11.113.18.85.relays.ordb.org type=A: Host not found, try again
Jan 10 13:50:58 mail postfix/smtpd[4230]: sql plugin Parse the username gabrix
Jan 10 13:50:58 mail postfix/smtpd[4230]: sql plugin try and connect to a host
Jan 10 13:50:58 mail postfix/smtpd[4230]: sql plugin trying to open db 'gabrix_mail_provider' on host '127.0.0.1'
Jan 10 13:50:58 mail postfix/smtpd[4230]: sql plugin could not connect to host 127.0.0.1
Jan 10 13:50:59 mail postfix/smtpd[4230]: sql plugin couldn't connect to any host
Jan 10 13:50:59 mail postfix/smtpd[4230]: sql plugin Parse the username gabrix
Jan 10 13:50:59 mail postfix/smtpd[4230]: sql plugin try and connect to a host
Jan 10 13:50:59 mail postfix/smtpd[4230]: sql plugin trying to open db 'gabrix_mail_provider' on host '127.0.0.1'
Quote:
Jan 10 13:50:59 mail postfix/smtpd[4230]: warning: SASL authentication failure: no secret in database
Jan 10 13:50:59 mail postfix/smtpd[4230]: warning: mail.gabrix.ath.cx[192.168.1.6]: SASL CRAM-MD5 authentication failed
Jan 10 13:50:59 mail postfix/smtpd[4230]: warning: SASL authentication failure: Password verification failed
I got this other logs sent by logchek on the host in charge.I'm not much into mysql , thanks !
__________________
http://www.gabrix.ath.cx
Reply With Quote
  #3  
Old 10th January 2007, 14:24
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

At least one error is explainable: ordb.org is dead since around Xmas:
http://www.theinquirer.net/default.aspx?article=36470. your other problem seems to be that the smtpd deamon cannont connect to mysql. Does postfix run chroot'ed?
Reply With Quote
  #4  
Old 11th January 2007, 19:00
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

What's in /etc/postfix/main.cf (please strip out the comments) and /etc/hosts? What's the output of
Code:
netstat -tap
and
Code:
ls -l /etc/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
  #5  
Old 12th January 2007, 22:09
gabrix gabrix is offline
Senior Member
 
Join Date: Sep 2006
Location: Napoli
Posts: 186
Thanks: 2
Thanked 0 Times in 0 Posts
Send a message via MSN to gabrix Send a message via Yahoo to gabrix Send a message via Skype™ to gabrix
 
Default

Cheers guys for answer.But i gave up working on this and i went backwords on configuration which is here http://www.howtoforge.org/forums/showthread.php?t=9744.I'm trying to add tls and spam filtering to my mail system , on the gateway host .Mysql integration wen really bad i didn't get any mail dlivered in the last days.All my mail,work,fun,friends,linux,mailing lists,server log status,relay on this so i rather move email connection encryption and spam filetring on an another to not bear on a machine has already apache apache-ssl courier-ssl mysql,and only 250 mb of ram.
__________________
http://www.gabrix.ath.cx
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade question for "Virtual Users And Domains With Postfix, Courier And MySQL" emresumengen HOWTO-Related Questions 3 1st December 2006 15:33
Centos 4.4 32bit Hangs, High Server load 3cwired_com Server Operation 11 16th November 2006 15:47
Verify email setup meekish Installation/Configuration 28 27th October 2006 15:36
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs k1piee HOWTO-Related Questions 14 1st October 2006 13:46
Virtual Users And Domains With Postfix, Courier And MySQL - "apt-get" and Courier burritonator HOWTO-Related Questions 3 15th March 2006 20:11


All times are GMT +2. The time now is 13:55.


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