Home
Personal
Unix
Programming
Networking
Documents
Reporting
APCUPS
SpamAssassin
DBMail
Weblog
CityRail
BOM pictures
Other projects
Contact me
               
   

DBMail (in combination with LogReports Lire)

The ISP I work for has changed their POP3/IMAP infrastructure from a mailbox system to DBMail, a mail-storage database backend with IMAP/POP3 frontends.

Logfile format

The DBMail logfile for POP3 is like this:

Oct 29 00:00:32 mag dbmail/pop3d[1936]: handle_client(): incoming connection from [10.194.62.131]
Oct 29 00:00:32 mag dbmail/pop3d[1936]: pop3(): user lmcdonald logged in [messages=2, octets=10240]
Oct 29 00:00:33 mag dbmail/pop3d[1936]: handle_client(): user lmcdonald logging out [message=1, octets=2048]
The first line is the connection setup (origin IP address), the second one is the login (username, number of messages on server and amount of space) and the third is logoff (the number of messages left on the server and the amount of space)

The DBMail logfile for IMAP is like this:

Oct 29 00:43:19 mag dbmail/imap4[92594]: SS_WaitAndProcess(): client @ socket 3 (IP: 202.181.6.2) accepted 
Oct 29 00:43:19 mag dbmail/imap4[92594]: COMMAND: [00000000 CAPABILITY] 
Oct 29 00:43:19 mag dbmail/imap4[92594]: COMMAND: [00000001 AUTHENTICATE LOGIN] 
Oct 29 00:43:20 mag dbmail/imap4[92594]: IMAPD [PID 92594]: user (id 549, name mfraser) login accepted @ 2002-10-29 00:43:19^M 
Oct 29 00:43:20 mag dbmail/imap4[92594]: COMMAND: [00000002 CAPABILITY] 
Oct 29 00:43:20 mag dbmail/imap4[92594]: COMMAND: [00000003 LOGOUT] 
Oct 29 00:43:20 mag dbmail/imap4[92594]: IMAPD [PID 92594]: user (id:549) logging out @ (null)^M 
Oct 29 00:43:20 mag dbmail/imap4[92594]: imap_process(): Closing connection for client from IP [202.181.6.2] 
And I have no intention for finding out how it works.

The result

                                                                  
Report generated: 2002-10-30 15:02:11 EST
Reporting on period:
2002-10-29 00:00:01 EST - 2002-10-30 00:00:09 EST

                            Protocol Reports
                            ----------------

  Number of Events by Protocol

   pop .................................................. 251345

                               By Period
                               ---------

  Login by 1d Period

   2002-10-28 ................................................ 0
   2002-10-29 ............................................ 82917
   2002-10-30 ................................................ 4

  Failed Logins by 1d Period

   2002-10-28 ................................................ 0
   2002-10-29 ............................................... 89

  Close By 1d Period

   2002-10-28 ................................................ 0
   2002-10-29 ............................................ 82754
   2002-10-30 ................................................ 4

  Unique Users by 1d Period

   2002-10-28 ................................................ 0
   2002-10-29 .............................................. 414
   2002-10-30 ................................................ 4

                                Top user
                                --------

  Most Active Users (login action), Top 20

   gmoore ................................................. 1718
   pwalker ................................................ 1625
   iirvine ................................................ 1413
   adamson ................................................ 1404
   mdalton ................................................ 1389
   gfurness ............................................... 1381
   acoleman ............................................... 1376
   newlinds ............................................... 1337
   ccleary ................................................ 1334
   meinfeld ............................................... 1333
   gordon ................................................. 1282
   pdowdy ................................................. 1175
   yvette ................................................. 1126
   duncan ................................................. 1061
   aspencer ................................................ 959
   hirish .................................................. 906
   swalsh .................................................. 894
   tomasetti ............................................... 798
   plarkin ................................................. 708
   ksmith .................................................. 704

  Most Active Users (Select Action), Top 20

  No content in report.

  Users With Most Messages Downloaded, Top 20

   michaelg ................................................. 78
   11gbcclerk ............................................... 68
   yvette ................................................... 62
   ihemmings ................................................ 60
   bdoorey .................................................. 55
   mkearns .................................................. 51
   dcampbell ................................................ 50
   nproctor ................................................. 48
   dhogan ................................................... 45
   efrizell ................................................. 43
   pittypat ................................................. 41
   lmcdonald ................................................ 41
   fpiercy .................................................. 39
   ktwomey .................................................. 37
   rmargetts ................................................ 36
   mdalton .................................................. 35
   csimpson ................................................. 35
   abennett ................................................. 35
   rcobden .................................................. 34
   npoynder ................................................. 34

  Users With Most Bytes Downloaded, Top 20

   rparsons ............................................... 6.9M
   bdoorey ................................................ 6.3M
   mwalsh ................................................. 4.7M
   jsharpe ................................................ 4.6M
   jsheahan ............................................... 4.5M
   lmcdonald .............................................. 4.4M
   sibtain ................................................ 4.0M
   igroberts .............................................. 4.0M
   cronalds ............................................... 3.8M
   pittypat ............................................... 3.7M
   michaelg ............................................... 3.3M
   kerr ................................................... 2.7M
   eivanovski ............................................. 2.6M
   wgmuddle ............................................... 2.5M
   mkearns ................................................ 2.4M
   khunt .................................................. 2.3M
   fpiercy ................................................ 2.3M
   cwebster ............................................... 2.2M
   rmccoll ................................................ 2.2M
   phillips ............................................... 2.2M

  Users With Most Messages Leftover, Top 20

   pclay ................................................... 848
   connell ................................................. 191
   abennett ................................................ 126
   mthangaraj .............................................. 124
   ihemmings ............................................... 113
   gturnbull ................................................ 92
   janderson ................................................ 90
   gellis ................................................... 88
   brogan ................................................... 82
   rfm ...................................................... 72
   ctraill .................................................. 63
   sduggan .................................................. 61
   ptaylor .................................................. 39
   pdowdy ................................................... 29
   duncan ................................................... 23
   southwick ................................................ 23
   asiderovski .............................................. 23
   jwebster ................................................. 19
   drimmer .................................................. 19
   amoses ................................................... 16

  Users With Most Bytes Leftover, Top 20

   pclay ................................................. 62.9M
   connell ................................................ 9.6M
   gellis ................................................. 7.5M
   rfm .................................................... 6.5M
   ptaylor ................................................ 5.8M
   ctraill ................................................ 3.7M
   gturnbull .............................................. 3.3M
   janderson .............................................. 3.3M
   mthangaraj ............................................. 2.2M
   abennett ............................................... 1.9M
   jbasten ................................................ 1.6M
   ihemmings .............................................. 1.5M
   sduggan ................................................ 1.5M
   nhutley ................................................ 1.4M
   wford .................................................. 1.3M
   duncan ................................................. 1.3M
   pdowdy ................................................. 1.3M
   brogan ................................................. 1.2M
   amoses ................................................. 1.1M
   asiderovski .......................................... 774.2k

       
               
               

$Id: dbmail.php,v 1.1 2002/10/30 05:12:05 mavetju Exp $