26

Re: how to manage throttling with phpMyAdmin ?

Please set 'log_detail = modules,tracking,protocols' in cluebringer.conf also. Then restart cluebringer and try again.

Official webui of Policyd-2 is not easy to use, i guess you don't have policy and limitation correctly configured. Please export your quota table with below command and paste here:

# pg_dump -U postgres -W --table=quotas cluebringer |grep -Ev '^(SE|--)'
# pg_dump -U postgres -W --table=quotas_limits cluebringer |grep -Ev '^(SE|--)'

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

27

Re: how to manage throttling with phpMyAdmin ?

i added 'log_detail = modules,tracking,protocols 
i restarted /etc/init.d/postfix-cluebringer

but i can't execute what you said like below;
root@postfix1:/etc/cluebringer# pg_dump -U postgres -W --table=quotas cluebringer |grep -Ev '^(SE|--)'
Error: You must install at least one postgresql-client-<version> package.

28

Re: how to manage throttling with phpMyAdmin ?

Oops, my mistake. i forget you're running OpenLDAP backend. sad

Then please try below command:

# mysql -uroot -p cluebringer
mysql> SELECT * FROM quotas;
mysql> SELECT * FROM quotas_limits;

29

Re: how to manage throttling with phpMyAdmin ?

mysql> SELECT * FROM quotas;
+----+----------+-------------------+-----------------------+--------+---------+------+----------+----------+
| ID | PolicyID | Name              | Track                 | Period | Verdict | Data | Comment  | Disabled |
+----+----------+-------------------+-----------------------+--------+---------+------+----------+----------+
|  1 |        5 | Recipient quotas  | Recipient:user@domain |   3600 | REJECT  | NULL | NULL     |        1 |
|  2 |        5 | Quota on all /24s | SenderIP:/24          |   3600 | REJECT  | NULL | NULL     |        0 |
|  3 |        2 | deneme            | Sender:user@domain    |   3600 | REJECT  |      | test.com |        0 |
+----+----------+-------------------+-----------------------+--------+---------+------+----------+----------+
3 rows in set (0.00 sec)

I use id3 above.

mysql> SELECT * FROM quotas_limits;
+----+----------+-----------------------+--------------+---------+----------+
| ID | QuotasID | Type                  | CounterLimit | Comment | Disabled |
+----+----------+-----------------------+--------------+---------+----------+
|  1 |        1 | MessageCount          |            1 | NULL    |        1 |
|  2 |        1 | MessageCumulativeSize |         8000 | NULL    |        0 |
|  3 |        2 | MessageCount          |           12 | NULL    |        0 |
|  4 |        3 | MessageCount          |            1 |         |        0 |
+----+----------+-----------------------+--------------+---------+----------+
4 rows in set (0.00 sec)

30

Re: how to manage throttling with phpMyAdmin ?

I'm afraid there's a bug in iRedMail-0.8.0-beta1 and beta2. Please try to fix it with below steps:

1) Open /etc/postfix/main.cf, find setting 'smtpd_recipient_restrictions'. For example:

smtpd_recipient_restrictions = ..., permit_mynetworks, ..., check_policy_service inet:127.0.0.1:10031

2) Move cluebringer policy service to the frond of 'permit_mynetworks':

smtpd_recipient_restrictions = ..., check_policy_service inet:127.0.0.1:10031, permit_mynetworks, ...

3) Restart Postfix service. And it should work as expected now.

Please do let me know whether it works for you or not. smile

31

Re: how to manage throttling with phpMyAdmin ?

i installed iRedMail-0.7.4.stable on ubuntu11.10 64 bit

i did what you said. But i can sent 6 mails concurrently.

32

Re: how to manage throttling with phpMyAdmin ?

Also there is also an expression check_policy_service inet:127.0.0.1:7777  in smtpd_recipient_restrictions

ofcourse there is already check_policy_service inet:127.0.0.1:10031 in  smtpd_recipient_restrictions.

