Skip to contentSkip to conversation

iptables + accounting +logging + mysql

LARTC ba luh 3 participants 5 messages Mar 10, 2003

lore
Share & tools
lore

ba luh

author
#0 lore raw

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/

#1 lore raw
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 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

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/
author
#2 lore raw
In reply to ba luh

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 traffic

i 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/

#3 lore raw
In reply to ba luh

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/
author
#4 lore raw
In reply to 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" <[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/