MySQL issue

Luigi Rosa lists at luigirosa.com
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 luigirosa.com 
> <mailto:lists at 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 at example.com <mailto:aj at 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"


More information about the dovecot mailing list