On Tue, Oct 11, 2005 at 03:12:58PM -0700, Barry Jeung wrote: snip
The second issue, is that dovecot seems to be ignoring my user_query settings. I have the following in dovecot-sql.conf:
password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 125 as uid, 125 as gid FROM mailbox WHERE username = '%u'
The password query works, however the user query seems to default to something else, and no matter how I change the user_query line in dovecot-sql.conf, it uses the same query. Here's an excerpt from my logs:
snip
dovecot: Oct 11 03:19:35 Info: auth-worker(default): sql(user@example.com,1.2.3.4): SELECT home, uid, gid FROM users WHERE userid = 'user@example.com'
snip
So obviously the query fails because that table doesn't exist. However that's not the query that I have in the configuration file. As a matter of fact, I have no idea where it's pulling that query from. Any pointers would be greatly appreciated.
The query perfectly matches the last example in the dovecot-sql.conf file. In my copy, that's the last line in in the file. Did you uncomment that line?
Did you do a search in the file for "SELECT home, uid, gid" to see if there's an uncommented line containing that query?