<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi List.<br>
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.<br>
<br>
Someone can help-me? []s;<br>
Andrey<br>
<br>
<br>
<br>
<br>
Here's my dovecot-mysql.conf:<br>
<br>
<small><font face="Courier New, Courier, monospace"># Dovecot queries<br>
db_host = localhost<br>
db_unix_socket = /var/lib/mysql/mysql.sock<br>
db_port = 3306<br>
db = mail<br>
db_user = my_conn_user<br>
db_passwd = my_conn_passwd<br>
<br>
<br>
<font color="#3333ff">#<br>
# Pehapes i need to change this, but I tryied changing it do md5 with
no success.<br>
#<br>
</font>default_pass_scheme = PLAIN<br>
<br>
#<br>
# This I changed for own reasons, but works.<br>
#<br>
password_query = SELECT clear FROM postfix_users WHERE
user=substring_index('%u', "@", 1)<br>
<br>
user_query = SELECT concat('/var/spool/mail/', maildir) AS mail, uid,
gid FROM postfix_users WHERE user=substring_index('%u', "@", 1)<br>
<br>
</font></small><br>
</body>
</html>