Displaying 20 results from an estimated 6000 matches similar to: "Maintaining table quota2"
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
2019 Feb 12
2
Maintaining table quota2
On 2/12/19 1:03 PM, Aki Tuomi via dovecot wrote:
>> On 12 February 2019 at 19:55 Robert Moskowitz via dovecot <dovecot 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:
>>>>
>>>>
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-worker process. Mail
deliveries will
# be
2017 Mar 17
2
Understanding quotas
Just to level-set, I am using Centos7-arm which supplies Dovecot
2.2.10. I don't have access to a arm build or mock environment and use
what is available (I DID try to install them but had dependency issues).
Much of what I have is from campworld, but some I have picked up from
other Centos mailserver builders.
Also I am using Postfixadmin which provides quotas per user in mysql
2019 Feb 12
0
Maintaining table quota2
> On 12 February 2019 at 19:55 Robert Moskowitz via dovecot <dovecot 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
2013 Sep 08
2
Postfixadmin/MySQL/Dovecot 2 and quota
Hi all,
I'm setting up a new email server based on the softwares list below:
* Postfix
* Dovecot 2.0.9
* MySQL
* Postfixadmin 2.3.6
My current problem is I'm unsure whether quota feature is well
configured or not.
In order to test and validate, I use Roundcubemail GUI which provides
percentage of the space used by the mailbox (quota should be applied per
mailbox).
Here, my
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:
>
2019 Feb 12
0
Maintaining table quota2
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 12 February 2019 at 20:52 Robert Moskowitz via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
2010 Jul 14
2
domain quota dictionary
Hi
I just configure dovecot with the second dictionary for the domain quota
dict {
quotadict = mysql:/usr/local/etc/dovecot-quota.conf
quota_domain = mysql:/usr/local/etc/dovecot-quota-domain.conf
}
plugin {
quota = dict:user::proxy::quotadict
quota2 = dict:domain:%d:proxy::quota_domain
}
and the dovecot-quota-domain.conf looks like this :
connect = host=xxx dbname=xxx
2015 Oct 06
4
More information about - Dovecot 2.2.x quota mysql and dict
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'
2018 Mar 28
1
Dovecot quota
Hello,
I'm running Dovecot on a FreeBSD system with Postfix in a virtual user
setup, with Mysql. I am trying to understand the quota configuration.
I've got a Mysql database with an accounts table with a quota field.
I've also got two other tables one quota (currently has nothing in it
an empty set), and quota2 messages and bytes which has one entry. My
goal is to have different
2017 Mar 19
0
Solved? - Re: Understanding quotas
I spent an evening, again, reading up on quota. This time I think my
search foo was strong enough. I found guidance and came up with the
following:
sed -i -e "s/#quota = /sqlquota = /w /dev/stdout"
/etc/dovecot/dovecot.conf
Sets up a dovecot dictionary of sqlquota to the default file of
/etc/dovecot/dovecot-dict-sql.conf.ext
cat
2011 Jun 24
2
Please help with Quota dict mysql configuration
Hello
So what i have:
centos 5.6
postfix 2.3.3
dovecot 2.0.13
postfixadmin 2.3.3
roundcube 0.5.3
All general things are working right now i can send receive email with
ssl connections etc...
Now i'm trying to configure additional options like quota and some
other plugins like sieve, trash, expire and deleted-to-trash.
Configuration of quota is on first place. I have read wiki regarding
quota
2012 Jun 24
2
dict Panic after upgrade to 2.1.7
Hello,
after upgrade my mailsystem to dovecot version 2.1.7, dovecot doesn't work
properly. something went wrong in dict service connecting the postgres
backend. that happens not on every connection. the db connection data are
correct, no difference connecting via tcp or linux socket.
dovecot log entries:
Jun 23 23:19:10 mx dovecot: dict: Panic: file driver-pgsql.c: line 84
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
2017 Apr 28
4
Sieve dict and bindir question
Hi,
I have setup the latest Dovecot and Sieve with dict in order to read
rules from MySQL and works fine:
sieve_before = dict:proxy::sieve;name=activesql;bindir=~/.sieve-bin
dict {
sieve = mysql:/etc/dovecot/dovecot-dict-sieve-sql.conf.ext
}
# cat /etc/dovecot/dovecot-dict-sieve-sql.conf.ext
connect = host=10.1.1.1 dbname=dovecot user=dovecot password=Ciao
map {
pattern =
2010 Oct 14
1
Quota, Postgres + Postfixadmin
Hi everybody,
i am currently testing dovecot-1.2.9 together with postfix, postgres and
postfixadmin.
After setting up the basics, i wanted to get the quotas working...
So i edited the dovecot.conf:
mail_plugins = quota imap_quota
mail_plugins = sieve quota
quotadict = pgsql:/etc/dovecot/dovecot-dict-quota.conf
quota = dict:user::proxy::quotadict
and dovecot-dict-quota.conf:
connect
2017 Mar 19
2
The challenge of customizing Dovecot
I have been running Dovecot for sometime, but I have just used someone
else efforts on customizing it. Many of these throw out the
dovecot/conf.d files for a single dovecot.conf with no explanation on
what does what. So tell you a few conf.d files to edit.
So over the past few days, I have rolled up my sleeves and did my best
to work out how to modify the proper conf.d files. To 'stay
2015 Feb 09
2
Geting mail quota exceeded with plenty of space
> that was it. Emptied trash and mail flowing. How is the message #
> quota managed? I never encountered it before.
>
> But don't have time today to dig into it. conference call coming up.
You might have messages quota configured somewhere.
And for :
> doveadm(root): Fatal: Unknown command 'quota', but plugin quota
>exists. Try to set mail_plugins=quota
See
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 this same value. Only if I
close my imap client value descending -2.