1 Topic by Rudigern

  • Rudigern
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 19

Topic: amavis logged message details encoded emails

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5.2
- Deployed with iRedMail Easy or the downloadable installer? download
- Linux/BSD distribution name and version: CentOS 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- 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.
====

When I login to iRedAdmin-Pro the senders and receivers are encoded. Something like \x3934ad23483de03943abe9324 (not a real one)

Looking at the database the maddr table sometimes has the same value for email as email_raw. I've done some test accounts and new ones get added where the email column in this table is the \x23423 one and email_raw is the correct email address.

My guess is there was a bad config or old version at some point that was producing bad data and as I'm not dropping the maddr table it's retaining this bad data.

I'm thinking I could just drop all the data from maddr and probably msgs and it would probably be fixed but want to check first. Is there a way to fix it normally or just dropping the data could also fix it? (Historic data isn't that important).

----

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,082

Re: amavis logged message details encoded emails

It's "caused" by PostgreSQL column type. This is expected.

3 Reply by Rudigern

  • Rudigern
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 19

Re: amavis logged message details encoded emails

So whats the solution to being able to see the email address in the iRedPro-Admin interface? At the moment it just shows the encoded string.

4 Reply by Rudigern

  • Rudigern
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 19

Re: amavis logged message details encoded emails

I updated the db with: 

update maddr set email_raw = encode(email, 'escape') where email_raw like '\\x%';

and it translated all the bytea data in email_raw into normal email addresses and has fixed iRedMail Pro interface. Not sure how it got into this format in the first place.

5 Reply by ZhangHuangbin

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

Re: amavis logged message details encoded emails

Seems an Amavisd issue to me. sad

6 Reply by Rudigern

  • Rudigern
  • Member
  • Offline
  • Registered: 2016-12-05
  • Posts: 19

Re: amavis logged message details encoded emails

Quite possibly. I was running an old version for a while and quite possibly miss-matched to iRedMail versions. New email addresses weren't a problem, just old ones (the ones actually on the server). After the update everything has been running fine.