[nanog] Re: Q: IP Space Management Software
S.T.Balbach
stephen at clark.net
Fri Mar 13 04:51:12 UTC 1998
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
More information about the NANOG
mailing list