[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'