Aaaand... fixed.
quota plugin was disabled in doveadm protocol as in:
protocol doveadm {
#mail_plugins = $mail_plugins pop3_migration
mail_plugins = pop3_migration
}
Added ‘quota' to mail_plugins
Now I don’t know why that wasn’t a problem after issuing “systemctl restart
dovecot”, but at least it works now.
On 28 Apr 2015, at 14:25, Edgaras Lukoševičius <[email protected]>
wrote:
> 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
>> }
>
