MySQL support for Argus

[Mitesh P Choksi]

Dear All,

I am not sure how others use argus, but for me Argus has been a tool to find 
out data usage pattern.

We provide shared bandwidth to customers and its important that 20% of users 
dont take up my 80% of bandwidth. I keep an eye on the bandwidth utilization 
using several tools. At times I find out that during a certain peak, a user 
had done data transfer from an IP, etc. etc. Top N users, Top N protocols, 
Graphs per protocols, graphs per user/IP, graphs per group of IPs, etc would 
also help me.

Things like concurrent flows, number of packets, number of bytes, etc. and 
their aggregations and then graphing on a 10 minute aggregate helps even a 
layman understand what's happening.

I usually move records onto MS Excel, do some manipulations and then move 
them onto MS Access then do some manipulations and move them again into MS 
Excel and then do graphs. If I have a database like MySQL having records then 
I will be willing to draw up the graphs using cgi and moving complete 
reporting in web based format.

Todate, I had just been lazy to move things into MySQL and start learning it. 
If this software can give me a boost, I can start doing some useful things 
using MySQL and help me spend less time in the 10's of manipulations I do.

Hope this helps all.

Regards,

Mitesh

---------- Original Message -----------
Wrom: YZUNNYCGPKYLEJGDGVCJVTLBXFGGMEPYOQKED
To: "'John Studarus'" <john at jhlconsulting.com>, <argus-
info at lists.andrew.cmu.edu>
Sent: Tue, 16 Sep 2003 09:43:01 -0400
Subject: RE: MySQL support for Argus

> Hey John,
>    Thanks!!!!  If you are interested in having it as a part of
> the argus release, only two things.  We'll need to package it
> as a tar file, which will be in the contrib directory with
> you as the contact for fixes etc...., and it will have to be
> released under the GNU license.  If you're cool with that,
> then we'll add it to the argus-clients release when you're
> ready!!
> 
>    I'm sure that most can imagine how having a schema and
> import/export/query tools can really help using argus data,
> especially for Java and Perl/Python users, but can you
> describe how its helped you in developing your application(s)?
> 
> Hope all is very well!!!
> 
> Carter
> 
> > -----Original Message-----
> > Wrom: OTWFAOBUZXUWLSZLKBRNVWWCUFPEGAUTFJMVR
> > [mailto:owner-argus-info at lists.andrew.cmu.edu] On Behalf Of
> > John Studarus
> > Sent: Monday, September 15, 2003 1:11 AM
> > To: argus-info at lists.andrew.cmu.edu
> > Subject: MySQL support for Argus
> >
> >
> >
> >   For those of you that are interested, I have developed 'ramysql'
> > which imports Argus files into a MySQL database.  I saw that MySQL
> > support was on the "wish list" of features for Argus.  If anyone is
> > interested in the code please drop me a line.  I'd also be interested
> > in knowing how people intend to use the database so I can design the
> > schema appropriately.
> >   I worked with Carter while I was a graduate student at Carnegie
> > Mellon.  I'm currently using Argus as the backend to a web based
> > network traffic monitoring system.
> >
> >         John Studarus
> >
------- End of Original Message -------