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@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