On Mon, 24 Mar 2003, Christian Schulte wrote:
Hi
I'm interesting to test that fonctionnality.
My boss keep bugging me to have some sort of statistics about the
use of cyrus imap server.
> Hello,
>
> I wrote a patch which enables one to do traffic logging into a mysql
> database. (mainly lib/prot.c lib/prot.h) The table in which that happens
> could look something like:
>
> CREATE TABLE cyrus_accounting (
> id int(11) NOT NULL auto_increment,
> login varchar(128) NOT NULL default '',
> service
> enum('IMAP','POP','OTHER','FILESYSTEM','BACKEND','LMTP','DELIVER','LMTP_FILESYSTEM','LMTP_TEMP','LMTP_SHUTDOWN','SHUTDOWN')
>
> NOT NULL default 'OTHER',
> bytes double NOT NULL default '0',
> type enum('IN','OUT') NOT NULL default 'UNSPECIFIED',
> connect_time datetime default NULL,
> disconnect_time datetime NOT NULL default '0000-00-00 00:00:00',
> PRIMARY KEY (id),
> KEY stamp (connect_time),
> KEY login (login)
> ) TYPE=InnoDB;
>
> If anybody has interest in that I could post the patch. I would have to
> do some changes to make everything configurable in the imapd.conf file
> first so that I cannot post the patch unchanged for now and wanted to
> ask first.
>
> --Christian--
>
>
--
Eric Doutreleau
I.N.T | Tel : +33 (0) 160764687
9 rue Charles Fourier | Fax : +33 (0) 160764321
91011 Evry France | email : [EMAIL PROTECTED]
