[Dovecot] Cant't get quota / dict work

Nicola Tiling nti at w4w.net
Wed Jul 2 12:47:44 EEST 2008


Hi

I have a mixed configuration for MAILDIR und MBOX accounts  LDA is  
exim. For maildir exim writes a maildirsize file and I can see the  
IMAP contingent in my mailclient.

But I can't find a solution for mbox. I tried dict with mysql, db, and  
pgsql - but notihing works for me.

- db: a file is written but it seems to be empty:
  1013 [mail] =db_dump-4.6 -p quota.db
VERSION=3
format=print
type=btree
db_pagesize=4096
HEADER=END
  priv/quota/messages
  0
  priv/quota/storage
  0
DATA=END

- mysql: the dict-server connects, but nothing is written to the table
dovecot: Jul 02 11:24:13 Info: dict: mysql: Connected to mail
the mysql log shows no entries for an update or insert to the table  
"quota"

- pgsql: same: the dict-server connects, but nothing is written to the  
table
dovecot: Jul 02 10:56:45 Info: dict: pgsql: Connected to mail
the pgsql log shows no activities

System:
FreeBSD 6.2-STABLE-200709

dict-quota.conf:
connect = host= ...
table = quota
select_field = current
where_field = path
username_field = username

Dovecot:
  1027 [mail] =dovecot --version
1.1.1
  1046 [mail] =dovecot --build-options
Build options: ioloop=kqueue notify=kqueue openssl
Mail storages: maildir mbox dbox cydir raw
SQL drivers: mysql postgresql
Passdb: checkpassword passwd passwd-file sql
Userdb: checkpassword passwd prefetch passwd-file sql static
  1047 [mail] =dovecot -n
# 1.1.1: /usr/local/etc/dovecot.conf
base_dir: /var/run/dovecot
log_path: /var/log/dovecot/dovecot
info_log_path: /var/log/dovecot/dovecot
protocols: imap imaps pop3 pop3s
...
disable_plaintext_auth: no
shutdown_clients: no
login_dir: /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
login_greeting: W4W Dovecot ready.
login_process_per_connection: no
verbose_proctitle: yes
first_valid_uid: 99
last_valid_uid: 99
first_valid_gid: 99
last_valid_gid: 99
mail_privileged_group: pop3

mail_location: mbox:/var/mbox/%u/mail:INBOX=/var/pop3/%u:INDEX=/var/ 
mbox/%u/indexes
(for maildir values comes from database)

mbox_write_locks: fcntl dotlock
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_plugins(default): quota imap_quota expire autocreate
mail_plugins(imap): quota imap_quota expire autocreate
mail_plugins(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
imap_client_workarounds(default): delay-newmail outlook-idle netscape- 
eoh tb-extra-mailbox-sep
imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh  
tb-extra-mailbox-sep
imap_client_workarounds(pop3):
pop3_lock_session(default): no
pop3_lock_session(imap): no
pop3_lock_session(pop3): yes
pop3_client_workarounds(default):
pop3_client_workarounds(imap):
pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh
dict_db_config: /usr/local/etc/dovecot/dovecot-db.conf
auth default:
   mechanisms: plain login
   user: dovecot_auth
   verbose: yes
   passdb:
     driver: sql
     args: /usr/local/etc/dovecot/pgsql.conf
   userdb:
     driver: prefetch
   userdb:
     driver: sql
     args: /usr/local/etc/dovecot/pgsql.conf
   socket:
     type: listen
     client:
       path: /var/run/dovecot/auth-client
       mode: 432
     master:
       path: /var/run/dovecot/auth-master
       mode: 384
plugin:
   autocreate: Sent
   autocreate2: Trash
   autocreate3: Drafts
   autocreate4: Junk
   autosubscribe: Sent
   autosubscribe2: Trash
   autosubscribe3: Drafts
   autosubscribe4: Junk
   expire: Trash 1 Trash/* 1 Junk 1
   expire_dict: proxy:/var/run/dovecot/dict-server:expire
   quota: maildir
   quota2: dict:::proxy:/var/run/dovecot/dict-server:quota
   quota_rule: *:storage=20M
   quota_rule2: Trash:storage=10M
   quota_rule3: Spam:storage=20M
   quota_rule4: Junk:storage=20M
   quota2_rule: *:storage=20M
   quota2_rule2: Trash:storage=10M
   quota2_rule3: Spam:storage=20M
   quota2_rule4: Junk:storage=20M
dict:
   expire: db:/usr/local/lib/dovecot/db/expire.db
   quota: mysql:/usr/local/etc/dovecot/dict-quota.conf
   or:
   quota: pgsql:/usr/local/etc/dovecot/dict-quota.conf
   or:
   quota = db:/usr/local/lib/dovecot/db/quota.db





  
  


More information about the dovecot mailing list