<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RANCID as an Element of a CMDB System</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi All<BR>
<BR>
We've recently been tasked with putting together a CMDB system, and one aspect of this system is the storage (and further analysis) of router configurations. Currently, this is handled in the following way:<BR>
<BR>
1. A rancid instance pulls router configs into the usual "config" directory, resulting in a collection of ,v files.<BR>
2. A "cmdb agent script" regularly polls the directory and extracts all new configs and changed router configs into a MySQL database schema. at this point the router configs are considered to be within the CMDB proper.<BR>
3. Staff with access to a php web interface can view the physical elements of routers (chassis, Slots, PSU, Processor, Feature Cards etc ...) and their serial and part numbers and thus conduct Asset Tracking and Stores Management.<BR>
<BR>
At this point, the system is functional, but a major problem I forsee is keeping the database schema up to date so that when new router models appear with new hardware element fields and formats I would have to modify the schema and some back-end import code to cater for new fields.<BR>
Ideally, 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.<BR>
<BR>
Does such a thing exist? Alternatively, is there a RANCID variant out there which already imports router configs to SQL databases?<BR>
<BR>
Thanks in Advance,<BR>
Traiano<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>