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
Amaechi Janneh wrote on 29/05/2017 02:47:
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
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
Yes it is.
On Mon, May 29, 2017 at 12:28 AM, Luigi Rosa lists@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@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
If you put the database name in the connect string you can omit it in the query
Append at the end of the connect string "dbname=mailserver" and remove "mailserver." from the table name
Of course the user you are using must have at least SELECT access to db mailserver
Amaechi Janneh wrote on 29/05/2017 22:30:
Yes it is.
On Mon, May 29, 2017 at 12:28 AM, Luigi Rosa
mailto:lists@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@example.com <mailto:aj@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]-- \
If you rely only on your eyes, your other senses weaken. --Frank Herbert, "Dune"
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."
participants (3)
-
Amaechi Janneh
-
Luigi Rosa
-
Odhiambo Washington