[Dovecot] trouble setting up dovecot on Ubuntu server with mysql backend
I'm trying to setup dovecot to use my postfixadmin user accounts on an ubuntu server.
dovecot versions: dovecot-common 1.0.beta3-3ubuntu5.3 dovecot-imapd 1.0.beta3-3ubuntu5.3
I have gotten the account up and I can see dovecot query for the password for the user, but I get login failed.
In my mail.log I only see this: dovecot: imap-login: Aborted login: user=user@domain.com, method=PLAIN, rip=IP_ADDR, lip=IP_ADDR, TLS
I can't see to find any other information that can help me figure out why it won't accept the password. The passwords in mysql are md5crypt passwords according to postfixadmin's conf file.
// In what way do you want the passwords to be crypted? // md5crypt = internal postfix admin md5 // system = whatever you have set as your PHP system default // cleartext = clear text passwords (ouch!) $CONF['encrypt'] = 'md5crypt';
In my old setup I have auth_mechanisms just set to plain. Any help is greatly appreciated. I feel like I'm just missing one thing that get the passwords to be accepted.
Thanks...Rick
dovecot.conf protocols = imap imaps ssl_disable = no log_timestamp = "%Y-%m-%d %H:%M:%S " mail_extra_groups = mail mail_debug = yes default_mail_env = maildir:/home/vmail/%d/%n/ protocol imap { }
protocol pop3 { }
auth default { mechanisms = plain login digest-md5 passdb sql { args = /etc/dovecot/dovecot-sql.conf }
userdb sql {
args = /etc/dovecot/dovecot-sql.conf
}
socket listen {
client {
user = postfix
group = postfix
path = /var/spool/postfix/private/auth
mode = 0660
}
}
mechanisms = digest-md5 plain user = root }
plugin { }
dovecot-sql.conf driver = mysql connect = host=127.0.0.1 user=postfix password=$PASS dbname=postfix password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 106 AS uid, 112 AS gid FROM mailbox WHERE username = '%u'
Richard Harding wrote:
Hi Richard,
I can't see to find any other information that can help me figure out why it won't accept the password. The passwords in mysql are md5crypt passwords according to postfixadmin's conf file.
The fact that the passwords are in md5crypt format in your mysql database is the key. You need to provide this information to Dovecot. In the dovecot-sql.conf file, you need to add a parameter, called "default_pass_scheme". If you do not specify one, Dovecot defaults to PLAIN-MD5, but you need to set it to MD5, as described here:
http://wiki.dovecot.org/Authentication/PasswordSchemes
-- Anand
participants (2)
-
Anand Buddhdev
-
Richard Harding