[rancid] Re: RANCID as an Element of a CMDB System

[Traiano Welcome]

Lance
 
Quite true. Thanks for this advice, a number of those points are worth looking at. It suggests I should look at first creating a set of scripts to generate a schema (or an approximate schema) given standard configs from cisco/juniper, and then creating code generic enough to handle new schema adjustments.
 
Time to hit that drawing board :-)
 
Regards,
Traiano
 
 
 

________________________________

From: lavermil at gheek.net on behalf of Lance Vermilion
Sent: Tue 2008/09/23 06:42 PM
To: Traiano Welcome
Cc: Oliver Gorwits; rancid-discuss at shrubbery.net
Subject: Re: [rancid] Re: RANCID as an Element of a CMDB System



Traniano,

I don't think it should be that hard. It will for sure take a little
bit of research to come up with a set of common commands between all
the systems that rancid supports. I would look at the commandtable and
then create a table for each vendor that way it can remain fairly
consistent and all your fields would match what you have in your
rancid file. You could create a table for each general command and
then just reference it via the nodeid. Different thoughts for sure one
is more relational while one is more flat. Anyway you layout the
database it is still going to be a result of what is captured from the
commandtable.

The above statement is the easy part, the not so fun part is changing
up rancid to use that database. Writting it isn't tough, it will be
getting it added to the distro so many can use all the hard work.

On Tue, Sep 23, 2008 at 1:19 AM, Traiano Welcome <twelcome at tenet.ac.za> wrote:
>
> How easy would it be to use the database schema and backend code, possibly
> with a different UI, do you think?
> Well, it's worth a try, it's one of those ymmv things :-)
>
>
>
> -----Original Message-----
> From: Lance Vermilion [mailto:lavermil at gheek.net]
> Sent: Mon 9/22/2008 6:47 PM
> To: Traiano Welcome
> Cc: Oliver Gorwits; rancid-discuss at shrubbery.net
> Subject: Re: [rancid] Re: RANCID as an Element of a CMDB System
>
> Traiano,
>
> The biggest downfall to Netdisco is that it is not a simple install. I
> think that is what has plagued the project. The UI could use a little
> updating, but it gets the job done.
>
> On Mon, Sep 22, 2008 at 1:47 AM, Traiano Welcome <twelcome at tenet.ac.za>
> wrote:
>> Hi Oliver
>>
>> I've gone some way towards building the router schema based on ENTITY-MIB
>> and others (quite labour intensive :-)). Netdisco seems to overlap a lot
>> of
>> what I've done, and offer a number of better features, so it might be
>> worth
>> looking at integrating it into the CMDB system I'm trying to build, as
>> opposed to the custom stuff I've scripted.
>>
>> Many Thanks!
>> Traiano
>>
>>
>> -----Original Message-----
>> From: rancid-discuss-bounces at shrubbery.net on behalf of Oliver Gorwits
>> Sent: Fri 9/19/2008 3:46 PM
>> To: rancid-discuss at shrubbery.net
>> Subject: [rancid] Re: RANCID as an Element of a CMDB System
>>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Hi Traiano,
>>
>> Traiano Welcome wrote:
>> | what I want is a pre-canned sql schema for each
>> | model router config (or a single generic one!) which would allow me
>> | to easily import a router config into a database.
>>
>> If you were using SNMP, you could poll the ENTITY-MIB on the network
>> devices. This would reveal their hardware configuration, and it uses a
>> standardized language as described in section 3 of RFC 2737.
>>
>> Some systems such as Netdisco will do this, and insert it into an SQL
>> database. The database schema is quite simple; the RFC uses a strict
>> hierachical model for the physical entities.
>>
>> You could look at the Netdisco or SNMP::Info code for some ideas,
>> perhaps, and translate them for your RANCID-based system.
>>
>> regards,
>> oliver.
>> - --
>> Oliver Gorwits, Network and Telecommunications Group,
>> Oxford University Computing Services
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (GNU/Linux)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org <http://enigmail.mozdev.org/> 
>>
>> iD8DBQFI061B2NPq7pwWBt4RAi52AJ93VHcMrSvg5JBCNTkW1H7Kbh2wDACfUVmu
>> h2KgL6cIfWtD7yfzw8x1rMI=
>> =7Yay
>> -----END PGP SIGNATURE-----
>> _______________________________________________
>> Rancid-discuss mailing list
>> Rancid-discuss at shrubbery.net
>> http://www.shrubbery.net/mailman/listinfo.cgi/rancid-discuss
>>
>>
>> _______________________________________________
>> Rancid-discuss mailing list
>> Rancid-discuss at shrubbery.net
>> http://www.shrubbery.net/mailman/listinfo.cgi/rancid-discuss
>>
>
>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.shrubbery.net/pipermail/rancid-discuss/attachments/20080924/1b15a318/attachment.html