Juan Miscaro wrote:
Hi everybody,
I have STARTTLS, SMTP-AUTH, and SASL running with cleartext passwords
in a SQL backend for a while now. I am trying to switch over from
cleartext to crypt in terms of my passwords stored in MySQL. I have
things running for IMAP with crypt. For SMTP-AUTH I am using the same
SQL table and password.
you forgot to tell us what sasl implementatoin you use. I guess it's
cyrus-sasl...
I thought all I would need to do is edit my
smtpd.conf file (point to the encrypted table column and specify crypt
as password format) but I'm getting
cyrus-sasl does not support encrypted mysql passwords. try something else.
note that:
- if you are using dovecot, then you'd better use dovecot as a sasl
implementation
- if you are using courier, then you'd better use authdaemon via
cyrus-sasl.
postfix/smtpd[6085]: warning: SASL authentication failure: Password
verification failed
postfix/smtpd[6085]: warning: modemcableBLAH[69.10.10.10]: SASL PLAIN
authentication failed: authentication failure
postfix/smtpd[6085]: warning: modemcableBLAH[69.10.10.10]: SASL LOGIN
authentication failed: authentication failure
Here is my smtpd.conf:
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: PLAIN LOGIN
#log_level: 2
sql_engine: mysql
sql_hostnames: localhost
sql_database: mail
sql_user: postfix
sql_passwd: yeahright
sql_select: SELECT crypt FROM virtual_users WHERE email = '[EMAIL
PROTECTED]'
sql_usessl: no
password_format: crypt
What am I missing?
you missed the fact that we have no idea about your configuration. you
are asking questions as though we all have similar configs. we don't.
