Man Linux: Main Page and Category List


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


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


       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;


       This  documentation  describes  mysqmail-postfix-logger  version 0.1.4.
       See for updates.


       syslog(3), logger(8)