1 Topic by jpetruzz

  • jpetruzz
  • Member
  • Offline
  • Registered: 2021-03-29
  • Posts: 1

Topic: Determine recipient of quarantined emails

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

Is it possible to determine the recipient address of a quarantined email without opening the mail_text blob?

I am trying to avoid opening the blob and potentially seeing other users info.

I see you can find the subject and sender by looking up the mail_id in the msgs table, but not the recipient.  Is the recipient stored elsewhere?  Or can it somehow be stored in the msgs table?

----

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: Determine recipient of quarantined emails

In "amavisd" sql db, column "msgs.sid" is sender and points to "maddr.id", column "msgrcpt.rid" is recipient and points to "maddr.id". If "msgs.mail_id" is same as "msgrcpt.mail_id", then they're linked to same message.