Bug#804622: -x auth_info is a required parameter, at least with SQL

[martin f krafft]

also sprach Apollon Oikonomopoulos <apoi...@debian.org> [2016-02-23 15:30 
+0100]:
> > When invoking doveadm auth without any -x parameter, the SQL
> > database sees the following invalid query:
> > 
> >    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
> >    Error: sql(t...@pantsfullofunix.net): Password query failed: ERROR:  
> > column "doveadm" does not exist
> 
> Unfortunately I am not able to reproduce this, however this query looks 
> terribly malformed :) Can you share the actual auth-sql.conf.ext as well 
> as the exact doveadm command that fails?

Attached is the auth conf. The failing command is 'doveadm auth'
without any -x parameter.

Thanks for looking into this, and sorry for the late reply!

-- 
 .''`.   martin f. krafft <madduck@d.o> @martinkrafft
: :'  :  proud Debian developer
`. `'`   http://people.debian.org/~madduck
  `-  Debian - when you have better things to do than fixing systems
 
"america may be unique in being a country which has leapt
 from barbarism to decadence without touching civilization."
                                                      -- john o'hara

# Authentication for SQL users. Included from 10-auth.conf.
#
# <doc/wiki/AuthDatabase.SQL.txt>

passdb {
  driver = sql

  # Path for SQL configuration file, see example-config/dovecot-sql.conf.ext
  args = /etc/dovecot/dovecot-sql.conf.ext
}

# "prefetch" user database means that the passdb already provided the
# needed information and there's no need to do a separate userdb lookup.
# <doc/wiki/UserDatabase.Prefetch.txt>
userdb {
  driver = prefetch
}

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

# If you don't have any user-specific settings, you can avoid the user_query
# by using userdb static instead of userdb sql, for example:
# <doc/wiki/UserDatabase.Static.txt>
#userdb {
  #driver = static
  #args = uid=vmail gid=vmail home=/var/vmail/%u
#}

signature.asc
Description: PGP signature