1 Topic by hifall

  • hifall
  • Member
  • Offline
  • Registered: 2017-01-31
  • Posts: 38

Topic: How to safely purge smtp_sessions in iredapd.

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.0 MARIADB edition
- Deployed with iRedMail Easy or the downloadable installer? the downloadable installer
- Linux/BSD distribution name and version: Ubuntu 18.04.2 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MARIADB
- 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.
====

I found that the smtp_sessions table in iredapd is taking up a huge amount of space. I'd like to understand how to safely purge this table without breaking the other parts of iRedmail, as I am not using this table?

Thanks!

----

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

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: How to safely purge smtp_sessions in iredapd.

just purge it

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: How to safely purge smtp_sessions in iredapd.

Run python script /opt/iredapd/tools/cleanup_db.py.

BTW, iRedMail 1.0 is tooooo old, please consider upgrading to latest version as soon as possible.

4 Reply by hifall

  • hifall
  • Member
  • Offline
  • Registered: 2017-01-31
  • Posts: 38

Re: How to safely purge smtp_sessions in iredapd.

Thanks for your advice.

Just wondering: is the data in this table for pure logging purposes? like logged and disposable after a certain period of time?

5 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: How to safely purge smtp_sessions in iredapd.

i guess it works with postscreen service to determine if a smtp sessiion was checked already (spamscore) and assumed good or not, but purging it doesn't do any harm at all and should be done regulary