1

Topic: iRedMail MySQL archive email using domain BCC

==== Required information ====
- iRedMail version: v0.3.3 (MySQL)
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: CentOS 6 on DigitalOcean VPS
- Related log if you're reporting an issue:
====

This is a quick how to add archiving to the iRedMail that works just like in the the Pro version.

I was used to doing this in the pro version but for our company I could not justify spending the money, therefore I am working on many scripts to do the work.

for example.com

In the Web GUI
1.) Create incoming@example.com and outgoing@example.com

Using MySQL, I use the command line but you can do this in phpmyadmin as well


2.) Type 'mysql vmail' at the command line. You should get a mysql prompt, if you don't you need to setup the correct authentication with mysql.

Passwords are located in your /root/iRedMail*/*tips file. Look for the root password
then at the command line: 'mysql -u root -p'

This will prompt you for your password.




use vmail
insert into recipient_bcc_domain (domain,bcc_address,active,created,modified) VALUES('example.com','incoming@example.com',1,NOW(),NOW());

insert into sender_bcc_domain (domain,bcc_address,active,created,modified) VALUES('example.com,'incoming@example.com',1,NOW(),NOW());

The above should complete without error and say that 1 row was affected.

check out your work:

select * from sender_bcc_domain;
select * from recipient_bcc_domain;


That should work.

Using iRedPro is MUCH easier.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: iRedMail MySQL archive email using domain BCC

We have a detailed tutorial for you:
http://www.iredmail.org/docs/monitor.in … h.bcc.html

3

Re: iRedMail MySQL archive email using domain BCC

Nice, I wish I had the tutorial before.

Might help in the tutorial to add that fact that you have to create the accounts first.

4

Re: iRedMail MySQL archive email using domain BCC

jpforte wrote:

Might help in the tutorial to add that fact that you have to create the accounts first.

You're right. Tutorial updated. smile
http://www.iredmail.org/docs/monitor.in … h.bcc.html