1

Topic: Dashboard Stats issue

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):  0.9.9
- Deployed with iRedMail Easy or the downloadable installer? No
- Linux/BSD distribution name and version:  CentOS 7.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  PGSQL v9.2
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes, 3.1
====

After upgrading to iREDADMIN-Pro 3.1, the stats under VIRUS mail count is still 0 even there are filtered mails as VIRUS under Quarantine section.
Why ?

----

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

2

Re: Dashboard Stats issue

Please upgrade to the latest iRedAdmin-Pro-SQL-3.2 and try again.

3

Re: Dashboard Stats issue

ZhangHuangbin wrote:

Please upgrade to the latest iRedAdmin-Pro-SQL-3.2 and try again.

Still  same issue persists.
Total virus mails = 4
But under dashboard count = 2

4

Re: Dashboard Stats issue

- Did you modify any Amavisd config files?
- Try to run "python /opt/www/iredadmin/tools/cleanup_amavisd_db.py" (or "python /var/www/iredadmin/tools/cleanup_amavisd_db.py" if iRedAdmin-Pro is stored under /var/www), then check the Dashboard again.
- Could you try to query SQL table "amavisd.msgs" with the column "msgs.content = 'V'"?

5

Re: Dashboard Stats issue

ZhangHuangbin wrote:

- Did you modify any Amavisd config files?
- Try to run "python /opt/www/iredadmin/tools/cleanup_amavisd_db.py" (or "python /var/www/iredadmin/tools/cleanup_amavisd_db.py" if iRedAdmin-Pro is stored under /var/www), then check the Dashboard again.
- Could you try to query SQL table "amavisd.msgs" with the column "msgs.content = 'V'"?

Fixed after running the script.