28 Mar
2013
28 Mar
'13
9:25 a.m.
On Thu, 28 Mar 2013 11:48:42 +0530 Vimuth <vimuthd@gmail.com> wrote:
Mar 26 07:00:44 box1 dovecot: auth: Error: sql(vimuth@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