RIPE Database docs
Sidebar Navigation

Introduction to the RIPE Database

RIPE Database Documentation Overview

Intended Audience

Conventions Used in the RIPE Database Documentation

What is the RIPE Database

Purpose and Content of the RIPE Database

History of the RIPE Database

Personal Data Database Management and Reponsabilities

RIPE Database Structure

Database Object

Primary and Secondary Objects

List of Primary Objects

List of Secondary Objects

The Attributes in Database Objects

Attribute Names

Attributes in an Object

Attribute Values

Attribute Properties

How to Organise Your Data

REST API Data model

RPSL Object Types

Descriptions of Primary Objects

Descriptions of Secondary Objects

Available Databases

RIPE Database

TEST Database

Release Candidate Database

Experimental Databases

Update Methods

RESTful API

Webupdates

Syncupdates

Email Updates

Updating Objects in the RIPE Database

Format of the Update Message

Accessing the Object Templates

Object Processing

Update Operations

Historical Data

Special Considerations for Object Creation

Garbage Collection

Dry run

Set Objects

Notifications

Acknowledgment Message

Notification Messages

Authorisation

Authorisation Model

Using the Authorisation Methods

Security of Data Using Authorisation

Protection of PERSON and ROLE Objects

Protection of AUT NUM Object Space

Protection of Address Space

Protection of Route Object Space

Protection of Reverse Delegation Objects

Protection of Objects with Hierarchical Names

Protecting Membership of a Set

Referencing an ORGANIZATION Object

Referencing an IRT Object

IRT Object

Force Delete Functionality

Request ENUM delegation

Request DNSSEC delegation

How to Query the RIPE Database

The Structure of a Query

Web Query Form

RESTful API Queries

Command Line Queries

Query Responses

Registration Data Access Protocol

Access to Personal Data

Types of Queries

Queries Using Primary and Lookup Keys

Queries for IP Networks

Queries for Autonomous Systems

More and Less Specific Lookups For Reverse Domains

Inverse Queries

Abuse Contacts

Grouping the RIPE Database Output

Filtering the Query Reponse

IRR Toolset Support

Persistent Connections and Keeping State

Getting All the Members of Set objects

Access Control for Queries

RIPE NCC Global Resource Service

Other Query Flags

Referenced Objects in Query Response

Historical Queries

Related Software and Tools

Geolocation in the RIPE Database

RIPE Database Mirror

Setup RIPE Database Mirror

Near Real Time Mirroring v3

Near Real Time Mirroring v4

Access to NRTM

Tables of Query Types Supported by the RIPE Database

How to Recover Access to a Maintainer Object

Installation and Development

Getting started on macOS

Getting started on Ubuntu Linux

Building whois

Configure MariaDB

Coding standard

Installation instructions

Database Support

Support Overview

Clean up of Unreferenced Data

Database Security

Configuring Reverse DNS

Database Business Rules

Highlighted Values in the RIPE Database

Create First Role Mntner

Removal of personal data

Release Notes

FAQ

Appendices

Appendix A Syntax of Object Attributes

Appendix B Copyright Statement

Appendix C RIPE Database Query Server Response Codes and Messages

Appendix-D--Route-Object-Creation-Flowchart

Appendix-E--Domain-Object-Creation-Flowchart

Appendix F Special Considerations for Object Types

Appendix G Object Types with Personal Data

Appendix H PGP Authentication Method

Appendix I Client Certificate Authentication

Appendix J Ripe Test Database

Appendix K API Keys

Glossary

Legal Information

RIPE Database Acceptable Use Policy

HTML Terms And Conditions

All Documentation Combined

On this page

Appendix J- RIPE Test Database ​

Introduction ​

The RIPE NCC has a test database where users may learn how to use the software. This database uses the same software as the RIPE Database, but is completely separate. You cannot change anything in the RIPE Database by changing an object in the TEST database.

The data in the TEST database is not a copy of the data in the RIPE Database. Also, it is not authoritative data. No value should be put on the data in the TEST database. The database is reset to a default state each night.

You can create objects in the TEST database to simulate a part of your real network. You can then experiment with different situations in this TEST environment safely.

Creating Objects in the TEST Database ​

There are different ways to create objects in the TEST database

Web interfaceFor creating a single object using a form. Go to
https://apps-test.db.ripe.net/db-web-ui/#/webupdates/select
To get started, create a role and maintainer pair. Go to
https://apps-test.db.ripe.net/db-web-ui/webupdates/create/TEST/role/self
MailupdatesEmail you object to test-dbm@ripe.net. You will receive an acknowledgement message with the result.
SyncupdatesFor creating one or more objects at a time, using a single field to edit objects. Go to https://apps-test.db.ripe.net/db-web-ui/syncupdates You can also submit updates from the command line (or script) via: https://syncupdates-test.db.ripe.net/
REST APISoftware API to create a single object at a time. Documented in whois rest api. The base URL for the TEST environment is https://rest-test.db.ripe.net/test

Finding Objects in the TEST Database ​

There are different ways to find objects in the TEST database

Web interfaceGo to https://apps-test.db.ripe.net/db-web-ui/query
Command lineDo
whois -h whois-test.ripe.net <Search String>
e.g.
whois -h whois-test.ripe.net PB3-RIPE
The query flags that work in the RIPE Database also work in the TEST Database. We invite you to try them.
REST APISoftware API to search Whois or lookup a single object. Documented in whois rest api

MNTNER Objects in the TEST Database ​

You can create your own mntner objects in the TEST database. This mntner object only maintains objects in the TEST database.

These are different ways to create a mntner object in the TEST database.

Web interfaceTo create a single object (choose mntner from the dropdown):
(a) Go to https://apps-test.db.ripe.net/db-web-ui/webupdates/select
(b) Choose mntner from the dropdown and click Create
(c) Complete the form and click Submit
REST APISoftware API to create, update or delete a single object. Documented in whois rest api
Mailupdates(a) complete (fill in) a mntner object template
(b) email the completed template to test-dbm@ripe.net.
(c) You will receive an email reply with the result.

There are some RIPE NCC maintainers in the TEST database which can be used for authentication.

TEST-DBM-MNTMaintainer for TEST DBM objects. The maintainer password is "emptypassword" without the quotes.
TEST-NCC-HM-MNTHostmaster maintainer. The maintainer password is "emptypassword" without the quotes.

Creating INETNUM Allocations in the TEST Database ​

For this example, use the web interface to create an inetnum.

If you did not create your own mntner object, please use TEST-NCC-HM-MNT as the mntner of the inetnum.

After typing in the inetnum field value, you will be prompted to choose a mntner to authenticate the update operation. Choose TEST-DBM-MNT and deselect the checkmark that says "Also authorise my RIPE NCC Access account for this maintainer".

For example, create an inetnum with a /21 prefix in the 2/8 range.

The "org:" (organisation) attribute is required for an inetnum object with the status 'ALLOCATED PA' or 'ALLOCATED PI'. The mntner password for the organisation "mnt-ref:" attribute must be known in order to make a reference to the organisation. The organisation object must have an "org-type:" attribute with the value 'LIR' for the 'ALLOCATED PA' status (for example, use ORG-EIPB1-TEST as an LIR and authenticate with the TEST-DBM-MNT password).

Creating AUT-NUM Objects in the TEST Database ​

Aut-num objects in the RIPE database are only assigned by the RIPE NCC. However, you are free to create aut-num objects in the TEST database.

You can create an aut-num object from create an Object page.

You can also create an aut-num object using the Syncupdates.

You need to authenticate with the TEST-DBM-MNT password, which maintains the root as-block object.

Creating Route Objects ​

For this example, use the web interface to create a pair role and maintainer.

You need to create an LIR organisation as well. Normally LIR organisations are created by the RIPE NCC for a member. Only an LIR organisation can be referenced from an allocation. Use your newly created role (e.g TR1-TEST) as the admin-c and tech-c. Use your newly created mntner (e.g. TESTMNT-MNT) as the mnt-by.

You can also create the organisation using the Syncupdates. e.g.:

organisation:    AUTO-1
org-name:        Test Organisation
org-type:        LIR
address:        Amsterdam
e-mail:         eshryane@ripe.net
admin-c:         TR1-TEST
tech-c:          TR1-TEST
mnt-ref:         TESTMNT-MNT
mnt-by:          TEST-NCC-HM-MNT
mnt-by:          TESTMNT-MNT
source:          TEST
password: emptypassword

After creating the organisation you need to create an allocation. Normally the allocations are created by the RIPE NCC for a member organisation. You need some address space before creating a route object. Use your new organisation (e.g. ORG-TO2-TEST) as your "org:" reference

You can also create the allocation using the Syncupdates. e.g.:

inetnum:         11.0.0.0 - 11.0.0.255
netname:         NL-TEST
country:         NL
org:               ORG-TO2-TEST
admin-c:         TR1-TEST
tech-c:          TR1-TEST
status:          ALLOCATED PA
mnt-by:     TEST-NCC-HM-MNT
mnt-by:          TESTMNT-MNT
source:          TEST
password: emptypassword

Finally, you can create the route object in the address space that you have just allocated.

You can also create the route object using the Syncupdates. e.g.:

route:           11.0.0.0/24
origin:          AS3333
descr:           route
mnt-by:          TESTMNT-MNT
source:          TEST

Last updated:

Pager
Previous pageAppendix I Client Certificate Authentication
Next pageAppendix K API Keys