Hi List.
I've got a dovecot running with mysql. All my users data are there. But I intend to use MD5 instead of clear passwords at MySQL.

Someone can help-me? []s;
    Andrey




Here's my dovecot-mysql.conf:

# Dovecot queries
db_host = localhost
db_unix_socket = /var/lib/mysql/mysql.sock
db_port = 3306
db = mail
db_user = my_conn_user
db_passwd = my_conn_passwd


#
# Pehapes i need to change this, but I tryied changing it do md5 with no success.
#
default_pass_scheme = PLAIN

#
# This I changed for own reasons, but works.
#
password_query = SELECT clear FROM postfix_users WHERE user=substring_index('%u', "@", 1)

user_query = SELECT concat('/var/spool/mail/', maildir) AS mail, uid, gid FROM postfix_users WHERE user=substring_index('%u', "@", 1)