postfix-tls sasl2 mysql courier-authmysql

Discussion in 'Server Operation' started by gabrix, Jan 10, 2007.

  1. gabrix

    gabrix New Member

    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
    Looks really strange that
    And this other error is one of my classical with postfix
    It's a $mynetworks variable issue but 192.168.1.1 is listed as variable value:
     
    Last edited: Jan 10, 2007
  2. gabrix

    gabrix New Member

    LOGS UPDATE:
    An this othe logs:
    I got this other logs sent by logchek on the host in charge.I'm not much into mysql , thanks !
     
  3. martinfst

    martinfst Member Moderator

  4. falko

    falko Super Moderator Howtoforge Staff

    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
    ?
     
  5. gabrix

    gabrix New Member

    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.
     

Share This Page