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@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