1 Topic by Clouseau

  • Clouseau
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 74

Topic: iredapd throttle_tracking

======== Required information ====
- iRedMail version 0.9.7
- Linux/BSD distribution name and version: Debian 8.10
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello, just wondering what is cur_quota number in that table? I have set 500 msgs per day globally on all users and I have tested it on my account. I have sent one email and cur_quota is 400. After second email that number is 800. After one more is 1200...

Tested sending with second account, after first sent record in table is shown and cur_quota is 405. After second email sent number is 804.

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: iredapd throttle_tracking

Clouseau wrote:

just wondering what is cur_quota number in that table?

Check the comment in SQL table template file:
https://bitbucket.org/zhb/iredapd/src/d … d.mysql-60

3 Reply by Clouseau

  • Clouseau
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 74

Re: iredapd throttle_tracking

ZhangHuangbin wrote:
Clouseau wrote:

just wondering what is cur_quota number in that table?

Check the comment in SQL table template file:
https://bitbucket.org/zhb/iredapd/src/d … d.mysql-60

Clear, tnx!

4 Reply by Clouseau

  • Clouseau
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 74

Re: iredapd throttle_tracking

Sorry for asking, is greylisting_whitelist_domains static meaning it will not be erased after 30 days (GREYLISTING_AUTH_TRIPLET_EXPIRE = 30)? If I sent for example and email from domainXYZ.com which is not in that table where is the whitelisted record set after the email is sent again? In greylisting_tracking? I thought the SPF and MX IP used for domainXYZ.com will be added to greylisting_whitelist_domain_spf also but that is not the case.

So  greylisting_whitelist_domains is used in corellation with greylisting_whitelist_domain_spf (what I have explicitily added in greylisting_whitelist_domains ) but IP's of other legite mail servers that send email to my users are not in those tables and only greylisting_tracking table is used for that?

5 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: iredapd throttle_tracking

Clouseau wrote:

is greylisting_whitelist_domains static meaning it will not be erased after 30 days (GREYLISTING_AUTH_TRIPLET_EXPIRE = 30)?

Records in SQL table "greylisting_whitelist_domains" is controlled by the (root's) cron job (/opt/iredapd/tools/spf_to_greylist_whitelists.py), usually it's updated every 30 minutes (old iRedMail releases update every 10 minutes).

GREYLISTING_AUTH_TRIPLET_EXPIRE is for SQL table "greylisting_tracking", controlled by (root's) cron job "/opt/iredapd/tools/cleanup_db.py".

Clouseau wrote:

If I sent for example and email from domainXYZ.com which is not in that table where is the whitelisted record set after the email is sent again? In greylisting_tracking?

Yes.

Clouseau wrote:

I thought the SPF and MX IP used for domainXYZ.com will be added to greylisting_whitelist_domain_spf also but that is not the case.

If you insert this domain in table "greylisting_whitelist_domains", cron job "spf_to_greylist_whitelists.py" will whitelist its servers listed in SPF/MX.

Clouseau wrote:

So  greylisting_whitelist_domains is used in corellation with greylisting_whitelist_domain_spf (what I have explicitily added in greylisting_whitelist_domains ) but IP's of other legite mail servers that send email to my users are not in those tables and only greylisting_tracking table is used for that?

Yes.

6 Reply by Clouseau

  • Clouseau
  • Member
  • Offline
  • Registered: 2012-03-18
  • Posts: 74

Re: iredapd throttle_tracking

I didn't had cron added to do this  /opt/iredapd/tools/cleanup_db.py. I have followed this to implement iredapd in iredmail  - https://docs.iredmail.org/manage.iredapd.html

https://bitbucket.org/zhb/iredapd/src/8 … ew-default

I would suggest to add crons in INSTALL.md file smile

Tnx a lot again, it is clear now smile

7 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: iredapd throttle_tracking

Old iRedAPD release may not have such cron jobs, but they will be added automatically during upgrading iRedAPD.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: iredapd throttle_tracking

Clouseau wrote:

I would suggest to add crons in INSTALL.md file

Added:
https://bitbucket.org/zhb/iredapd/commi … at=default

Thanks for the feedback. smile