.TH mysqmail-qmail-logger 8 .SH NAME mysqmail-qmail-logger \- logs smtp traffic to a mysql database .SH SYNOPSIS .B mysqmail-qmail-logger .I subprogram [ .I args ... ] .SH DESCRIPTION .B mysqmail-qmail-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. .B mysqmail-qmail-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; .SH "VERSION" This documentation describes .B mysqmail-logger version 0.1.4. See .B http://gplhost.com/?rub=softwares for updates. .SH "SEE ALSO" qmail-send(3), syslog(3), logger(8)