Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Custom reports in BandwidthD? Or how do I download the log.cdf file?

    Scheduled Pinned Locked Moved pfSense Packages
    5 Posts 3 Posters 6.7k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      cinepro
      last edited by

      I've got BandwidthD up and running on my pfSense 1.2.1-rc1 system.  Is there any way to create custom reports (i.e. weekly), or am I limited to the daily/monthly/yearly reports that come with it?

      I also have it set to save data to the htdocs/log.cdf file, but how can I actually download that file to use it?

      Thanks for any input…

      JB

      1 Reply Last reply Reply Quote 0
      • R
        rhy7s
        last edited by

        The *.cdf files are actually up a level from the htdocs folder (in /usr/local/bandwidthd/) you can SCP in if SSH is enabled. http://doc.pfsense.org/index.php/HOWTO:_Access_pfSense_filesystems_remotely_with_scp

        1 Reply Last reply Reply Quote 0
        • R
          rhy7s
          last edited by

          Does anyone know how to analyse the cdf spreadsheet to create reports for custom date ranges?

          1 Reply Last reply Reply Quote 0
          • H
            Hormah
            last edited by

            Sheesh.. I have now been searching high and low to find an answer to this question. Some previous user has posted a similar query to mine but there was no finite answer. I can understand why.. I suppose; running a database on your firewall isn't such a good idea…. Here is the post link: http://forum.pfsense.org/index.php?topic=3234.0

            My question. BandwidhtD generates its log files and then save them in /usr/local/bandwidhtd log.1.0.cdf etc. I want to parse these files using a PHP script and then post the field values to a MySQL database running on some other server. After some research, I have managed to get MySQL working by installing the MySQL client package and the mysql.so extension. (It may be a good idea to make this part of future releases...?)

            The issue, as correctly pointed out by the other user, PFsense or something restores the default php.ini file. Not nice :(. I can appreciate this for stability reasons. I have a work around to load the mysql.so extension, but there must be a better way. Here is how I am currently doing it:

            dl('mysql.so'); //Loading the mysql database extension
            $FSQLHost = "192.168.1.105"; //IP address of other Server
            $FSQLUser = "root";
            $FSQLPass = "somepass";
            $FSQLDB = "bandwidthd";

            $FSQLLink = mysql_connect($FSQLHost, $FSQLUser, $FSQLPass) ; //Connection to the database running on 192.168.1.105:3306
            mysql_select_db($FSQLDB, $FSQLLink);

            $mqry = "show databases";
            $fdata = mysql_query($mqry, $FSQLLink);

            while ($fline = mysql_fetch_assoc($fdata)) {
              print_r($fline);
            }

            ?>

            Questions:
            1. How can I load the extension on start-up like one normally would using the php.ini
            2. Am I re-inventing the wheel here. I know about the postgres solution, but I need this to work on PHP for very custom reports. Would be nice if there was a out-of-the box tool for custom reporting and data mining.

            Any help will be greatly appreciated.

            1 Reply Last reply Reply Quote 0
            • R
              rhy7s
              last edited by

              @rhy7s:

              Does anyone know how to analyse the cdf spreadsheet to create reports for custom date ranges?

              Still would like to know how to go about this if anyone has a method to use, there's the link on the wiki http://devwiki.pfsense.org/BandwidthD but I get a message about too many rows when opening my yearly log. I'd really like to get a custom report per IP for custom date ranges but not sure how to achieve this.

              1 Reply Last reply Reply Quote 0
              • First post
                Last post
              Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.