1

Topic: Mail Log Sender and Recipient information missing

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version: CENTOS 6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MYSQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? YES
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

I found that my mail log have some problem after upgrade to Pro 3.5.

It cannot show the Sender and Recipient information, but not all .. some Recipient can show (as Attached).

May I know which part I'm missing?

Thanks!

B.Rgds.
Roy Wong

Post's attachments

mailLog.jpg
mailLog.jpg 93.31 kb, file has never been downloaded. 

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

2

Re: Mail Log Sender and Recipient information missing

- Login to iRedAdmin-Pro as global admin, release or delete quarantined emails first.
- Run SQL commands below as root user:

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

This should fix it.

----

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 (edited by roy.wong 2019-07-10 13:56:12)

Re: Mail Log Sender and Recipient information missing

ZhangHuangbin wrote:

- Login to iRedAdmin-Pro as global admin, release or delete quarantined emails first.
- Run SQL commands below as root user:

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

This should fix it.

Hi Zhang,

This problem Fixed. Thanks!

But another problem, when i delete user, it show "INVALID_API_AUTH_TOKEN" (Attached)then force logout. After login again, the deleted account is disappear from iRedAdmin-Pro portal, any advise?

Thanks!

Post's attachments

delUser.jpg
delUser.jpg 52.82 kb, file has never been downloaded. 

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

4

Re: Mail Log Sender and Recipient information missing

Check the value of parameter "mlmmjadmin_api_auth_token" in iRedAdmin-Pro config file (/opt/www/iredadmin/settings.py), is the value listed in /opt/mlmmjadmin/settings.py, parameter "api_auth_tokens"?

----

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: Mail Log Sender and Recipient information missing

ZhangHuangbin wrote:

Check the value of parameter "mlmmjadmin_api_auth_token" in iRedAdmin-Pro config file (/opt/www/iredadmin/settings.py), is the value listed in /opt/mlmmjadmin/settings.py, parameter "api_auth_tokens"?

Success. Thanks So much.

and i found that dovecot still in "dovecot-2.1.17-0_136.el6.x86_64" version, phpMyAdmin is "4.2.0" and MySQL is "5.1.73".

Any tutorials for update this application?

Thanks!

6

Re: Mail Log Sender and Recipient information missing

- Dovecot 2.1.17 is the latest version of 2.1.x branch, you can stick to it.
- iRedMail doesn't ship phpMyAdmin anymore for a looooong time, you should consider remove it too due to security concern. Alternative is adminer (one single PHP file): https://adminer.org/

We always recommend to upgrade packages from the official yum repo offered by your Linux vendor.

----

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

buy me a cup of coffee