- db-wg - mailman.ripe.net

Increasing the Limit of IP Addresses Used for the NRTM Service
by Theodoros Polychniatis 30 Aug '18

30 Aug '18

Dear colleagues, We would like to increase the limit of IP addresses used with the NRTM service. The limit of two addresses per member was set eight years ago and we might be able to handle up to three times that amount now. We are in the process of determining the new limit. If you are interested in helping us test the capacity of our NRTM servers, please open a ticket with us to add more IP addresses to the ones you currently use: https://www.ripe.net/contact-form?topic=ripe-dbm&show_form=true Kind regards, Theodoros Polychniatis Manager SW Engineering RIPE NCC

1 0

improve --list-sources query to display latest serial?
by Job Snijders 30 Aug '18

30 Aug '18

Hi all, It appears there currently is no easy way to retrieve the current serial from the RIPE DB. We're implementing some software to monitor whether our local mirror is wildly out of sync with the RIPE DB or not. I kind of expected th serial to be listed in the --list-sources command, but that field is set to 0. hanna:~ job$ whois -h whois.ripe.net -- --list-sources | grep RIPE % This is the RIPE Database query service. % The RIPE Database is subject to Terms and Conditions. RIPE:3:N:0-0 RIPE-GRS:3:N:0-0 % This query was served by the RIPE Database Query Service version 1.91.2 (HEREFORD) In comparison, IRRd will display the current serial when the !j query is issued: hanna:~ job$ whois -h rr.ntt.net -- '!jNTTCOM' A25 NTTCOM:N:0-978492:978492 C hanna:~ job$ I came up with a really ugly oneliner: $ whois -h 193.0.6.135 -p 4444 -- \ "-g RIPE:3:$(curl -s https://ftp.ripe.net/ripe/dbase/RIPE.CURRENTSERIAL)-LAST" | \ grep -v : | sed '/^$/d' | tail -n 2 | head -1 | awk '{ print $NF }' 42486238 Depending on the time of day that oneliner may be quite quick, or take several minutes to complete... obviously not ideal. Can --list-sources perhaps be improved to list the current serial? Kind regards, Job

2 2

improve --list-sources query to retain history
by Erik Bais 30 Aug '18

30 Aug '18

If the WG is going to look at improving the --list-sources code base, I have something that I would love to see on the wish list to be implemented.. Maintaining history (upto the point where a prefix is leaving the RIPE DB, due to an inter-rir transfer. ) is helpful to see who the previous holder was or where the prefix came from. This is particular the case with Legacy prefixes that are being split up.. as it is current practise to delete the parent prefix after a prefix split and transfer. Once the parent is deleted, you can't list or request the history of the parent prefix anymore. If the historic --list-versions and --show-version could be preserved somehow (on the original prefix size.. instead of them being deleted..), that would be very helpful. Regards, Erik Bais

2 1

NWI-5 changes deployed to RC (Release Candidate) environment
by Nathalie Trenaman 30 Aug '18

30 Aug '18

Dear Colleagues, Following the implementation plan for NWI-5 (Out-of-region ROUTE(6) objects and removal of ASN authorisation for ROUTE(6) object creation) we have now deployed the NWI-5 changes to the RC (Release Candidate) environment. The RC environment allows you to test the impact of the changes before we will go to production on 4 September 2018. Changes include: - removal of mnt-routes from aut-num objects - updating the source: attribute to RIPE-NONAUTH on out-of-region route,route6 and aut-num objects - removal of the RIPE-NCC-RPSL-MNT In this RC release, the FTP split files, the database dump and the NRTM stream will contain objects with the sources RIPE and RIPE-NONAUTH. In the next release (in the coming weeks), there will be two NRTM streams, two database dumps and also two sets of split files, one per source. We will separately announce this release to the Database Working Group. We encourage you to test the impact of the NWI-5 changes on your scripts and tools and report any issues you may find to ripe-dbm(a)ripe.net <mailto:ripe-dbm@ripe.net> Information about Release Candidate can be found at: https://www.ripe.net/manage-ips-and-asns/db/release-notes/ripe-database-rel… <https://www.ripe.net/manage-ips-and-asns/db/release-notes/ripe-database-rel…> The full NWI-5 implementation plan can be found at: https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple… <https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple…> Kind regards, Nathalie Trenaman Product Manager

2 2

Incorrect RDAP response
by Brian Rak 25 Aug '18

25 Aug '18

https://rdap.db.ripe.net/ip/24.235.22.0/23 This will just infinitely redirect between ARIN and RIPE: $ wget https://rdap.arin.net/registry/ip/24.235.22.0/23 --2018-08-24 14:00:05-- https://rdap.arin.net/registry/ip/24.235.22.0/23 Resolving rdap.arin.net... 2001:500:a9::160, 2001:500:31::160, 2001:500:13::160, ... Connecting to rdap.arin.net|2001:500:a9::160|:443... connected. HTTP request sent, awaiting response... 303 See Other Location: https://rdap.db.ripe.net/ip/24.235.22.0/23 [following] --2018-08-24 14:00:06-- https://rdap.db.ripe.net/ip/24.235.22.0/23 Resolving rdap.db.ripe.net... 2001:67c:2e8:22::c100:68e, 193.0.6.142 Connecting to rdap.db.ripe.net|2001:67c:2e8:22::c100:68e|:443... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://rdap.arin.net/registry/ip/24.235.22.0/23 [following] --2018-08-24 14:00:06-- https://rdap.arin.net/registry/ip/24.235.22.0/23 Connecting to rdap.arin.net|2001:500:a9::160|:443... connected. HTTP request sent, awaiting response... 303 See Other Location: https://rdap.db.ripe.net/ip/24.235.22.0/23 [following] --2018-08-24 14:00:07-- https://rdap.db.ripe.net/ip/24.235.22.0/23 Connecting to rdap.db.ripe.net|2001:67c:2e8:22::c100:68e|:443... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://rdap.arin.net/registry/ip/24.235.22.0/23 [following] --2018-08-24 14:00:07-- https://rdap.arin.net/registry/ip/24.235.22.0/23 Connecting to rdap.arin.net|2001:500:a9::160|:443... connected. HTTP request sent, awaiting response... 303 See Other It seems to be a RIPE issue though, because RIPE has valid data when I query via the web UI: https://apps.db.ripe.net/db-web-ui/#/query?searchtext=24.235.22.0%2F23

2 1

The Ongoing Summer of Hijacks: MNT-SERVERSGET / dnsget.top
by Ronald F. Guilmette 23 Aug '18

23 Aug '18

