1 Topic by rnravi

  • rnravi
  • Member
  • Offline
  • Registered: 2020-10-05
  • Posts: 2

Topic: cleanup amavis_db

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Getting this error when i run cleanup_amavisd_db.py

Traceback (most recent call last):
  File "./cleanup_amavisd_db.py", line 42, in <module>
    from libs import iredutils
ImportError: cannot import name 'iredutils'

Please help me resolve this issue.

----

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: 31,502

Re: cleanup amavis_db

- Please show us full command you ran on console.
- Which iRedAdmin-Pro release are you running?

3 Reply by rnravi

  • rnravi
  • Member
  • Offline
  • Registered: 2020-10-05
  • Posts: 2

Re: cleanup amavis_db

-rw-r----- 1 mysql mysql 9.6G Jun 20 21:00 quarantine.ibd
-rw-r----- 1 mysql mysql 4.8G Jun 20 21:00 msgs.ibd
-rw-r----- 1 mysql mysql 1.8G Jun 20 21:00 msgrcpt.ibd

How to clear these files. This is taking up a lot of space. I ran clean_amavis_db.py. It didn't help me clear these files.

4 Reply by Cthulhu

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

Re: cleanup amavis_db

.idb are database files, it is done by deleting everything in the table quarantine, msgs, and msgrcpt

5 Reply by ZhangHuangbin

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

Re: cleanup amavis_db

rnravi wrote:

Traceback (most recent call last):
  File "./cleanup_amavisd_db.py", line 42, in <module>
    from libs import iredutils
ImportError: cannot import name 'iredutils'

Please run it with this command:

python3 /opt/www/iredadmin/tools/cleanup_amavisd_db.py