dovecot - Oct 2005 - Does anyone have SQL working in 1.03?

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 at 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 at 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 at domain.com,69.86.67.250): unknown user
     Oct 15 23:02:07 rsrr1 dovecot: auth(default): passdb 
(username at domain.com,69.86.67.250): passdb didn't return userdb entries
     Oct 15 23:02:07 rsrr1 dovecot: auth(default): userdb 
(username at 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 at 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.

On Fri, 2005-10-14 at 22:52 -0400, Jonathan wrote:
> This just isn't working for me.  I've tried everything.
>  ==> 
> 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.
> 
What is in your auth section of dovecot.conf?

Regards
Andrew
--
Andrew Hutchings (A-Wing) - Linux Guru
Netserve Consultants - http://www.domaincity.co.uk/
Linux CDs and DVDs - http://www.linuxiso.co.uk/
Random quote 90: "This is not about browsers. Our competitors are trying
to create an alternative platform to Windows." - BRAD SILVERGBERG,
Senior Vice President, Microsoft