NAME

       mysqmail-postfix-logger - logs smtp traffic to a mysql database

SYNOPSIS

       mysqmail-postfix-logger subprogram [ args ...  ]

DESCRIPTION

       mysqmail-postfix-logger  reads the syslog using tail -F and for each lines, does an action
       in  a  selected  table  in  the  selected   mysql   server   (configuration   done   using
       /etc/mysqmail.conf).  All  messages that have been delivered are marqued as so in the from
       and in the to field of the smtp traffic table.

       mysqmail-postfix-logger uses a table corresponding to this one:

       CREATE TABLE  IF NOT EXISTS smtp_logs (
         id int(11) NOT NULL auto_increment,
         newmsg_id bigint(20) default NULL,
         bounce_qp int(11) default NULL,
         bytes int(11) NOT NULL default '0',
         sender_user varchar(128) NOT NULL default '',
         sender_domain varchar(128) NOT NULL default '',
         delivery_id bigint(20) default NULL,
         delivery_user varchar(128) NOT NULL default '',
         delivery_domain varchar(128) NOT NULL default '',
         delivery_success enum('yes','no') NOT NULL default 'no',
         time_stamp timestamp(14) NOT NULL,
         PRIMARY KEY  (id),
         UNIQUE KEY bounce_qp (bounce_qp),
         UNIQUE KEY newmsg_id (newmsg_id),
         KEY sender_domain (sender_domain),
         KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;

VERSION

       This    documentation    describes    mysqmail-postfix-logger    version    0.1.4.     See
       http://gplhost.com/softwares-mysqmail.html for updates.

SEE ALSO

       syslog(3), logger(8)

                                                                       mysqmail-postfix-logger(8)