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 >