| View previous topic :: View next topic |
| Author |
Message |
lostinspace2011
Apprentice
Joined: 09 Sep 2005
Posts: 230
|
 Posted: Sun Oct 25, 2009 12:15 am Post subject: Postfix / SASL only works for plain text password [RESOLVED] |
 |
|
I am trying to configure my postfix mail server with virtual accounts. Local account work, but any virtual accounts only work with a plain text password. In the previous install I had this working, but since I re-installed it doesn't work any more. From the log message it seems that it is using only PLAIN authentication. I have verified this by entering the password's crypt/hash into the password field and then it worked. I am storing the crypt/hash of the password the same way it did in my previous installation. Since the log doesn't attempt to use other mechanisms (DIGEST-MD5...) I don't thing it's a crypt/hash problem.
Any suggestions on this would really make my day. Have been struggling with this for some time now.
| Code: | # $Header: /var/cvsroot/gentoo-x86/mail-mta/postfix/files/smtp.sasl,v 1.2 2004/07/18 03:26:56 dragonheart Exp $
mech_list: PLAIN LOGIN
pwcheck_method: saslauthd
#pwcheck_method: auxprop
mech_list: PLAIN CRAM-MD5 DIGEST-MD5 LOGIN
allowanonymouslogin: no
allowplaintext: no
sasl_auxprop_plugin: sql
sql_engine: pgsql
# Leave commented out to use the unix socket
#sql_hostnames: localhost
sql_database: postman
sql_user: postman
# Not present means no password
#sql_passwd:
sql_select: SELECT password FROM mailbox WHERE username = '%u' AND domain = '%r' |
This is the error from the console log
| Quote: | Oct 24 18:23:19 bumblebee postfix/smtpd[10743]: Anonymous TLS connection established from www.routerlogin.com[192.168.0.1]: TLSv1 with cipher AES128-SHA (128/128 bits)
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin Parse the username info@abc.com
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin try and connect to a host
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin trying to open db 'postman' on host ''
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin Parse the username info@abc.com
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin try and connect to a host
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin trying to open db 'postman' on host ''
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: begin transaction
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin create statement from userPassword info abc.com
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin doing query SELECT password FROM mailbox WHERE username = 'info@abc.com' AND domain = 'abc.com';
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin create statement from cmusaslsecretPLAIN info abc.com
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin doing query SELECT password FROM mailbox WHERE username = 'info@abc.com' AND domain = 'abc.com';
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: commit transaction
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin Parse the username info@abc.com
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin try and connect to a host
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: sql plugin trying to open db 'postman' on host ''
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: warning: SASL authentication failure: Password verification failed
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: warning: www.routerlogin.com[192.168.0.1]: SASL PLAIN authentication failed: authentication failure
Oct 24 18:23:27 bumblebee postfix/smtpd[10743]: lost connection after AUTH from www.routerlogin.com[192.168.0.1]
|
|
|
| Back to top |
|
 |
lostinspace2011
Apprentice
Joined: 09 Sep 2005
Posts: 230
|
| Posted: Thu Nov 05, 2009 8:12 pm Post subject: |
|
|
Using the crypt USE flag (i think) resolved the problem. I am not 100% sure it was the crypt flag as I am using the following, but in any case this works.
| Code: |
USE="mmx sse sse2 X unicode truetype jpeg jpeg2k tiff java6 java5 java png \
opengl dri postgres subversion gpm apache2 unicode maildir type1-fonts \
bitmap-fonts truetype-fonts postfix subversion crypt pam perl php sasl \
ssl xml xml2" |
|
|
| Back to top |
|
|
|
Networking & Security
