1 Topic by mohamedmaalej.sde (edited by mohamedmaalej.sde 2017-05-06 00:47:01)

  • mohamedmaalej.sde
  • Member
  • Offline
  • Registered: 2017-01-23
  • Posts: 26

Topic: Retrieving the message recipient address from Iredmail databases

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.6.9
- Linux/BSD distribution name and version: Debian server Jessie
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): PGSQL
- Web server (Apache or Nginx): NONE
- Manage mail accounts with iRedAdmin-Pro? NO
- Related log if you're reporting an issue: NONE
====

I tried to retrieve the recipient's mail address of a given (mail / message), I tried to figure out this information in the amavisd Database in the "msgrcpt" table. I found only "from_address". Where can I find the 'to_address' (The address of the recipient) ??
Is there any way to do that ? If yes, how ??


Thank you in advance.

----

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: 30,770

Re: Retrieving the message recipient address from Iredmail databases

*) msgs.mail_id = msgrcpt.mail_id
*) msgs.sid = maddr.id
*) msgrcpt.rid = maddr.id