The entire set of objects in the RIPE WHOIS data base that are currently registered with mnt-by: MNT-SERVERSGET is listed here: https://pastebin.com/raw/GiYWxHMh Among this set of objects there are 235 separate route objects. Evidence indicates persuasively that some sizable fraction of these RIPE- registered route objects are fradulent and are simply there to provide cover for multiple IPv4 address block hijacks. The presence of these objects in the data base permits the following set of ASNs to claim that they are acting "legitimately" even as they route these hijacked blocks: AS9009 M247 Ltd (UK) AS43350 NFOrce Internet Sevices (Netherlands) AS57129 Optibit, LLC (Russia) AS197328 Istanbuldc Veri Merkezi Ltd. Sti (Turkey) AS202287 Men Danil Valentinovich (Russia) AS204895 Santa Plus, LLC (Russia) The total amount of IPv4 space encompassed within the set of route objects registered with mnt-by: MNT-SERVERSGET at the present time amounts to eight hundred and fifty nine (859) /24 blocks. Of these, only three hundred and five (305) actually have correctly functioning and properly delegated reverse DNS at the present time, and even among those, only two hundred and two (202) have functioning reverse DNS delegations to the prefered name servers of MNT-SERVERSGET, which is to say the name servers ns5.dnsget.top and ns6.dnsget.top. The bottom line is that it appears that, at the present time, something less than 1/4 of all of the IPv4 address space currently registered in the RIPE data base (via route objects) by and to MNT-SERVERSGET is space for which a plausible case could be made that the blocks in question are actually legitimately assigned to and/or under the legitimate control of whoever or whatever is MNT-SERVERSGET. The other 3/4ths of the IPv4 space in question has provenance which is, at best, dubious. Due to its use of little country-of-registration flags for each IP address block, the web site bgp.he.net provides the most visually obvious indications of at least two of the specific block hijacks in this case, specifically the hijacks of 27.103.192.0/19 and 36.0.192.0/19 by AS57129: https://bgp.he.net/AS57129#_prefixes Based upon the foregoing, I hereby respectfully request RIPE NCC to undertake an immediate and conmprehensive review of all objects in the data base that are currently registered with mnt-by: MNT-SERVERSGET. Additionally, I also respectfully request RIPE NCC to publish the results of this review to the mailing lists of the Database Working Group and the Anti-Abuse Working Group. The charters of both of these Working Groups are directly relevant to this issue, and there exists neither need nor reason to simply sweep this issue quietly under the carpet, as has been done in previous and similar cases. Cases such as this, and the two others of similar magnitude that I have publicly disclosed just this summer, affect the operation of, the stability of, and the continued enjoyment of the entire planetary Internet and its billions of users. Despite its status as a strictly private corporation, RIPE has a public responsibility, not only to handle such incidents responsibly and competently, but to show the world that it is ready, willing, and able to do so. The responses of RIPE to prior instances of this exact type of bad behavior have been largely or entirely cloaked in secrecy, presumably to protect the guilty. This longstanding and antiquated tradition of omerta within the RIPE community is unambiguously counterproductive to the goal of a well-managed and properly fuctioning Internet. Just as importantly, it naturally gives rise to unavoidable questions about the actual competence of, and capabilities of RIPE NCC staff as they attempt to deal with such incidents. I personally feel that RIPE NCC staff are doing the best they can when responding to incidents such as this, but the tradition of playing "hide the ball" with respect to their actions in such cases reflects badly on them, and badly on RIPE generally. It certainly raises doubts about RIPE's claim to authority over even its own data base. Lastly, I respectfully request both the RIPE Executive Board and the RIPE membership to make plain and explicit their respective intentions with regards to the various bad actors that have been caught, and that may in future be caught red handed engaging in the deliberate and premeditated corruption of the RIPE data base. To date, the policies an actions that RIPE applies, or which RIPE may apply to such bad actors have been shrouded in apparently deliberate secrecy and mystery. To put this request in more concrete terms, I would like to know if RIPE and the Executive Board actually and deliberately intend to take no action whatsoever with respect to the ongoing RIPE memberships of clearly identified bad actors, specifically, in this case, whatever persons or entities are currently hiding behind the RIPE WHOIS handle MNT-SERVERSGET (aka AS202287 and AS202275), which would appear to be this specific entity / RIPE member: https://www.ripe.net/membership/indices/data/ru.danil.html Is it the express intention of both the Board and the RIPE membership to simply deprive this bad actor of just those fradulent data base entries that have effectively legitimized his/her/its fradulent routing announcements? Is it the express intention of both the Board and the RIPE membership to simply make this bad actor give back what he has stolen, and to otherwise take no action, just as the response has been in the two other and similar cases that have also arisen in the RIPE region and that I have also publicly reported on this summer? https://mailman.nanog.org/pipermail/nanog/2018-June/096034.html https://mailman.nanog.org/pipermail/nanog/2018-July/096437.html My question is prompted by the following simple facts. In the two prior cases cited above, and also in the one I am presenting here today, the bad actors involved were seen to have not only hijacked large swaths of IP address space that clearly didn't belong to them, but also, as in the case I am presenting today, these same bad actors additionally acted to corrupt the RIPE data base with premeditated and deliberately fradulent entries. Nonetheless, and regardless of these attacks on the reliability and trustworthyness of the RIPE data base, to date it appears that no action whatsoever has been taken which might affect the ongoing RIPE memberships of the relevant parties and bad actors involved, and they are all still members in good standing of RIPE at the present time: https://www.ripe.net/membership/indices/data/pt.bitcanal-pt.html https://www.ripe.net/membership/indices/data/ua.d2investukraine.html https://www.ripe.net/membership/indices/data/bz.universal.html This is, to say the least, puzzling. I would like to know when, where, and how the Executive Board and/or the RIPE membership reached the altogether dubious conclusion that the best possible way to deal with bad actors such as these is to make them give back -just- the stuff the stole, and then to otherwise impose no penality of any kind, thus allowing them to live on, so that they may hijack another day. Whether this policy is a result of either deliberation or default, it *does* appear to be the policy, based on the evidence. Without intending to be rude, I feel that I must ask the obvious question: In what Universe does this otherwise admirable and generous Christian policy of "turning the other cheek" with respect to such verified bad actors have any effect other than encouraging the next hijacker, and then next one, and the one after that? Has either the Board or the membership even ever seriously debated what penalties should be imposed upon those members who are caught red handed deliberately corrupting the RIPE data base? Is the present RIPE policy of "forgive and forget" with respect to such travesties a product of anyone's intentional design, or is it instead merely the result of utter apathy and indifference on the part of the entire RIPE community? In either case, I believe it to be self evident that the time is... ummm... blooming, blossoming, burgeoning, flourishing, and flowering for this policy to be reexamined and revised. From where I am sitting it is self evident that the current policy of turning a blind eye to these events, and to the bad actors behind them is quite clearly encouraging others to follow suit and to themselves undertake the exact same sorts of travesties. Why shouldn't they? There is no downside. At the very worst, one is simply made to give back all of the stuff that one has stolen, and one is then allowed to go on one's merry way. Regards, rfg P.S. As incensed as I am at the fact that the above named bad actors have been allowed not only to retain their RIPE memberships, but also, apparently, 100% of their legitimately-allocated number resources, this is not even nearly as utterly appalling and inexplicable as the fact that two of the bad actors with direct and provable connections to the prior instances of hijacking that I have reported on publicly this summer have been allowed to remain as officially recognized RIPE IP brokers: https://www.ripe.net/manage-ips-and-asns/resource-transfers-and-mergers/bro… I am referring here specifically to Ebonyhorizon Telecomunicacoes Lda (aka Bitcanal) and also to NetAssist LLC (AS29632), which conveniently continues to maintain its association with, and peering arrangements with both AS57166 aka D2 International Investment Ukraine, Ltd. and, indirectly via D2, AS205869 aka Universal IP Solution Corp., both of which apparently continue to this day to try their best to hijack, either directly or indirectly, via AS Path fraud, a number of IPv4 blocks that clearly do not belong to any of these three Ukranian entities: https://bgp.he.net/AS57166#_peers https://bgp.he.net/AS205869#_peers https://bgp.he.net/AS29632#_peers What IP blocks are these two officially recognized RIPE IP brokers, Ebony Horizon and NetAssist brokering, exactly? Are they blocks that have been successfully hijacked? Does either RIPE or RIPE NCC even know? Does either RIPE or RIPE NCC even care? (One cannot help but wonder what might occur if RIPE were put in charge of distributing meat supplies within Europe. Would RIPE officially designate the McDonald's "Hamburglar" as RIPE's officially recognized agent for said distributions?) I guess that, in the end, all of the questions I have raised above can be boiled down to just one simple question: Who exactly does one need to either kill or maim or seriously wound in order to get kicked out of this organization (RIPE)? Regards, rfg P.P.S. Among the set of six companies / ASNs listed toward the top of this message as possible facilitators of the current hijacks of MNT-SERVERSGET, three are already fairly well known... at least in anti-spam circles... as being among "the usual suspects" when it comes to facilitating spamming and spammers. And no, I do not care to publicly specify which three. It may be true, as the saying goes that "On the Internet, nobody knows that you're a dog", but memories are long, and people don't forget if your company has been repeatedly caught acting like one.

3 4

Re: [db-wg] [anti-abuse-wg] The Ongoing Summer of Hijacks: MNT-SERVERSGET / dnsget.top
by Ronald F. Guilmette 16 Aug '18

16 Aug '18

In message <8A9C974B-FFA9-421C-B5ED-90E95624A8FE(a)a2b-internet.com>, Erik Bais <ebais(a)a2b-internet.com> wrote: >So the question that I have with all the information that you stated here. >- Are they doing something (Other than 'probably' leasing IP space) wrong?? The answer to that question is a clear "yes" and indeed, the events that have followed in the wake of my posting of only a few days ago have actually proven that to be the case, beyond a reasonable doubt. There are two key facts that support this view. First, China is not in the habit of allowing mysterious Russians to route their IP space for them. Call it a matter of national pride, or a matter of national security, or something else. It doesn't matter. The Chinese simply don't allow this sort of thing. I challenge you to find an example, i.e. _any_ example, that will prove this assertion wrong. Second, and even more convincingly, someone somewhere (perhaps someone within RIPE NCC) clearly understood that some or all of the route objects that were in the data base as recently as last week, and that were associated with MNT-SERVERSGET were in fact fradulent, and as a result, _many_ of these route objects have now been quietly removed from the data base. In my prior posting, I specifically called out the following two route objects for special attention: ======================================================================== route: 27.103.192.0/19 origin: AS204895 mnt-by: MNT-SERVERSGET created: 2018-07-02T07:30:29Z last-modified: 2018-07-02T07:30:29Z source: RIPE ======================================================================== route: 36.0.192.0/19 origin: AS204895 mnt-by: MNT-SERVERSGET created: 2018-07-02T07:30:55Z last-modified: 2018-07-02T07:30:55Z source: RIPE ======================================================================== Since my posting, these routes objects, *and numerous others* (full list available upon request) have been withdrawn from the data base *by someone*. By your question Erik, are you attempting to deny that these objects existed in the data base, as recently as last week? By your question, are you attempting to deny that these routes have since been removed from the data base? By your question, are you attempting to assert that these routes... and the several others that have now also been quietly and mysteriously disappeared from the data base... were anything other than blatantly and obviously fradulent? >- Are the leased or used prefixes used to send out spam or host malware or >do something else that is frowned upon ? or even illegal.. ( And is there >proof of spam source or hijacking etc.. ? ) I believe that to be the case, and I could even marshall some compelling evidence of that, but as I am sure you know that is entirely irrelevant here. Do I really need to say what has already been said innumerable times in the past, i.e. that RIPE is not the Internet Police? The issue I have raised has nothing to do with spamming, which RIPE and all of its members have elected not to concern themselves with. The issue I have raised also has nothing to do with the hijacking of IP address space via the BGP announcement of fradulent routes. This is also a topic which, I am told, RIPE and all of its members have elected not to concern themselves with, because once again, RIPE is not the Internet Police. So, please Erik, do not attempt to confuse the issue by injecting these irrelevancies into the conversation. Let's try to stay focused. The one issue that RIPE and its membership _have_ generally asserted a serious interest in is the quality and accuracy of the data base. The clear evidence, from both last week and today, and particularly the comparison between the two, show quite clearly that *somebody* knows that one hell of a lot of fradulent route objects were inserted into the data base by the party or parties associated with the MNT-SERVERSGET handle. And as a direct result of my posting of last week, *someone* has now mysteriously "disappeared" most or all of the fradulent route objects that had been put into the data base by MNT-SERVERSGET aka Alexander Samuilov. (I say that these route objects have been "mysteriously disappeared" because whoever did that did not see fit to mention who was doing the disappearing or why it was being done, exactly, on any of the RIPE mailing lists to which I posted my message of last week. Nor have I received any private messages explaining why these route objects were being removed.) Try as you might Erik, you cannot make these inconvenient facts go away, e.g. just by introducing a bunch of irrelevancies into the conversation. People... even people here in the relevant RIPE mailing lists... are not all stupid. They can see for themselves that there were in fact *numerous* fradulent route objects in the RIPE data base last week that have mysterious disappeared since my posting of last week. (If anyone needs to have me generate a side-by-side comparison showing the set of fradulent MNT-SERVERSGET route objects that have been disappeared from the data base over just the past few days then I will try to create that sort of side-by-side listing so that any doubters may have a clear view and a clear understanding of what has happened, over just the past few days.) How do you explain this Erik? How does RIPE NCC explain all of these sudden disappearances of route objects from the data base? Does it not seem, even to you, that the rather sudden and unexplained disapperances, just since my posting last week, of so many of the MNT-SERVERSGET route objects may be somewhat more than just purely coincidental? Somebody somewhere knows that those route objects were unambiguously fradulent. Perhaps it was only the perpetrator, Mr. Alexander Samuilov. Perhaps it was some member of the technical staff inside RIPE NCC. Whoever it was, it cannot now be denied that the route objects in question were fradulent, or that this pollution was deliberately inserted into the data base by *some* RIPE member. So the only remaining question is: Is RIPE even willing or able to "police" its own data base? What sanctions, if any, are going to be imposed, by RIPE, on the crook who engineered all of this crap? RIPE has a bad habit of just looking the other way when its members spam massively, engage in massive hacking attacks, and even when they use BGP to hijack IP space that doesn't belong to them. Will RIPE also now look the other way and do nothing when the one and only thing that all RIPE members actually hold dear, i.e. the data base, is used like a toilet by certain specific and easily identifiable members? >If you want to get the exec-board to take action to a listed broker, that >should be take up with the exec-board and the NCC. >It is my experience that they are very responsive Your experience is apparently unique. Since my posting of last week, which was CC'd to exec-board(a)ripe.net, and which clearly and unambiguously called for the investigation of, and the expulsion of several very specific RIPE members (and also the deletion of certain entities from RIPE's list of officially recognized IP brokers), I have had not a single response of any kind from *any* board member. None of them have even had the courtesy to send me a FOAD message in response. Their silence on these matters is deafening. Regards, rfg

4 6

NWI-5 NRTM changes deployed to RC (Release Candidate) environment
by Nathalie Trenaman 14 Aug '18

14 Aug '18

Dear Colleagues, As per request of the RIPE Database Working Group, we have now created two separate NRTM streams, two database dumps and two sets of split files, one per source (RIPE and RIPE-NONAUTH) This has been added to the RC environment for you to test before we make the changes in production on the 4th of September 2018. We encourage you to test the impact of the NWI-5 changes on your scripts and tools and report any issues you may find to ripe-dbm(a)ripe.net <mailto:ripe-dbm@ripe.net> Information about Release Candidate can be found at: https://www.ripe.net/manage-ips-and-asns/db/release-notes/ripe-database-rel… <https://www.ripe.net/manage-ips-and-asns/db/release-notes/ripe-database-rel…> The full NWI-5 implementation plan can be found at: https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple… <https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple…> Kind regards, Nathalie Trenaman Product Manager

1 0

Broken RDAP response
by Brian Rak 13 Aug '18

13 Aug '18

We hit issues with: https://rdap.db.ripe.net/ip/37.246.0.0/16 It looks like someone added multiple country: fields in the RIPE database inetnum: 37.246.0.0 - 37.246.255.255 netname: MD-SHATRANS-20120417 country: GB country: US org: ORG-TS151-RIPE How did this even get into the database in the first place? I'm not sure returning an error via RDAP is really the best way of handling this.

5 7

FW: #79981 - Re: RIPE database tool
by Aviolat Romain 10 Aug '18

10 Aug '18

Dear RIPE DB WG, We coded a tool to manage RIPE objects as code in my company, we're using it in production for almost a year and so far it's working great. We're not dealing with a ton of objects (quite a small LIR) and there's probably use-cases that aren't met yet but the tool is quite simple and opensource so feel free to play with it. Let me know ! https://github.com/xens/ripeinator +++ Romain From: RIPE NCC Support <support(a)ripe.net> Sent: lundi, 16 juillet 2018 13:11 To: Aviolat Romain <Romain.Aviolat(a)nagra.com> Subject: #79981 - Re: RIPE database tool ##- Please type your reply above this line -## Ticket (79981) has been updated. To add additional comments, reply to this email. Gabriel Ajabahian (RIPE NCC Support) Jul 16, 13:11 CEST Dear Romain, Thank you for your email. Unfortunately the email was missed in the communication and took us long time to reply. As Software Engineering department at RIPE NCC does not use Python we wont be able to use it but for sure I'm passing it to the other departments who has Python in their stack. I see the tool as very useful, and you can always announce it on the database working group so other community members can know about it and use it and you can get a feedback. The link to the database working group: https://www.ripe.net/participate/ripe/wg/db Good luck, and thanks for the great work. Kind regards, Gabriel Ajabahian Software Engineer RIPE NCC Romain Aviolat Mar 19, 20:22 CET Dear RIPE support, just to inform you that I coded a tool to talk to the RIPE APIs: https://github.com/xens/ripeinator with it you can define your objects in a yaml structure and let the tool talk to RIPE APIs, it's a nice way to manage ripe-objects as-code. Let me know if it's useful, +++ Romain This email is a service from RIPE NCC Support. [WV7LYZ-X3E8]

1 0

WG Chair Selection
by William Sylvester 31 Jul '18

31 Jul '18

WG Members, This email kicks off the chair selection process for the open seat vacated last fall. With the new chair processes agreed to by the working group this will be a single chair seat for three years. This will migrate us into the new process where we will select one chair per year to maintain continuity and consistency for the chairs and prevent a situation like we have encountered previously where we were selecting chairs out of a drawing from a hat. As a reminder, chair terms are staggered yearly. The working group will select the chair by consensus. The process is as follows; This is the call for interested parties. Interested parties have two (2) weeks to make their interest known on this mailing list, or directly to the chair(s). After two weeks, the chair(s) ensure that all candidates are announced on the mailing list and issue a call for discussion. All members of the community are encourage to make a discussion and express their approval or otherwise of the presented candidates. Two (2) weeks after the call for discussion, the chair(s) declare a decision, based on mailing list discussion, as they would do for a policy proposal. All candidates please post to the mailing list at this time or contact the chairs (db-wg-chairs(a)ripe.net<mailto:db-wg-chairs@ripe.net>). Kind regards, William & Denis DB-WG Co-Chairs

4 3

Implementation plan and dates for NWI5 - Out-of-region ROUTE(6) objects and removal of ASN authorisation for ROUTE(6) object creation.
by Nathalie Trenaman 24 Jul '18

24 Jul '18

Dear colleagues, In February 2018, the RIPE Database Working Group reached consensus on NWI-5 - creating out of region ROUTE(6) objects in the RIPE Database. We will soon be making changes to the way out-of-region objects are handled in the RIPE Database. It's important that database users are aware of these changes and what they mean: 1. The RIPE Routing Registry will no longer support the creation of out-of-region ROUTE(6) and AUT-NUM objects 2. Existing out-of-region objects will have their "source:” attribute changed to "RIPE-NONAUTH” 3. The creation of ROUTE(6) objects will no longer need authorisation from the ASN holder We will implement these changes in the Release Candidate environment on Thursday, 2 August and go to full production on Tuesday, 4 September. Our implementation plan can be found at: https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple… <https://www.ripe.net/manage-ips-and-asns/db/impact-analysis-for-nwi-5-imple…> The RIPE Database Working Group chairs also wrote a RIPE Labs article that describes the background of NWI-5: https://labs.ripe.net/Members/denis/out-of-region-route-6-and-aut-num-objec… <https://labs.ripe.net/Members/denis/out-of-region-route-6-and-aut-num-objec…> <https://labs.ripe.net/Members/denis/out-of-region-route-6-and-aut-num-objec… <https://labs.ripe.net/Members/denis/out-of-region-route-6-and-aut-num-objec…>> Please contact ,ripe-dbm(a)ripe.net <mailto:ripe-dbm@ripe.net>. if you still have questions after reading the implementation plan. Best regards, Nathalie Trenaman Product Manager RIPE NCC

6 7

Source GRS vs RIPE
by Aftab Siddiqui 18 Jul '18

18 Jul '18

Hi, I would like to understand the difference between these 2 results for the same prefix. Source: GRS https://apps.db.ripe.net/db-web-ui/#/query?bflag=true&source=GRS&searchtext… Source: RIPE https://apps.db.ripe.net/db-web-ui/#/query?bflag&searchtext=188.64.224.0%2F…

7 17

stat.ripe.net down?
by Ronald F. Guilmette 20 Jun '18

20 Jun '18

I've come to rely on the services provided by the stat.ripe.net WHOIS service. Thus it is rather disappointing to find that today, it's down, as least if one is an ordinary sort of bloke like me who is confined to IPv4. % telnet stat.ripe.net whois Trying 193.0.6.150... telnet: connect to address 193.0.6.150: Connection refused Trying 2001:67c:2e8:22::c100:696... telnet: connect to address 2001:67c:2e8:22::c100:696: No route to host telnet: Unable to connect to remote host Did I just miss the memo? Has the stat.ripe.net IPv4 service been taken down deliberately, or is this just a transient sort of outtage? More to the point, what email address should I be writing to in order to make further inquiries about this apparent outtage?

3 2

IRRd re-write
by denis walker 19 Jun '18

19 Jun '18

Colleagues During the current discussion on out-of-region ROUTE objects, Job announced that IRRd is being re-written and will have some 'potentially' fantastic features including 'possibly' authentication against the RIRs number registries. The alternative/commercial IRRs have also been heavily promoted at many points in this discussion as 'the answer' to the current problems. I personally, and some others, have some issues with this. So I thought it appropriate to open a discussion on this issue as it does impact on, or is influenced by, the operation of the RIPE Database. Firstly it is unfortunate that all the RIRs that operate an IRR may not be in a position to accomodate all routing requirements that are currently provided for by the designed security hole in the RIPE Database at the time this security hole will be closed. To push operators to switch to commercial services as the answer simply monetarises routing which, as Randy pointed out, may affect smaller operators more, as perhaps the IPv4 market has done. I looked at the github details of this new IRRd. I get the feeling that this is simply trying to re-invent the RIPE Database software in yet another language. This is being done without the decades of experience, knowledge and understanding that has gone into developing the RIPE Database software on which all 4 IRRs are based that are operated by the RIRs. Job also pointed out that "One of the possible (and desired) extensions is an authorisation link to the authoritative RIR." This suggests some form of cross registry authorisation with/between the RIRs. During the years of debate about these out of region ROUTE objects this has been discussed and virtually dismissed on several occasions. If the RIRs, and certainly the RIPE NCC, are going to devote time, effort and members money to develop some form of authorisation system for a remote IRR to connect to each of the 5 RIR number registries to authorise ROUTE creation, then I personally would prefer to see the development of a single, global IRR operated by the RIRs. This cross registry authorisation is probably the main element of having a single IRR. Currently 4 of the 5 RIRs operate an IRR and they are all based on a version of the RIPE Database software. So we already have a common IRR database format. Add in this cross registry authorisation and we have a global IRR. I don't see the point of putting in the effort to develop a multitude of alternative/commercial IRRs when we can go the other way and have a single, authoritative, free IRR service. We have one internet, one DNS, why not one IRR? I know the first comment is probably going to be, "we already have this with RPKI". But for whatever reason, not all operators use, or want to use, RPKI. That is a reality, just as much as everyone switching to IPv6...not. Since RPKI is not the complete answer, we still need an IRR where the ROUTE objects are validated and trusted. I think the RIRs are in the best position to each develop a trusted IRR linked to their own number registry, then take the leap to create a single IRR. I personally think this is the better way to go than develop secure authorisation modules for IRRd. cheers denis co-chair DB-WG

4 4

