Control: tags -1 - moreinfo + wontfix
Hi Timo,
On 01:51 Fri 22 Jul , Timo Sirainen wrote:
> The initial report says:
>
> pgsql: Query failed, aborting: SELECT p.userid, p.password, u.uid AS
> userdb_uid, u.gid AS userdb_gid, u.home AS userdb_home, u.mail AS userdb_mail
> FROM dovecotpassword('test','pantsfullofunix.net') p, dovecotuser('test',
> 'pantsfullofunix.net') u WHERE doveadm
>
> So here it means that the passdb_query has something like "... WHERE
> %s". The %s expands to the service name, which could be any of imap,
> pop3, lmtp, doveadm, sieve, and several others. In this database
> apparently there are "imap" and "pop3" fields in the database but not
> "doveadm" and maybe not the others. When using "doveadm auth" without
> explicitly specifying the service name, it also defaults to "doveadm".
> This in turn leads to the query failing due to the doveadm field not
> existing in SQL. This is all working as intended and I can't think of
> anything that could be fixed or improved here on Dovecot's side. It's
> not only doveadm that is failing with this config, but various other
> pieces of Dovecot that just aren't (currently) being used by Martin.
>
Thanks for the clarification. Indeed, it looks as if there's not much we
can do on the Debian side either.
Martin, I guess you can work around this locally by rewriting your query
to not check the service name at all, if that's consistent with your
local policy.
Regards,
Apollon
