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