This just isn't working for me. I've tried everything.
Trailing the logs with debug and vebose...
we connect fine
===
Oct 15 22:51:35 rsrr1 dovecot: Killed with signal 15
Oct 15 22:51:37 rsrr1 dovecot: Dovecot v1.0.alpha3 starting up
Oct 15 22:51:38 rsrr1 dovecot: auth(default): pgsql: Connected
to vmail
===
and then we die:
===
Oct 15 23:02:07 rsrr1 dovecot: auth(default): sql
(username@domain.com,69.86.67.250): query: SELECT password FROM
accounts WHERE local_part = 'username' AND domain = 'domain.com' AND
active = 'Y' LIMIT 1;
Oct 15 23:02:07 rsrr1 dovecot: auth(default): client out: OK
1 user=username@domain.com
Oct 15 23:02:07 rsrr1 dovecot: auth(default): master in:
REQUEST 24 33278 1
Oct 15 23:02:07 rsrr1 dovecot: auth(default): passwd
(username@domain.com,69.86.67.250): unknown user
Oct 15 23:02:07 rsrr1 dovecot: auth(default): passdb
(username@domain.com,69.86.67.250): passdb didn't return userdb entries
Oct 15 23:02:07 rsrr1 dovecot: auth(default): userdb
(username@domain.com,69.86.67.250): user not found from userdb
Oct 15 23:02:07 rsrr1 dovecot: auth(default): master out:
NOTFOUND 24
Oct 15 23:02:07 rsrr1 dovecot: imap-login: Internal login
failure: user=username@domain.com, method=PLAIN, rip=69.86.67.250,
lip=66.250.131.114, TLS
===
I've tried both of these selects on the password:
password_query = SELECT local_part || '@' || domain as user, password FROM accounts WHERE local_part = '%n' AND domain = '%d' AND a
ctive = 'Y' ;
password_query = SELECT password FROM accounts WHERE local_part
= '%n' AND domain = '%d' AND active = 'Y' LIMIT 1;
and this, and some variants, on the user
user_query = SELECT home_dir AS home, uid, gid FROM accounts
WHERE local_part = '%n' AND domain = '%d' LIMIT 1;
all mimic the functionality of the conf example files.