[Dovecot] vpopmail/mysql/quota

[Marty Diesburg]

Hi All,

I'm new to the list and have a quota question.  I am building a new server
with dovecot/qmail/vpopmail/mysql and
emails are sending and recieving fine when the quota is set to NOQUOTA, but
when the quota is changed qmail
doesn't deliver any messages.  I have read the docs and still need some help
understanding the process for dovecot
quotas relating to the vpopmail mysql database they are stored in.  Thanks
for your help.

Marty

# 1.2.8: /usr/local/etc/dovecot.conf
# OS: Linux 2.6.18-164.6.1.el5 i686 CentOS release 5.4 (Final)
protocols: imap pop3
ssl: no
disable_plaintext_auth: no
login_dir: /usr/local/var/run/dovecot/login
login_executable(default): /usr/local/libexec/dovecot/imap-login
login_executable(imap): /usr/local/libexec/dovecot/imap-login
login_executable(pop3): /usr/local/libexec/dovecot/pop3-login
first_valid_uid: 508
last_valid_uid: 508
first_valid_gid: 503
last_valid_gid: 503
mail_uid: 508
mail_gid: 503
mail_executable(default): /usr/local/libexec/dovecot/imap
mail_executable(imap): /usr/local/libexec/dovecot/imap
mail_executable(pop3): /usr/local/libexec/dovecot/pop3
mail_plugin_dir(default): /usr/local/lib/dovecot/imap
mail_plugin_dir(imap): /usr/local/lib/dovecot/imap
mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3
lda:
  postmaster_address: postmaster at teknickel.net
auth default:
  default_realm: teknickel.net
  verbose: yes
  debug: yes
  debug_passwords: yes
  passdb:
    driver: sql
    args: /home/vpopmail/dovecotsql.conf
  passdb:
    driver: vpopmail
    args: webmail=127.0.0.1
  userdb:
    driver: sql
    args: /home/vpopmail/dovecotsql.conf
  userdb:
    driver: vpopmaildriver = mysql
#
connect = host=/var/lib/mysql/mysql.sock user=vpopuser password=xxxxxxxx
dbname=vpopmail
#
default_pass_scheme = PLAIN
# NOTE: '\' line splitting works only with v1.1+


password_query = SELECT pw_clear_passwd AS password, CONCAT(pw_name, '@',
pw_domain) AS user FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'

user_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_dir as home,
508 AS uid, 503 AS gid, concat('maildir:backend=%q', pw_shell) AS quota_rule
FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d'
    args: quota_template=quota_rule=*:backend=%q
plugin:
  quota: maildir
----------------------------------------------------------------------------------------

dovecotsql.conf