IRedMail/FAQ/MySQL/Monitor.Incoming.and.Outgoing.Mails.with.BCC

From iRedMail
Revision as of 07:49, 26 July 2011 by ZhangHuangbin (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents


This tutorial describes how to configure your iRedMail server (MySQL backend) to monitor incoming and outgoing mails with BCC, via iRedAdmin-Pro or MySQL command line.

Configure BCC with iRedAdmin-Pro

With iRedAdmin-Pro, you can configure BCC easily:

Per-domain BCC settings

Go to domain profile page, then you can enable sender bcc or recipient bcc in tab 'BCC'.

Per-user BCC settings

Go to user profile page, then you can enable sender bcc or recipient bcc in tab 'Advanced'.

Configure BCC via MySQL command line

Per-domain BCC settings

We will configure both sender bcc and recipient bcc for domain example.com in below example. With this configure:

  • all outgoing emails will be BCCed to address outgoing@example.com.
  • all incoming emails will be BCCed to address incoming@example.com.
Terminal:
$ mysql -uroot -p
mysql> USE vmail;

/* Sender BCC */
mysql> INSERT INTO sender_bcc_domain (domain, bcc_address, created)
              VALUES ('example.com', 'outgoing@example.com', NOW());

/* Recipient BCC */
mysql> INSERT INTO recipient_bcc_domain (domain, bcc_address, created)
              VALUES ('example.com', 'incoming@example.com', NOW());

Per-user BCC settings

We will configure both sender bcc and recipient bcc for user user@example.com in below example. With this configure:

  • all mails sent by user@example.com will be BCCed to address outgoing@example.com.
  • all received emails for user@example.com will be BCCed to address incoming@example.com.
Terminal:
$ mysql -uroot -p
mysql> USE vmail;

/* Sender BCC */
mysql> INSERT INTO sender_bcc_user (username, bcc_address, domain, created)
              VALUES ('user@example.com', 'outgoing@example.com', 'example.com', NOW());

/* Recipient BCC */
mysql> INSERT INTO recipient_bcc_user (username, bcc_address, domain, created)
              VALUES ('user@example.com', 'incoming@example.com', 'example.com', NOW());
Personal tools