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

Re: MySQL issue

On 29 May 2017 at 03:47, Amaechi Janneh wrote: > Hello. > > 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=< > a...@example.com>, method=PLAIN,

Re: MySQL issue

Yes it is. On Mon, May 29, 2017 at 12:28 AM, Luigi Rosa wrote: > Amaechi Janneh wrote on 29/05/2017 02:47: > > May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql( >> a...@example.com,): User query failed: Table 'mailserver.users' doesn't >> exist >> > >

Re: MySQL issue

Amaechi Janneh wrote on 29/05/2017 02:47: May 28 20:20:32 AmaechiJ dovecot[10516]: auth-worker(10892): Error: sql( a...@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

MySQL issue

Hello. 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=< a...@example.com>, method=PLAIN, rip=, lip=, mpid=10879, TLS, ses...QOQBg9rlR> May 28 20:18:42 AmaechiJ dovecot[10516]:

Re: [Dovecot] current quota in mysql issue

ok, i will answer my question by myself: from the dovecot wiki: You can configure quota globally by placing the settings in plugin section in dovecot.conf and you can give per-user limits by having your userdb return the quota setting as an extra field. The userdb quota setting always overrides

[Dovecot] current quota in mysql issue

hi all, i have a problem with storing the current quota in mysql. the configuration of the dictionary quota mostly looks like the example from the wiki. the dirsize quota limit is read correctly from the user_query, but nothing stored with quotadict in the quota table. i wonder that there is