Getting quota limits from DB

Alberto via dovecot <[email protected]>
Newsgroups gmane.mail.imap.dovecot
Message-ID <[email protected]>
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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.