- db-wg - mailman.ripe.net

RIPE 73 DB-WG agenda V1
by Piotr Strzyzewski 27 Oct '16

27 Oct '16

Dear DB-WG Members This is the 1st draft of the agenda for the DB-WG Meeting at RIPE73 at the Meliá Castilla hotel in Madrid, Spain. The DB-WG Meeting is scheduled as usual for Thursday, Oct 27th, starting at 15:00 local time, after the lunch break. The length of our timeslot is 90 minutes. ATTENTION: This time the meeting start and end times have been adjusted by one hour to complement the local Spanish working hours and customs. For the overall RIPE 73 meeting plan please refer to its most up-to-date version at https://ripe73.ripe.net/programme/meeting-plan/ Please feel free to comment agenda items or propose additional topics to be discussed both on the mailing list or direct to the WG Chairs at db-wg-chairs(a)ripe.net Looking forward to see you all in Madrid. All the best, Job, Nigel & Piotr ________________________________________________________________________ A. Administrative Matters [~10 min] . Welcome . select scribe (thanks to Nigel for volunteering again!) . finalise agenda . approval of minutes from previous WG meeting(s) B. Review of Numbered Work Items (Job Snijders) [~10 min] C. NWI model - where are we? (Job Snijders) [~10 min] D. DB Operational Update New and revised DB-Software functionality (proposed, test, deployment) Recent DB issues (Tim Bruijnzeels, RIPE NCC) [~15 min] E. Afrinic IRR homing project update (Piotr Strzyżewski) [~10 min] F. Recent work on the UI improvements (Alex Band, RIPE NCC) [~20 min] G. DB-WG - What next? (discussion) [~15 min] Y. Input from other Working Groups and/or Task Forces Z. AOB -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

6 8

Afrinic IRR homing project
by denis 26 Oct '16

26 Oct '16

Hi Piotr I commented some time ago about the possibility of a ROUTE object existing in both the RIPE Database and the Afrinic Database with different content. Did anyone do the simple check to see if any such objects exist? If they do, has anyone thought about who's responsibility it is to decide how to handle them? Has anyone considered what to do with AUT-NUM objects that reference the Afrinic ROUTE objects after they are deleted? At the Warsaw RIPE Meeting I dared to ask the question to the community about the RIPE NCC 'fixing' AUT-NUM objects (apparently a very controversial question). cheers denis

3 2

RIPE 73 DB-WG agenda V2
by Piotr Strzyzewski 26 Oct '16

26 Oct '16

Dear DB-WG Members This is the 2nd draft of the agenda for the DB-WG Meeting at RIPE73 at the Meliá Castilla hotel in Madrid, Spain. The DB-WG Meeting is scheduled as usual for Thursday, Oct 27th, starting at 15:00 local time, after the lunch break. The length of our timeslot is 90 minutes. ATTENTION: This time the meeting start and end times have been adjusted by one hour to complement the local Spanish working hours and customs. For the overall RIPE 73 meeting plan please refer to its most up-to-date version at https://ripe73.ripe.net/programme/meeting-plan/ Please feel free to comment agenda items or propose additional topics to be discussed both on the mailing list or direct to the WG Chairs at db-wg-chairs(a)ripe.net Looking forward to see you all in Madrid. All the best, Job, Nigel & Piotr ________________________________________________________________________ A. Administrative Matters [~10 min] . Welcome . select scribe (thanks to Nigel for volunteering again!) . finalise agenda . approval of minutes from previous WG meeting(s) B. WG Chairs Selection & discussion on DB-WG [~15 min] C. Review of Numbered Work Items NWI model - where are we? (Job Snijders) [~15 min] D. DB Operational Update (Tim Bruijnzeels, RIPE NCC) [~15 min] E. Afrinic IRR homing project update (Piotr Strzyżewski) [~10 min] F. Recent work on the UI improvements (Alex Band, RIPE NCC) [~20 min] Y. Input from other Working Groups and/or Task Forces Z. AOB -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

1 0

out of region ROUTE objects
by denis 25 Oct '16

25 Oct '16

HI guys I know this is a NWI, but with only a 10 minute slot in the agenda to review all the NWIs I doubt much will be discussed. I have a question. This issue has generated an almost identical discussion at the last 4 RIPE Meetings, with the same options on the table and the same indecision at the end of the discussion. In between RIPE Meetings it doesn't seem to be a problem (maybe it isn't a problem at all). I see it is not on either agendas at this meeting for DB or Routing WGs. If it is still a (real) problem, can someone actually make a decision on one of the options to fix it and do something? cheers denis

1 0

Re: [db-wg] Query all route objects for a given AS?
by Ronald F. Guilmette 07 Oct '16

07 Oct '16