and i moved check_policy_service inet:127.0.0.1:10031 in front of  permit_mynetworks.

33

Re: how to manage throttling with phpMyAdmin ?

Please also make sure you don't have other restrictions apply on your testing email. For example, there's no quota limit based on SenderIP which will match your client IP address.

34

Re: how to manage throttling with phpMyAdmin ?

Off course, I just installed iredmail-0.7.4.stable on ubuntu11.10 as default . I didn't apply any application, script or  tool.

35

Re: how to manage throttling with phpMyAdmin ?

is there a solution ?

36

Re: how to manage throttling with phpMyAdmin ?

I cannot see problem in your setting. Could you please post your issue in Cluebringer mailing list instead?
http://www.policyd.org/content/policyd-support

37

Re: how to manage throttling with phpMyAdmin ?

Thank you,   after I went through this problem I was awared of a thing that I need to add policy members my domain.
it works now. But I still have a problem.

I can manage to run throttling.
But I can't do "defer operation"
I use http://serverip/cluebringer and quotas tab
if I select DEFER to delay for mails exceeded the limit at the verdict.
postfix rejects mails exceeded my limit
Namely cluebringer behaves as reject about that.

How can I fix the issue ?

38

Re: how to manage throttling with phpMyAdmin ?

Could you please post related Postfix log here?
Sounds like Cluebringer issue/bug, it's a good idea to post this issue in its mailing list.

39

Re: how to manage throttling with phpMyAdmin ?

to test I sent an email towards 4 mail addresses as concurrently and I limit 2 concurrent as outbound mail.
I selected DEFER for limit exceeed at the cluebringer.
But the mail server REJECTED a mail due to exceeding limit   

