Displaying 20 results from an estimated 2000 matches similar to: "Quota PostgreSQL INSERT trigger"
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
2015 Oct 16
0
quotas configuration a few questions
hi everyone
need a few questions answering if possible before i can complete some
modifications on my mailserver
1 how do i modify my user_query line in dovecot-sql.conf for quotas
2 is my iterate_query line ok
3 should i use lmtp or lda to deliver the quota warnings in
quota-warning.sh
my server is using lmtp but i've only seen examples using lda
4 how do i break long lines
2015 Jul 24
0
possible patch for ACL SQL ERROR: duplicate key value violates unique constraint "user_shares_pkey"
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm using Postgres as dict backend now and then I get this error, when
someone changed ACLs, actually for some reason some users, who get
permission from other users, get this error quite often:
dict: Error: sql dict: commit failed:
ERROR: duplicate key value violates unique constraint "user_shares_pkey"
(query: INSERT INTO
2009 Aug 09
1
Wiki entry for expire plugin, PostgreSQL trigger needs update
The wiki entry at http://wiki.dovecot.org/Plugins/Expire needs an
update for Dovecot 1.2 and PostgreSQL:
-- v1.2+:
CREATE OR REPLACE FUNCTION merge_expires() RETURNS TRIGGER AS $$
BEGIN
IF exists(SELECT 1 FROM expires WHERE username = NEW.username AND mailbox = NEW.mailbox) THEN
UPDATE expires SET expire_stamp = NEW.expire_stamp
WHERE username = NEW.username AND mailbox = NEW.mailbox;
2009 Apr 29
1
Quota/Dict Postgres Trigger
I posted the trigger for v1.1 versions of Dovecot on the Wiki (http://wiki.dovecot.org/Quota/Dict
) and while I understand the comment posted about two process
inserting at the same time, I'm not sure I understand how this is
fixed in v1.2 other than via the revised trigger in the Wiki. Does
someone have a known working trigger that will handle a double insert
correctly?
Also, out of
2009 Jan 19
0
Reject message if user is over quota. 2/3 solution for Postfix w/ PostgreSQL
Hi,
according to the both discussions in the last few days I've tried to
find a solution for Postfix with a PostgreSQL back-end.
Its working nice for regular recipient addresses like user at example.com
and addresses with an extension like user+foo at example.com.
Alias addresses are currently ignored.
* An alias may expand into multiple destinations. If one of this
destinations is
2010 Mar 10
0
Postgres plpgsql is created by default in new version, but schema dump tries to create it
As of some recent version of Postgres, plpgsql is created for new
databases by default, but the sql schema export
(config.active_record.schema_format = :sql) expots a create command in
development_structure.sql, resulting in an error.
CREATE PROCEDURAL LANGUAGE plpgsql;
I could not find the version this changed in, however it is noted
here:
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
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
2005 Jun 08
14
HTB is being hang my computer :/
What''s wrong... I have Celeron 633MHz nd 768Mb RAM.
When I''m running my script everything is OK, but when I''m connecting
Internet and LAN link computer is hanging. But when i dissconnect this
everything is OK.
I have 500 users, 1500 classes and 3000 filters.
Is it normal? What should I do?
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:
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
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:
>>>>
>>>>
2005 Oct 28
3
PostgreSQL. Multiply schemas in one database. How to?
Hi all.
I am using PostgreSQL in my current project and I have couple of questions
on this topic.
Previously I have used 3 databases for project. i.e.
megaproject_development, megaproject_test and megaproject_development.
But I don''t like this variant because of ''rake dump_db_structure'' writes a
lot of PostgreSQL specific data for structure file (operators, functions,
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 {
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 =