Poster of Linux kernelThe best gift for a Linux geek
mysqmail-postfix-logger

mysqmail-postfix-logger

Section: Maintenance Commands (8)
Local index Up
 

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)


 

Index

NAME
SYNOPSIS
DESCRIPTION
VERSION
SEE ALSO

This document was created by man2html, using the manual pages.
Time: 22:02:01 GMT, April 16, 2011