I am trying to get Postfix, Dovecot, Postfixadmin, and MySQP all
working together. I'm using 1.0.5 atm.
I've hit a point where I can't seem top get dovecot to auth to the
MySQL password database
It seems to see the user OK, but I can't seem to get a password match.
MySQL has password stored as MD5, as per Postfixadmin. When I add
plain-md5 to the auth mechanisms dovecot seems to use plain and fails.
From dovecot.conf..
# Space separated list of wanted authentication mechanisms: # plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi # NOTE: See also disable_plaintext_auth setting. mechanisms = cram-md5 plain login #
dovecot log file...
dovecot: Sep 25 11:17:30 Info: pop3-login: Login:
user=jdehnert@dehnert.com, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, secured
dovecot: Sep 25 11:19:54 Info: auth(default): client in: AUTH
1 PLAIN service=IMAP secured lip=127.0.0.1
rip=127.0.0.1 resp=<hidden>
dovecot: Sep 25 11:19:54 Info: auth-worker(default): sql
(jdehnert@dehnert.com,127.0.0.1): query: SELECT username as user,
password, concat('/var/vmail/',domain,'/',maildir) as userdb_home,
concat('maildir:/var/vmail/',domain,'/',maildir) as userdb_mail, 101
as userdb_uid, 101 as userdb_gid FROM mailbox WHERE username =
'jdehnert@dehnert.com' AND active = '1'
dovecot: Sep 25 11:19:54 Info: auth-worker(default): sql
(jdehnert@dehnert.com,127.0.0.1): Password mismatch
dovecot: Sep 25 11:19:54 Info: auth(default): client out: FAIL
1 user=jdehnert@dehnert.com
dovecot: Sep 25 11:22:54 Info: imap-login: Disconnected: Inactivity:
user=jdehnert@dehnert.com, method=PLAIN, rip=127.0.0.1,
lip=127.0.0.1, secured
and the sql script thats called is has just minor tweaks...
driver = mysql
connect = host=localhost dbname=postfix user=postfix password=postfix
user_query = SELECT concat('/var/vmail/',domain,'/',maildir) as home,
concat('maildir:/var/vmail/',domain,'/',maildir)
as mail, 101 AS uid, 101 AS gid, concat('maildir:storage=', quota)
AS quota FROM mailbox WHERE username = '%u' AND
active = '1'
password_query = SELECT username as user, password, concat('/var/
vmail/',domain,'/',maildir) as
userdb_home, concat('maildir:/var/vmail/',domain,'/',maildir) as
userdb_mail, 101 as userdb_uid,
101 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'