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