[db-wg] Removal of bogon route objects

Friends,

As previously discussed, the decision was made awhile back to remove from
the data base all RIPE-NONAUTH route objects which refer to currently
unallocated IP space:

    https://www.ripe.net/ripe/mail/archives/db-wg/2021-May/006952.html

In recent days I stumbled upon one such object that was still present
in the data base.  Upon seeing that object, I necessarily assumed that
it was most likely not a "one off", and that it probably had siblings.

In the spirit of trying to help out, and after a fair bit of fooling
around on my part, I managed to concoct a rather simple method for
finding all such bogon route objects that remain in the data base,
and I wrote a small Perl script to do that exact thing.  A copy of
the script may be obtained here, for anyone who may be interested:

    https://pastebin.com/raw/LsvZ05tX

Notes:

*)  The script assumes the presence of two external programs and their
presence on the user's current $PATH, i.e. the widely used wget progarm,
and also John Levine's version of a thing called grepcidr, sources for
which may be obtained here:

    https://github.com/jrlevine/grepcidr3

*) The initial line of the script may have to be adjusted depending on the
location, in the filesystem, of your local Perl interpreter.

*)  The script computes its results based upon the following two input data
files, both of which are automagically fetched by the script using wget:

    https://www.nro.net/wp-content/uploads/delegated-stats/nro-extended-stats
    ftp://ftp.ripe.net/ripe/dbase/ripe-nonauth.db.gz

(It is my understanding that each of these is updated on a daily basis.)

*)  The script DOES NOT verify that the entirety of any given RIPE-NONAUTH
route object in fact refers to bogon space.  Rather the script only checks
to see whether or not the first IPv4 address of each current RIPE-NONAUTH
route object does or does not refer to current bogon space.  If it does,
then the entire IPv4 CIDR of the route object is printed to stdout.

*)  Assuming that the script is installed as "ripebogonroutes" and in one's
path, it may be invoked simply as:

       ripebogonroutes > bogon-route-cidrs

*)  At present there are 55,964 RIPE-NONAUTH objects in the data base.  Of
these, the first address of 857 of them refers to current bogon space.
It is my fervent hope that the corresponding RIPE-NONAUTH route objects
will be removed from the data base as soon as reasonably practical.


Regards,
rfg