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.