postfix-tls sasl2 mysql courier-authmysql

[gabrix]

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:

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

mysql:/etc/postfix/mysql-virtual_domains.cf.

Looks really strange that

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

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:

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

[gabrix]

LOGS UPDATE:

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:

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'

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 !

[martinfst]

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?

[falko]

What's in /etc/postfix/main.cf (please strip out the comments) and /etc/hosts? What's the output of

netstat -tap

and

ls -l /etc/postfix

?

[gabrix]

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.