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=<****[email protected]> 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...
this is ubuntu perfect server with ispconfig 3 http://www.howtoforge.com/perfect-server-ubuntu-10.10-maverick-meerkat-ispconfig-3
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.
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?
Please do the exact steps that I described above. It does not matter for that if the intalled version is the latest version.
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...
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.
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]
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]
from telnet i`m getting this error then trying to send email: 554 5.7.1 <artu****@gmail.com>: Relay access denied
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]
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...
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'