Re: [Dovecot] Dovecot quota dict

2011-08-10 Thread Nikita Koshikov
On Tue, 09 Aug 2011 11:18:55 -0300 Juan Bernhard wrote: Hi Nikita, thanks for the help, but I don't have any problem with bouncing the mail after the deliver (in fact, the mail pass two MTAs servers before reaching the final storage) I will try (with my limited english) to explain it

Re: [Dovecot] Dovecot quota dict

2011-08-10 Thread Juan Bernhard
Thank you Nikita, that's what I need. El 10/08/2011 03:35 a.m., Nikita Koshikov escribió: On Tue, 09 Aug 2011 11:18:55 -0300 Juan Bernhard wrote: Hi Nikita, thanks for the help, but I don't have any problem with bouncing the mail after the deliver (in fact, the mail pass two MTAs servers

Re: [Dovecot] Dovecot quota dict

2011-08-09 Thread Nikita Koshikov
On Mon, 08 Aug 2011 16:35:53 -0300 Juan Bernhard wrote: Hi, Im using dovecot with maildir++ quota and I have this problem, maybe some of you already solve this and can helpme. I want to use some flat file to tell exim and dovecot the quota limit for each user, i tried to work with exim and

Re: [Dovecot] Dovecot quota dict

2011-08-09 Thread Juan Bernhard
Hi Nikita, thanks for the help, but I don't have any problem with bouncing the mail after the deliver (in fact, the mail pass two MTAs servers before reaching the final storage) I will try (with my limited english) to explain it better. Now I m working with a single quota rule for everyone.

[Dovecot] Dovecot quota dict

2011-08-08 Thread Juan Bernhard
Hi, Im using dovecot with maildir++ quota and I have this problem, maybe some of you already solve this and can helpme. I want to use some flat file to tell exim and dovecot the quota limit for each user, i tried to work with exim and maildirsize file, but exim just ignores the limits there. I

[Dovecot] quota dict play nice with existing tables

2010-09-14 Thread Miha Vrhovnik
Hi, I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a dedicated table for quota management. When I've run *doveadm quota recalc -A* I've noticed in the logs that Dovecot tries to run DELETE statements. Fortunately it

Re: [Dovecot] quota dict play nice with existing tables

2010-09-14 Thread Timo Sirainen
On Tue, 2010-09-14 at 18:07 +0200, Miha Vrhovnik wrote: I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a dedicated table for quota management. When I've run *doveadm quota recalc -A* I've noticed in the logs that

Re: [Dovecot] quota dict play nice with existing tables

2010-09-14 Thread Timo Sirainen
On Tue, 2010-09-14 at 17:49 +0100, Timo Sirainen wrote: On Tue, 2010-09-14 at 18:07 +0200, Miha Vrhovnik wrote: I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a dedicated table for quota management. When I've run

Re: [Dovecot] quota dict play nice with existing table s

2010-09-14 Thread Miha Vrhovnik
Timo Sirainen t...@iki.fi wrote on 14.9.2010 18:51:29: On Tue, 2010-09-14 at 17:49 +0100, Timo Sirainen wrote: On Tue, 2010-09-14 at 18:07 +0200, Miha Vrhovnik wrote: I'm trying to set Dovecot 2.0 with postgresql dict. It's kind of working but not as I'd like to. Dovecot expects to get a

Re: [Dovecot] quota dict play nice with existing tables

2010-09-14 Thread Timo Sirainen
On Tue, 2010-09-14 at 19:08 +0200, Miha Vrhovnik wrote: When removing/receiving new message and same in case of doveadm recalc. SELECT with key.. if not found INSERT else UPDATE I don't think this kind of code exists anywhere? It's possible that doveadm does a SELECT, but it's

Re: [Dovecot] quota dict play nice with existing table s

2010-09-14 Thread Miha Vrhovnik
Timo Sirainen t...@iki.fi wrote on 14.9.2010 19:24:14: On Tue, 2010-09-14 at 19:08 +0200, Miha Vrhovnik wrote: When removing/receiving new message and same in case of doveadm recalc. SELECT with key.. if not found INSERT else UPDATE I don't think this kind of code exists

Re: [Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-26 Thread Timo Sirainen
On Mon, 2010-05-24 at 00:47 +0400, Andrey Melnikov wrote: after mysql_query() - mysql return right data (affected rows = 1), but there is no result to store (this is UPDATE/DELETE query), next unconditional call to mysql_store_result() return nothing (right, there no result) and reset

Re: [Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-26 Thread e-frog
On 26.05.2010 16:32, wrote Timo Sirainen: On Mon, 2010-05-24 at 00:47 +0400, Andrey Melnikov wrote: after mysql_query() - mysql return right data (affected rows = 1), but there is no result to store (this is UPDATE/DELETE query), next unconditional call to mysql_store_result() return nothing

Re: [Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-25 Thread e-frog
On 20.05.2010 19:52, wrote Timo Sirainen: On 5.5.2010, at 20.34, Michael Kliewe wrote: -- dovecot-2.0.beta4-25/src/lib-sql/driver-mysql.c 2010-04-02 16:47:13.0 +0400 +++ dovecot-2.0.beta4/src/lib-sql/driver-mysql.c2010-05-01 03:29:02.0 +0400 @@ -630,7 +631,9

Re: [Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-20 Thread Timo Sirainen
On 5.5.2010, at 20.34, Michael Kliewe wrote: -- dovecot-2.0.beta4-25/src/lib-sql/driver-mysql.c 2010-04-02 16:47:13.0 +0400 +++ dovecot-2.0.beta4/src/lib-sql/driver-mysql.c2010-05-01 03:29:02.0 +0400 @@ -630,7 +631,9 @@ struct mysql_result

[Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-05 Thread Michael Kliewe
Hi, I have a problem when setting up the quota dict plugin. I get this error in my logfile when trying to store a draft (APPEND): May 05 14:44:53 imap(t...@domain.de): Error: net_connect_unix(/usr/ local/var/run/dovecot/dict) failed: Permission denied May 05 14:44:53 imap(t...@domain.de):

Re: [Dovecot] quota dict mysql not working (2.0.beta4)

2010-05-05 Thread Michael Kliewe
Ok, found the problem and fixed it. Two things had to be done: master.cnf service dict { extra_groups = vmail unix_listener dict { group = vmail mode = 0660 } } After restart I got

Re: [Dovecot] quota dict with mysql 4.0

2010-03-26 Thread Timo Sirainen
On 25.3.2010, at 11.24, Andre Hübner wrote: i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers dovecot internally uses sql: ON DUPLICATE KEY UPDATE which was introduced in mysql 4.1 The original code supported dict-sql only if ON

Re: [Dovecot] quota dict with mysql 4.0

2010-03-26 Thread Andre Hübner
Hello, i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers dovecot internally uses sql: ON DUPLICATE KEY UPDATE which was introduced in mysql 4.1 The original code supported dict-sql only if ON DUPLICATE KEY UPDATE was supported by

[Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Andre Hübner
Hello, i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers dovecot internally uses sql: ON DUPLICATE KEY UPDATE which was introduced in mysql 4.1 Is there a chance to make this statement mysql 4.0 compatible or should i update mysql? i

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Jerry
On Thu, 25 Mar 2010 10:24:37 +0100, Andre Hübner andre.hueb...@gmx.de articulated: i use successfully mysql-quotasystem with dovecot 1.2.11 on different servers except for mysql 4.0 servers dovecot internally uses sql: ON DUPLICATE KEY UPDATE which was introduced in mysql 4.1 Is there a

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Charles Marcus
On 2010-03-25 6:26 AM, Jerry wrote: In my opinion, continued use of depreciated software peeve-mode It is 'deprecated', not 'depreciated'... /peeve-mode -- Best regards, Charles

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Daryl Tester
Charles Marcus wrote: In my opinion, continued use of depreciated software peeve-mode It is 'deprecated', not 'depreciated'... /peeve-mode Perhaps he's found a way to depreciate free software? -- Regards, Daryl Tester Member of the Amalgamated Australian Association Against Apostrophe

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Andre Hübner
Hello, I am somewhat surprised that the older software is not compatible with the newer version of MySQL. Usually, it is the other way around. Have you checked to see if newer versions of the incompatible software exist? I would be willing to wager that they have been updated to accommodate the

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Jerry
On Thu, 25 Mar 2010 12:46:10 +0100, Andre Hübner andre.hueb...@gmx.de articulated: Hello, I am somewhat surprised that the older software is not compatible with the newer version of MySQL. Usually, it is the other way around. Have you checked to see if newer versions of the

Re: [Dovecot] quota dict with mysql 4.0

2010-03-25 Thread Andre Hübner
(sorry, i only read the digest version of list and always create i new thread by fake-Re) Hello, Perhaps you can implement some updating procedure that would only involve a percentage of your users at one time. no way, i want to fix this! but i need help because i have no idea of

[Dovecot] quota dict

2009-11-22 Thread Lampa
Hello, i'm using dict quota stored in mysql (/etc/dovecot/dovecot-dict-quota.conf): connect = host=localhost dbname=vmail user=dovecot password= # CREATE TABLE quota ( # username varchar(100) not null, # bytes bigint not null default 0, # messages integer not null default 0, # primary

Re: [Dovecot] quota dict

2009-11-22 Thread Pascal Volk
On 11/22/2009 11:36 AM Lampa wrote: Hello, … plugin { quota = dict:user::proxy::quotadict quota_warning = storage=99%% /etc/dovecot/quota-warning.sh 99 quota_warning2 = storage=95%% /etc/dovecot/quota-warning.sh 95 quota_warning3 = storage=80%% /etc/dovecot/quota-warning.sh 80 But how

Re: [Dovecot] quota dict

2009-11-22 Thread Lampa
Hello, hmm, if you mean: quota2_rule = Trash:ignore that seems not working. I'm copying message between Trash and inbox, both contains one message with size 1m5, quota_rule = *:storage=2M:messages=1 (from userdb) now is not possible to copy message from Trash to inbox and vice versa.

Re: [Dovecot] quota dict

2009-11-22 Thread Pascal Volk
On 11/22/2009 11:56 AM Lampa wrote: Hello, hmm, if you mean: quota2_rule = Trash:ignore that seems not working. I'm copying message between Trash and inbox, both contains one message with size 1m5, quota_rule = *:storage=2M:messages=1 (from userdb) now is not possible to copy

Re: [Dovecot] quota dict

2009-11-22 Thread Pascal Volk
On 11/22/2009 12:03 PM Pascal Volk wrote: On 11/22/2009 11:56 AM Lampa wrote: Hello, hmm, if you mean: quota2_rule = Trash:ignore ^ quota2_rule = INBOX.Trash:ignore ^ Use quota_ruleN: quota_rule2 = Trash:ignore Regards, Pascal -- The trapper recommends

[Dovecot] Quota/Dict Postgres Trigger

2009-04-29 Thread Warren Volz
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

Re: [Dovecot] Quota/Dict Postgres Trigger

2009-04-29 Thread Timo Sirainen
On Apr 29, 2009, at 3:25 AM, Warren Volz wrote: 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

Re: [Dovecot] Quota/Dict Postgres Trigger

2009-04-29 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, Apr 29, 2009 at 03:38:27AM -0400, Timo Sirainen wrote: On Apr 29, 2009, at 3:25 AM, Warren Volz wrote: 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

[Dovecot] quota - dict - username = '(null)'

2007-03-14 Thread Andreas Jørgensen
I am trying setting up at virtual domain with quota using postfix and dovecut. But I can't get the quota to work, every time I try sending a mail the following queries is run on the database. SELECT home, uid, gid FROM mail_view_tmp WHERE account = 'dummy' AND domain = 'example.com' SELECT