Postfixlog;
May 21 16:59:45 postfix1 postfix/smtpd[5635]: connect from unknown[192.168.1.247]
May 21 16:59:46 postfix1 cbpolicyd[4530]: module=Quotas, mode=update, host=192.168.1.247, helo=com2007, from=bulend@test.org, to=malidbulend@gmail.com, reason=quota_update, policy=2, quota=3, limit=4, track=Sender:bulend@test.org, counter=MessageCount, quota=1/2 (50.0%)
May 21 16:59:46 postfix1 postfix/smtpd[5635]: 322061620E6C: client=unknown[192.168.1.247], sasl_method=LOGIN, sasl_username=bulend@test.org
May 21 16:59:48 postfix1 cbpolicyd[4576]: module=Quotas, mode=update, host=192.168.1.247, helo=com2007, from=bulend@test.org, to=bulend.malid@test.net.tr, reason=quota_update, policy=2, quota=3, limit=4, track=Sender:bulend@test.org, counter=MessageCount, quota=2/2 (99.8%)
May 21 16:59:50 postfix1 cbpolicyd[30809]: module=Quotas, mode=update, host=192.168.1.247, helo=com2007, from=bulend@test.org, to=bulend@test.net.tr, reason=quota_update, policy=2, quota=3, limit=4, track=Sender:bulend@test.org, counter=MessageCount, quota=3/2 (149.4%)
May 21 16:59:52 postfix1 cbpolicyd[30194]: module=Quotas, action=defer, host=192.168.1.247, helo=com2007, from=bulend@test.org, to=ymmalid@hotmail.com, reason=quota_match, policy=2, quota=3, limit=4, track=Sender:bulend@test.org, counter=MessageCount, quota=4/2 (198.8%)
May 21 16:59:52 postfix1 postfix/smtpd[5635]: 322061620E6C: reject: RCPT from unknown[192.168.1.247]: 450 4.7.1 <ymmalid@hotmail.com>: Recipient address rejected: limitexceed; from=<bulend@test.org> to=<ymmalid@hotmail.com> proto=ESMTP helo=<com2007>
May 21 16:59:54 postfix1 postfix/cleanup[5648]: 322061620E6C: message-id=<055b01cd3759$fa8660a0$ef9321e0$@test.org>
May 21 16:59:54 postfix1 postfix/qmgr[4260]: 322061620E6C: from=<bulend@test.org>, size=2731, nrcpt=3 (queue active)
May 21 16:59:54 postfix1 postfix/smtpd[5658]: connect from localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/smtpd[5658]: 3E8301620E71: client=localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/cleanup[5648]: 3E8301620E71: message-id=<055b01cd3759$fa8660a0$ef9321e0$@test.org>
May 21 16:59:54 postfix1 postfix/smtpd[5659]: connect from localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/smtpd[5659]: 4249A1620E79: client=localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/cleanup[5660]: 4249A1620E79: message-id=<055b01cd3759$fa8660a0$ef9321e0$@test.org>
May 21 16:59:54 postfix1 postfix/smtpd[5658]: disconnect from localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/qmgr[4260]: 3E8301620E71: from=<bulend@test.org>, size=3143, nrcpt=1 (queue active)
May 21 16:59:54 postfix1 postfix/qmgr[4260]: 4249A1620E79: from=<bulend@test.org>, size=3151, nrcpt=1 (queue active)
May 21 16:59:54 postfix1 amavis[26280]: (26280-15) Passed CLEAN, LOCAL [192.168.1.247] [192.168.1.247] <bulend@test.org> -> <malidbulend@gmail.com>, Message-ID: <055b01cd3759$fa8660a0$ef9321e0$@test.org>, mail_id: byVWk3gnNYRF, Hits: -, size: 2731, queued_as: 3E8301620E71, 200 ms
May 21 16:59:54 postfix1 postfix/smtp[5654]: 322061620E6C: to=<malidbulend@gmail.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=8.5, delays=8.3/0/0/0.2, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 3E8301620E71)
May 21 16:59:54 postfix1 postfix/smtpd[5659]: disconnect from localhost[127.0.0.1]
May 21 16:59:54 postfix1 amavis[26279]: (26279-16) Passed CLEAN, LOCAL [192.168.1.247] [192.168.1.247] <bulend@test.org> -> <bulend.malid@test.net.tr>, Message-ID: <055b01cd3759$fa8660a0$ef9321e0$@test.org>, mail_id: bnihhcOX+g9Q, Hits: -, size: 2731, queued_as: 4249A1620E79, 254 ms
May 21 16:59:54 postfix1 postfix/smtp[5655]: 322061620E6C: to=<bulend.malid@test.net.tr>, relay=127.0.0.1[127.0.0.1]:10024, delay=8.6, delays=8.3/0.01/0/0.26, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 4249A1620E79)
May 21 16:59:54 postfix1 postfix/smtpd[5658]: connect from localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/smtpd[5658]: 6D7811620E74: client=localhost[127.0.0.1]
May 21 16:59:54 postfix1 postfix/cleanup[5648]: 6D7811620E74: message-id=<055b01cd3759$fa8660a0$ef9321e0$@test.org>
May 21 16:59:54 postfix1 postfix/qmgr[4260]: 6D7811620E74: from=<bulend@test.org>, size=3137, nrcpt=1 (queue active)
May 21 16:59:54 postfix1 amavis[26280]: (26280-16) Passed CLEAN, LOCAL [192.168.1.247] [192.168.1.247] <bulend@test.org> -> <bulend@test.net.tr>, Message-ID: <055b01cd3759$fa8660a0$ef9321e0$@test.org>, mail_id: vNM+0Uf+T4PJ, Hits: -, size: 2731, queued_as: 6D7811620E74, 153 ms
May 21 16:59:54 postfix1 postfix/smtp[5654]: 322061620E6C: to=<bulend@test.net.tr>, relay=127.0.0.1[127.0.0.1]:10024, delay=8.7, delays=8.3/0.21/0/0.16, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 6D7811620E74)
May 21 16:59:54 postfix1 postfix/qmgr[4260]: 322061620E6C: removed
May 21 16:59:55 postfix1 postfix/smtp[5661]: 3E8301620E71: to=<malidbulend@gmail.com>, relay=gmail-smtp-in.l.google.com[173.194.70.26]:25, delay=1.3, delays=0.12/0.01/0.27/0.93, dsn=2.0.0, status=sent (250 2.0.0 OK 1337608793 l8si11001560wiw.14)
May 21 16:59:55 postfix1 postfix/qmgr[4260]: 3E8301620E71: removed
May 21 16:59:55 postfix1 postfix/smtp[5664]: 6D7811620E74: to=<bulend@test.net.tr>, relay=mailhub2.test.net.tr[192.168.128.252]:25, delay=1.2, delays=0.08/0.01/0.62/0.52, dsn=2.0.0, status=sent (250 ok 1337608793 qp 69243)
May 21 16:59:55 postfix1 postfix/qmgr[4260]: 6D7811620E74: removed
May 21 16:59:56 postfix1 postfix/smtpd[5635]: disconnect from unknown[192.168.1.247]
May 21 16:59:57 postfix1 postfix/smtp[5662]: 4249A1620E79: to=<bulend.malid@test.net.tr>, relay=mailhub2.test.net.tr[192.168.128.252]:25, delay=3.7, delays=0.11/0.01/3.5/0.03, dsn=2.0.0, status=sent (250 ok 1337608795 qp 69257)
May 21 16:59:57 postfix1 postfix/qmgr[4260]: 4249A1620E79: removed

