[Dovecot] quota in mysql not being updated

Marshal Newrock marshal at idealso.com
Mon Jan 8 04:11:20 UTC 2007


I'm having trouble getting the quota plugin to work with deliver.
The quota in the database is not getting set.

I am using dovecot-1.0-rc15.  This server is not yet in production.
Some values below are because I'm trying to test with the simplest
possible case, and some because it's reading from a different
database.  Also, I noticed that "dovecot -n" doesn't display any
information for the lda, nor any plugin information.

Entries from /etc/dovecot/dovecot.conf:
protocol lda {
    ...
    mail_plugins = quota
}

auth default {
    ....
    userdb sql {
        args = /etc/dovecot/dovecot-sql.conf
    }
}

dict {
  quotadict = mysql:/etc/dovecot/dict-quota.conf
}

plugin {
    quota = dict:storage=1024000: proxy::quotadict
}

from dovecot-sql.conf:
user_query = SELECT 225 as uid, 225 as gid, mailbox_path as home,
mailbox_path as mail, 'dirsize:storage=10240:messages=1000' as quota
FROM transports WHERE email = '%u'

dict-quota.conf:
connect = ...
table = quota_used
select_field = quota_used_kb
where_field = quota_type
username_field = username_and_realm

in mysql:
describe quota_used;
+--------------------+--------------+------+-----+---------+-------+
| Field              | Type         | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| username_and_realm | varchar(255) | NO   | PRI |         |       | 
| quota_type         | varchar(255) | NO   | PRI |         |       | 
| quota_used_kb      | int(11)      | NO   |     | 0       |       | 
+--------------------+--------------+------+-----+---------+-------+

mail logs:
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
test.marshal at acd.net
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
uid=225
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
gid=225
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
home=/var/mail/vmail01/00/00000001
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
mail=/var/mail/vmail01/00/00000001
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): auth input:
quota=maildir:storage=1048576
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): Loading modules
from directory: /usr/lib/dovecot/lda
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): Module
loaded: /usr/lib/dovecot/lda/lib01_quota_plugin.so
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): maildir:
data=/var/mail/vmail01/00/00000001
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net): maildir:
root=/var/mail/vmail01/00/00000001,
index=/var/mail/vmail01/00/00000001, control=, inbox=
Jan  7 22:13:46 sentinel deliver(test.marshal at acd.net):
msgid=<20070107221155.0db93ce6 at localhost>: saved mail to INBOX


-- 
Marshal Newrock
Ideal Solution, LLC - http://www.idealso.com


More information about the dovecot mailing list