Hi group:
I have a Docker Dovecot 2.4.2 installation with MySQL user management, with this record:
SELECT * FROM users; +---------------------------------------------------------------------------- | username | domain | password | home | uid | gid | active | quota | quotamsgs | crampassword
+---------------------------------------------------------------------------- | alberto | bersol.info | {MD5-CRYPT}$1$Jm... | /var/mail/alberto | 1000 | 1000 | Y | 3221225472 | 149999 | {CRAM-MD5}fd246... | +----------------------------------------------------------------------------
But I have a problem with user quota definitions...
If I run "doveadm" command, I get the user quota occupation, I have "quota_clone" plugin working, but I don't get user quota limit, I don't know why:
docker exec -it midovecot doveadm quota get -A
Username Quota name Type Value Limit % alberto@bersol.info User quota STORAGE 1925805 3145728 61 alberto@bersol.info User quota MESSAGE 37608 100000 37
That limit isn't the correct limit set in DB, but the one is put in the config, and it must to be override in my userdb:Extra Fields.
# docker exec -it midovecot doveadm config
2.4.2 (0962ed2104): /etc/dovecot/dovecot.conf
... userdb sql { iterate_query = SELECT CONCAT(username,'@',domain) AS user FROM users query = SELECT home,CONCAT(username,'@',domain) AS username,crampassword AS password,uid AS userdb_uid,gid AS userdb_gid,CONCAT(quota,'B') AS userdb_quota_storage_size,concat('*:messages=',quotamsgs) AS userdb_quota_storage_size FROM users WHERE username = '%{ user | username | lower }' AND domain = '%{ user | domain | lower }' } ... quota_storage_size = 3G quota_message_count = 100000 ...
Do you have any idea of the problem?
Best Regards, Alberto