[Dovecot] Unknown column username in where clause
Timo Sirainen
tss at iki.fi
Tue Jul 20 01:12:23 EEST 2010
On 19.7.2010, at 22.59, Daniel Luttermann wrote:
> The queries uses only "userid" instead of "username" so I think if one
> sql field were missing it should report that "userid" could not be
> found because the query is "FROM users WHERE userid = '%u'".
>
> I've not select "username" in any sql select so I wonder where does
> this name come from.
There's actually a default query.. Hmm. Maybe it should be made empty, since probably no one wants to use it.
> password_query = SELECT userid AS user, password, \
> home AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, \
> concat('*:bytes=', quota_bytes) as userdb_quota_rule \
> FROM users WHERE userid = '%u'
You must also have a user_query for LDA/LMTP.
More information about the dovecot
mailing list