Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysqmail-postfix-logger(8) [debian man page]

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

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 for updates. SEE ALSO
syslog(3), logger(8) mysqmail-postfix-logger(8)

Check Out this Related Man Page

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

mysqmail-courier-logger - logs courier-imap traffic to a mysql database SYNOPSIS
mysqmail-courier-logger subprogram [ args ... ] DESCRIPTION
mysqmail-courier-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq- mail-courier-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf. mysqmail-courier-logger uses a table corresponding to this one: CREATE TABLE IF NOT EXISTS pop_access ( id varchar(32) NOT NULL default '', uid int(11) NOT NULL default '65534', gid int(11) NOT NULL default '65534', home varchar(255) NOT NULL default '', shell varchar(255) NOT NULL default '', mbox_host varchar(120) NOT NULL default '', crypt varchar(50) NOT NULL default '', passwd varchar(50) NOT NULL default '', active int(11) NOT NULL default '1', start_date date NOT NULL default '0000-00-00', expire_date date NOT NULL default '0000-00-00', quota_size int(11) NOT NULL default '0', type varchar(20) NOT NULL default 'default', memo text,du bigint(20) NOT NULL default '0', another_perso varchar(5) NOT NULL default 'no', redirect1 varchar(255) default NULL, redirect2 varchar(255) default NULL, localdeliver varchar(10) NOT NULL default 'yes', pop3_login_count int(9) NOT NULL default '0', pop3_transfered_bytes int(14) NOT NULL default '0', imap_login_count int(9) NOT NULL default '0', imap_transfered_bytes int(14) NOT NULL default '0', last_login int(14) NOT NULL default '0', PRIMARY KEY (id,mbox_host) ) TYPE=MyISAM To have mysqmail-courier-logger working, you should have issued mkfifo /var/log/courier.fifo to create the fifo and use nohup cat /var/log/courier.fifo | /usr/bin/mysqmail-courier-logger > /dev/null 2>&1 & to launch it. VERSION
This documentation describes mysqmail-courier-logger version 0.1.4. See for updates. SEE ALSO
qmail-send(3), syslog(3), logger(8) mysqmail-logger(8)
Man Page

Featured Tech Videos