[LARTC] iptables + accounting +logging + mysql

[LARTC] iptables + accounting +logging + mysql

[ba luh]

Hi all

thanks for helping me who ever behind to setup my box
as a bridge.

my bridge is working fine like below setup


My Lan--- eth1-Bridge-eht0---switch--router-- internet

i have some user in my office lan

i wopuld like to have accounting like this

protocol
ip level
un wanted traffic

i would like to know is there prossible to have all
protocol wise traffic log to send to Mysql and make
them useful in graphics manner

thanks
blu




__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
LARTC mailing list / LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/

Re: [LARTC] iptables + accounting +logging + mysql

[Stef Coene]

On Monday 10 March 2003 18:52, ba luh wrote:
> Hi all
>
> thanks for helping me who ever behind to setup my box
> as a bridge.
>
> my bridge is working fine like below setup
>
>
> My Lan--- eth1-Bridge-eht0---switch--router-- internet
>
> i have some user in my office lan
>
> i wopuld like to have accounting like this
>
> protocol
> ip level
> un wanted traffic
>
> i would like to know is there prossible to have all
> protocol wise traffic log to send to Mysql and make
> them useful in graphics manner
I think it's possible.  At least there are tools to log the traffic and graph 
it, but I don't know if they can use mssql as a backend.
Do a google search for it and I'm sure you will find something.

Stef

-- 

stef.coene@docum.org
 "Using Linux as bandwidth manager"
     http://www.docum.org/
     #lartc @ irc.oftc.net

_______________________________________________
LARTC mailing list / LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/

Re: [LARTC] iptables + accounting +logging + mysql

[ba luh]

Hi

i been doing
but nothing find much
if you find any proceedure
can you send me the URL

thanks\blu
--- Stef Coene <stef.coene@docum.org> wrote:
> On Monday 10 March 2003 18:52, ba luh wrote:
> > Hi all
> >
> > thanks for helping me who ever behind to setup my
> box
> > as a bridge.
> >
> > my bridge is working fine like below setup
> >
> >
> > My Lan--- eth1-Bridge-eht0---switch--router--
> internet
> >
> > i have some user in my office lan
> >
> > i wopuld like to have accounting like this
> >
> > protocol
> > ip level
> > un wanted traffic
> >
> > i would like to know is there prossible to have
> all
> > protocol wise traffic log to send to Mysql and
> make
> > them useful in graphics manner
> I think it's possible.  At least there are tools to
> log the traffic and graph 
> it, but I don't know if they can use mssql as a
> backend.
> Do a google search for it and I'm sure you will find
> something.
> 
> Stef
> 
> -- 
> 
> stef.coene@docum.org
>  "Using Linux as bandwidth manager"
>      http://www.docum.org/
>      #lartc @ irc.oftc.net
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
LARTC mailing list / LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/

Re: [LARTC] iptables + accounting +logging + mysql

[Martin A. Brown]

Ba Luh,

There are a number of IP accounting packages you could look into.  Here's
one.

  http://sourceforge.net/projects/ipac-ng/

I have little experience with ipac-ng, but this may be the tool you seek.

I don't know anything about the back end storage, but it looks like it can
use at least postgresql, you can probably also tweak it to use mysql.

If you want to write your own, you should consider the ULOG target in
iptables.

Good luck,

-Martin

 : thanks for helping me who ever behind to setup my box
 : as a bridge.
 :
 : my bridge is working fine like below setup
 :
 :
 : My Lan--- eth1-Bridge-eht0---switch--router-- internet
 :
 : i have some user in my office lan
 :
 : i wopuld like to have accounting like this
 :
 : protocol
 : ip level
 : un wanted traffic
 :
 : i would like to know is there prossible to have all
 : protocol wise traffic log to send to Mysql and make
 : them useful in graphics manner
 :
 : thanks
 : blu
 :
 :
 :
 :
 : __________________________________________________
 : Do you Yahoo!?
 : Yahoo! Tax Center - forms, calculators, tips, more
 : http://taxes.yahoo.com/
 : _______________________________________________
 : LARTC mailing list / LARTC@mailman.ds9a.nl
 : http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
 :

-- 
Martin A. Brown --- SecurePipe, Inc. --- mabrown@securepipe.com

_______________________________________________
LARTC mailing list / LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/

Re: [LARTC] iptables + accounting +logging + mysql

[ba luh]

Hi

Could you just give small example
how can log all the traffic inclusing Forward, Input,.
Output, Drop

and all protocols seperatly

thanks
blu
--- "Martin A. Brown" <mabrown-lartc@securepipe.com>
wrote:
> Ba Luh,
> 
> There are a number of IP accounting packages you
> could look into.  Here's
> one.
> 
>   http://sourceforge.net/projects/ipac-ng/
> 
> I have little experience with ipac-ng, but this may
> be the tool you seek.
> 
> I don't know anything about the back end storage,
> but it looks like it can
> use at least postgresql, you can probably also tweak
> it to use mysql.
> 
> If you want to write your own, you should consider
> the ULOG target in
> iptables.
> 
> Good luck,
> 
> -Martin
> 
>  : thanks for helping me who ever behind to setup my
> box
>  : as a bridge.
>  :
>  : my bridge is working fine like below setup
>  :
>  :
>  : My Lan--- eth1-Bridge-eht0---switch--router--
> internet
>  :
>  : i have some user in my office lan
>  :
>  : i wopuld like to have accounting like this
>  :
>  : protocol
>  : ip level
>  : un wanted traffic
>  :
>  : i would like to know is there prossible to have
> all
>  : protocol wise traffic log to send to Mysql and
> make
>  : them useful in graphics manner
>  :
>  : thanks
>  : blu
>  :
>  :
>  :
>  :
>  :
> __________________________________________________
>  : Do you Yahoo!?
>  : Yahoo! Tax Center - forms, calculators, tips,
> more
>  : http://taxes.yahoo.com/
>  : _______________________________________________
>  : LARTC mailing list / LARTC@mailman.ds9a.nl
>  : http://mailman.ds9a.nl/mailman/listinfo/lartc
> HOWTO: http://lartc.org/
>  :
> 
> -- 
> Martin A. Brown --- SecurePipe, Inc. ---
> mabrown@securepipe.com
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
LARTC mailing list / LARTC@mailman.ds9a.nl
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/