search for: quota2

Displaying 20 results from an estimated 166 matches for "quota2".

Did you mean: quota
2019 Feb 12
2
Maintaining table quota2
On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote: >> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: >> >> >> Does dovecot compute that values for quota2 with each email it updates >> for the user?? Or only an incremental change? >> >> I ask because I am looking at migrating all the user mail from the old >> server to the new and building a new sql database.? All I see is: >> >> dovecot-dict-sql.conf.ext: connect...
2019 Feb 12
2
Maintaining table quota2
Does dovecot compute that values for quota2 with each email it updates for the user?? Or only an incremental change? I ask because I am looking at migrating all the user mail from the old server to the new and building a new sql database.? All I see is: dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock dbname=postfix u...
2013 Oct 19
6
[Bug 866] New: Missing newline with --list-rules
...: 2.0 It appears that Android has again been too lazy to include something that should always exist; for example, iptables always emits this error which is hardcoded into libc: FIX ME! implement getprotobynumber() bionic/libc/bionic/stubs.c:456 My current filter table contains two references to quota2, and they are in the INPUT chain. I have no idea what inserts them; I hope Android does not use them for something important. The second may have originally appeared in the OUTPUT chain and somehow migrated. Chain INPUT (policy ACCEPT 273K packets, 85M bytes) pkts bytes target prot opt in...
2019 Feb 12
2
Maintaining table quota2
...te: >> >> >> >> >> On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote: >>>> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: >>>> >>>> >>>> Does dovecot compute that values for quota2 with each email it updates >>>> for the user?? Or only an incremental change? >>>> >>>> I ask because I am looking at migrating all the user mail from the old >>>> server to the new and building a new sql database.? All I see is: >>>> >...
2019 Feb 12
0
Maintaining table quota2
...vecot at dovecot.org> wrote: > > > > > On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote: > >> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: > >> > >> > >> Does dovecot compute that values for quota2 with each email it updates > >> for the user?? Or only an incremental change? > >> > >> I ask because I am looking at migrating all the user mail from the old > >> server to the new and building a new sql database.? All I see is: > >> > >> dovec...
2015 Oct 19
1
More information about - Dovecot 2.2.x quota mysql and dict
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 >> 135 Query UPDATE quota2 SET >> bytes=bytes+2570,messages=me...
2013 Jan 09
14
how to setup different quota for multiple namespaces
...uthentication with LDAP and fetch some user attributes from LDAP entries: user_attrs = =home=/var/vmail/%Ln/Maildir,=mail=maildir:/var/vmail/%Ln/Maildir/,otherPager=quota_rule=*:storage=%$ I configured the quota plugin in the following way: plugin { quota = maildir:User quota:ns= quota2 = maildir:Archive quota:ns=Archives. quota_rule = *:storage=1G quota_rule2 = ns=Archives.:ignore } unfortunately this does not give the desired result. Folders under the Archives namespace use the same quota as INBOX. Does anyone have an idea how to fix this ? Thank you for your...
2015 Oct 06
4
More information about - Dovecot 2.2.x quota mysql and dict
...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' 135 Query SELECT bytes FROM quota2 WHERE username = 'user at mydomain.lan' 135 Query BEGIN 135 Query UPDATE quota2 SET bytes=bytes+2570,messages=messages+1 WHERE username = 'user at mydomain....
2019 Feb 12
0
Maintaining table quota2
...cot < <a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote: </div> <div> >>>> </div> <div> >>>> </div> <div> >>>> Does dovecot compute that values for quota2 with each email it updates </div> <div> >>>> for the user? Or only an incremental change? </div> <div> >>>> </div> <div> >>>> I ask because I am looking at migrating all the user mail from the old...
2019 Feb 12
0
Maintaining table quota2
> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: > > > Does dovecot compute that values for quota2 with each email it updates > for the user?? Or only an incremental change? > > I ask because I am looking at migrating all the user mail from the old > server to the new and building a new sql database.? All I see is: > > dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysq...
2019 Sep 03
0
Quota count and clone questions
Hi, I presume you figured this out after all this time, but in any case. Since quota_clone is not cumulative, it always inserts new record with actual quota, to be able to get correct results in postfixadmin one must: DROP TRIGGER mergequota2 ON quota2; And to prevent ERROR: duplicate key value violates unique constraint "quota2_pkey": CREATE FUNCTION public.clone_quota2() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN UPDATE quota2 SET bytes = NEW.bytes, messages = NEW.messages...
2017 Feb 05
2
Dict quota calculation errors "remote disconnected"/"broken pipe" on 2.22.
...ng4 = storage=75%% quota-warning 75 %u } dict { sqlquota = pgsql:/etc/dovecot/dovecot-dict-sql-user.conf } /etc/dovecot/dovecot-dict-sql-user.conf: **************************************** connect = host=A.B.C.D dbname=db user=DDD password=YYY 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 } I will not be able to provide full "doveconf -n" output unfortunately. Logging ALL incoming DB queries: ****...
2012 Oct 16
1
Problem with quota update in dovecot 1.2
Hi A have a problem with quota2 table, working under postfixadmin. When I login into imap server with thunderbird client everything works fine, quota is update when i receive a message, but when I move message to trash or any other folder value for messages field in table quota2 increases +1 instead decreases or have still th...
2019 Feb 14
1
Quota count and clone questions
all this almost reads like I can drop maintaining the quota2 table? From https://wiki.dovecot.org/Quota/Count mailbox_list_index = yes # Avoid spending excessive time waiting for the quota calculation to finish when # mails' vsizes aren't already cached. If this many mails are opened, finish the # quota calculation on background in indexer-worke...
2017 Dec 03
0
doveadm with 2-level user/domain quotas scheme
Hi! I believe now it a right time to return to previous discussion about Dovecot's in 2-level user/domain quotas scheme wich was finished here https://dovecot.org/pipermail/dovecot/2015-October/102346.html Here is configuration. 1. Dictionary storage placed in MySQL table "quota2" root at localhost [(none)]> SHOW COLUMNS FROM quota2 FROM exim; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | username | varchar(100) | NO | PRI | NULL...
2015 Oct 17
0
More information about - Dovecot 2.2.x quota mysql and dict
...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' > 135 Query SELECT bytes FROM quota2 WHERE username = > 'user at mydomain.lan' > 135 Query BEGIN > 135 Query UPDATE quota2 SET > bytes=bytes+2570,messages=messages+1 WHERE userna...
2019 Feb 13
0
Maintaining table quota2
On 13.2.2019 2.02, Robert Moskowitz via dovecot wrote: > > > On 2/12/19 1:57 PM, Aki Tuomi wrote: >> >>> On 12 February 2019 at 20:52 Robert Moskowitz via dovecot < >>> dovecot at dovecot.org <mailto:dovecot at dovecot.org>> wrote: >>> >>> >>> >>> >>> On 2/12/19 1:03 PM, Aki Tuomi via dovecot wrote:
2019 Feb 13
0
Maintaining table quota2
Robert Moskowitz via dovecot skrev den 2019-02-14 00:22: > Am I 'getting it'? 15- is loaded before 20- check dovecot -n always gives wanted results
2015 Jul 28
2
bug in acl_defaults_from_inbox option
...= no acl_shared_dict = file:/var/shared/dovecot/shared-mailboxes.dict fts = solr fts_autoindex = yes fts_autoindex_max_recent_msgs = 20 fts_solr = url=http://solr.localdomain:8080/solr/ mailbox_alias_new = INBOX_spam mailbox_alias_old = Junk quota = maildir:User quota:ns= quota2 = maildir:Archive quota:ns=Archives. quota2_rule = *:storage=20GB quota2_warning = storage=95%% quota2-warning 95 %u quota2_warning2 = storage=90%% quota2-warning 90 %u quota2_warning3 = storage=80%% quota2-warning 80 %u quota_rule = *:storage=5GB quota_rule2 = Trash:storage=+20%%...
2013 Sep 08
2
Postfixadmin/MySQL/Dovecot 2 and quota
...(quota should be applied per mailbox). Here, my dovecot configuration: dovecot.conf: dict { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } dovecot-dict-quota.conf: connect = host=localhost dbname=postfix user=postfix password=postfix 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 } dovecot-sql.conf.ext: driver = mysql connect = host=localhost dbname=postfix user=postfix password=postfix default_pass_sche...