February 2014 - 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

Draft minutes of RIPE 67 meeting
by Nigel Titley 05 Nov '14

05 Nov '14

Please find draft minutes of the DB-WG meeting held in Athens today. Comments, complaint, misrepresentations etc, to me Nigel

1 1

Support for expansion of an origin into a list of prefixes
by Job Snijders 01 May '14

01 May '14

Dear RIPE DB-WG, Much like my previous request regarding server side expansion of objects, I'd very much like the RIPE Database team to implement two flags which IRRd currently supports: !g & !6 I've filed an enhancement request on github: https://github.com/RIPE-NCC/whois/issues/73 The !g and !6 flags signficantly reduce the amount of RPSL interpretation a client has to perform, as the server provides the clients with a straight answer (abeit simplified). If the DB team implements such a feature, I'd also very much like an implementation in context or RDAP so I can query for lists of prefixes through HTTP rather than WHOIS. Kind regards, Job

2 1

Proposal: DB object syntax change
by Piotr Strzyzewski 25 Apr '14

25 Apr '14

Dear working group I would like to propose syntax change of the role attribute of the ROLE object in the RIPE DB. Bellow you can find all details. I would like to hear your opinion about this idea and ask for the support to allow RIPE NCC to implement it. ------------- Short description: I would like to propose to change the syntax of the role attribute of the ROLE object from <person-name> to <organisation-name>, where both <person-name> and <organisation-name> are defined in RIPE Database Update Reference Manual. I would like to emphasize that I don't want to change the syntax of the nic-hdl attribute of the ROLE object. Nevertheless, my proposal influence the automatic mechanism of choosing the nic-hdl attribute value of the ROLE object, while it is created with AUTO directive. Rationale: Abuse-c implementation have influenced business procedures of LIRs and have led to increased importance of ROLE object. Since ROLE object is mandatory in the process of proper abuse-c registration, LIRs could be interested in automatic creation of it. Right now, due to its syntax, the role attribute of the ROLE object has number of limitations and cannot accept bunch of characters and or whole labels/words which are natural parts of company names. As an example, it is impossible to create ROLE objects with one of the following role attributes: - Company Father, Son & Daughter Abuse Team - 4U Network Abuse Team - 123 Ltd. Hostmaster - WOW! Network Dept. and so on. Moreover, the original intention was for the ROLE object to represent business roles and not personal data (see: paragraph 1.2.17 of the RIPE Database Update Reference Manual). Taking this into account the <organisation-name> would be the natural choice since it both perfectly solves the problem and is already well defined and implemented. Possible problems: As for now, the nic-hdl attribute of the ROLE object is auto-generated and based on the value of the role attribute. Since <person-name> do not allow all-numeric labels, this mechanism is quite simple. However, similar mechanism exists for the auto-generated organisation attribute of the ORGANISATION object, where <organisation-name> allows this kind of labels. While this is significant change to syntax, I would like to emphasize that <person-name> is a subset of <organisation-name>. This means that even if some people may rely on the current syntax, this change would most probably not influence their procedures. ----------- Best regards, Piotr -- gucio -> Piotr Strzyżewski E-mail: Piotr.Strzyzewski(a)polsl.pl

7 11

[training] RIPE NCC Webinars - new dates
by Training Services 25 Feb '14

25 Feb '14

Dear colleagues, We are pleased to announce the launch of new dates for our Webinars. The RIPE NCC Webinars are live and take only one hour. You can interact with our trainers without leaving your desk. We focus on the topics and issues most important for LIRs. Register now at https://www.ripe.net/lir-services/training/e-learning/webinars Participation is limited to 20 people, so don't hesitate if you want to take part! If you have questions, please email <training(a)ripe.net>. We look forward to seeing you online. Kind regards, RIPE NCC Training Services

1 0

[training] RIPE NCC Training Courses April-June 2014
by Training Services 18 Feb '14

18 Feb '14

Dear Colleagues, Our training team travels the RIPE NCC service region to deliver training courses to our members without any additional cost. Over the next few months, we'll be in St. Julian's, Zagreb, Sofia, Brussels, Edinburgh, Tehran, Helsinki, Moscow, Kiel, Almaty, Reykjavik, Geneva. Visit the following page to register and to check which training courses we are giving in your area: https://lirportal.ripe.net/training/courses The RIPE NCC delivers the following training courses: - LIR Training Course - Database Training Course - IPv6 for LIRs Training Course - Routing Security Training Course - 3 day Deploying IPv6 Training Course (New) - DNSSec Training Course (New) For more information visit: https://www.ripe.net/lir-services/training/courses With kind regards, Rumy Spratley-Kanis Training Services Manager

1 0

[training] RIPE NCC Training Courses April-June 2014
by Training Services 17 Feb '14

17 Feb '14

