On 29 May 2017 at 03:47, Amaechi Janneh pokemonex222@gmail.com wrote:
Hello.
It appears that I have an issue with my dovecot setup. When trying to authenticate, i get this error:
May 28 20:18:26 AmaechiJ dovecot[10516]: imap-login: Login: user=< aj@example.com>, method=PLAIN, rip=, lip=, mpid=10879, TLS, ses...QOQBg9rlR> May 28 20:18:42 AmaechiJ dovecot[10516]: imap(aj@example.com): Connection closed in=116 out=1311 May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Warning: mysql: Query failed, retrying: Table 'mailserver.users' doesn't exist May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql( aj@example.com,): User query failed: Table 'mailserver.users' doesn't exist May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< aj@example.com>, method=PLAIN, rip=, lip=, mpid=10894, TLS, ses...QZwBg9rlR>
But I already have the users data under virtual_users. So what should I do?
Regards,
Amaechi Janneh
I am running dovecot 2.2.13 Debian 8
What does virtual_users have to do with a table named 'users' in the database named 'mailserver'?
I fear the Debian split configs, but maybe you should check your configuration in etc/dovecot/dovecot-sql.conf.ext or something close? Make sure the params there match what you want in terms of MySQL db and tables.
-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft."