[db-wg] Removal of bogon route objects

Hi Ronald,

Could I request that you provide a pastebin of the actual list of prefixes
that you think are at issue here?

-Cynthia

On Thu, Jun 10, 2021, 21:43 Ronald F. Guilmette via db-wg <db-wg at ripe.net>
wrote:

> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ripe.net/ripe/mail/archives/db-wg/attachments/20210610/642d82ec/attachment.html>