I'm having a major problem converting my Dovecot configuration file to version 2.4.x. What I'm struggling with is using a dictionary to handle quotas within the MySQL backend (dict - plugin - Dovecot).
---------------------------- */etc/dovecot/dovecot.conf * ---------------------------- dict_server { dict quota { # driver = sql sql_driver = mysql mysql localhost { host = 127.0.0.1 port = 3306 dbname = dovecotdb user = dovecotdbadm password = p**** ssl = no } dict_map "priv/quota/storage" { sql_table = used_quota dict_map_username_field = username dict_map_value_field bytes { type = uint } } dict_map "priv/quota/messages" { sql_table = used_quota dict_map_username_field = username dict_map_value_field messages { type = uint } } } }
I'm using the Samba4 backend (LDAP) for authentication. However, I'd like to handle volume and quantity limits (storage: message count/bytes) using a table (as in the configuration). However, I can't find (where in the configuration file and which section to use) a place to embed the dictionary definition and use a proxy to connect to the MySQL backend.
Previously, in Dovecot version 2.3.x, the dictionary usage configuration (with proxy) could look like this:
dict { quotadict = mysql:/etc/dovecot/dovecot-used-quota.conf }
I'm also not sure if my approach is correct, because I expect that in the MariaDB (MySQL) log I should see information about database queries, database:
dovecotdb
according to the driver configuration - backend (dictionary)
From the Dovecot, documentation:
Dict quota; Dirsize quota These drivers are removed. You should use Quota Driver: Count instead along with quota-clone plugin.
Note that switching to quota count can cause all users' indexes to update, so reserve time for this.
Does this mean I can't use what I described in the question?