By the way, my quotas are configured to use SQL:
user_query = SELECT CONCAT('/home/vmail/', maildir) AS home, 997 AS uid, 996 AS
gid, CONCAT('*:bytes=', quota) AS quota_rule, CONCAT('maildir:storage=', quota)
AS quota FROM mailbox WHERE username = LOWER('%u') AND active = '1' AND
suspended = ‘0'
And when I run command "doveadm -D quota get -u [email protected]” i see In
MySQL query log that query is sent.
On 28 Apr 2015, at 12:00, Edgaras Lukoševičius <[email protected]>
wrote:
> Hello,
>
> after rebooting my dovecot server quotas are no longer working.
>
> # dovecot --version
> 2.2.10
>
> CentOS Linux release 7.0.1406
>
> It is strange that restarting dovecot did not reveal this problem, but
> rebooting whole server did.
>
>
>
> Before reboot it was like this:
>
> # doveadm -D quota get -u [email protected]
> doveadm(root): Debug: Loading modules from directory: /usr/lib64/dovecot
> doveadm(root): Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so
> doveadm(root): Debug: Loading modules from directory:
> /usr/lib64/dovecot/doveadm
> 03NB0d9erYBwhnzXhbS66fLDMU8v4ZiCDQDM3tDHCKme4ujpHy/lRk33305AIO9UXtgHGFyJYSpcVgoVnXJQGpJBphGvkAF4XI1JGx83Dtlb44wgJ8ZBgOm4qSNOoQIXKv0NO35EwUohtYBMlDJKPRUTwRF93tW7RsfWZGVNi4Eo5k616Tn4ooU3JMXkQA8LZ5zzLllspBVDbyb4GPAmWiw==
> root@ovzcloud
> doveadm(root): Debug: Skipping module doveadm_acl_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib10_doveadm_acl_plugin.so: undefined
> symbol: acl_user_module (this is usually intentional, so just ignore this
> message)
> doveadm(root): Debug: Skipping module doveadm_expire_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib10_doveadm_expire_plugin.so: undefined
> symbol: expire_set_deinit (this is usually intentional, so just ignore this
> message)
> doveadm(root): Debug: Module loaded:
> /usr/lib64/dovecot/doveadm/lib10_doveadm_quota_plugin.so
> doveadm(root): Debug: Module loaded:
> /usr/lib64/dovecot/doveadm/lib10_doveadm_sieve_plugin.so
> doveadm(root): Debug: Skipping module doveadm_fts_lucene_plugin, because
> dlopen() failed:
> /usr/lib64/dovecot/doveadm/lib20_doveadm_fts_lucene_plugin.so: undefined
> symbol: lucene_index_iter_deinit (this is usually intentional, so just ignore
> this message)
> doveadm(root): Debug: Skipping module doveadm_fts_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib20_doveadm_fts_plugin.so: undefined
> symbol: fts_backend_rescan (this is usually intentional, so just ignore this
> message)
> doveadm([email protected]): Debug: Added userdb setting:
> plugin/quota=maildir:storage=512000000
> doveadm([email protected]): Debug: Added userdb setting:
> plugin/quota_rule=*:bytes=512000000
> doveadm([email protected]): Debug: Effective uid=997, gid=996,
> home=/home/vmail/t/e/testdomain1.tld/test1/
> doveadm([email protected]): Debug: Quota root: name=storage=512000000
> backend=maildir args=
> doveadm([email protected]): Debug: Quota rule: root=storage=512000000
> mailbox=* bytes=512000000 messages=0
> doveadm([email protected]): Debug: Quota warning: bytes=486400000 (95%)
> messages=0 reverse=no command=quota-warning 95 [email protected]
> doveadm([email protected]): Debug: Quota warning: bytes=409600000 (80%)
> messages=0 reverse=no command=quota-warning 80 [email protected]
> doveadm([email protected]): Debug: Quota grace: root=storage=512000000
> bytes=25600000 (5%)
> doveadm([email protected]): Debug: Namespace inbox: type=private,
> prefix=INBOX., sep=., inbox=yes, hidden=no, list=yes, subscriptions=yes
> location=maildir:/home/vmail/t/e/testdomain1.tld/test1/
> doveadm([email protected]): Debug: maildir++:
> root=/home/vmail/t/e/testdomain1.tld/test1, index=, indexpvt=, control=,
> inbox=/home/vmail/t/e/testdomain1.tld/test1, alt=
> doveadm([email protected]): Debug: Namespace : type=private, prefix=,
> sep=, inbox=no, hidden=yes, list=no, subscriptions=no
> location=fail::LAYOUT=none
> doveadm([email protected]): Debug: none: root=, index=, indexpvt=,
> control=, inbox=, alt=
> Quota name Type Value Limit
> %
> storage=512000000 STORAGE 0 500000
> 0
> storage=512000000 MESSAGE 0 -
>
>
>
> Now after rebooting i get this output:
>
> # doveadm -D quota get -u [email protected]
> doveadm(root): Debug: Loading modules from directory: /usr/lib64/dovecot
> doveadm(root): Debug: Module loaded: /usr/lib64/dovecot/lib10_quota_plugin.so
> doveadm(root): Debug: Loading modules from directory:
> /usr/lib64/dovecot/doveadm
> doveadm(root): Debug: Skipping module doveadm_acl_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib10_doveadm_acl_plugin.so: undefined
> symbol: acl_user_module (this is usually intentional, so just ignore this
> message)
> doveadm(root): Debug: Skipping module doveadm_expire_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib10_doveadm_expire_plugin.so: undefined
> symbol: expire_set_deinit (this is usually intentional, so just ignore this
> message)
> doveadm(root): Debug: Module loaded:
> /usr/lib64/dovecot/doveadm/lib10_doveadm_quota_plugin.so
> doveadm(root): Debug: Module loaded:
> /usr/lib64/dovecot/doveadm/lib10_doveadm_sieve_plugin.so
> doveadm(root): Debug: Skipping module doveadm_fts_lucene_plugin, because
> dlopen() failed:
> /usr/lib64/dovecot/doveadm/lib20_doveadm_fts_lucene_plugin.so: undefined
> symbol: lucene_index_iter_deinit (this is usually intentional, so just ignore
> this message)
> doveadm(root): Debug: Skipping module doveadm_fts_plugin, because dlopen()
> failed: /usr/lib64/dovecot/doveadm/lib20_doveadm_fts_plugin.so: undefined
> symbol: fts_backend_rescan (this is usually intentional, so just ignore this
> message)
> doveadm([email protected]): Debug: Added userdb setting:
> plugin/quota=maildir:storage=512000000
> doveadm([email protected]): Debug: Added userdb setting:
> plugin/quota_rule=*:bytes=512000000
> doveadm([email protected]): Debug: Effective uid=997, gid=996,
> home=/home/vmail/t/e/testdomain1.tld/test1/
> doveadm([email protected]): Debug: Namespace inbox: type=private,
> prefix=INBOX., sep=., inbox=yes, hidden=no, list=yes, subscriptions=yes
> location=maildir:/home/vmail/t/e/testdomain1.tld/test1/
> doveadm([email protected]): Debug: maildir++:
> root=/home/vmail/t/e/testdomain1.tld/test1, index=, indexpvt=, control=,
> inbox=/home/vmail/t/e/testdomain1.tld/test1, alt=
> doveadm([email protected]): Debug: Namespace : type=private,
> prefix=POP3-MIGRATION-NS/, sep=, inbox=no, hidden=yes, list=no,
> subscriptions=yes location=pop3c:
> doveadm([email protected]): Debug: fs: root=, index=, indexpvt=,
> control=, inbox=, alt=
> doveadm([email protected]): Debug: Namespace : type=private, prefix=,
> sep=, inbox=no, hidden=yes, list=no, subscriptions=no
> location=fail::LAYOUT=none
> doveadm([email protected]): Debug: none: root=, index=, indexpvt=,
> control=, inbox=, alt=
> doveadm([email protected]): Error: Quota not enabled
> Quota name Type Value Limit
> %
>
>
>
>
> # egrep -v "^#|^$" /etc/dovecot/conf.d/90-quota.conf
> plugin {
> quota = maildir
> #quota_rule = *:storage=1G
> #quota_rule2 = Trash:storage=+100M
> # LDA/LMTP allows saving the last mail to bring user from under quota to
> # over quota, if the quota doesn't grow too high. Default is to allow as
> # long as quota will stay under 10% above the limit. Also allowed e.g. 10M.
> #quota_grace = 10%%
> quota_grace = 5%%
> quota_status_success = DUNNO
> quota_status_nouser = DUNNO
> quota_status_overquota = "552 5.2.2 Mailbox is full"
> }
> plugin {
> quota_warning = storage=95%% quota-warning 95 %u
> quota_warning2 = storage=80%% quota-warning 80 %u
> }
> plugin {
> #quota = dirsize:User quota
> #quota = maildir:User quota
> #quota = dict:User quota::proxy::quota
> #quota = fs:User quota
> }
> plugin {
> #quota = dict:user::proxy::quota
> #quota2 = dict:domain:%d:proxy::quota_domain
> #quota_rule = *:storage=102400
> #quota2_rule = *:storage=1048576
> }
> service quota-warning {
> executable = script /usr/local/bin/quota-warning.sh
> user = dovecot
> unix_listener quota-warning {
> user = vmail
> }
> }
> service quota-status {
> executable = quota-status -p postfix
> inet_listener {
> port = 12340
> # You can choose any port you want
> }
> client_limit = 1
> }
