(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@acd.net): auth input: test.marshal@acd.net Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): auth input: uid=225 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): auth input: gid=225 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): auth input: home=/var/mail/vmail01/00/00000001 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): auth input: mail=/var/mail/vmail01/00/00000001 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): Loading modules from directory: /usr/lib/dovecot/lda Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): Module loaded: /usr/lib/dovecot/lda/lib01_quota_plugin.so Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): maildir: data=/var/mail/vmail01/00/00000001 Jan 8 08:45:07 sentinel deliver(test.marshal@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@acd.net): dict quota: uri = mysql:/etc/dovecot/dict-quota.conf Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): dict quota: byte limit = 1000 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): dict quota: count limit = 0 Jan 8 08:45:07 sentinel deliver(test.marshal@acd.net): Unknown dict module: mysql Jan 8 08:45:07 sentinel deliver(test.marshal@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