[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

cyrus-sasl and auth via mysql


I get install cyrus-sasl-2.1.9 and cyrus-imapd-2.1.11.
User mail account`s stored in mysql in plain text.
Auth with imapd.conf:
configdirectory: /var/imap
defaultpartition: default
partition-default: /var/spool/imap
admins: cyrus
sasl_pwcheck_method: auxprop
unixhierarchysep: yes
tls_cert_file: /var/imap/server.pem
tls_key_file: /var/imap/server.pem
sendmail: /usr/sbin/sendmail
sasl_mysql_user: mysqluser
sasl_mysql_passwd: mysqlpass
sasl_mysql_database: internet
sasl_mysql_statement: select %p from mailclient where login = '%u'
sasl_mysql_verbose: yes
autocreatequota: 2000
lmtp_overquota_perm_failure: yes
reject8bit: no
goes ok.
But, i want replace plain password on like:
update mailclient set userPassword=ENCRYPT("la-la-la","$1$mFeTJdKh$") wh
ere login='samelogin';
What shell i add|replace in imapd.conf?
Im google for this guest, but no answer found.
Anybody use this sheme in work?



Andrey Ponomarev.
System administrator, ISP "Arvi".

Reply to: