Topic: Top Senders / Top Recipients empty after upgraded
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.1
- Linux/BSD distribution name and version: ubuntu 18.04 LTS
- 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.
====
I have followed up this KB https://forum.iredmail.org/topic14624-t … ents.html.
It still doesn't help.
@storage_sql_dsn = (['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306', 'amavisd', 'xxxxxx']);
main.cf:
#
# Amavisd + SpamAssassin + ClamAV
#
#content_filter = smtp-amavis:[127.0.0.1]:10024
# Concurrency per recipient limit.
smtp-amavis_destination_recipient_limit = 1
127.0.0.1:10025 inet n - n - - smtpd
-o syslog_name=postfix/10025
-o content_filter=
MariaDB [(none)]> USE amavisd;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [amavisd]> TRUNCATE quarantine;
Query OK, 0 rows affected (0.05 sec)
MariaDB [amavisd]> TRUNCATE msgrcpt;
Query OK, 0 rows affected (0.07 sec)
MariaDB [amavisd]> TRUNCATE msgs;
Query OK, 0 rows affected (0.12 sec)
MariaDB [amavisd]> TRUNCATE maddr;
Query OK, 0 rows affected (0.07 sec)
MariaDB [amavisd]> DESC maddr;
+---------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+----------------+
| partition_tag | int(11) | YES | MUL | 0 | |
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| email | varbinary(255) | NO | MUL | NULL | |
| email_raw | varbinary(255) | NO | MUL | | |
| domain | varchar(255) | NO | MUL | NULL | |
+---------------+---------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
NOTE: I have upgraded from iRedMail-0.9.9 to iRedMail-1.0 (I have found the issues since upgrade here but I ignore about this until upgraded iRedadmin Pro 4.4)
iRedAPD 2.7 > 3.3
iRedAdmin 0.9.6 > 0.9.9
roundcube 1.3.8 > 1.4.1
iRedAdmin-Pro-SQL-4.0 to iRedAdmin-Pro-SQL-4.1.2
and
iRedMail-1.0 to iRedMail-1.3.1
iRedAPD-3.3 to iRedAPD-4.4
mlmmjadmin-2.1 to mlmmjadmin-3.0.2
roundcube 1.4.1 > 1.4.8
netdata-v1.19.0.gz.run to netdata-v1.24.0.gz.run
iRedAdmin-Pro-SQL-4.1.2 to iRedAdmin-Pro-SQL-4.4
Thank you in advance.
Best regards,
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.