Fwd: [ETISALAT DOMAINS TICKET #ZZH-628-73999]: Re: IRRd re-write
by Randy Bush 18 Jun '18

18 Jun '18

could someone unsub these <bleep>s sorry for spamming the list, but the headers have no list whinee address randy

1 0

A test on AFRINIC range announcing without RIPE route object
by Lu Heng 15 Jun '18

15 Jun '18

Dear colleagues, In the past three weeks, we have done some tests on 3 AFRINIC /24 which have been announced in the US, Europe, and Asia, by an ARIN ASN, APNIC ASN, and an RIPE ASN. Test results: If it is a direct announce to NTT, Telia, GTT as a small provider and without route object, announcement will not be accepted. All of them accept RIPE route object. If you announce to one of the telecoms, and that telecom happens to accept your announcement without route object, then all the other telecoms will have to accept the announcement without route object. This is simply because big guys trust each other. In the example we tested, we first announced to NTT directly and got rejected. Then we announce to CN2(next generation enterprise network of China telecom). After this NTT accepted the announcement from China telecom without route object created. Current situation: AFRINIC accepts foreign ASN with manual verification of the ownership of the ASN holder as stated by their hostmaster in the mailing list. If you don't own the ASN, they will not create the route object. Despite this, the process is long and unpractical in daily operation. Some providers do accept RPKI. One can create an AFRINIC RPKI that go though the filter, however, not all provider accept RPKI at the moment. In conclusion, If you employ a non-Afrinic asn for announcements (which means a foreign asn), using RIPE’s route object will be the only choice for you unless you are one of those big telecoms which has the liberty to announce anything as they wish. I am not opposing to the idea of cleaning up the database, but until things get fixed, the current process will only break networks. -- -- Kind regards. Lu

11 46

Re: [db-wg] A test on AFRINIC range announcing without RIPE route object
by denis walker 15 Jun '18

15 Jun '18

Hi All The co-chairs of the DB-WG are talking in the background to the RIRs about how this change will impact the holders of their address space. We are following the points raised here and checking some issues with the appropriate RIRs. The RIPE NCC Database team is also in the loop of these talks so any relevant points can be included in their impact analysis. As some have already said consensus is not unanimity and there is a consensus to close this security hole in the RIPE Database. Even though the security hole will continue to exist in many alternative and commercial IRRs and will continue to be exploited by abusers for some considerable time. cheersdenisco-chair DB-WG

3 3

query related to Open Source wg talk on blockchain
by Sandra Murphy 19 May '18

19 May '18

(A comment about the presentation that I’m asking here because I wasn’t quick enough in typing in the chat window - I was participating remotely.) There was a question at the mike at the very end of the presentation about blockchain, about the purpose for the work. The answer was that the purpose was to protect origin authorization. That got me thinking about the blockchain model vs the RIPE model. In times past, I’ve seen RIPE reminders to their members that they are responsible for their entire allocation, even if some of it is sub-allocated. And I’ve seen training that carefully instructs the members how to use mnt-by, mat-lower, mat-routes, etc., to retain control over the sub-allocation portions of their address space, but give some control to the recipient. And warnings that lack of care may result in losing authority, which would require correction by the database staff. I did find a FAQ for Sub-allocation that says some of this, so hopefully I am not totally off-base. Is that still the RIPE model, that authority over the sub-allocation is more shared than relinquished? If I understand blockchain properly, it presumes a model where control is given up entirely when an object is transferred. No two entities can have authority over an object. Nothing says I’m right about that, either, of course. —Sandy

2 1

Weird IRR entry
by Brian Rak 18 May '18

18 May '18

Seems like this shouldn't have been allowed to be created: route6: 2001:db8::/32 origin: AS10 mnt-by: EJU created: 2018-02-18T06:45:59Z last-modified: 2018-02-18T06:45:59Z source: RIPE

3 2

comment on comment at mic: database "purpose" vs not-globally-routed prefixes
by Sandra Murphy 17 May '18

17 May '18

(Sorry about this. typed the comment into the chat window, hit submit, got “disconnected” error, reconnected, but too late to comment.) The comment at the mic was that there are many IP prefix resources in the database that are not globally routed, and that those objects were not part of the RIPE database purpose as stated. So collection of personal data for those objects could not rely on the RIPE database purpose for justification. I disagree that the lack of current global routing for an IP prefix means the RIPE database purpose of facilitating coordination does not apply. An allocated prefix can be globally announced at any time. So there’s a need to have the data, anyway. In the current state of routing security, an allocated prefix can be globally announced at any time, not necessarily by the legitimate prefix holder. We’ve seen several examples of some ISP announcing a prefix that seemed not to be in use, sometimes even registering a route object for the announcement, and using that prefix for some unfriendly purpose. So there is still a need to have contact data for a prefix even before the legitimate prefix holder decides to globally announce the prefix. —Sandy

2 1

FW: Weird IRR entry
by Gunnar Guðvarðarson 17 May '18

17 May '18

Yeah, there is also a corresponding ASn aut-num: AS10 as-name: EJU1-RIPE admin-c: EJU1-RIPE tech-c: EJU2-RIPE status: OTHER mnt-by: EJU created: 2018-02-18T06:19:45Z last-modified: 2018-02-18T06:19:45Z source: RIPE AS10 is allocated to ARIN, and is in use by CSNET: as-block: AS8 - AS27 descr: ASN block not managed by the RIPE NCC I reported these objects to ripe-dbm, ops and abuse @ripe.net

1 0

<auto-dbm@ripe.net> is slow this afternoon.
by RIPE Database Administration 17 May '18

17 May '18

Dear Colleagues, Because of a very high level of use this afternoon, the response time of <auto-dbm(a)ripe.net> is longer than normal. I have made contact with those who are responsible and I expect the situation to improve as the machine works through the queue. Please be patient. Obviously we at the RIPE NCC Database Group are continuously working to make the performance of the database as good as possible. However, we cannot make improvements in zero time. We thank you for your co-operation up to now and we ask for your continued co-operation so that everyone receives the best possible service. If you have anymore questions, please contact <ripe-dbm(a)ripe.net>. Regards, Ambrose Magee ____________________________ RIPE Database Administration.

2 2

New on RIPE Labs: The GDPR: Amendments to the RIPE Database
by Mirjam Kuehne 14 May '18

14 May '18

Dear colleagues, This is our fourth in a series of RIPE Labs articles discussing the General Data Protection Regulation (GDPR) implementation. Here we're looking at amendments that will be needed to the RIPE Database in order to ensure GDPR compliance: https://labs.ripe.net/Members/maria_stafyla/how-were-implementing-the-gdpr-… Kind regards, Mirjam Kühne RIPE NCC

1 0

New on RIPE Labs: Out-of-Region ROUTE(6) and AUT-NUM Objects in the RIPE Database
by Antony Gollan 09 May '18

09 May '18

Dear colleagues, In a new article on RIPE Labs, Denis Walker provides some context around the changes being made to the way out-of-region objects are managed and represented in the RIPE Database: https://labs.ripe.net/Members/denis/out-of-region-route-6-and-aut-num-objec… Kind regards, Antony Gollan RIPE NCC

2 1