[Dovecot] Dict-server mysql module error
hi all when i setup plugin quota by quota = dict: mysql:/etc/quota-dict.conf i get the folowing error:
deliver(zzzz@zzzz.zz): Unknown dict module: mysql deliver(zzzz@zzz.zz): dict quota: dict_init() failed
quota-dict.conf:
connect = host=localhost dbname=zzzz user=zzzz password=zzzz table = mailbox select_field = quota where_field = maildir username_field = username
dovecot.conf: # 1.0.2: /etc/dovecot//dovecot.conf base_dir: /var/run/dovecot/ protocols: imap pop3 imaps pop3s ssl_disable: yes 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 first_valid_uid: 5000 mail_location: maildir:/mbox/%d/%u/Maildir 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 mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota 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 pop3_uidl_format(default): pop3_uidl_format(imap): pop3_uidl_format(pop3): %08Xu%08Xv auth default: passdb: driver: pam passdb: driver: sql args: /etc/dovecot-sql.conf userdb: driver: passwd userdb: driver: sql args: /etc/dovecot-sql.conf socket: type: listen master: path: /var/run/dovecot/auth-master mode: 384 user: vmail group: mail plugin: quota: dict:storage=10240:messages=1000 mysql:/etc/dovecot-dict-quota.conf quota_warning: storage=80% /usr/local/bin/quota_warning.sh 80 dict: quota: mysql:/etc/dovecot-dict-quota.conf
i applied the patch for quota warning message by nicolas.
thank you in advance Workino
On 16.7.2007, at 17.39, Gabriele Fergola wrote:
deliver(zzzz@zzzz.zz): Unknown dict module: mysql deliver(zzzz@zzz.zz): dict quota: dict_init() failed
You're trying to make deliver use mysql directly. That doesn't work,
you'll have to make it go through proxy as described in http://
wiki.dovecot.org/Quota/Dict
Based on your previous mail you apparently already tried that:
net_connect_unix(/usr/local/var/run/dovecot/dict-server) failed:
Permission denied
You can change this path from the quota proxy settings:
quota = dict:storage=10240:messages=1000 proxy:/var/run/dovecot/ dict-server:quotadict
Anyway, you might not want to use dict quota because it doesn't keep
track of quota properly when multiple sessions are modifying the
mailbox at the same time. With upcoming v1.1 this works properly.
participants (2)
-
Gabriele Fergola
-
Timo Sirainen