BandwidthD - how to send data to MySQL?

bob76535 · Feb 1, 2010, 3:39 PM

I recently added the BandwidthD package to our pfsense box. It works great but we want to send the data to our MySQL server (sits on our LAN). It appears to have an option (somewhere) to send to a DB but I can find no documentation on it. The BandwidthD forums are old and dead and I can't find any docs for it.

Can anyone here enlighten me.

Thanks

Bob

bob76535 · Feb 5, 2010, 3:46 PM

I have found out a little bit about the problem here so I though I would add. It does not support MySQL but we just added Postgresql to one of the lan machine to handle that. The real problem is that the package that is installed from the pfsense package manager is the non database capable version. To use an external DB the database capable package needs to be installed. I can't seem to figure out how to do that. I have searched for instructions but I have found none.

Has anyone else out there done this successfully? We want to log the bandwidth used by each IP behind the firewall. They are all static public ips and there is no DHCP. If BandwidthD can't cut it, is there a package that will?

Thanks

Bob

rkelleyrtp · Feb 13, 2010, 2:44 PM

Hey Bob,

Have you tried using MRTG or Cacti on a management server instead of using bandwidthd on the pfSense machine? You can use SNMP to poll the pfSense machines to collect the data.

-Ron