search

Cacti / plugin_reportit

ReportIt Plugin for Cacti
GNU General Public License v2.0
7 stars 8 forks source link

Cacti ReportIt not reporting TDI [Bytes] or TDO [Bytes] correctly in all cases #101

Open jjasen opened 1 year ago

jjasen commented 1 year ago

Describe the bug Failures in collecting TDI/TDO data, resulting in either NA or 0 displayed

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Console, Management, Reports'
  2. select any report to run and run it'
  3. Wait for the report to complete.
  4. Go to the ReportIt tab, select the newly run report, sort by lowest->highest TDI.
  5. Pick a data source showing NA, click on it, and review 7200 second interval successful data collection.

Expected behavior

TDI [Bytes] and TDO [Bytes] should be populated upon a ReportIt run.

Screenshots If applicable, add screenshots to help explain your problem.

Plugin (please complete the following inf Capture-data-cacti ormation):

ReportIt was a git clone from the reportit github repo from last week. This also occurred with ReportIt 1.1.3

jjasen commented 1 year ago

This happens on ReportIt 1.1.3 as well as git/develop branch.

jjasen commented 1 year ago

This was working with Cacti 1.2.14 and ReportIt 1.1.3

TheWitness commented 1 year ago

Hopefully @browniebraun can allocate some time to this one.

jjasen commented 1 year ago

You asked in forum about errors -- we see these during ReportIt runs:

2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared()) 2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list' 2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared()) 2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list' 2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared()) 2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list'