Timo Sirainen wrote on 20.07.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. hmm, I've nothing read about that - but it's OK because the examples in the wiki creates tables with the field "username" instead of "userid" which I've used so the default query should then match... >> 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. OK, it seems to be working if I add this in dovecot-sql.conf.ext too: user_query = SELECT home, uid, gid, \ concat('*:bytes=', quota_bytes) as quota_rule \ FROM users WHERE userid = '%u' -- Daniel