Displaying 20 results from an estimated 2000 matches similar to: "Quota count and clone questions"
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
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
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 user=postfix password=$Postfix_Database_Password map {
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:
>>>>
>>>>
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
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'
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:
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
2018 Oct 15
2
Problems with qouta_clone plugin
Hello
I'm having troubles getting the quota_clone plugin to work for me.
i?, trying to put the quota values into to to fields, messages and
usage_in_bytes, in the mysql database.
The quotas are getting written to the maildirsize file and can be
updated with the doveadm quota recalc -A or -u "*" command
But i can't seem to get it to trigger the quota_clone plugin, not even
an
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
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
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
2018 Aug 16
2
Does domain quota work and how?
Hello,
I'm in the process of moving users from an old dovecot setup with system
users to a modern virtual user setup.
I can't find good documentation on domain quota.
It is mentioned in the docs as
quota2 = dict:domain:%d:proxy::quota_domain
but not much more.
Searching the mailing list or Google doesn't reveal much more info.
Searching the German mailing list at jpberlin finds
2018 Oct 15
2
Problems with qouta_clone plugin
On Mon, 2018-10-15 at 15:31 +0300, Aki Tuomi wrote:
> You should add quota_clone to mail plugins.
>
> Aki
>
>
> On 15.10.2018 15:28, Christian Ejlertsen wrote:
> > Hello
> >
> > I'm having troubles getting the quota_clone plugin to work for me.
> > i?, trying to put the quota values into to to fields, messages and
> > usage_in_bytes, in the
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
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 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:
>
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
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