1 Topic by mithu

  • mithu
  • Member
  • Offline
  • Registered: 2011-03-20
  • Posts: 31

Topic: Mail delivery log is not showing in iRedadmin

==== Required information ====
- iRedMail version: iRedmail-0.6.0 (iRedAdmin-Pro v1.4.1)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Apache
- Linux/BSD distribution name and version: Centos 6
- Related log if you're reporting an issue:
====

We are using iredmail from 3 years ago. Mail are delivering properly but from few days there are not showing senders, receivers and also Quarantined Mails in the Dashboard of iRedadmin.
Do you have any idea?

----

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,094

Re: Mail delivery log is not showing in iRedadmin

*) Do you have '@storage_sql_dsn =' enabled in Amavisd config file /etc/amavisd.conf or /etc/amavisd/amavisd.conf?
*) Do you have correct SQL username/password in iRedAdmin-Pro config file (/var/www/iredadmin/settings.py)?

3 Reply by mithu

  • mithu
  • Member
  • Offline
  • Registered: 2011-03-20
  • Posts: 31

Re: Mail delivery log is not showing in iRedadmin

Zahang Wrote:
...............................................
*) Do you have '@storage_sql_dsn =' enabled in Amavisd config file /etc/amavisd.conf or /etc/amavisd/amavisd.conf?
*) Do you have correct SQL username/password in iRedAdmin-Pro config file (/var/www/iredadmin/settings.py)?


We checked, '@storage_sql_dsn has enabled of that config file and  SQL username/password is already corrected but there are not showing statistics.

4 Reply by ZhangHuangbin

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

Re: Mail delivery log is not showing in iRedadmin

Not sure why it happened. Some questions:

*) Does it take long time to login to iRedAdmin-Pro?
*) Do you have cron job to run 'tools/cleanup_amavisd_db.py' to remove old records in Amavisd database?
*) How many records in SQL table `amavisd.msgs`?

Let's see whether this issue is related to slow SQL queries (caused by too many records in `amavisd.msgs` and other tables).