On Mon, 2005-10-10 at 14:50 -0400, Jonathan Vanasco wrote:
password_query = SELECT local_part || '@' || domain as user,password FROM accounts WHERE local_part = '%n' AND domain = '%d' AND
active = 'Y' ;but i can't get things to work with the user query
user_query = SELECT home_dir AS home, uid, gid FROM accountsWHERE local_part = '%n' AND domain = '%d' ;
..
Oct 11 11:53:37 rsrr1 dovecot: auth(default): passdb(test@
mydomain.com,209.73.1.130): passdb didn't return userdb entries Oct 11 11:53:37 rsrr1 dovecot: auth(default): userdb(test@
mydomain.com,209.73.1.130): user not found from userdb
Looks like you're using passdb as userdb (BTW. I just renamed that to prefetch userdb, the passdb name for it was too confusing). If you really want to use that, you'll have to make password_query return all the fields, as http://wiki.dovecot.org/moin.cgi/AuthSpecials explains.
The easiest way to fix this however would be to use sql as the userdb. So you'd have something like:
passdb sql { args = /etc/dovecot.conf } userdb sql { args = /etc/dovecot.conf }