[Dovecot] dovecot v-2.0, postfix+mysql configuration issue.

Oli Schacher dovecot at lists.wgwh.ch
Thu Mar 28 09:25:13 EET 2013

On Thu, 28 Mar 2013 11:48:42 +0530
Vimuth <vimuthd at gmail.com> wrote:

> Mar 26 07:00:44 box1 dovecot: auth: Error: sql(vimuth at mydomain.rock):
> User query failed: Table 'mailserver.users' doesn't exist (using
> built-in default user_query: SELECT home, uid, gid FROM users WHERE
> username = '%n' AND domain = '%d')

> here's *"/etc/dovecot/dovecot-sql.conf.ext"*

>driver = mysql
>connect = host= dbname=mailserver user=mailuser
>default_pass_scheme = MD5
>password_query = SELECT email as user, password FROM virtual_users

looks like the "user_query" is missing in this file and therefore
dovecot uses a builtin query which uses a different table name


More information about the dovecot mailing list