Network Operations Guide

Sat Sep 8 14:30:42 UTC 2007

On 25/08/2007, at 7:04 AM, Bill Nash wrote:

> On Fri, 24 Aug 2007, Bill Nash wrote:
>> I built a perl daemon using Net::BGP and DBI that inserted and  
>> removed
>> routes, on update, into an SQL db. I could then query to my hearts
>> content, beating up a db with full routes with all the efficiency  
>> of SQL.
>> It's simple as hell and works great.
>
> Just to answer a bunch of off-list mails en masse, no, I do not have a
> copy of this code for distribution. I wrote it originally for an
> ex-employer, so I don't have a copy. I plan on rebuilding it, it's  
> fairly
> simple, so if you have use cases for a tool like this, shoot me an  
> email
> off list with your thoughts. Time permitting, I'll rebuild and post. I
> need it for some of my own purposes anyway, might as well make it suck
> less.

An alternative that I've been meaning to tinker with for some time  
might be to use OpenBGPd/zebra/quagga dumping to a file, and load  
that file in to SQL.

I like that a bit more than INSERT/DELETE direct to SQL, because  
those dump files are dumps of all BGP messages, as well as table  
states, so you can move to any point in time when diagnosing problems.

A quick google reveals http://nms.lcs.mit.edu/software/bgp/bgptools/  
- tools that can deal with SQL and MRT dump files.

--
Nathan Ward