1

Topic: Received and sent emails not visible

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9
- Deployed with iRedMail Easy or the downloadable installer?: Installer
- Linux/BSD distribution name and version: Debian 9.11
- 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 can't see the list of sent and received emails (see screenshots). This is since 0.9.7.
Can anyone help?

Regards
Peter

Post's attachments

2.png
2.png 19.41 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

2

Re: Received and sent emails not visible

Try this:

- Login to iRedAdmin-Pro as global admin
- Delete or release quarantined mails, make sure no quarantined mails left.
- Run SQL commands as root user:

USE amavisd;
TRUNCATE quarantine;
TRUNCATE msgrcpt;
TRUNCATE msgs;
TRUNCATE maddr;

Now it should be fine.

Also, make sure you're running the latest iRedAdmin-Pro.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

3

Re: Received and sent emails not visible

ZhangHuangbin wrote:

Try this:

- Login to iRedAdmin-Pro as global admin
- Delete or release quarantined mails, make sure no quarantined mails left.
- Run SQL commands as root user:

USE amavisd;
TRUNCATE quarantine;
TRUNCATE msgrcpt;
TRUNCATE msgs;
TRUNCATE maddr;

Now it should be fine.

Also, make sure you're running the latest iRedAdmin-Pro.

Unfortunately this didn't help. I did as mentioned above and sent a test mail. The result is the same (see screenshot).

Post's attachments

Bildschirmfoto vom 2019-09-12 07-47-25.png
Bildschirmfoto vom 2019-09-12 07-47-25.png 17.91 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

4

Re: Received and sent emails not visible

Could you please show me output of SQL commands below (run as SQL root user):

USE amavisd;
DESC maddr;

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

5

Re: Received and sent emails not visible

Sorry for thew late reply - here it is:

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    |                |
| domain        | varchar(255)        | NO   | MUL | NULL    |                |
+---------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

6

Re: Received and sent emails not visible

Your "maddr" table doesn't have column "email_raw", this is introduced in iRedMail-0.9.8, so it's quite obvious that you missed this step while upgrading your iRedMail server.
https://docs.iredmail.org/upgrade.iredm … xtension_1

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

7

Re: Received and sent emails not visible

ZhangHuangbin wrote:

Your "maddr" table doesn't have column "email_raw", this is introduced in iRedMail-0.9.8, so it's quite obvious that you missed this step while upgrading your iRedMail server.
https://docs.iredmail.org/upgrade.iredm … xtension_1

Thanks a lot - this did the trick.