1 Topic by sbignell

  • sbignell
  • Member
  • Offline
  • Registered: 2018-09-05
  • Posts: 24

Topic: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

==== 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: Centos7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- 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'm not sure when this started, as it's only just been brought to my attention.

When you try to display the sent/received emails in iRedadmin Pro it doesn't bring them up. I've checked that the emails are being logged to the amavisd mysql databse which they are, I've made sure the  database username and password are correct, but when I try to display the sent emails for instance, the number of pages available to view goes up so I assume that iRedadmin Pro is reading the database correctly, but it simply doesn't display any emails. See attached Image. If I refresh the page the number of pages available increases but still no emails are displayed.

----

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: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

Dear @sbignell,

Sorry about this trouble. Could you attach the image?
Or, contact us directly: https://www.iredmail.org/contact.html

3 Reply by ZhangHuangbin

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

Re: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

Did you upgrade iRedMail from an old release? Could you please show me output of SQL commands below?

USE amavisd;
DESC maddr;

Also, you can try steps below to fix it:

- Login to iRedAdmin-Pro as global admin
- Clean up all quarantined emails (release the clean ones and delete the spams/viruses)
- Login to MySQL server as root user, then run commands below to EMPTY related SQL tables:

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

Then it should work.

4 Reply by sbignell (edited by sbignell 2019-08-28 08:39:03)

  • sbignell
  • Member
  • Offline
  • Registered: 2018-09-05
  • Posts: 24

Re: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

ZhangHuangbin wrote:

Did you upgrade iRedMail from an old release? Could you please show me output of SQL commands below?

USE amavisd;
DESC maddr;

Also, you can try steps below to fix it:

- Login to iRedAdmin-Pro as global admin
- Clean up all quarantined emails (release the clean ones and delete the spams/viruses)
- Login to MySQL server as root user, then run commands below to EMPTY related SQL tables:

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

Then it should work.

These steps have been completed. Doesn't appear to have made any difference other than reset the count of emails available (page numbers reset but still not displaying emails).

It was a fresh install of 0.9.8 upgraded to 0.9.9


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

5 Reply by ZhangHuangbin

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

Re: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

It's more like you installed iRedMail-0.9.7 instead of 0.9.8, because SQL column "maddr.email_raw" is missing.
This SQL change is mentioned in upgrade tutorial for iRedMail-0.9.7:
https://docs.iredmail.org/upgrade.iredm … xtension_1

6 Reply by sbignell

  • sbignell
  • Member
  • Offline
  • Registered: 2018-09-05
  • Posts: 24

Re: iRedadmin Pro (3.9) not displaying Sent/Recieved Emails

ZhangHuangbin wrote:

It's more like you installed iRedMail-0.9.7 instead of 0.9.8, because SQL column "maddr.email_raw" is missing.
This SQL change is mentioned in upgrade tutorial for iRedMail-0.9.7:
https://docs.iredmail.org/upgrade.iredm … xtension_1

That was it. Thank You so much!