-----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 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
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 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?
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-----