On 29 May 2017 at 03:47, Amaechi Janneh <pokemonex...@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=< > a...@example.com>, method=PLAIN, rip=, lip=, mpid=10879, TLS, > ses...QOQBg9rlR> > May 28 20:18:42 AmaechiJ dovecot[10516]: imap(a...@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( > a...@example.com,): User query failed: Table 'mailserver.users' doesn't > exist > May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< > a...@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."