CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146' Cacti
Error:
01/11/2017 07:22:55 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0"
Cause & Solution:
Check and found that cacti DB does not have plugin_routerconfigs_devicetypes table. Added the Table in the cacti DB with following Commands.
INSERT INTO plugin_routerconfigs_devicetypes (id, name, username, password, copytftp, version, confirm, forceconfirm) VALUES (1, 'Cisco IOS', 'sername:', 'assword:', 'copy run tftp', 'show version', 'y', 0),(2, 'Cisco CatOS', 'sername:', 'assword:', 'copy config tftp', '', 'y', 1);
01/11/2017 07:22:55 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devicetypes WHERE id = 0"
Cause & Solution:
Check and found that cacti DB does not have plugin_routerconfigs_devicetypes table. Added the Table in the cacti DB with following Commands.
INSERT INTO plugin_routerconfigs_devicetypes (id, name, username, password, copytftp, version, confirm, forceconfirm) VALUES (1, 'Cisco IOS', 'sername:', 'assword:', 'copy run tftp', 'show version', 'y', 0),(2, 'Cisco CatOS', 'sername:', 'assword:', 'copy config tftp', '', 'y', 1);
No comments