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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Sun, 28 May 2017, Amaechi Janneh wrote:
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
The error says that the place (SQL database) you've configured in Dovecot to look at is missing a table named 'mailserver.users'.
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?
What's the sameness of "virtual_users" and "mailserver.users"?
Show us your SQL definition and SQL database layout.
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1
iQEVAwUBWS5TAnz1H7kL/d9rAQLiGAf/f5fIwVTkZ/OEW3G+z3bpZT5YrMziROav QtJyFDIv+WQ3g7Y3HjaNK89MdVKqWJTn4P/slbfncl5F/a/BjKYyf1nHtl1E7SnY jSyuKcf6MOuj8jwfRyUzkkrl45sRsePMOro1xhDE5LqK2pIgrXflqJdDEEWdEvCX JRIG2oPw3NHzOVeMkjgps6I972OEBMsFCicRQT2MqGXEAY36qQ0Tm8Fekh01LG80 kwmeweMG9Ln87x8B7v0Pj8fb2kFFQhuGwFyr2C+HV0DoMZ4DVibZ1OujQaEmAkTN UHE59AgXGtjaN7/ZUfxK7J46zSQMxyi6HPspuAfjty45zjssZJ1HQw== =yEGO -----END PGP SIGNATURE-----
participants (2)
-
Amaechi Janneh
-
Steffen Kaiser