Hi Andrew, thanks for the suggestion, pmacct is one I have looked at already, it certainly has some merit and is pretty flexible, once I can get the IP accounting happy I can then try to integrate into our billing system, using static IP's for everybody makes it easier too. Regards Paul -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Andrew Van Slageren Sent: Wednesday, 12 November 2014 8:18 PM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] ccr's and routeros 1.20+ Bit premature on my reply there! I'm currently running pmacct (http://www.pmacct.net/) to collect netflow from a fleet of ESXi boxes, push it into RabbitMQ and then into an ELK instance. It apparently also has MySQL backend support, so could be worth some investigation. Cheers, Andrew. -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Andrew Van Slageren Sent: Wednesday, 12 November 2014 8:11 PM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] ccr's and routeros 1.20+ -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Paul Julian Sent: Wednesday, 12 November 2014 8:01 PM To: 'MikroTik Australia Public List' Subject: Re: [MT-AU Public] ccr's and routeros 1.20+ Thanks guys, I have been looking at netflow collectors to dump data into MySQL but also found the figures to be a bit dodgy, perhaps I might give it another go, any suggestions on good collectors that are around ? Regards Paul -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Alex Samad - Yieldbroker Sent: Wednesday, 12 November 2014 7:59 PM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] ccr's and routeros 1.20+ Hi I am using netflow more for traffic monitoring. I have I found pre 6.19 the numbers where just wrong. I think around 6.12 they were good.. Alex
-----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Andrew Cox Sent: Wednesday, 12 November 2014 7:10 PM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] ccr's and routeros 1.20+
Hey Paul,
http://blog.naturalnetworks.net/2007/08/recording-routeross-ip- accounting-data.html - this might be useful in your quest to use the IP accounting, but personally I'd recommend building a netflow collector instead just for easier ability to scale.
- Andrew {snip}
Off topic a bit, but I wanted to ask is anybody using Mikrotik for NBN LNS termination in a DHCP modem and if so how are you handling multiple AVC's for each customer and DHCP to them ? I was thinking that just bridging them was the best option but a wary of doing that, would appreciate any comments on the design required if anybody is willing to share, and once you get there any good suggestions on IP accounting packages which can dump the IP accounting info from the router into MySQL ?
Regards Paul
-----Original Message----- {snip}
_______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone. Deakin University does not warrant that this email and any attachments are error or virus free. _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone. Deakin University does not warrant that this email and any attachments are error or virus free. _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au