RE: SWIP and Rwhois in the Real World

Can someone summarize the alternatives to the ARIN recommended RWHOIS
server bits (from rwhois.org)? A quick hit on Google and Freshmeat was
fairly barren.

Looking for one that is mostly or fully put together, or a cookbook to
assemble one from parts (i.e. MySQL, PHP, Apache, 3 rubber bands, 2
gallons of perl, etc...).

Regards,
Robin Greenhagen
GSI
http://www.gsihosting.com/

Can someone summarize the alternatives to the ARIN recommended RWHOIS
server bits (from rwhois.org)? A quick hit on Google and Freshmeat was
fairly barren.

i use irrd

randy

Looking for one that is mostly or fully put together, or a cookbook to
assemble one from parts (i.e. MySQL, PHP, Apache, 3 rubber bands, 2
gallons of perl, etc...).

ARIN themselves are happy to accept your database in
various formats such as CSV files.

LDAP was designed to allow queries to a hierarchical
database and ARIN could allow this if people were willing
to vote for it at an ARIN meeting. At least one
company has built their own rwhois server as a shim
over top of an LDAP server.

This type of database query could also be supported
by means of a standard HTTP GET query like hundreds
of thousands of other web applications. Then we could
put together an rwhois server in a day or two using
our favourite web applications toolkit.

The rwhois protocol is ancient and completely uneccessary.

The rwhois service *IS* necessary and if it were implemented
with some kind of standard modern toolset, then it would
be widely deployed, correctly deployed and kept up to
date.

Please do not confuse the service with either the ancient
and creaking server implementation or the unecessarily specific
database query protocol.

By the way, there is a mailing list ppml@arin.net where
this can be discussed. Instructions to subscribe are here:
http://www.arin.net/mailing_lists/index.html

--Michael Dillon

I'm curious how you or anyone else using irrd deals with the following issues:

1) Needing to be able to tell ARIN how much of your space is reserved vs assigned, what percentages of each of those are the various "sub-categories" ARIN seems to care about. i.e. Dial-up, Cable, Hosting, Leased Line, DSL, Colo, Wireless, other. Did you hack the irrd source to add a custom field(s) to route objects, abuse the member-of field, or create a maintainer object for each category of usage and use the mnt-by field as a classifier. Or if you have all your space in irrd, can you just point ARIN to your whois server and say "there's all the data, have fun with it", and skip questions 4-8 on net-isp.txt?

2) Finding unassigned space, preferably appropriately sized for the desired allocation. Shell script that asks irrd for all routes mnt-by your "Unallocated maintainer" sorted by (selectable) either prefix or prefix length?

2a) Finding open bits of reserved space. i.e. We'll commonly take a /24 and mark it as reserved for router interface /30s. The /24 isn't "open" anymore, but until its been used up, there's lots of /30s within it that are available for assignment. I suppose instead of putting the /24 in irrd as reserved, each of the /30s could be put into irrd marked as either reserved in use, or reserved available.

3) Assuming you let multiple people add/remove route objects, what's done to enforce consistency in the data? Perhaps a web interface to sending the updates that populates as many of the fields as possbile from pull down selections?

Also, is there some secret to mirroring other registries with irrd? After installing, I figured it'd be fun to play with someone else's data, so I tried to mirror altdb and then arin. Each gave me similar errors:

% ERROR: serials (1 - 108) don't exist!
% ERROR: 4: Invalid range: serial(s) 1-2902 don't exist