Re: MySQL issue

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"