[Dovecot] quota in mysql not being updated
Marshal Newrock
marshal at idealso.com
Mon Jan 8 14:02:51 UTC 2007
(Resent from the correct address. If this is an indication of how my
day will be going, I should go back to bed.)
Let's try this again, a little simpler. And making sure all the
information is correct and up to date. I eliminated setting the quota
from the userdb query.
dovecot.conf:
plugins {
quota = dict:storage=10240:messages=1000
mysql:/etc/dovecot/dict-quota.conf
}
(quota is all on one line, though)
dovecot-sql.conf:
user_query = SELECT 225 as uid, 225 as gid, mailbox_path as home,
mailbox_path as mail FROM transports WHERE email = '%u'
The log says:
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): auth input:
test.marshal at acd.net
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): auth input:
uid=225
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): auth input:
gid=225
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): auth input:
home=/var/mail/vmail01/00/00000001
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): auth input:
mail=/var/mail/vmail01/00/00000001
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): Loading modules
from directory: /usr/lib/dovecot/lda
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): Module
loaded: /usr/lib/dovecot/lda/lib01_quota_plugin.so
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): maildir:
data=/var/mail/vmail01/00/00000001
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): maildir:
root=/var/mail/vmail01/00/00000001,
index=/var/mail/vmail01/00/00000001, control=, inbox=
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): dict quota: uri
= mysql:/etc/dovecot/dict-quota.conf
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): dict quota:
byte limit = 1000
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): dict quota:
count limit = 0
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net):
Unknown dict module: mysql
Jan 8 08:45:07 sentinel deliver(test.marshal at acd.net): dict quota:
dict_init() failed
# dovecot --build-options
Build options: ioloop=epoll notify=dnotify openssl
SQL drivers: mysql
Passdb: checkpassword ldap pam passwd passwd-file shadow sql
Userdb: checkpassword ldap passwd prefetch passwd-file sql static
--
Marshal Newrock
Ideal Solution, LLC - http://www.idealso.com
More information about the dovecot
mailing list