On 22 Jul 2016, at 01:10, Apollon Oikonomopoulos <apoi...@debian.org> wrote:
>
> Hi Martin,
>
> On 22:00 Tue 12 Jul , martin f krafft wrote:
>> Attached is the auth conf. The failing command is 'doveadm auth'
>> without any -x parameter.
>
> I'm afraid we'll also need the actual query from dovecot-sql.conf.ext.
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.
