[Dovecot] Unknown column username in where clause
Anton Dollmaier
antondollmaier at aditsystems.de
Mon Jul 19 23:52:42 EEST 2010
Hi,
> I dont' know where the field "username" should come from because I
> don't use this field (or query).
perhabs this is the problem? ;-)
> The relevant files are:
Output of "dovecot -n" would be better, together with the additional files.
> dovecot-sql.conf.ext
> ====================
>
> 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'
I think you're missing a user_query.
best regards,
Anton
More information about the dovecot
mailing list