search for: sqldomainquota

...age=+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 = dict:domain_quota:%d:proxy::sqldomainquota } dict { sqluserquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-user.conf sqldomainquota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql-domain.conf } service dict { unix_listener dict { user = mailnull mode = 0660 } } ... 3. Both stored in the same table and files "d...

...ten = * 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 = Junk:storage=+20%% quota2_grace = 10%% quota2_warning = storage=100%...

...dovecot -n # 2.2.33.2 (d6601f4ec): /etc/dovecot/dovecot.conf # Pigeonhole 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 =...

...cot/dovecot.conf > # Pigeonhole 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&qu...

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'

...est.testing.local auth_mechanisms = plain login auth_username_chars = "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 %...

...cot/dovecot.conf > # Pigeonhole 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&qu...

On 17 Oct 2015, at 12:41, Timo Sirainen <tss at iki.fi> wrote: > >> Connect postfix at localhost on postfix >> 134 Query SELECT bytes FROM quota2 WHERE username = >> 'user at mydomain.lan' >> 135 Query SELECT bytes FROM quota2 WHERE username = >> 'user at mydomain.lan' >> 135 Query BEGIN

...--------------------------------- require ["fileinto"]; # 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_capabili...

...y an error in how I'm using my SQL queries. Any guidance, 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_...

...on 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 >...

...= plain login > auth_username_chars = > "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.lo...

...quota limit of user2! Is this possible? Is this a bug? Do I have 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...

...auth_username_chars = >> "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...