Server08 - Routerconfigs issue

[druwade]

Hi Guys,

Im not going to pretend, I am indeed very new to this, running Server 08 rc2 and attempting to get routerconfigs to run.

I have installed it however when I attempt to add a device or authentication, nothing is added and the following happens:

09/30/2011 03:40:34 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
09/30/2011 03:40:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"
09/30/2011 03:40:34 AM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_routerconfigs_devices'. Error was 'Table 'cacti.plugin_routerconfigs_devices' doesn't exist'
09/30/2011 03:40:28 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
09/30/2011 03:40:28 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"

Any help in resolving this would be greatly appreciated.

[TheWitness]

What version of Routerconfigs? What version of PIA? What version of Cacti?

[fenris]

I am having the same issue. Server 2008 R2, used windows installer, Cacti Version: 0.8.7g, Plugin Architecture Version: 2.8, routerconfigs v0.3

I am using solarwinds TFTP server.

I know its a SQL issue, but I am not sure how to fix it.. Any help would be great!


0/27/2011 05:28:19 PM - CMDPHP: Poller[0] ERROR: SQL Save Command Failed for Table 'plugin_routerconfigs_accounts'. Error was 'Table 'cacti.plugin_routerconfigs_accounts' doesn't exist'
10/27/2011 05:28:12 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_accounts"
10/27/2011 05:28:12 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_accounts limit 0, 30"
10/27/2011 05:28:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT device, id FROM plugin_routerconfigs_backups ORDER BY btime ASC"
10/27/2011 05:28:11 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_backups"
10/27/2011 05:28:11 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_routerconfigs_devices.hostname,plugin_routerconfigs_devices.ipaddress, plugin_routerconfigs_backups.id,plugin_routerconfigs_backups.username,plugin_routerconfigs_backups.lastchange, plugin_routerconfigs_backups.btime, plugin_routerconfigs_backups.device, plugin_routerconfigs_backups.directory, plugin_routerconfigs_backups.filename FROM plugin_routerconfigs_devices,plugin_routerconfigs_backups WHERE plugin_routerconfigs_devices.id = plugin_routerconfigs_backups.device ORDER BY plugin_routerconfigs_backups.btime DESC limit 0, 30"

[TheWitness]

Reinstall from the latest SVN. It will create the missing tables for you.