Antonio Casado RodrÃguez
2010-May-24 12:57 UTC
[Dovecot] Problem with deliver and quota userdb sql
I have quota with userdb sql override. When i overpass 100M deliver
reject the message. I have 200M in sql. Deliver don't query the database.
What happen in it?
# 1.2.11: /etc/dovecot.conf
# OS: Linux 2.6.9-89.0.25.ELsmp i686 Red Hat Enterprise Linux AS release
4 (Nahant Update 8) ext3
log_path: /var/log/dovecot/dovecot.log
info_log_path: /var/log/dovecot/dovecot.info
protocols: imaps managesieve
ssl_cert_file: /etc/httpd/conf/ssl.crt/alboran.ual.es.dovecot_mas_ca.crt
ssl_key_file: /etc/httpd/conf/ssl.key/server.key
login_dir: /var/run/dovecot/login
login_executable(default): /usr/libexec/dovecot/imap-login
login_executable(imap): /usr/libexec/dovecot/imap-login
login_executable(managesieve): /usr/local/libexec/dovecot/managesieve-login
verbose_proctitle: yes
mail_location: maildir:/var/spool/mail/%n
mail_executable(default): /usr/sbin/post-login-dovecot
mail_executable(imap): /usr/sbin/post-login-dovecot
mail_executable(managesieve): /usr/local/libexec/dovecot/managesieve
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(managesieve):
mail_plugin_dir(default): /usr/lib/dovecot/imap
mail_plugin_dir(imap): /usr/lib/dovecot/imap
mail_plugin_dir(managesieve): /usr/lib/dovecot/managesieve
namespace:
type: private
separator: /
location: maildir:/var/spool/mail/%n
inbox: yes
list: yes
subscriptions: yes
lda:
postmaster_address: postmaster at alboran.ual.es
mail_plugins: quota sieve
log_path: /var/log/dovecot/dovecot-deliver.log
info_log_path: /var/log/dovecot/dovecot-deliver.log
auth default:
master_user_separator: *
passdb:
driver: passwd-file
args: /etc/passwd.masterusers
master: yes
passdb:
driver: pam
userdb:
driver: sql
args: /etc/dovecot-sql.conf
userdb:
driver: passwd
plugin:
quota: maildir
quota_rule: *:storage=100M
quota_rule2: Trash:storage=15M
sieve_dir: ~/sieve
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3322 bytes
Desc: S/MIME Cryptographic Signature
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20100524/4fa2f5b2/attachment-0002.bin>
Antonio Casado RodrÃguez
2010-May-25 12:41 UTC
[Dovecot] Problem with deliver and quota userdb sql
Hi all. The way for deliver read "user_query" is to use "deliver -n" in main.cf of postfix, Is it? El 24/05/2010 14:57, Antonio Casado Rodr?guez escribi?:> I have quota with userdb sql override. When i overpass 100M deliver > reject the message. I have 200M in sql. Deliver don't query the database. > > What happen in it? > > # 1.2.11: /etc/dovecot.conf > # OS: Linux 2.6.9-89.0.25.ELsmp i686 Red Hat Enterprise Linux AS > release 4 (Nahant Update 8) ext3 > log_path: /var/log/dovecot/dovecot.log > info_log_path: /var/log/dovecot/dovecot.info > protocols: imaps managesieve > ssl_cert_file: /etc/httpd/conf/ssl.crt/alboran.ual.es.dovecot_mas_ca.crt > ssl_key_file: /etc/httpd/conf/ssl.key/server.key > login_dir: /var/run/dovecot/login > login_executable(default): /usr/libexec/dovecot/imap-login > login_executable(imap): /usr/libexec/dovecot/imap-login > login_executable(managesieve): > /usr/local/libexec/dovecot/managesieve-login > verbose_proctitle: yes > mail_location: maildir:/var/spool/mail/%n > mail_executable(default): /usr/sbin/post-login-dovecot > mail_executable(imap): /usr/sbin/post-login-dovecot > mail_executable(managesieve): /usr/local/libexec/dovecot/managesieve > mail_plugins(default): quota imap_quota > mail_plugins(imap): quota imap_quota > mail_plugins(managesieve): > mail_plugin_dir(default): /usr/lib/dovecot/imap > mail_plugin_dir(imap): /usr/lib/dovecot/imap > mail_plugin_dir(managesieve): /usr/lib/dovecot/managesieve > namespace: > type: private > separator: / > location: maildir:/var/spool/mail/%n > inbox: yes > list: yes > subscriptions: yes > lda: > postmaster_address: postmaster at alboran.ual.es > mail_plugins: quota sieve > log_path: /var/log/dovecot/dovecot-deliver.log > info_log_path: /var/log/dovecot/dovecot-deliver.log > auth default: > master_user_separator: * > passdb: > driver: passwd-file > args: /etc/passwd.masterusers > master: yes > passdb: > driver: pam > userdb: > driver: sql > args: /etc/dovecot-sql.conf > userdb: > driver: passwd > plugin: > quota: maildir > quota_rule: *:storage=100M > quota_rule2: Trash:storage=15M > sieve_dir: ~/sieve >