* Re: [LARTC] iptables + accounting +logging + mysql
2003-03-10 17:52 [LARTC] iptables + accounting +logging + mysql ba luh
@ 2003-03-10 18:17 ` Stef Coene
2003-03-10 18:22 ` ba luh
` (2 subsequent siblings)
3 siblings, 0 replies; 5+ messages in thread
From: Stef Coene @ 2003-03-10 18:17 UTC (permalink / raw)
To: lartc
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/
^ permalink raw reply [flat|nested] 5+ messages in thread* Re: [LARTC] iptables + accounting +logging + mysql
2003-03-10 17:52 [LARTC] iptables + accounting +logging + mysql ba luh
2003-03-10 18:17 ` Stef Coene
@ 2003-03-10 18:22 ` ba luh
2003-03-10 18:28 ` Martin A. Brown
2003-03-10 18:34 ` ba luh
3 siblings, 0 replies; 5+ messages in thread
From: ba luh @ 2003-03-10 18:22 UTC (permalink / raw)
To: lartc
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/
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: [LARTC] iptables + accounting +logging + mysql
2003-03-10 17:52 [LARTC] iptables + accounting +logging + mysql ba luh
2003-03-10 18:17 ` Stef Coene
2003-03-10 18:22 ` ba luh
@ 2003-03-10 18:28 ` Martin A. Brown
2003-03-10 18:34 ` ba luh
3 siblings, 0 replies; 5+ messages in thread
From: Martin A. Brown @ 2003-03-10 18:28 UTC (permalink / raw)
To: lartc
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/
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: [LARTC] iptables + accounting +logging + mysql
2003-03-10 17:52 [LARTC] iptables + accounting +logging + mysql ba luh
` (2 preceding siblings ...)
2003-03-10 18:28 ` Martin A. Brown
@ 2003-03-10 18:34 ` ba luh
3 siblings, 0 replies; 5+ messages in thread
From: ba luh @ 2003-03-10 18:34 UTC (permalink / raw)
To: lartc
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/
^ permalink raw reply [flat|nested] 5+ messages in thread