1 Topic by lamagra

  • lamagra
  • Member
  • Offline
  • Registered: 2015-01-29
  • Posts: 45

Topic: cleanup_amavisd_db - not working properly

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer? download
- Linux/BSD distribution name and version: Debian 10.7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi,
i have problem with cleanup_amavisd - script has not cleaned the database (send and receive msgs). It should delete all older then 7 days, but it doesn't. I tried to start script manually but no effects and no errors.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 28,151

Re: cleanup_amavisd_db - not working properly

- Did you see older records in Amavisd database, "msgs" table?
- What are the settings in your iRedAdmin-Pro config file:

AMAVISD_REMOVE_MAILLOG_IN_DAYS =
AMAVISD_REMOVE_QUARANTINED_IN_DAYS =

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee

3 Reply by lamagra

  • lamagra
  • Member
  • Offline
  • Registered: 2015-01-29
  • Posts: 45

Re: cleanup_amavisd_db - not working properly

ZhangHuangbin wrote:

- Did you see older records in Amavisd database, "msgs" table?
- What are the settings in your iRedAdmin-Pro config file:

AMAVISD_REMOVE_MAILLOG_IN_DAYS =
AMAVISD_REMOVE_QUARANTINED_IN_DAYS =

Hi yes i have older records in Amavisd database. Database is growing and because of that first page of iredadmin is slowing down every day.

Settings like bellow but in database i have msgs from 18.12.2020.
AMAVISD_REMOVE_MAILLOG_IN_DAYS = 7
AMAVISD_REMOVE_QUARANTINED_IN_DAYS = 7

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 28,151

Re: cleanup_amavisd_db - not working properly

Seems something wrong with our cleanup script.
As a temporary solution, you can remove the old records manually and keep tracking this issue, i will take a look and try to fix it.

----

Buy me a cup of coffee ($5) to support iRedMail:

buy me a cup of coffee