October 2016 - db-wg - mailman.ripe.net

<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

WG Chairs Selection
by Piotr Strzyzewski 25 Nov '16

25 Nov '16

Dear DB-WG Members As agreed during DB-WG session at RIPE69 Meeting in London on 06.11.2014, the WG Chair Selection procedure is executed at yearly intervals. This means that it is about time to run it this year. This is the call for interested parties. Interested parties have 2 weeks to make their interest known on this mailing list. All members of the community are encourage to make a discussion and express their approval or otherwise of the presented candidates. After two weeks the chairs will declare consensus. Since there is a limit of 3 co-chairs, if at the end of the discussion phase there will be more than 3 proposed co-chairs then a call will be made for any of the candidates to withdraw. If there still will be more than 3 candidates then names will be put into a hat and the first three names drawn from the hat will take on the role of chairs for the next 12 months. As you may know, Job Snijders decided at the RIPE73, last week, to step down. Moreover, Nigel Titley declare that when a new chair is found, he would like to step down as well. This means, that the only reason Nigel is staying on, is not to leave the WG with only one chair. Taking this opportunity, I would like to express my interest in being co-chair for another term. All the best, Piotr -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

22 43

WG Chairs Selection
by Piotr Strzyzewski 16 Nov '16

16 Nov '16

Dear DB-WG Members As agreed during DB-WG session at RIPE69 Meeting in London on 06.11.2014, the WG Chair Selection procedure is executed at yearly intervals. This means that it is about time to run it for the very first time. This is the call for interested parties. Interested parties have 2 weeks to make their interest known on this mailing list. All members of the community are encourage to make a discussion and express their approval or otherwise of the presented candidates. After two weeks the chairs will declare consensus. Since there is a limit of 3 co-chairs, if at the end of the discussion phase there will be more than 3 proposed co-chairs then a call will be made for any of the candidates to withdraw. If there still will be more than 3 candidates then names will be put into a hat and the first three names drawn from the hat will take on the role of chairs for the next 12 months. All three of present co-chairs expressed their interest in being co-chairs for another term. All the best, Job, Nigel & Piotr -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

9 11

Release 1.88 deployed to RC
by Tim Bruijnzeels 31 Oct '16

31 Oct '16

Dear working group, We have released whois version 1.88 to the Release Candidate (RC) environment. We plan to deploy this version to production on Monday 10 October. This release contains a number of small improvements: - Users can now delete syntactically incorrect objects (before you would have to update the object before it could be deleted) - Users are now allowed to change the status if a resource object if it is NOT-SET This release also includes some minor fixes for infrequent bugs, and provides an API that can be used in a future release of the Webupdate User Interface that will allow users to set up rDNS for a prefix and create domain objects in bulk. We are currently working on the latter but expect to have this ready just after the RIPE Meeting. Kind regards Tim Bruijnzeels Assistant Manager Software Engineering RIPE NCC Database Group

4 5

Route object authentication for multiple inet(6)num
by fransossen＠yahoo.com 28 Oct '16

28 Oct '16

Hi, Following up on the AP policy WG discussion: https://www.ripe.net/ripe/mail/archives/address-policy-wg/2016-October/0119… If/when implemented it would eventually break up large contiguous inetnums with status ALLOCATED PI/UNSPECIFIED into smaller prefixes. As a consequence, route aggregation will be lost since when the parent inetnum is removed from the RIPE DB, the equivalent route will be removed as well. The current RIPE DB process and rules are not allowing for a /23 route to be created out of two /24s bit boundary contiguous prefixes registered as separate /24s without a common parent range. This is something that could be remedied by allowing a parent route to be created, the system could be rather easily implemented using the current DB rules layout. Existing inetnum objects in DB: inetnum: x.x.x.0/24 mnt-routes: ASXXXX-mnt mnt-by: prefix-holderA-mnt inetnum: x.x.y.0/24 mnt-routes: ASXXXX-mnt mnt-by: prefix-holderB-mnt Submission to the DB update: route: x.x.x.0/23 origin: AS-mnt mnt-by: ASXXXX-mnt authentication credentials for ASXXXX-mnt The DB would currently only look for an exact match and if none found, it will look for a less specific inetnum to authenticate the route creation. So today such an update would get rejected as you would not be able to authenticate whatever is above the /23. If it is changed to look for an exact match, then for more specifics with a matching summary to the route object prefix and then for a less specific, the creation of parent route would be allowed as part of the second step in the checks in the creation logic mechanism. It would not change the current authentication system logic, all will continue to work as it is today. Things to consider: A) Recall mechanism. To allow a prefix holders to recall a route object from a less specific route objects just like they today can with exact match and more specifics. Notifications could then be sent to the involved parties about the route recall having taken place. B) RIPE-NCC-RPSL-MNT! If the above mechanism was to be introduced, that maintainer could then create less specific route for any range, restrictions would need to be implemented in order to prevent mistakes or abuse of RIPE-NCC-RPSL-MNT. C) Adding this to the IRR wizard Alex Band described at the DB WG session. Simple interface and overview of what could be aggregated. D) Could any of this have any negative effect in the RIPE Database? E) Should this also be passed through the routing WG? Cheers, David Hilario

1 0

passwords
by ripedenis＠yahoo.co.uk 27 Oct '16

27 Oct '16

Hi Tim You just said that you can still use passwords with webupdates. I am looking at webupdates right now and I can't see any way to create or update an object using a password. You cannot get past the stage where it says "Login to create" or "Login to update". So where can I enter a password? cheersdenis

2 1

BGP Policy Update Questionnaire (only 3 questions) for research purposes (SNE/OS3 MSc. thesis University of Amsterdam)
by Stavros Konstantaras 27 Oct '16

27 Oct '16

Dear members, First of all, I would like to apologize if you received this message more than once. I am sending this e-mail on behalf of my colleague, Stamatios Maritsas, who is a master student of System and Network Engineering MSc. (SNE/OS3) program at University of Amsterdam and currently conducting his master's thesis project titled: "A decentralized system for automatic exchange of policies for BGP configurations”. The purpose of the questionnaire (only 3 questions :)), that you will find in the following link, is to help him gather important information based on your implemented BGP routing policy, which will help design an exchange policy system in the most efficient way. I want also to inform you that all the data that will be gathered and used will be only for research purposes and fully anonymized. Link of questionnaire: https://docs.google.com/forms/d/e/1FAIpQLSd7TzoYvFGcXAOUWaZa30v-zHeRH8jfm__… <https://docs.google.com/forms/d/e/1FAIpQLSd7TzoYvFGcXAOUWaZa30v-zHeRH8jfm__…> Thank you in advance for your time, and I hope that you can help him/us! Kind Regards, Stavros Konstantaras ---- Stavros Konstantaras Internet Research Engineer, NLnet Labs Science Park 400, 1098 XH, Amsterdam Fingerprint: 4502 7D16 2DF8 ADB0 4AA6 21A9 BF9E EFFF 2744 FE5D

1 0

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