[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