search for: sqluserquota

...etting: plugin/quota_rule=*:bytes=102400000 May 1 18:09:48 mx1 dovecot: doveadm(192.168.1.10,screenie at test.domain): Debug: Effective uid=5000, gid=5000, home= May 1 18:09:48 mx1 dovecot: doveadm(192.168.1.10,screenie at test.domain): Debug: Quota root: name=User Quota backend=dict args=:proxy::sqluserquota May 1 18:09:48 mx1 dovecot: doveadm(192.168.1.10,screenie at test.domain): Debug: Quota rule: root=User Quota mailbox=* bytes=102400000 messages=0 May 1 18:09:48 mx1 dovecot: doveadm(192.168.1.10,screenie at test.domain): Debug: Quota rule: root=User Quota mailbox=Trash bytes=+10240000 (10%) mess...

...ole version 0.4.21 (92477967) # OS: Linux 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS auth_debug = yes auth_debug_passwords = yes auth_master_user_separator = * auth_mechanisms = plain login auth_verbose_passwords = yes dict { sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext } disable_plaintext_auth = no login_greeting = Dovecot ready. mail_debug = yes mail_location = maildir:~/Maildir mail_plugins = " quota" managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encod...

...x 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS > auth_debug = yes > auth_debug_passwords = yes > auth_master_user_separator = * > auth_mechanisms = plain login > auth_verbose_passwords = yes > dict { > sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext > sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext > } > disable_plaintext_auth = no > login_greeting = Dovecot ready. > mail_debug = yes > mail_location = maildir:~/Maildir > mail_plugins = " quota" > managesieve_notify_capability = mailto > managesieve_sieve_cap...

...= "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_ at +*#" base_dir = /var/run/dovecot/ debug_log_path = /var/log/dovecot/debug.log dict { expire = mysql:/etc/dovecot/dovecot-dict-sql-expire.conf sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf } info_log_path = /var/log/dovecot/info.log lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes listen = * log_path = /var/log/dovecot/main.log log_timestamp = "%Y-%m-%d %H:%M:%S " login_greeting = dovecot ready login_log_format = %...

...| | | messages | int(11) | NO | | 0 | | +----------+--------------+------+-----+---------+-------+ 3 rows in set (0,00 sec) 2. Two types of quota - for domains with index "2" and for users without index. ... plugin { quota = dict:user_quota::proxy::sqluserquota quota_rule2 = Trash:storage=+10%% quota_rule3 = Junk:storage=+10%% quota_warning = storage=100%% quota-exceeded 100 %u quota_warning2 = storage=95%% quota-warning 95 %u quota_warning3 = storage=90%% quota-warning 90 %u quota_warning4 = storage=75%% quota-warning 75 %u quota2 =...

...x 4.15.0-39-generic x86_64 Ubuntu 18.04.1 LTS > auth_debug = yes > auth_debug_passwords = yes > auth_master_user_separator = * > auth_mechanisms = plain login > auth_verbose_passwords = yes > dict { > sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext > sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext > } > disable_plaintext_auth = no > login_greeting = Dovecot ready. > mail_debug = yes > mail_location = maildir:~/Maildir > mail_plugins = " quota" > managesieve_notify_capability = mailto > managesieve_sieve_cap...

...;]; # rule:[SPAM] if header :contains "X-Spam-Level" "**********" { fileinto "Junk"; } Config ======= # 2.1.7: /etc/dovecot/dovecot.conf # OS: Linux 3.2.0-4-amd64 x86_64 Debian 7.3 ext4 dict { sqldomainquota = mysql:/etc/dovecot/dovecot-sql-domain.conf sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf } mail_location = maildir:/home/vmail/%d/%n/Maildir:INDEX=/home/vmail/%d/%n/Maildir/indexes mail_plugins = " quota" managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation sub...