In message <2099338805.63709.1475822808834(a)mail.yahoo.com>, denis walker <dw100uk(a)yahoo.co.uk> wrote: >If you type it on the command line you need: >whois -rBGi or AS3333 >which basically says do an inverse query (-i or) on objects containing:origin: AS3333 >give the full object details (-B), without any grouping (-G) and don't return related personal data (-r) >If you use the query.html you must also check 'origin' under the 'Inverse lookup' tab. Thank you. I guess that I must have a very old whois client, because it objected to most of the command line options you listed. But I was able to apply what you said and get the information I wanted from RIPE's web-based WHOIS query page, so that's great. Thanks a lot! Regards, rfg

4 4

Query all route objects for a given AS?
by Ronald F. Guilmette 07 Oct '16

07 Oct '16

Greetings, Sorry if this is an FAQ, but I'd like to know if there is a way to formulate a WHOIS query against whois.ripe.net in a way so as to obtain a complete list of the registered route objects that are associated with a given particular AS. If there's a way to do this, and if someone can instruct me on how it is done, I sure would appreciate that. Thanks.

3 3

Re: [db-wg] Query all route objects for a given AS?
by ripedenis＠yahoo.co.uk 07 Oct '16

07 Oct '16

Hi Ronald If you type it on the command line you need: whois -rBGi or AS3333 which basically says do an inverse query (-i or) on objects containing:origin: AS3333 give the full object details (-B), without any grouping (-G) and don't return related personal data (-r) If you use the query.html you must also check 'origin' under the 'Inverse lookup' tab. I also suggest you check the 'Do not retrieve related objects' box other wise you may return lots of personal data objects and get blocked very quickly. cheersdenis From: Ronald F. Guilmette <rfg(a)tristatelogic.com> To: "db-wg(a)ripe.net" <db-wg(a)ripe.net> Sent: Friday, 7 October 2016, 5:02 Subject: Re: [db-wg] Query all route objects for a given AS? In message <1870001011.3703.1475803719463(a)mail.yahoo.com>, <ripedenis(a)yahoo.co.uk> wrote: >-rBGi or as3333 I'm sorry, but your reply is not at all clear to me. Could you perhaps show me a complete example command line? Regards, rfg P.S. I also just now visited the following page: https://apps.db.ripe.net/search/query.html Under "Types" I checked only "route". Then in the search box I entered only the AS number of interest to me. Then I clicked on the "search" button. The result was that I only got the following error: ERROR:115: invalid search key Search key entered is not valid for the specified object type(s) Is it actually not possible to obtain from the RIPE WHOIS data base a list of all route objects currently associated with a particular AS number?

1 0

Progress on Numbered Work Items September 2016
by Tim Bruijnzeels 29 Sep '16

29 Sep '16

Dear working group, Although there is technically one more day in September I have to send this update now for planning reasons. Last month there were no updates to any of the Numbered Work Items. The list of items and their status is therefore unchanged since the last update. Repeating here for your convenience: NWI-1 Staying on top of abuse contact changes State: Problem Definition 3 messages 3 participants last message: 27 June 16 NWI-2 Displaying history for database objects where available State: Problem Definition 10 messages 5 participants last message: 12 July 16 NWI-3 AFRINIC IRR homing State: Solution Definition 18 messages 8 participants last message: 1 August 16 NWI-4 Role of status: field in multivalued status context State: Problem Definition 4 messages 3 participants last message: 27 June 16 NWI-5 Out of region ROUTE(6) / AUT-NUM objects State: Problem Definition 3 messages 3 participants last message: 28 July 16 NWI-6 Applicable data model not clear from contextless objects State: Problem Definition 3 messages 3 participants last message: 28 June 16 The progress on numbered work items (NWIs) is also available on the web site: https://www.ripe.net/manage-ips-and-asns/db/numbered-work-items Kind regards Tim Bruijnzeels Assistant Manager Software Engineering RIPE NCC Database Group

2 1

Call for agenda items, DB-WG meeting during RIPE73, Madrid, Spain
by Piotr Strzyzewski 12 Sep '16

12 Sep '16

Dear DB-WG participants We are reaching out to you for agenda items for the Database Working Group session during the RIPE73 meeting in Madrid, Spain, 24-28 October 2016. The DB-WG session is currently scheduled as usual for Thursday (Oct 27th), starting at 15:00 local time, after the lunch break. The length of our timeslot is 90 minutes. ATTENTION: This time the meeting start and end times have been adjusted by one hour to complement the local Spanish working hours and customs. Please submit your items or topic suggestions directly to the WG chairs or to the list for public discussion. The draft agenda will be published soon. Looking forward to see you all in Madrid. All the best, Job, Nigel & Piotr -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

1 0

RIPE NCC whois REST API
by janemba 12 Sep '16

12 Sep '16

Hi, I would like to know if it is possible to perform a full-text search with the Whois REST API ? Cheers, Janemba

2 1