Displaying 20 results from an estimated 900 matches similar to: "Quota count and clone questions"
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
2011 Dec 15
1
Quota PostgreSQL INSERT trigger
Wiki instructions for creating insert trigger for PostgreSQL are wrong
http://wiki.dovecot.org/Quota/Dict
Calling INSERT on the table from within BEFORE INSERT trigger creates
cascading trigger.
http://www.postgresql.org/docs/current/interactive/trigger-definition.html
Instead, one should return NEW record from the trigger, and it will be
inserted after trigger execution.
---
CREATE OR
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
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 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
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
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:
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 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:
>
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
2017 Mar 15
1
Using environment variables in mariadb
On 03/14/2017 06:29 PM, Richard wrote:
>
>> Date: Tuesday, March 14, 2017 14:53:01 -0700
>> From: Robert Moskowitz <rgm at htt-consult.com>
>>
>> I want to script a rather simple create database operation. Thing
>> is, I have to provide the password for that database. I would like
>> to do this with an environment variable, but the simple approach
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
2017 Feb 05
2
Dict quota calculation errors "remote disconnected"/"broken pipe" on 2.22.
Keywords: dovecot, dict, quota, postgre sql, broken pipe, remote
disconnected
Having Dovecot 2.2.22 (fe789d2) with Postgre SQL 9.5
(9.5.5-0ubuntu0.16.04) as the backend. I do not understand why quota
service is not working, not seeing it as a configuration error at least.
My quotas are DICT/SQL based.
OS: Ubuntu 16.0.4.1 32-bit (Linux XXX 4.4.0-59-generic #80-Ubuntu SMP
Fri Jan 6 17:36:54
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;
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'
2015 Oct 17
0
More information about - Dovecot 2.2.x quota mysql and dict
On 07 Oct 2015, at 01:34, Simon <semfly at gmail.com> wrote:
>
> 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
2015 Jul 28
2
bug in acl_defaults_from_inbox option
Hi at all,
there is a bug in in acl_defaults_from_inbox option: if you define it
with ANY value ('yes', 'no', 'whatyouwant', 'xxx') it acts like the
value is ALWAYS 'yes', and Dovecot enable it; the only way to disable
it, is comment it or delete from configuration file.
With 'acl_defaults_from_inbox = no', or 'acl_defaults_from_inbox =
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.
2018 Feb 28
0
BUG: Error: dovecot.index.pvt reset, view is now inconsistent when shared folder is new and empty
Hi,
I'm using Dovecot 2.2.33.2 on a RHEL 7, new installation. My log is full
of :
Error: INDEX_FOLDER/dovecot.index.pvt reset, view is now inconsistent
or
Error: INDEX_FOLDER/dovecot.index.pvt view is inconsistent
when shared folder is never touched and empty.
UserA share XXXXX folder with UserB, if XXXXX folder is new (never
touched) and empty every time UserB looks in that folder, an