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 at example.com>, method=PLAIN, rip=, lip=, mpid=10879, TLS, ses...QOQBg9rlR> May 28 20:18:42 AmaechiJ dovecot[10516]: imap(aj at 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 at example.com,): User query failed: Table 'mailserver.users' doesn't exist May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< aj at 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
Amaechi Janneh wrote on 29/05/2017 02:47:> May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql( > aj at example.com,): User query failed: Table 'mailserver.users' doesn't existStart MySQL command line interface with the same username/password you use in Dovecot and do the same query Dovecot does. "mailserver" is the database name? -- Ciao, luigi / +--[Luigi Rosa]-- \ Never ascribe to malice that which is caused by greed and ignorance. --Cal Keegan
Yes it is. On Mon, May 29, 2017 at 12:28 AM, Luigi Rosa <lists at luigirosa.com> wrote:> Amaechi Janneh wrote on 29/05/2017 02:47: > > May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql( >> aj at example.com,): User query failed: Table 'mailserver.users' doesn't >> exist >> > > Start MySQL command line interface with the same username/password you use > in Dovecot and do the same query Dovecot does. > > "mailserver" is the database name? > > > > -- > > > Ciao, > luigi > > / > +--[Luigi Rosa]-- > \ > > Never ascribe to malice that which is caused by greed and ignorance. > --Cal Keegan >
On 29 May 2017 at 03:47, Amaechi Janneh <pokemonex222 at 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 at example.com>, method=PLAIN, rip=, lip=, mpid=10879, TLS, > ses...QOQBg9rlR> > May 28 20:18:42 AmaechiJ dovecot[10516]: imap(aj at 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 at example.com,): User query failed: Table 'mailserver.users' doesn't > exist > May 28 20:20:32 AmaechiJ dovecot[10516]: imap-login: Login: user=< > aj at 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."