[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