1 Topic by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

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 Reply by ZhangHuangbin

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

Re: Dashboard Stats issue

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

3 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

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 Reply by ZhangHuangbin

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

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 Reply by saquib.akhtar

  • saquib.akhtar
  • saquib.akhtar
  • Member
  • Offline
  • From: INDIA
  • Registered: 2018-02-20
  • Posts: 110

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.