mailserver.users does not exist

[Steffen Kaiser]

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