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
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."
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 <lists@luigirosa.com <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"
participants (3)
-
Amaechi Janneh
-
Luigi Rosa
-
Odhiambo Washington