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 o
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, rip=, lip=, mpid=10879, TLS
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
>>
>
> Start MySQL command l
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 sam
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]: i
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 t
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 nothi