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

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)

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

NAME

       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 http://gplhost.com/softwares-mysqmail.html for updates.

SEE ALSO

       qmail-send(3), syslog(3), logger(8)

																mysqmail-logger(8)