dovecot - Jul 2010 - Unknown column username in where clause

Version: Dovecot 2.0 rc2

I'm testing Dovecot with MySQL quotas but I get always this error for
incoming mails:

tux dovecot: lmtp(4928): Error: user testuser at dlutt.de: Auth USER lookup
failed
tux dovecot: auth: Error: mysql: Query failed, retrying: Unknown column
'username' in 'where clause'

I dont' know where the field "username" should come from because I
don't use this field (or query).

The relevant files are:

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'

auth-sql.conf.ext
================
passdb {
  driver = sql
  args = /etc/dovecot/dovecot-sql.conf.ext
}

userdb {
  driver = prefetch
}

userdb {
  driver = sql
  args = /etc/dovecot/dovecot-sql.conf.ext
}

90-quota.conf
============
plugin {
  quota = dict:user::proxy::quota
  quota_rule = *:storage=0
}

dovecot-dict-sql.conf.ext
========================
map {
  pattern = priv/quota/storage
  table = quota
  username_field = userid
  value_field = bytes
}
map {
  pattern = priv/quota/messages
  table = quota
  username_field = userid
  value_field = messages
}

I've grepped through all config files but I can't find any (active)
query which uses the above "where username=...".

The quota db gets correctly updated if an user logs in so the problem
only exists during mail delivery. My SQL tables were crated as
follows:

CREATE TABLE IF NOT EXISTS `users` (
  `userid` varchar(100) NOT NULL,
  `password` varchar(64) NOT NULL,
  `home` varchar(255) NOT NULL,
  `uid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  `quota_bytes` varchar(10) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `quota` (
  `userid` varchar(100) NOT NULL,
  `bytes` bigint(20) NOT NULL default '0',
  `messages` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
Daniel

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