Dear Colleagues, Our training team travels the RIPE NCC service region to deliver training courses to our members without any additional cost. Over the next few months, we'll be in St. Julian's, Zagreb, Sofia, Brussels, Edinburgh, Tehran, Helsinki, Moscow, Kiel, Almaty, Reykjavik, Geneva. Visit the following page to register and to check which training courses we are giving in your area: https://lirportal.ripe.net/training/courses The RIPE NCC delivers the following training courses: - LIR Training Course - Database Training Course - IPv6 for LIRs Training Course - Routing Security Training Course - 3 day Deploying IPv6 Training Course (New) - DNSSec Training Course (New) For more information visit: http://www.ripe.net/lir-services/training/courses With kind regards, Rumy Spratley-Kanis Training Services Manager

1 0

[training] RIPE NCC Webinars - new dates
by Training Services 11 Feb '14

11 Feb '14

Dear colleagues, We are pleased to announce the launch of new dates for our Webinars. The RIPE NCC Webinars are live and take only one hour. You can interact with our trainers without leaving your desk. We focus on the topics and issues most important for LIRs. Register now at https://www.ripe.net/lir-services/training/e-learning/webinars Participation is limited to 20 people, so don't hesitate if you want to take part! If you have questions, please email <training(a)ripe.net>. We look forward to seeing you online. Kind regards, RIPE NCC Training Services

1 0

Multiple Sources and the REST API?
by Aleksi Suhonen 07 Feb '14

07 Feb '14

Hello, I'm trying to fetch data from the RIPE db and the mirrored databases at the same time: http://rest.db.ripe.net/search?source=ripe&source=apnic&inverse-attribute=o… I get 400 Bad Request even tho it should work according to the documentation I'm reading: https://github.com/RIPE-NCC/whois/wiki/WHOIS-REST-API-search Halp. -- +358 4567 02048 / http://www.trex.fi/ Aleksi Suhonen / TREX Regional Exchanges Oy You say "potato", I say "closest-exit."

2 1

New minor release 1.71.1 to fix REST API JSON issue
by Denis Walker 06 Feb '14

06 Feb '14

Dear colleagues, We have identified the cause of the REST API JSON issues some users have been experiencing. Details can be found on github: https://github.com/RIPE-NCC/whois/issues/114 We deployed a new minor version (1.71.1) of the RIPE Database software today at 17:15 (UTC +1) to fix this issue. Release notes can be found here: https://www.ripe.net/data-tools/db/release-notes Regards, Denis Walker Business Analyst RIPE NCC Database Team

3 4

RC version of the JSON API?
by Job Snijders 06 Feb '14

06 Feb '14

Hi, I want to use the JSON API RC edition of the database in an automated fashion to detect changes that break our software earlier. But I have trouble finding the correct endpoint. For production I use the following URL: https://apps.db.ripe.net/whois What is the equivalent URL for the RC version of the database? From the post on http://www.ripe.net/data-tools/db/release-notes/rc-release-candidate-enviro… it is not clear which of the URLs would emulate apps.db.ripe.net/whois. I tried: rc.db.ripe.net/whois rest-rc.db.ripe.net/whois whois-rc.ripe.net/whois I kinda expect rest-rc.db.ripe.net/whois to work, but it gives me a "The requested URL /whois/create was not found on this server." error. What is the endpoint? Kind regards, Job

2 1

Release 1.71.1 reverted, current RIPE Database release is 1.71
by Johan Åhlén 06 Feb '14

06 Feb '14

Dear colleagues, Earlier today we deployed a minor release of the RIPE Database software. The release contained a correction of an invalid data structure returned in the JSON format. The issue is described in detail here: https://github.com/RIPE-NCC/whois/issues/114 The beta REST API was decommissioned with the deployment of 1.71. As the issue above was affecting users that had not yet migrated to the new API we decided to go ahead with the minor release. However, we were just informed that there are users that rely on this specific structure for their operations so we have reverted the minor release. The current RIPE Database version in production is now back to 1.71 We’ve also made sure that the old beta API is available for any users that can’t migrate because of the issue mentioned above. Please contact me directly and I will provide you with the details on how you can connect to the old beta API. We are sorry for any inconvenience this might have caused you and if you have any questions or concerns then please let me know. Kind regards, Johan Åhlén Assistant Manager Database RIPE NCC

1 0

RIPE Database Release 1.71
by Johan Åhlén 04 Feb '14

04 Feb '14

Dear colleagues, We are pleased to announce RIPE Database release 1.71. You can find details about the new features, changes and how you might be affected, and important dates in the release notes: https://www.ripe.net/data-tools/db/release-notes/ripe-database-release-1.71 The new release contains the "import-via" and "export-via" attributes that were discussed in the Database and Routing Working Groups at RIPE 67, the initial implementation of which was made by Job Snijders. After further discussions on the mailing lists, the working group chairs decided that this feature should be incorporated in the RIPE Database. You can find out more about these attributes here: http://www.ietf.org/id/draft-snijders-rpsl-via-02.txt With this release we would also like to introduce our new Release Candidate environment. The Release Candidate environment is distinct from the TEST Database, and aims to provide an environment as close as possible to "production" where you can test that your software will work with upcoming RIPE Database releases. You can find out more about the Release Candidate environment in the release notes linked above. We look forward to hearing any questions or comments you might have! Kind regards, Johan Åhlén Assistant Manager Database RIPE NCC

2 2