[Dovecot] current quota in mysql issue

[stefan at webetc.de]

ok, i will answer my question by myself:

from the dovecot wiki:
"You can configure quota globally by placing the settings in plugin
section in dovecot.conf and you can give per-user limits by having your
userdb return the quota setting as an extra field. The userdb quota
setting always overrides the global plugin setting."

stefan


> hi all,
>
> i have a problem with storing the current quota in mysql. the
> configuration of the dictionary quota mostly looks like the example from
> the wiki.
> the dirsize quota limit is read correctly from the user_query, but nothing
> stored with quotadict in the quota table. i wonder that there is nothing
> like a "dict" in the logfile. did i configured anything wrong?
>
> regars
> stefan
>
>
> logfile from a imap login:
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): Effective uid=150,
> gid=8
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): Loading modules from
> directory: /usr/lib/dovecot/modules/imap
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): Module loaded:
> /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): Module loaded:
> /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): Namespace:
> type=private, prefix=, sep=/, inbox=yes, hidden=no, subscriptions=no
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): maildir:
> data=/var/vmail/mydomain.de/me/Maildir
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): maildir:
> root=/var/vmail/mydomain.de/me/Maildir,
> index=/var/vmail/mydomain.de/me/Maildir, control=, inbox=
> Mar 15 14:12:18 mx01 dovecot: IMAP(me at mydomain.de): dirsize quota limit =
> 20000000kB
> Mar 15 14:12:18 mx01 dovecot: imap-login: Login: user=<me at mydomain.de>,
> method=PLAIN, rip=10.1.1.147, lip=10.1.1.146
>
>
> here is my current config:
>
> package from debian etch (1.0.rc15)
>
> ###
> # file dovecot.conf
> disable_plaintext_auth = no
> base_dir = /var/run/dovecot/
> protocols = imap imaps pop3 pop3s
> protocol imap {
>   listen = mx01.int.example.net:143
>   ssl_listen = mx01.int.example.net:993
> }
> protocol pop3 {
>   listen = mx01.int.example.net:110
>   ssl_listen = mx01.int.example.net:995
> }
> log_timestamp = .%Y-%m-%d %H:%M:%S .
> syslog_facility = mail
> ssl_cert_file = /etc/ssl/example.net/mailserver/mail-cert.pem
> ssl_key_file = /etc/ssl/example.net/mailserver/mail-key.pem
> ssl_ca_file = /etc/ssl/example.net/mailserver/ca.pem
> ssl_parameters_regenerate = 168
> verbose_ssl = no
> mail_extra_groups = mail
> mail_debug = yes
> auth_verbose = no
> auth_debug = no
> auth_debug_passwords = no
> first_valid_uid = 150
> last_valid_uid = 150
> first_valid_gid = 8
> last_valid_gid = 8
> maildir_copy_with_hardlinks = yes
> protocol imap {
>   login_executable = /usr/lib/dovecot/imap-login
>   mail_executable = /usr/lib/dovecot/imap
>   imap_client_workarounds = outlook-idle
>   imap_max_line_length = 65536
>   mail_plugins = quota imap_quota
> }
> protocol pop3 {
>   login_executable = /usr/lib/dovecot/pop3-login
>   mail_executable = /usr/lib/dovecot/pop3
>   mail_plugins = quota
> }
> protocol lda {
>   postmaster_address = postmaster at mydomain.com
>   sendmail_path = /usr/lib/sendmail
>   auth_socket_path = /var/run/dovecot/auth-master
>   mail_plugins = cmusieve quota
> }
> auth_username_translation = %Lu
> auth default {
>   mechanisms = plain
>     passdb sql {
>       args = /etc/dovecot/dovecot-sql.conf
>     }
>     userdb sql {
>       args = /etc/dovecot/dovecot-sql.conf
>     }
>     user = nobody
>     socket listen {
>     master {
>       path = /var/run/dovecot/auth-master
>       mode = 0660
>       user = vmail
>       group = mail
>     }
>     client {
>       path = /var/spool/postfix/private/auth
>       mode = 0660
>       user = postfix
>       group = postfix
>     }
>   }
> }
> namespace private {
>   separator = /
>   prefix =
>   inbox = yes
>  }
> plugin {
>   quota = dict::: proxy::quotadict
> }
> dict {
>   quotadict = mysql:/etc/dovecot/dovecot-sql-quota-dict.conf
> }
>
> ###
> # file dovecot-sql.conf
> driver = mysql
> connect = host=mx01.int.example.net dbname=db_mail user=dovecot
> password=********
> default_pass_scheme = PLAIN
> user_query = select concat('/var/vmail/%d/%n/Maildir') as home,
> concat('maildir:/var/vmail/%d/%n/Maildir') as mail, 150 as uid, 8 as gid,
> quota from qry_dovecot where user = '%u'
> password_query = select user, password, concat('/var/vmail/%d/%n') as
> userdb_home, concat('maildir:/var/vmail/%d/%n') as userdb_mail, 150 as
> userdb_uid, 8 as userdb_gid from qry_dovecot where user = '%u'
>
> ###
> # file dovecot-sql-quota-dict.conf
> connect = host=db01.int.example.net dbname=db_mail user=quota
> password==********
> table = quota
> select_field = current
> where_field = path
> username_field = username
>
> (don't wonder about the different database hosts. mx01 is a readonly slave
> from db01)
>
>
>
>
>
>