1

Topic: Decode failed in Subject column

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

Hello,

I've backup and restore a server on a new machine and everything works fine except the subject column in iredadmin Pro sometime reports <<< DECODE FAILED >>>. See attached file.

This happen for half the emails in the Received,Sent and Quarantined section.

Any ideas what might cause this ?

Thanks

Post's attachments

Screen Shot 2020-09-10 at 10.31.01 AM.png
Screen Shot 2020-09-10 at 10.31.01 AM.png 17.78 kb, file has never been downloaded. 

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

2

Re: Decode failed in Subject column

Which iRedAdmin-Pro release are you running?

----

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: Decode failed in Subject column

ZhangHuangbin wrote:

Which iRedAdmin-Pro release are you running?

hey Zhang,

I'm running 4.4 (PostgreSQL)

4

Re: Decode failed in Subject column

Could you help extract this SQL record from SQL table "amavisd.msgs"? I'd like to check its "subject".

----

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: Decode failed in Subject column

Here's what the subject look like in amavisd msgs table for one of the message which have a DECODE FAILED:

\x50726f74c383c2a967656f6e73206c65732070c3a2c280c2997469747320706f756d6f6e73206465206e6f7320656e66616e7473

6

Re: Decode failed in Subject column

Any ideas ?

7

Re: Decode failed in Subject column

Quack66 wrote:

\x50726f74c383c2a967656f6e73206c65732070c3a2c280c2997469747320706f756d6f6e73206465206e6f7320656e66616e7473

This is not a valid encode/decoded subject.
It's possible that the sender didn't compose it correctly (mostly spammer), hence no way to properly decode it.

Don't panic, if something is wrong, it could be the data source, not only the iRedAdmin-Pro part. smile

----

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

buy me a cup of coffee

8

Re: Decode failed in Subject column

Make sense. Thanks for the update Zhang