Query: mysqmail-courier-logger
OS: debian
Section: 8
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
mysqmail-logger(8) System Manager's Manual mysqmail-logger(8)NAMEmysqmail-courier-logger - logs courier-imap traffic to a mysql databaseSYNOPSISmysqmail-courier-logger subprogram [ args ... ]DESCRIPTIONmysqmail-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.VERSIONThis documentation describes mysqmail-courier-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.SEE ALSOqmail-send(3), syslog(3), logger(8) mysqmail-logger(8)
Related Man Pages |
---|
loggerappender(n) - mojave |
gammu-smsd-mysql(7) - debian |
mysqmail-courier-logger(8) - debian |
loggerappender(n) - suse |
makepercentrelay(8) - osx |
Similar Topics in the Unix Linux Community |
---|
font courier doesn't seem to work for me |
courier-imap auth problem |
reverse sort |
Keep lines with specific words up in an order |
Search for a pattern in a file and split the line into two lines |