search

Cacti / plugin_mikrotik

Mikrotik Plugin for Cacti
GNU General Public License v2.0
60 stars 24 forks source link

Error: Unknown column 'no' in 'field list' #50

Closed itmarcanals closed 2 years ago

itmarcanals commented 3 years ago

In log apear some "Error: Unknown column 'no' in 'field list'" in ss_mikrotik_health.php and errors in Error in packet at 'MIKROTIK-MIB in mtxrSerialNumber, mtxrSystem and mtxrFirmwareVersion

Server:

Operating System: CentOS Linux 7 (Core) CPE OS Name: cpe:/o:centos:centos:7 Kernel: Linux 3.10.0-1160.2.2.el7.x86_64 PHP 7.1.33 MySQL Ver 8.0.22 for Linux on x 86_64 (MySQL Community Server - GPL) Cacti 1.2.14

Error log:


2020-11-18 13:07:31 - CMDPHP WARNING: SNMP Error:'snmp2_get(): Error in packet at 'MIKROTIK-MIB::mtxrSerialNumber.0': No Such Object available on this agent at this OID', Device:'188.165.128.83', OID:'.1.3.6.1.4.1.14988.1.1.7.3.0'
--
2020-11-18 13:07:31 - CMDPHP WARNING: SNMP Error:'snmp2_get(): Error in packet at 'MIKROTIK-MIB::mtxrSystem.7.0': No Such Object available on this agent at this OID', Device:'188.165.128.83', OID:'.1.3.6.1.4.1.14988.1.1.7.7.0'
2020-11-18 13:07:31 - CMDPHP WARNING: SNMP Error:'snmp2_get(): Error in packet at 'MIKROTIK-MIB::mtxrFirmwareVersion.0': No Such Object available on this agent at this OID', Device:'188.165.128.83', OID:'.1.3.6.1.4.1.14988.1.1.7.4.0'
2020-11-18 13:07:30 - SYSTEM STATS: Time:1.2418 Method:cmd.php Processes:1 Threads:0 Hosts:2 HostsPerProcess:2 DataSources:37 RRDsProcessed:31
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] WARNING: Invalid Response(s), Errors[1] Device[CASANOVAS - MK] Thread[1] DS[CASANOVAS - MK - Uptime] Graphs[CASANOVAS - MK - Uptime]


2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
--
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - 5.0 Voltage] Graphs[CASANOVAS - MK - 5.0 Voltage] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - 3.3 Voltage] Graphs[CASANOVAS - MK - 3.3 Voltage] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Core Voltage] Graphs[CASANOVAS - MK - Core Voltage] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Voltage] Graphs[CASANOVAS - MK - Voltage] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - CPU Temperature] Graphs[CASANOVAS - MK - CPU Temperature] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Active PPP Connections] Graphs[CASANOVAS - MK - Active PPP Connections] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_snmpget.php ss_mikrotik_snmpget , output: 0
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Sensor Temperature] Graphs[CASANOVAS - MK - Sensor Temperature] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Temperature] Graphs[CASANOVAS - MK - Temperature] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Power] Graphs[CASANOVAS - MK - Power Consumption] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'
2020-11-18 13:07:29 - POLLER: Poller[Main Poller] Device[CASANOVAS - MK] DS[CASANOVAS - MK - Current] Graphs[CASANOVAS - MK - Current Utilization] SERVER: /usr/share/cacti/plugins/mikrotik/templates/scripts/ss_mikrotik_health.php ss_mikrotik_health , output: U
2020-11-18 13:07:29 - CMDPHP SQL Backtrace: (/script_server.php[247]:ss_mikrotik_health(), /plugins/mikrotik/templates/scripts/ss_mikrotik_health.php[37]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020-11-18 13:07:29 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'no' in 'field list'

Some ideas to resolve it?

Thanks!!

TheWitness commented 2 years ago

This one is odd. I'm suspecting that updating to Cacti 1.2.20 might solve this. We had some last minute changes. Were planning on releasing this month, but the changes were pretty significant. So, we are pushing it off to do more testing.

TheWitness commented 2 years ago

No feedback.