I have installed redis backend for quota and my dovecot.conf is as follow:
quota = dict:User quota:ignoreunlimited:redis:host=127.0.0.1:prefix=%u/
but for all of my users doveadm quota get return always same quota (of
the last user)
Someone could help me in the right direction?
--
*Davide Marc
Hi,
I have enabled quota dict with mysql following wiki
http://wiki2.dovecot.org/Quota/Dict
Everything work as expected. I just have a question about query used for
updating quota usage. I already check the source file dict-sql.c but i still
can't figure it out.
I store user info in a mysql t
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 befor
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 bet
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. What
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 a
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 n
"Timo Sirainen" 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
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
"Timo Sirainen" 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
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'v
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 D
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 didn't
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
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 affe
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
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 *m
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 anothe
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): Er
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 t
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
(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
c-progr
On Thu, 25 Mar 2010 12:46:10 +0100, Andre Hübner
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
> >> incompatible softw
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
Charles Marcus wrote:
In my opinion, continued use of depreciated software
It is 'deprecated', not 'depreciated'...
Perhaps he's found a way to depreciate free software?
--
Regards,
Daryl Tester
Member of the Amalgamated Australian Association Against Apostrophe Abuse.
(formerly the 6
On 2010-03-25 6:26 AM, Jerry wrote:
> In my opinion, continued use of depreciated software
It is 'deprecated', not 'depreciated'...
--
Best regards,
Charles
On Thu, 25 Mar 2010 10:24:37 +0100, Andre Hübner
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 chance to make th
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 w
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
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
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.
200
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
>
>
>
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 ke
-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 comm
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 othe
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
On Tue, 2007-03-13 at 19:40 +0100, Andreas Jørgensen wrote:
> I am using the package dovecot-1.0.rc2p3-mysql on OpenBSD 4.0 for macppc
If this means 1.0.rc2, then that's the problem. Dictionary quota was
completely broken until rc8.
signature.asc
Description: This is a digitally signed message p
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
38 matches
Mail list logo