Man Linux: Main Page and Category List

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)

                                                            mysqmail-logger(8)