dovecot - Oct 2006 - 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 at 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