Sasl2 + auxprop + mysql + md5 hesla
Miroslav Chlasták
chlastak at goasedlcany.cz
Thu Oct 7 12:18:53 CEST 2004
Zdravim,
chtel bych na mailservru rozbehnout overovani pri smtp, ale nejak jsem
se zasekl. Vse funguje skvele, pokud pouziji plaintextovy hesla. Ale
kdyz pouziji md5 hesla ve formatu $1$q8..ri2.$XkswKbm1Ri8FoMFfFLQRj1,
tak mi sasl vyhodi do maillogu hlasku:
Oct 7 11:43:34 mail postfix/smtpd[81233]: warning: SASL authentication
failure: incorrect digest response
Oct 7 11:43:34 mail postfix/smtpd[81233]: warning:
unknown[192.168.10.214]: SASL CRAM-MD5 authentication failed
Oct 7 11:43:34 mail postfix/smtpd[81233]: warning: SASL authentication
failure: Password verification failed
Oct 7 11:43:34 mail postfix/smtpd[81233]: warning:
unknown[192.168.10.214]: SASL PLAIN authentication failed
Oct 7 11:43:34 mail postfix/smtpd[81233]: warning:
unknown[192.168.10.214]: SASL LOGIN authentication failed
V smtpd.conf mam toto:
pwcheck_method: auxprop
auxprop_plugin: sql
sql_engine: mysql
mech_list: plain login cram-md5 digest-md5
sql_user: postfix
sql_passwd: <tajne_heslo>
sql_database: postfix
sql_statement: SELECT password FROM mailbox WHERE username = '%u at domena.cz'
sql_verbose: yes
A dalsi dotaz mam ohledne toho radku sql_statement. Username je v mysql
ulozeno jmeno at domena.cz. Lze nejak nastavit, abych nemusel v SQL dotazu
uvadet tu domenu?
Mira
More information about the Users-l
mailing list