Hello, i have problem with postfix after update to ubuntu 11.04

Discussion in 'HOWTO-Related Questions' started by uteliux, Oct 17, 2011.

  1. uteliux

    uteliux Member

    Hello, i have problem with postfix after update to ubuntu 11.04. Problem starter just after update. I cant send email from email clients outlook or thunderbird (error i got Relay access denied ) and asks for passwords?? P.S. i can get new mail. But moust interesting that i can send/recieve email thrue squirrelmail... in log files i see:

    mail.log
    Oct 17 19:43:02 **** postfix/smtpd[2256]: NOQUEUE: reject: RCPT from hst-226-133.444us.lt[11.11.222.124]: 554 5.7.1 <****@gmail.com>: Relay access denied; from=<arturas@*****.lt> to=<****.lap@gmail.com> proto=ESMTP helo=<[192.168.1.104]>

    this error i saw just after update in mail.err

    Oct 17 16:03:22 ******** postfix/smtpd[30104]: fatal: no SASL authentication mechanisms
    Oct 17 16:10:22 ******** postfix/smtp[22220]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Oct 17 16:10:23 ******** postfix/error[22228]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Oct 17 16:10:24 ******** postfix/qmgr[22216]: fatal: mysql:/etc/postfix/mysql-virtual_relaydomains.cf(0,lock|fold_fix): table lookup problem
    Oct 17 17:05:09 ******** spamd[1328]: spamd: respawning server at /usr/sbin/spamd line 1140.

    mabey someone can hellp? and sorry for my english...
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Do you use ispconfig 3 on that server? Or is this the postfix virtual user setup from falko?
     
  3. uteliux

    uteliux Member

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely the update has overwritten some config files. First you should check if mysql is working, e.g. with this command:

    netstat -tap | grep mysql

    If mysql works, then you can use the ispconfig update script to rebuild the config files. Download ispconfig 3.0.3.3 tar.gz, unpack it and run the update.php script which is in the install folder. Choose "yes" when the updater asks you if the services shall be reconfigured.
     
  5. uteliux

    uteliux Member

    tcp 0 0 *:mysql *:* LISTEN 1056/mysqld
    tcp 0 0 localhost.localdo:33074 localhost.localdo:mysql ESTABLISHED 1365/amavisd (ch9-a
    tcp 0 0 localhost.localdo:mysql localhost.localdo:33074 ESTABLISHED 1056/mysqld
    tcp 0 0 localhost.localdo:59605 localhost.localdo:mysql ESTABLISHED 1366/amavisd (ch9-a
    tcp 0 0 localhost.localdo:mysql localhost.localdo:59605 ESTABLISHED 1056/mysqld

    so... i need to try reconfigure ispconfig?
     
  6. uteliux

    uteliux Member

    i already have newest ispconfig...

    There are no updates available for ISPConfig 3.0.3.3
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Please do the exact steps that I described above. It does not matter for that if the intalled version is the latest version.
     
  8. uteliux

    uteliux Member

    Till, i reconfigured like you said, same problem persist.... logs shows same problem, i can get mail but cant send, from external clients.... everything else works fine...
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Please try this:

    Code:
    sudo apt-get install libsasl2-2 libsasl2-modules libsasl2-modules-sql sasl2-bin libpam-mysql
    and then restart postfix and saslauthd.
     
  10. uteliux

    uteliux Member

    libpam-mysql is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.

    and logs show:

    Oct 18 09:24:10 ******* postfix/smtpd[4495]: connect from karamele.******* .lt[******* .177]
    Oct 18 09:24:10 ******* postfix/smtpd[4495]: warning: karamele.******* .lt[******* .177]: SASL LOGIN authentication failed: no mechanism available
    Oct 18 09:24:10 ******* postfix/smtpd[4495]: lost connection after AUTH from karamele.******* .lt[******* .177]
    Oct 18 09:24:10 ******* postfix/smtpd[4495]: disconnect from karamele.******* .lt******* .177]
     
  11. uteliux

    uteliux Member

    Til, any ideas? i`m so confused... cant find answer...
     
  12. uteliux

    uteliux Member

    Oct 19 10:52:42 ************** postfix/smtpd[19125]: warning: karamele.************** .lt[************** .177]: SASL LOGIN authentication failed: no mechanism available
    Oct 19 10:52:43 ************** postfix/smtpd[19125]: disconnect from karamele.************** .lt[************** .177]
     
  13. uteliux

    uteliux Member

    from telnet i`m getting this error then trying to send email:
    554 5.7.1 <artu****@gmail.com>: Relay access denied
     
  14. falko

    falko Super Moderator ISPConfig Developer

    Are these the only errors, or are there additional error messages in the mail log?
     
  15. uteliux

    uteliux Member

    this is the only warning i`m getting in mail.log and syslog....

    Oct 20 07:37:14 ****** postfix/smtpd[22594]: connect from ****** .lt[****** .177]
    Oct 20 07:37:22 ****** postfix/smtpd[22594]: warning: ****** [****** .177]: SASL PLAIN authentication failed: no mechanism available
    Oct 20 07:37:22 ****** postfix/smtpd[22594]: warning: ****** [****** .177]: SASL LOGIN authentication failed: no mechanism available
    Oct 20 07:37:23 ****** postfix/smtpd[22594]: disconnect from ****** [****** .177]
     
    Last edited: Oct 20, 2011
  16. uteliux

    uteliux Member

    I got suggestion, to check to check access to mysql-virtual_relaydomains.cd via mysql tools, but i dont know how to do this better to test it... mabey somenone can tell me how i can do this? I think that postfix is not able to lookup there...
     
    Last edited: Oct 20, 2011
  17. falko

    falko Super Moderator ISPConfig Developer

    If that is the case, you should get MySQL lookup errors in your mail log...
     
  18. uteliux

    uteliux Member

    I think you're right ... After all, i can send mail from web mail client hosted on that server...
     
  19. falko

    falko Super Moderator ISPConfig Developer

    What's in /etc/postfix/sasl/smtpd.conf?
     
  20. uteliux

    uteliux Member

    pwcheck_method: saslauthd
    mech_list: plain login
    allow_plaintext: true
    auxprop_plugin: mysql
    sql_hostnames: 127.0.0.1
    sql_user: ispconfig
    sql_passwd: 0fa887be393cd0f913d19f6057a80868
    sql_database: dbispconfig
    sql_select: select password from mail_user where email = '%u'
     

Share This Page