[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