Query: mysqmail-dovecot-logger
OS: debian
Section: 8
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
mysqmail-dovecot-logger(8) System Manager's Manual mysqmail-dovecot-logger(8)NAMEmysqmail-dovecot-logger - logs dovecot-imapd and dovecot-pop3d traffic to a mysql databaseSYNOPSISmysqmail-dovecot-logger subprogram [ args ... ]DESCRIPTIONmysqmail-dovecot-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq- mail-dovecot-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf. mysqmail-dovecot-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=MyISAMVERSIONThis documentation describes mysqmail-dovecot-logger version 0.4.4 or superior. See http://gplhost.com/softwares-mysqmail.html for updates.SEE ALSOqmail-send(3), syslog(3), logger(8) mysqmail-dovecot-logger(8)
Related Man Pages |
---|
doveadm-log(1) - debian |
dovecot(1) - debian |
gammu-smsd-pgsql(7) - debian |
dovecot(1) - centos |
dovecot(1) - freebsd |
Similar Topics in the Unix Linux Community |
---|
Keep lines with specific words up in an order |
cutting field |
Script to remove line of text |
Home email server setup - stuck |
Mounting temperature logger on Centos 7.0 |