1

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?

2

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

Re: save incomming and outgoing mail subject in MYSQL DB

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

4

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 (edited by icedevil 2010-07-06 22:55:16)

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;