...ir = /var/run/dovecot/ first_valid_gid = 1983 first_valid_uid = 1983 listen = * log_path = /var/log/dovecot.log mail_debug = yes mail_gid = virtual mail_location = maildir:/var/spool/mail/%d/%u mail_uid = virtual passdb { args = /usr/local/etc/dovecot/dovecot-sql.conf driver = sql } dict { sqluserquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-user.conf sqldomainquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-domain.conf } plugin { quota = dict:domain_quota:%d:proxy::sqldomainquota quota2 = dict:user_quota::proxy::sqluserquota quota2_rule2 = Trash:storage=+20%% quota2_rule3...

...pointers, or advice would be greatly appreciated. root at mail:/etc/dovecot/conf.d# dovecot -n # 2.0.19: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-042stab079.6 x86_64 Ubuntu 12.04.3 LTS reiserfs auth_mechanisms = plain login dict { sqldomainquota = mysql:/etc/dovecot/dovecot-sql-domain.conf sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf } first_valid_uid = 150 last_valid_uid = 150 mail_gid = mail mail_location = maildir:/var/vmail/%d/%n mail_plugins = quota mail_uid = vmail managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-characte...

...1 LTS > > auth_debug = yes > > auth_debug_passwords = yes > > auth_master_user_separator = * > > auth_mechanisms = plain login > > auth_verbose_passwords = yes > > dict { > > ? sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf.ext > > ? sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf.ext > > } > > disable_plaintext_auth = no > > login_greeting = Dovecot ready. > > mail_debug = yes > > mail_location = maildir:~/Maildir > > mail_plugins = " quota" > > managesieve_notify_capability...

...stuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_ at +*#" > base_dir = /var/run/dovecot/ > debug_log_path = /var/log/dovecot/debug.log > dict { > ? expire = mysql:/etc/dovecot/dovecot-dict-sql-expire.conf > ? sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf > ? sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf > } > info_log_path = /var/log/dovecot/info.log > lda_mailbox_autocreate = yes > lda_mailbox_autosubscribe = yes > listen = * > log_path = /var/log/dovecot/main.log > log_timestamp = "%Y-%m-%d %H:%M:%S " > login_greet...

...ve a configuration problem? dovecot -n # 2.0.19: /etc/dovecot/dovecot.conf # OS: Linux 3.5.0-51-generic x86_64 Ubuntu 12.04.4 LTS ext4 auth_debug = yes auth_debug_passwords = yes auth_mechanisms = plain login auth_verbose = yes dict { sqldomainquota = mysql:/etc/dovecot/dovecot-sql-domain.conf sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf } first_valid_uid = 150 last_valid_uid = 150 mail_debug = yes mail_gid = mail mail_location = maildir:/var/vmail/%d/%n mail_plugins = " quota quota acl" mail_uid = vmail managesieve_notify_capability = mailto managesieve_sieve_capability = f...

...KLMNOPQRSTUVWXYZ01234567890.-_ at +*#" >> base_dir = /var/run/dovecot/ >> debug_log_path = /var/log/dovecot/debug.log >> dict { >> expire = mysql:/etc/dovecot/dovecot-dict-sql-expire.conf >> sqldomainquota = mysql:/etc/dovecot/dovecot-dict-sql-domain.conf >> sqluserquota = mysql:/etc/dovecot/dovecot-dict-sql-user.conf >> } >> info_log_path = /var/log/dovecot/info.log >> lda_mailbox_autocreate = yes >> lda_mailbox_autosubscribe = yes >> listen = * >> log_path = /var/log/dovecot/main.log >> log_timestamp = "%Y-%m-%d %H:%...

I some add information about bug... Dovecot 2.2.19 version on server FreeBSD 10.2 Release. Config quota (dict + mysql) Database create Postfixadmin 2.3.7 Old version Dovecot 2.2.13 use method UPDATE in MySQL base + dict example mysql.log ----------------- Connect postfix at localhost on postfix 134 Query SELECT bytes FROM quota2 WHERE username = 'user at mydomain.lan'

...=on: MySQL database support > GSSAPI_BASE=on: Use GSSAPI from base Config: # doveconf -n # 2.2.27 (c0f36b0): /usr/local/etc/dovecot/dovecot.conf # Pigeonhole version 0.4.16 (fed8554) # OS: FreeBSD 11.0-RELEASE-p8 amd64 ufs auth_mechanisms = plain login default_login_user = dovecot dict { sqluserquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-user.conf } disable_plaintext_auth = no first_valid_gid = 0 first_valid_uid = 25 lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes login_access_sockets = tcpwrap login_greeting = Dovecot ready! login_log_format_elements = user=<%u> me...