Backup router plugin - error

[acvoliveira]

Hello all,

Recently i´ve installed the router backup plugin, but it didn´t work... I think there is a problem with the plugin, SQL or with the interaction between the plugin and SQL DB.

Did anyone had the same problem? How can I fix it?

I´m using CACTI version 0.8.7g, Linux Debian 6.0...

Follow the log...

08/29/2013 10:48:26 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_accounts limit 0, 30"
08/29/2013 10:48:26 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_accounts"
08/29/2013 10:48:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"
08/29/2013 10:48:37 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"
08/29/2013 10:48:38 AM - 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"
08/29/2013 10:48:38 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_backups"
08/29/2013 10:48:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT device, id FROM plugin_routerconfigs_backups ORDER BY btime ASC"
08/29/2013 10:48:39 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_accounts limit 0, 30"
08/29/2013 10:48:39 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_accounts"
08/29/2013 10:48:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_routerconfigs_devices ORDER BY hostname limit 0, 30"
08/29/2013 10:48:45 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM plugin_routerconfigs_devices"

Does anyone have any clue how to fix it? My e-mail is alexandre.vilarinho@neovia.com.br

Regards

Alex

[mabelrxu]

it looks like the user that the plugin is running as does not have permissions to select any tables in your cacti database ...

try a

Code: Select all

mysql -u <username> -p <cacti database name>

and then execute the SELECT commands from your log to see if it's a permissions issue?

[acvoliveira]

I´ve found the problema... For some reason, the plugin do not add to the DB the router config tables, and I had to add them manualy.

Now I can add the device, but CACTI is not able to donwload and backup the configuration file...

I looking if there is something wrong...

[acvoliveira]

I´ve managed to get the plugin working fine with no error, but is not backing up automatically... Shoudn´t it execute the automatic backup every day? Is there something that I need to do, to make it execute according to my need?

[syl22]

Hello !

(sorry for my poor english)

I had the same problem and i resolved it by following instructions here:
http://abdulet.net/?p=140

Everything works fine now.

Bye

Sylvain

[acvoliveira]

Thanks for the reply... I will do what is in the webpage. Hope it will works.

[acvoliveira]

I´ve followed the instructions on the webpage you suggested, but unfortunately it didn´t work.

Do you have any more suggestions?