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

[Lance Vermilion]

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
>>
>> 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
>>
>
>