[Dovecot] FreeBSD Ports Issues

[Bob Hall]

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 at example.com,1.2.3.4): SELECT home, uid, gid FROM users WHERE userid
> = 'user at 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?