sourCEntral - mobile manpages

pdf

mysqmail-logger

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, mysqmail-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)

pdf