1 Topic by icedevil

  • icedevil
  • icedevil
  • Member
  • Offline
  • From: Bucharest, Romania
  • Registered: 2010-03-15
  • Posts: 51

Topic: save incomming and outgoing mail subject in MYSQL DB

is there a way to save incomming and outgoing mail subject for all users to DB?

----

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,131

Re: save incomming and outgoing mail subject in MYSQL DB

It's better to hack Amavisd to implement this feature. Try to ask in mail list of amavisd

3 Reply by icedevil

  • icedevil
  • icedevil
  • Member
  • Offline
  • From: Bucharest, Romania
  • Registered: 2010-03-15
  • Posts: 51

Re: save incomming and outgoing mail subject in MYSQL DB

it seems if you use sql logging, its all done!

4 Reply by maxie_ro

  • maxie_ro
  • Member
  • Offline
  • From: Constanţa, România
  • Registered: 2009-10-09
  • Posts: 214

Re: save incomming and outgoing mail subject in MYSQL DB

icedevil wrote:

it seems if you use sql logging, its all done!

SQL logging where and how? tongue

5 Reply by icedevil (edited by icedevil 2010-07-06 22:55:16)

  • icedevil
  • icedevil
  • Member
  • Offline
  • From: Bucharest, Romania
  • Registered: 2010-03-15
  • Posts: 51

Re: save incomming and outgoing mail subject in MYSQL DB

1. amavisd.conf
@lookup_sql_dsn = ( ['DBI:mysql:database=amavisd;host=127.0.0.1;port=3306', 'vmail', 'password'] );

2. DB
   create database amavisd;
   grant all privileges on amavisd.* to vmail@'localhost' identified by 'password';
   flush privileges;

3. you can find in README_FILES/README.sql-mysql from amavisd-new package the sql table schemas;