- db-wg - mailman.ripe.net

First round of cleanup of Database WG NWIs
by Peter Hessler 14 Jul '24

14 Jul '24

Hello Working Group, As you all know, the Database Working Group uses a different process from other working groups, and have Numbered Work Items instead of Policy Development Process. We've had many Items on the list, and some have been there since we created the NWI process. So, the Chairs have decided that we need to go through and clean up the list so we can complete the items we wish to complete. For this round, we'd like us to review two NWIs that are similar to each other. https://www.ripe.net/manage-ips-and-asns/db/numbered-work-items/ NWI-2 - Displaying history for database objects where available NWI-17 - Historical data We ask the working group to discuss these two Items and decide if the WG can confirm the problem statements and provide feedback if either of these Items are still a problem that should be persued. We ask for discussion on list until Friday July 5th. Peter Hessler on behalf of the Database WG Chairs

12 20

Historical Queries Statistics
by Miguel Mosquera 05 Jul '24

05 Jul '24

Good Morning all! We'd like to give you some insight into the use of historical queries. We counted all the 'list-versions' and 'show-version' queries since January this year. We categorise the queries in: resources, organisation and others. - We found an average of a total of 50k historical queries per month between January and April. The average of total queries increased in these last two months (June and May) with an average of 90k. - We found an average of 23k resources (Ipv4, IPv6, ASN) historical queries per month between January and April. The average of these historical queries increases to 42k in May and June. - We found an average of 26k organisation historical queries per month between January and April. The average of these historical queries increases to 48k in May and June. - We found an insignificant amount of other object types (<300 queries) per month. Regards Miguel Herrán RIPE NCC

1 0

IPv6 object update error
by Jure Knez 04 Jul '24

04 Jul '24

Hello! I'm trying to update an IPv6 object in RIPE databease via API and I'm getting an error: <errormessages> <errormessage severity="Error" text=""%s:" attribute not allowed for resources with "%s:" status"> <args value="mnt-lower"/> <args value="ASSIGNED"/> </errormessage> <errormessage severity="Info" text="Value %s converted to %s"> <attribute name="source" value="RIPE"/> <args value="ripe"/> <args value="RIPE"/> </errormessage> </errormessages> I started getting this error about a month ago. Regards Jure

3 4

Re: [db-wg] So what happened last night to the DB?
by Hank Nussbacher 03 Jul '24

03 Jul '24

> Dear colleagues, > > We are aware of an incident affecting Whois updates yesterday evening, which we are continuing to investigate. We will keep the DB-WG informed. > > Regards > Ed Shryane > RIPE NCC There is still ongoing activity with perhaps malicious whois updates. See attached. Regards, Hank

8 11

Whois Release 1.113
by Edward Shryane 01 Jul '24

01 Jul '24

Dear colleagues, RIPE Database release 1.113 has been deployed to the Release Candidate environment for testing. We plan to deploy to production on Monday 1st July. The 1.113 release has the following main changes: * Inetnum AGGREGATED-BY-LIR status (implements RIPE-822 policy) (#1467) * Enable Client Auth Certificate for REST API lookup (#1475) * ROA Overlapping INVALID ROA and VALID ROA fix (#1470) * Java 21 Support (#1440) The release notes are on the website: https://apps.db.ripe.net/docs/Release-Notes/#ripe-database-release-1-113 More information on the Release Candidate environment can be found on our website: https://apps.db.ripe.net/docs/Release-Notes/ The data in the RC environment is a dummified copy of production from 12th June. Please let us know if you find any issues with this release in the RC environment. Regards Ed Shryane RIPE NCC

2 1

Whois Release 1.112.1
by Edward Shryane 24 Jun '24

24 Jun '24

Dear colleagues, RIPE Database release 1.112.1 has been deployed to the PRODUCTION environment just now. This is a bugfix release to help mitigate the ongoing production issue caused by many updates containing objects with an unusual amount of references. This is the only change from release 1.112. We will also apply this change to the upcoming 1.113 release (due next Monday, 1st July). We will continue to monitor for any more incidents, and will publish a full post-mortem later. Regards Ed Shryane RIPE NCC

1 0

RPSL for for foreigh IPv6 space
by Randy Bush 23 Jun '24

23 Jun '24

hi, All of RGnet's address space, mostly legacy, is in the RIPE whois, with RPKI etc. Except ... RGnet has three IPv6 /48s from NTT. Cogent filters BGP based on RPSL, and wants the RPSL for our ASs to be in the appropriate RPSL route6: objects, each with the appropriate AS. This is pretty old-fashioned and reasonable. Do we figure out how to register the route6: objects in NTT and presume Cogent will pick them up across IRR instances? Do we try some hack to violate the RIPE database's pristine authority model? Do we give up on this silly IPv6 stuff? [ just kidding, gert :) ] Surely other have been here before us. randy

3 2

RIPE Policy document updated “IPv4 Address Allocation and Assignment Policies for the RIPE NCC Service Region” (ripe-826)
by Angela Dall'Ara 20 Jun '24

20 Jun '24

Dear Colleagues, The RIPE policy “IPv4 Address Allocation and Assignment Policies for the RIPE NCC Service Region” has been updated to align with the implementation of NWI4, done in Whois release 1.112, which added the option to change the status of an IPv4 allocation object in the RIPE Database from “ALLOCATED PA” to “ALLOCATED-ASSIGNED PA” when the whole address space is assigned to the LIR infrastructure or for use by an End User with services provided by the issuing LIR. The new document is called ripe-826 and is available at: https://www.ripe.net/publications/docs/ripe-826/ Please note that also the following has been updated: 1) In the Abstract: The link to the webpage where to find information on the Address Policy WG from https://www.ripe.net/participate/ripe/wg/ap to https://www.ripe.net/community/wg/active-wg/ap/ 2) In 1.1 Scope: The link to the webpage listing the RIPE community’s policies: from https://www.ripe.net/ripe-policies to https://www.ripe.net/publications/docs/ripe-policies/ 3) In 5.3 Sub-Allocations The option to ask for a conversion of PI to PA via LIR Portal has been added. Kind regards, Angela Dall'Ara Policy Officer RIPE NCC

1 0

So what happened last night to the DB?
by Hank Nussbacher 17 Jun '24

17 Jun '24

3 2

Re: [db-wg] So what happened last night to the DB?
by Lutz Donnerhacke 17 Jun '24

17 Jun '24

> I have thought about doing it so, as I was also included as the > maintainers of the object. The real question is: why did blake66 made > such an object ? And how could we prevent something alike to happen > again (not an easy question -- maybe limiting the amount of mnt-by ?) Especially the DB should not process backscatter messages from MAILER-DAEMON.

1 0