[15644] in North American Network Operators' Group
Re: [nanog] Re: Q: IP Space Management Software
daemon@ATHENA.MIT.EDU (S.T.Balbach)
Fri Mar 13 00:04:21 1998
Date: Thu, 12 Mar 1998 23:51:12 -0500 (EST)
From: "S.T.Balbach" <stephen@clark.net>
To: rjohnson@deliverance.genuity.net
cc: Brantley Jones <bjones@cte.net>, nanog@merit.edu
In-Reply-To: <199803122228.PAA23152@deliverance.genuity.net>
On Thu, 12 Mar 1998, Ron Johnson wrote:
> Oh, and a side note for the database flag bearers.
> Databases, don't help much, as they tend to hide the view. Allocation of IP
> space is akin to creation of jigsaw puzzles, that you received completed
> intact and must cut to pieces and reassemble to look like the original with a
> little loss as possible. Databases are great methods to make allocation
> information available to others for digestion. But do little to aid in the
> allocation process, like helping determine what size block is available for
> specific customer.
bzzt. I designed a simple flat-file Dbase system that handles sub-net's
etc. very well. It automatically sends in SWIP's and other nifty things.
Using a database is the way to go vs. paperless ledgers.
It stores IP space in the smallest component /30's (that we allocate) and
then has a sub-net field to say what bigger block it is part of. Just
change the sub-net field, the database structure doesnt change, views can
be constructuted based on the sub-net field value.
Unix Tools:
* usereyep views the database
explorer:[/homeb/stephen/doc] usereyep
Usage: usereyep x.x.x.x Search for IP in database
usereyep -a List first record for each block
usereyep -u username Search for username in database
usereyep -f <netmask> Show unused IP blocks <with given netmask>
usereyep -d Dump database, show all records
* editeyep edits the database
explorer:[/opt/staff/office/src] editeyep
Usage: editeyep -a username x.x.x.x assign network
editeyep -ac username x.x.x.x assign network & edit comment
editeyep -u x.x.x.x unassign network
editeyep -c x.x.x.x edit comment field for a network
editeyep -r x.x.x.0 remove a full Class C network
* makeeyep loads new allocations into the database
explorer:[/opt/staff/office/src] makeeyep
Usage: makeeyep x.x.x.0 [netmask] Create new Class C IP
(default netmask = 24)
I could make this stuff public but youll need Codebase which is a
commercial Dbase library for C to compile - if interested let me know.
Stb
