debian man page for mysqmail-postfix-logger

Query: mysqmail-postfix-logger

OS: debian

Section: 8

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

mysqmail-postfix-logger(8)				      System Manager's Manual					mysqmail-postfix-logger(8)

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)
Related Man Pages
gammu-smsd-mysql(7) - debian
gammu-smsd-pgsql(7) - debian
mysqmail-dovecot-logger(8) - debian
loggerutils(n) - suse
logger(1) - freebsd
Similar Topics in the Unix Linux Community
postfix connection timed out issue on centOS
Change ip from user input
Mounting temperature logger on Centos 7.0
Python program
Send email using postfix