- db-wg - mailman.ripe.net

DB documentation?
by Gilles Massen 07 Oct '13

07 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

training] RIPE NCC Webinars - new dates
by Training Team 24 Sep '13

24 Sep '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 1

Re: [db-wg] new "via" attributes in aut-num Class
by David Freedman 22 Sep '13

22 Sep '13

>http://tools.ietf.org/html/draft-snijders-rpsl-via Having read the draft, this seems sensible and seems to have a strong use case. >If the community supports the addition of the proposed attributes the >RIPE NCC can go ahead and merge his implementation and make it available >in the next release Yes, I'd like to see an implementation please. Dave.

1 0

RIPE67 DB-WG Draft Agenda V1
by Wilfried Woeber 08 Sep '13

08 Sep '13

Dear DB-WG folks, Chairpersons, "Meeting"! This is the 1st draft of an agenda for the DB-WG Meeting at RIPE67 in Athens, scheduled for October 17, 2013. For time slot allocations please refer to the most up-to-date meeting plan at https://ripe67.ripe.net/programme/meeting-plan/ The DB-WG Meeting is scheduled for *Thursday*, starting at 11:00 local time[1] in the morning. The length of our timeslot is 90 Minutes. The overall (draft) RIPE 67 meeting outline is already available at https://ripe67.ripe.net/programme/meeting-plan/ Please feel free to propose additional topics to be discussed! I'd also suggest that you submit your points of view regarding the topics on the proposed agenda on the mailing list, preferably before the WG meeting's start :-) Best regards, hope to see you soon in Athens, Wilfried. [1] for remote participation, we'll come back later with the UTC information ________________________________________________________________________ A. Administrative Matters . Welcome . select scribe . finalise agenda . approval of minutes from previous WG meeting(s) . review of action list B. Data Base Operational Update (N.N., RIPE NCC) C. New DB-Software functionality - in beta - proposed D. Dicussion / Report regarding management of Software Releases - formal procedure for announcments and deployment - functionality / importance of TEST DB environment - report and/or discussion of Workshop/BoF-Results (t.b.c.) E. UTF-8 transparency in the Registry - functionality and/or restrictions by components - policy or business logic interactions, - coordination /input ith/from other WGs F. Status update on IETF WEIRDS activities (N.N. t.b.c.) Y. Input from other Working Groups and/or Task Forces - review of abuse contact stuff (N.N. t.b.c.)) Z. AOB ________________________________________________________________________ 08.09.2013 12:30 UTC

1 0

Call for agenda items, DB-WG Meeting during RIPE67, Athens, GR
by Wilfried Woeber 04 Sep '13

04 Sep '13

Dear DB-WG folks, planning activities for the next RIPE Meeting - RIPE67 in Athens, GR, Oct. 14 - Oct. 18, 2013, have already started a while ago - thus this _call for agenda items_ for the meeting of the Database Working-Group. Please submit (to the WG list!) your item requests and|or suggest topics for discussion to be included in the draft agenda! Please note that the DataBase-WG meeting is *at the moment* scheduled for *Thursday* (starting at 11:00 local time). This is according to the *draft* meeting plan - which is pretty stable already but may still need to be changed as we get closer to the meeting date! The overall (draft) RIPE 66 meeting outline is already available at https://ripe67.ripe.net/programme/meeting-plan/ Looking forward to a successful meeting and see you soon in Greece! Wilfried.

1 0

New bug fix release scheduled for 29 August
by Johan Åhlén 29 Aug '13

29 Aug '13

Dear colleagues, We have moved documentation for the RIPE Database WHOIS REST API out of the database software. It can be accessed at: https://github.com/RIPE-NCC/whois/wiki/WHOIS-REST-API Given the benefits associated with generated documentation, we intend to look for another solution for this at a later stage. Since the last release there have been a number of issues reported regarding the REST API. As this is particularly important for users migrating from the old REST service to the new one, we have now addressed these issues in a bug fix release that we will put in production this week, ahead of the next major RIPE Database release. The issues addressed by this release are listed here: https://github.com/RIPE-NCC/whois/issues?milestone=1&state=closed For users migrating from the old REST API, we have also created a migration guide that can be found at: https://github.com/RIPE-NCC/whois/wiki/WHOIS-REST-API-Migration-Guide The bug fix release is now available in TEST Database and we intend to upgrade the production database on Thursday evening, 29 August. Kind regards, Johan Åhlén Assistant Manager Database RIPE NCC

3 2

Update on today's bug fix release
by Johan Åhlén 29 Aug '13

29 Aug '13

Dear colleagues, Since announcing the next bug fix release for the RIPE Database, we have received some important feedback from the community. Based on some discussions off-list on how to proceed we have decided to move forward and put the release into production today. The current production version of the REST API was not working as intended, and while investigating issues with the broken documentation, other issues were identified, that if not fixed, would lead to unintended use of the REST API. We believe that since this is now affecting certain RIPE Database users, we should not delay deployment any more than necessary. We realise this may not be the most satisfactory deployment and we assure you that the matter will be further considered and discussed at RIPE 67. If you can't be there and have some views on this matter we would very much appreciate hearing from you on the mailing list. Kind regards, Johan Åhlén Assistant Manager Database RIPE NCC

1 0

[training] RIPE NCC Webinars - new dates
by Training Mailbox 29 Aug '13

29 Aug '13

[Apologies for duplicate e-mails] Dear colleagues, We are pleased to announce the launch of new dates for our Webinars for LIRs. The RIPE NCC Webinars are live, one hour online training courses that allow participants to interact with our trainers without leaving their desks. 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<e-learning(a)ripe.net>. We look forward to seeing you online. Kind regards, RIPE NCC Training Services

2 2