Thanks for your samples, they would help me so much! My config is commented because i didn't know how to properly configure it, didn't understand theory to start doing things on practice. can you show me your dovecot-mysql.conf as well ? it should be final peace of puzzle for me. i'm interested in this two almost different user_query lines:

user_query = SELECT concat('/home/vmail/', maildir) as home, concat('maildir:/home/vmail/', maildir) as mail, 1001 AS uid, 12 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'

user_query = SELECT maildir, 1001 AS uid, 1001 AS gid, CONCAT('dict:storage=',floor(quota/1000),' proxy::quota') as quota FROM mailbox WHERE username = '%u' AND active='1'

first one provided from dovecot wiki and second one from postfixadmin docs regarding dovecot configuration. may i use user_query like this? :

user_query = SELECT concat('/home/vmail/', maildir) as home, concat('maildir:/home/vmail/', maildir) as mail, 1001 AS uid, 12 AS gid, CONCAT('dict:storage=',floor(quota/1000),' proxy::quota') AS quota FROM mailbox WHERE username = '%u' AND active = '1'

seems like this line doing some nice customization showing quota in kilobytes and not in bytes. or if someone could explain what does this string means. also what does this line means ?: concat('maildir:/home/vmail/', maildir) as mail string about home i understood dovecot reads users home dir from this line. And i dont understand if why should i indicate in 10-mail.conf next string: mail_location = maildir:/home/vmail/%d/%u If it is overided by user_query from mysql?

Also what is meaning of quota(2) table. does dovecot reading configuration from there or just stores usage information ? Also what does this string mean?: pattern = priv/quota/messages what privileges those who reads the, or where are they indicated ?

Thanks in advance. Denis.

Maybe stupid, but are these  plugin examples really from your dovecot.conf file ? If so remove the # before the quota lines!

this is my part from dovecot.conf (only relavant quota parts.)

 quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota.conf

plugin { # Quota config quota = dict:User quota::noenforcing:proxy::quotadict quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M quota_warning = storage=95%% quota-warning 95 %u quota_warning2 = storage=90%% quota-warning 90 %u quota_warning3 = storage=80%% quota-warning 80 %u #OTHER Plugins .... .... }

service quota-warning { executable = script /usr/local/bin/quota-warning.sh user = vmail unix_listener quota-warning { user = vmail } }

protocol imap { imap_client_workarounds = delay-newmail tb-extra-mailbox-sep imap_idle_notify_interval = 120 s imap_logout_format = bytes=%i/%o imap_max_line_length = 65536 mail_plugins = quota imap_quota autocreate acl imap_acl mail_log notify fts fts_squat }

protocol lmtp { auth_socket_path = /var/run/dovecot/auth-master mail_plugins = sieve quota acl mail_log notify postmaster_address = postmaster@yourdomain.com sendmail_path = /usr/local/sbin/sendmail }

Above protocol lmtp could be protocol lda in your case

This is my dovecot-dict-quota.conf  file

# Dovecot 2.0.x connect = host=192.xxx.xxx.xxx dbname=postfix user=postfix password=mypostfixpasswd map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages }

This is my /usr/local/bin/quota-warning.sh file

#!/usr/local/bin/bash PERCENT=$1 USER=$2 cat << EOF | /usr/local/libexec/dovecot/deliver -d $USER -o "plugin/quota=maildir:User quota:noenforcing" From: support@yourdomain.com Subject: quota warning

Uw mailbox is momenteel voor $PERCENT% gevult. Verwijder oude mail, of vraag een verruiming van uw quota aan.

Your mailbox is now $PERCENT% full. Please remove some old mail, or ask for a larger quota.

Skrzynka pocztowa jest w tym momencie w $PERCENT% zapelniona. Usun stare wiadomosci,albo przenies w inny folder.

EOF

Hope this helps.

Regards, Johan Hendriks Double L Automatisering

Hm, it looks very straighforward and not so flexible. i want get this string get working. some missconfiguration of arguments and syntax. i dont wanna mannually insert amount of message or bytes, if it's possible i would like everything to be read from database quota.conf Hope developers would see this thread and help also i understood aalmost all strings in query concat('/home/vmail/', maildir) as home - virtual users home directory concat('maildir:/home/vmail/', maildir) as mail - virtualusers maildirectory floor(quota/1000) - seems to be minimal quota for user. users quota devided by 1000

so for now i've tried to do next query string changed quota to quota_rule user_query = SELECT concat('/home/vmail/', maildir) as home, concat('maildir:/home/vmail/', maildir) as mail, 1001 AS uid, 12 AS gid, concat('dict:storage=',floor(quota/1000),' proxy::quotadict') AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1'

plugin { quota = dict:User quota::proxy::quotadict quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M }

dict { quotadict = mysql:/etc/dovecot/conf.d/sql/dovecot-dict-sql.conf # expire = sqlite:/etc/dovecot/dovecot-dict-sql.conf }

and now error

Jun 24 13:19:59 imap: Debug: Added userdb setting: mail=maildir:/home/vmail/office.dev/test/ Jun 24 13:19:59 imap: Debug: Added userdb setting: plugin/quota_rule=dict:storage=10240 proxy::quotadict Jun 24 13:19:59 imap(test@office.dev): Debug: Effective uid=1001, gid=12, home=/home/vmail/office.dev/test/ Jun 24 13:19:59 imap(test@office.dev): Debug: Quota root: name=User quota backend=dict args=:proxy::quotadict Jun 24 13:19:59 imap(test@office.dev): Warning: quota root User quota rule dict:storage=10240 proxy::quotadict: obsolete configuration for rule 'storage=10240 proxy' should be changed to 'storage=+10240 proxy' Jun 24 13:19:59 imap(test@office.dev): Debug: Quota rule: root=User quota mailbox=dict bytes=+10240 messages=0 Jun 24 13:19:59 imap(test@office.dev): Error: user test@office.dev: Initialization failed: Failed to initialize quota: Invalid quota root quota: Invalid rule dict:storage=10240 proxy::quotadict: Invalid rule limit value: storage=10240 proxy Jun 24 13:19:59 imap(test@office.dev): Error: Invalid user settings. Refer to server log for more information. Jun 24 13:19:59 imap-login: Info: Login: user=<test@office.dev>, method=PLAIN, rip=192.168.0.11, lip=192.168.0.31, mpid=5742, TLS Jun 24 13:19:59 imap-login: Warning: SSL alert: where=0x4008, ret=256: warning close notify [192.168.0.11]

Here it is.

# Database driver: mysql, pgsql driver = mysql

# Currently supported schemes include PLAIN, PLAIN-MD5, DIGEST-MD5, and CRYPT. default_pass_scheme = CRYPT

# Database options connect = host=192.xxx.xxx.xxx dbname=postfix user=postfix password=mypostfixpassword

password_query = select password
from mailbox where username = '%u'
and active = '1'

user_query = select maildir,
concat('*:messages=50000:bytes=', quota) as quota_rule
from mailbox where username = '%u' and active = '1'

Gr Johan