Routerconfig bulk import

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
robertocaramia
Posts: 4
Joined: Wed Aug 14, 2013 4:08 am

Routerconfig bulk import

Post by robertocaramia »

Hi all,
a week ago i have installed the routerconfig plugin and it is a very useful plugin but it don't permit the bulk import from a file or (better) the import from the device tab like smokeping.
I found a very raw solution working directy on the database making a insert into the routerconfig device table from the host table (before i create an account ("1") to logon an the routers).

that's the mysql query that i use:

INSERT INTO plugin_routerconfigs_devices (ipaddress,hostname,account) SELECT hostname,description,"1" FROM host;

As result i have all my routers under routerconfig backup but it is not a scalable solution.

Anyone have found a better solution?

Thanks
rvk
Posts: 10
Joined: Mon Feb 24, 2020 11:48 am

Re: Routerconfig bulk import

Post by rvk »

Thank you. It's still a working solution. I suggest not putting in the line just like that, instead put a WHERE clause to only add those hosts that are actually the ones you want. i did: ... WHERE description like "AB%SW%';
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest