Config manager/ Router config backup

[tpolim008]

Hi All, I am new to cacti and running into an issue that I cant seem to figure out and was wondering if anyone might be able to provide me some assistance. I am trying routerconfig backup plugin and config manager to work and having issues. Can anyone provide me any guidance on how to correct the following. Running cacti 0.8.8.g on ubuntu 14.4 LTS


05/02/2016 11:12:34 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
05/02/2016 11:12:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"
05/02/2016 11:12:34 AM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_routerconfigs_devices'. Error was 'Table 'cactidb.plugin_routerconfigs_devices' doesn't exist'
05/02/2016 11:12:13 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
05/02/2016 11:12:13 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"
05/02/2016 11:10:11 AM - AUTH LOGIN: User 'admin' Authenticated
05/02/2016 11:10:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from plugin_cfgmng "

[VinxItak]

Hi,

I just found the solution (cacti 0.8.8h, configmanager 0.826), the problem is that the mysql tables for configmanager were not created.
1/ edit plugins/configmanager/install_uninstall/sql-install-manually-configmanager.sql and replace from TYPE=MyISAM; to ENGINE=MyISAM;
2/ execute manually sql command : mysql --user=%mysqluser% --password %your_db% < install_uninstall/sql-install-manually-configmanager.sql

[edit : your error messageq were not exactly the same as mine, so it's maybe not the solution. I just had this message : CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select * from plugin_cfgmng "]