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 % [email protected] User quota STORAGE 1925805 3145728 61 [email protected] 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

_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to