-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 have you looked at Ntop? if so were there issues?
Robert On 3/30/10 12:24 PM, Matt Larsen - Lists wrote: > Hello list, > > I am looking for a solution that will keep track of the monthly > bandwidth consumption for all of my broadband customers and am having a > hard time coming up with a good solution. > Our goal is to collect the traffic flows every 15 minutes and generate > three things: > > 1) Internal reports showing bandwidth consumption by customers and > that is in a database form that we can perform queries on > 2) Data that can be exported to our customer portal page that will > show customers how much bandwidth they have consumed since the first of > each month > 3) A batch file showing customers over their thresholds that we can > import into our billing system (Freeside) at the end of the month so we > can bill overages > > Our system is setup as follows: > 1) StarOS access points > 2) OSPF backbone back to two separate 50 meg Internet backbone links > 3) Mikrotik core routers at each backbone location > 4) StarOS routers performing NAT at each backbone location > 5) Mikrotik edge routers connected to the Internet backbone > > Radius accounting is not an option, due to inaccurate IP accounting > information returned by the StarOS APs. PPPoE is also not an option as > we have 2000+ customers in place and not all of the hardware would > easily convert to PPPoE. > > Ideally, the data should be collectable at the Mikrotik core routers, as > that is the place where all of the private IP traffic is still in its > pre-NAT status. We have been trying to keep track of it with Netflow > data from our Mikrotik core routers, but it does not seem to be accurate > and there are documented problems with the Mikrotik Netflow exports. We > have confirmed that the data we have been collecting is not accurate, > and I have no intention on billing a customer based on inaccurate data. > > We have a couple of reporting engines that we have tried, with mixed > levels of success. I did contact Brandon Checketts about his program, > which was close to what we wanted, but it is out of date and he was not > responsive so our efforts are focused on either using something open > source that we can modify or just buying an appliance that will do what > we need. My preference is to go open source because we have multiple > backbone connections and also because I have several consulting > customers who want to have similar setups put in place on their > networks. Also, I want to make sure that this is "revenue neutral" and > can pay for for itself in the overage billing after it is installed. > > We can install either a switch or a transparent bandwidth monitoring > server of some kind between the core and NAT servers to collect the data > flows. My lead tech and I are both Linux savvy, and would prefer > something that runs on Linux. > I recall that Travis Johnson posted a description of an open source, > linux-based system that he uses to track bandwidth, but I cannot find > the email where he lays all of the elements out. Does anyone have any > recommendations for this situation? > > Thanks! > > Matt Larsen > vistabeam.com > > _______________________________________________ > Mikrotik mailing list > Mikrotik@mail.butchevans.com > http://www.butchevans.com/mailman/listinfo/mikrotik > > Visit http://blog.butchevans.com/ for tutorials related to Mikrotik > RouterOS > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJLslinAAoJEMpomM6iKZApMsgIAKADPCsd0PL8MklIf9YH+aPL 6op/cY6SgDKtYnxLBt1CqALEey1DFBaffmBLdpLILDFD1TTsn6I/1m4CM/Q2SGrR V087iz4qdjiwEerTjWFxQbSGwHBExHgImBF7p/A15xBlOeLILOPnls4puA7g7jOa fQTEfZy57UHxKr2tEmsXzjpnkngLQfU61sXmKPhQn9PgyWwd/AwScAu4Z7o760U4 t+g6LPE2MRkfrg6l18IXv6zbVHFPiXtBvPlGOw6keancfvcXBJlT5ZeUBUqxP+rb PnmlDSSUxbiKn02WcoBIokWGDFEa1LaEnecTqPlrszkESr2XASRtz3TF6d5CQHw= =TfTd -----END PGP SIGNATURE----- _______________________________________________ Mikrotik mailing list Mikrotik@mail.butchevans.com http://www.butchevans.com/mailman/listinfo/mikrotik Visit http://blog.butchevans.com/ for tutorials related to Mikrotik RouterOS