40

Re: how to manage throttling with phpMyAdmin ?

Please post this issue in Cluebringer mailing list instead. sorry.

41

Re: how to manage throttling with phpMyAdmin ?

i wrote to them. one of them recommends me to use the last version of cluebringer (cluebringer-snapshot-2.1.x-201205100639).
he wants me to test with the last cluebringer .
Meanwhile, I can run cluebringer. it works as general. But when I select DEFER for limit exceeded outgoing mails . the postfix rejects exceeded mails.
But if select HOLD  postfix does right and it holds those mails.

How can I upgrade the last cluebringer or How can I reinstall cluebringer ?

Thanks

42

Re: how to manage throttling with phpMyAdmin ?

You can find download link and documentations on Cluebringer home page: http://www.policyd.org/

Looks like it's a bug in Cluebringer, it would be great if Cluebringer developers can release a patch to fix this issue instead of upgrading to the latest snapshot release.

43

Re: how to manage throttling with phpMyAdmin ?

ZhangHuangbin wrote:

You can find download link and documentations on Cluebringer home page: http://www.policyd.org/

Looks like it's a bug in Cluebringer, it would be great if Cluebringer developers can release a patch to fix this issue instead of upgrading to the latest snapshot release.

I downloaded it.
How can I upgrade to the latest sanpshot until the developers release a patch about that ?
Thanks

44

Re: how to manage throttling with phpMyAdmin ?

I sent to  the policyd maillist;
I downloaded new snapshot version. there is an upgrading file.
What does r348 mean ? my version v2.0.11a-debian . In that case, what  is my revision  ?


one of them says;

"Unfortunately we can only support packages distributed on the official site. If you installed policyd another way it's best to contact the packager/s and find out how to upgrade."

So i wish to ask you that case.
How can i upgrade without harming the iredmail?

45

Re: how to manage throttling with phpMyAdmin ?

bulend wrote:

What does r348 mean ? my version v2.0.11a-debian . In that case, what  is my revision  ?

You version is Cluebringer-2.0.11, packed by Debian package maintainer.
Please checking its upgrade tutorial.

bulend wrote:

"Unfortunately we can only support packages distributed on the official site. If you installed policyd another way it's best to contact the packager/s and find out how to upgrade."

I really don't understand what Cluebringer developers are thinking about ...