iptables + accounting +logging + mysql
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 / [email protected]
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
Quoted 14 lines · 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
Quoted 7 lines
protocol
ip level
un wanted traffici 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
Signature · 8 lines
[email protected] "Using Linux as bandwidth manager" http://www.docum.org/ #lartc @ irc.oftc.net _______________________________________________ LARTC mailing list / [email protected] http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
Hi
i been doing
but nothing find much
if you find any proceedure
can you send me the URL
thanks\blu
Quoted 26 lines · --- Stef Coene
Quoted 3 lines · ba luh
Hi all
thanks for helping me who ever behind to setup my
box
Quoted 6 lines
as a bridge.
my bridge is working fine like below setup
My Lan--- eth1-Bridge-eht0---switch--router--
internet
Quoted 10 lines
i have some user in my office lan
i wopuld like to have accounting like this
protocol
ip level
un wanted traffici would like to know is there prossible to have
all
Quoted 1 line
protocol wise traffic log to send to Mysql and
make
Quoted 1 line
them useful in graphics manner
Quoted 16 lines
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
Signature · 4 lines
[email protected] "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 / [email protected]
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
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 / [email protected]
: http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
:
Signature · 5 lines
Martin A. Brown --- SecurePipe, Inc. --- [email protected] _______________________________________________ LARTC mailing list / [email protected] http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/
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" <[email protected]>
Quoted 57 lines · 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!?
Quoted 13 lines
: Yahoo! Tax Center - forms, calculators, tips,
more
: http://taxes.yahoo.com/
: _______________________________________________ : LARTC mailing list / [email protected] : http://mailman.ds9a.nl/mailman/listinfo/lartc
HOWTO: http://lartc.org/
:Signature · 2 lines
Martin A. Brown --- SecurePipe, Inc. --- [email protected]
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
LARTC mailing list / [email protected]
http://mailman.ds9a.nl/mailman/listinfo/lartc HOWTO: http://lartc.org/