Re: MySQL issue

30 May 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@luigirosa.com
<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 &lt;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"