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

[Oli Schacher]

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=127.0.0.1 dbname=mailserver user=mailuser
>password=redhat
>default_pass_scheme = MD5
>password_query = SELECT email as user, password FROM virtual_users
>WHERE
>email='%u';  

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

http://wiki2.dovecot.org/AuthDatabase/SQL