1

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.

2

Re: Top Senders / Top Recipients empty after upgraded

TonnarakNET wrote:

#content_filter = smtp-amavis:[127.0.0.1]:10024

You comment out "content_filter", that means Amavisd won't scan incoming emails. So no surprise the top sender/recipients are empty. smile

3

Re: Top Senders / Top Recipients empty after upgraded

Fixed!

# Amavisd + SpamAssassin + ClamAV
#
content_filter = smtp-amavis:[127.0.0.1]:10024

/etc/init.d/amavis restart
/etc/init.d/postfix reload

Thank you very much. smile