MySQL issue

Luigi Rosa lists at
Tue May 30 07:13:28 EEST 2017

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 at 
> <mailto:lists at>> wrote:
>     Amaechi Janneh wrote on 29/05/2017 02:47:
>         May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql(
>         aj at <mailto:aj at>,): 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?



+--[Luigi Rosa]--

If you rely only on your eyes, your other senses weaken.
     --Frank Herbert, "Dune"

More information about the dovecot mailing list