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

[training] RIPE NCC Webinars - new dates
by Training Team 15 Oct '13

15 Oct '13

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://lirportal.ripe.net/training/courses 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

Improvements to RIPE Database Software Release Management
by Johan Åhlén 10 Oct '13

10 Oct '13

Dear colleagues, Following recent discussion regarding the release management of the RIPE Database software, we looked closely at our procedures and would like to propose some improvements. Together with the Database Working Group chairs, we've scheduled an informal meeting during RIPE 67, open for anyone that is interested in this topic, to discuss the proposals and talk about how we can improve our procedures. The meeting will take place on Monday, 14 October from 18:00-19:00 in room Sigma + Theta. We hope you will join us. Of course, you can also send your feedback and suggestions to this list. This is what we propose: - Split the RIPE Database software into smaller modules. Modularisation would minimise the release frequency for our services. For instance, with a modern API like RDAP we might have bi-weekly major releases and weekly minor releases to quickly respond to changes in the specification. With the NRTM feed, there might be just one major release per year or even less. - Replace the "emergency release" with a "minor release" that only contains patches for operational purposes and bug fixes. No new functionality would be introduced and no feature changes. We would also have "major releases" where functionality is added, changed or removed. With major releases we would keep the minimum two-week user test period leading up to the production release as stated in the previously proposed release procedure. With any minor release, we would put it in production as soon as it's available. Most bugs affect some users. Rather than trying to determine urgency based on numbers of users, size of users, number of networks affected, importance of functionality affected, etc., we would treat all bugs the same. In short, if someone reports an issue to us, we fix it right away. This process has generally worked well over recent years. - Improve the test environment. We know that users would like to have their real data to do proper testing. To solve this issue, we propose to use snapshots of the current database for this purpose. - Improve communication surrounding new releases. This covers all documentation and how we inform users about changes. We hope that you find this way forward beneficial. Kind regards, Johan Åhlén Assistant Manager Database RIPE NCC

2 2

Syntax Change to Aut-num Object in the RIPE Database
by Denis Walker 09 Oct '13

09 Oct '13

Dear colleagues, We would like to give you a heads-up about a proposal, currently being considered, to add two new attributes to the aut-num object in the RIPE Database: "import-via:" and "export-via:". In this email we are not concerned with the details of this specific change so much as the fact that a change is being considered. We know that these objects are very important for routing and many of them are updated daily in the RIPE Database. We also know that many scripts exist for auto-generating these objects and processing the contents. Although the RFC for RPSL clearly states that scripts should be written to ignore attributes they don't recognise, we don't know if all scripts are written this way. The RIPE NCC is considering the best ways to get information about any changes to routing object syntax in the RIPE Database out to the people who need to know. We would welcome any feedback on this issue from the community. Regards, Denis Walker Business Analyst RIPE NCC Database Team

1 0

Re: [db-wg] new "via" attributes in aut-num Class
by Erik Bais 09 Oct '13

09 Oct '13

Hi Job & Johan, I think the implementation makes sense and my compliments on the draft. It looks good: > http://tools.ietf.org/html/draft-snijders-rpsl-via Is this already in the new db version or is this still waiting for more community support ? For me, support +1. Kind regards, Erik Bais A2B Internet > > I have submitted the following draft to the IETF: > > http://tools.ietf.org/html/draft-snijders-rpsl-via > > And I have submitted a patch for the RIPE whois server to support the feature. > > https://github.com/job/whois > > The extension should be backward compatible with minimal impact on existing > tools and processes, following Section 10.2 of RFC2622. RPSL parsers which > do not understand the new attributes are expected to just ignore it. > > I am looking for feedback from this community, and especially the community's > blessing to allow RIPE NCC to adopt the patch. > > Kind regards, > > Job

2 1

DB documentation?
by Gilles Massen 08 Oct '13

08 Oct '13

Hi, Considering that the documentation linked from the RIPE website ( http://www.ripe.net/data-tools/support/documentation/update-ref-manual ) is out of date, is a current database documentation / reference manual available somewhere? Any pointer (short of the database source code) welcome... Gilles -- Fondation RESTENA - DNS-LU 6, rue Coudenhove-Kalergi L-1359 Luxembourg tel: (+352) 424409 fax: (+352) 422473

2 2

RIPE Database Release 1.69 Available Soon
by Denis Walker 01 Oct '13

01 Oct '13

Dear colleagues, The RIPE NCC is pleased to announce that we have deployed a new release of the RIPE Database to the TEST Database environment. Detailed information about the new release, including dates and information about the changes can be found here: https://www.ripe.net/data-tools/db/release-notes/ripe-database-release-1.69 Of special note in this release is the inclusion of "dry-run". Using the dry-run function you can test whether an update would succeed or not. The update procedure runs as normal except that no change is made to the database. Find out more about the dry-run function here: https://labs.ripe.net/Members/denis/dry-run-testing-in-the-ripe-database Due to recent issues with the REST API, we've extended the migration period up until the 1.70 release. This release is currently scheduled for the end of October. If you have any questions or comments, we look forward to hearing them! Regards, Denis Walker Business Analyst RIPE NCC Database Team

4 7

installing "RIPE Whois Database"
by Martin T 01 Oct '13

01 Oct '13

Hi, I would like to install "RIPE Whois Database" locally for testing purposes. I have downloaded the latest release: dbase@A58:~$ wget -q https://github.com/RIPE-NCC/whois/archive/master.zip dbase@A58:~$ unzip -qq master.zip dbase@A58:~$ ..and installed logrotate, sendmail, git, maven, openjdk-7-doc, openjdk-7-jdk, openjdk-7-source, mysql-server and mysql-client packages from Debian Wheezy repository. Mysqld is listening on TCP port 3306 and user dbint is created: mysql> SELECT * FROM mysql.user WHERE User = 'dbint' ; +-----------+-------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | +-----------+-------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ | localhost | dbint | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | | NULL | +-----------+-------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+ 1 row in set (0.00 sec) mysql> As I understand, now I need whois.jar file which is an archive containing Java class files? Where can I get this? regards Martin

2 3