[Dovecot] Does anyone have SQL working in 1.03?

Jonathan dovecot-list at 2xlp.com
Sat Oct 15 05:52:34 EEST 2005


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.



More information about the dovecot mailing list