- db-wg - mailman.ripe.net

draft agenda (v1) for DB-WG meeting, RIPE 37, Amsterdam
by Wilfried Woeber, UniVie/ACOnet 06 Sep '00

06 Sep '00

Dear WG list members, fellow chair persons, "meeting", attached please find the 1st draft, proposed agenda for the DB-WG Meeting. A few minor items might get added later this week. While the general outline of the meeting should be quite stable already, please expect some re-scheduling due to the parallel WG streams. This requires us to do some "micro-management" to avoid "over-booking" of individuals. As usual, comments, suggestions and additions are welcome! Looking forward to see many of you in Amsterdam, Wilfried. ______________________________________________________________________ Proposed Agenda for the Database Working Group Meeting RIPE-37, Sept. 2000, Amsterdam, NL 1. Draft Thursday, Sept 14, 2000 at 09:00-12:30 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Part I: WG-Meeting A. Administrative stuff (Wilfried Woeber, chair) . volunteering a scribe . list of participants . agenda bashing . minutes distributed B. Actions Items . B. RIPE DB, operations update (RIPE NCC) 20min C. New Database implementation (RIPE NCC) 40min D. IRRd: experiences, registration software weaknesses (G.Winters, MERIT) 20min E. Activity Plan proposal(s) for next year (N.N.) . summary . next steps (requirements?) Y. Input from other WGs - Z. AOB: Part II: Re-Implementation/Migration TF A: Members, ToR B: Test Reports/Feedback B: Deployment Plan C: Next steps ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ WW, 6-SEP-2000 13:44:48 _________________________________:_____________________________________ Wilfried Woeber : e-mail: Woeber(a)CC.UniVie.ac.at UniVie Computer Center - ACOnet : Tel: +43 1 4277 - 140 33 Universitaetsstrasse 7 : Fax: +43 1 4277 - 9 140 A-1010 Vienna, Austria, Europe : RIPE-DB: WW144, PGP keyID 0xF0ACB369 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ First things first, but not necessarily in that order....

1 0

RIPE 36 DB-WG Minutes (final version)
by Nigel Titley 04 Sep '00

04 Sep '00

Gentlefolk, After receiving comments. Here are the final minutes of the RIPE DB-WG minutes. Share and enjoy. Nigel Minutes for the Database Working Group Meeting RIPE-36, May 2000, Budapest, HU Thursday, May 18, 2000 at 10:30 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ A. Administrative stuff (Wilfried Woeber, chair) . scribe Nigel Titley volunteered to take the minutes . raw scribe notes distributed Wilfried had not had time to process the raw notes from RIPE 35, but these were circulated in lieu of full minutes. . help offered by - Nigel Titley, - Ulf Kieber Wilfried asked the WG if they were happy to accept the help offered by Nigel Titley and Ulf Kieber. Nigel would help with the PR and documentation side of the group, and Ulf will help to co-ordinate the working group. He received approval from WG on this issue. B. RIPE DB, operational update (Andrei Robachevsky, RIPE NCC) Andrei Robachevsky gave an operational update on the state of the RIPE DB. Amongst the many statistics that he presented it was noted the very large number of domain objects, mostly from the .de domain. It was explained that these objects would be shortly devolved to the DE-NIC whois server, and plans were currently being formulated to perform this move with minimum disruption to the RIPE community. C. DB Software Re-Implementation (Joao Damas, RIPE NCC) Joao Damas gave a short presentation on the progress of the DB Software re-implementation project. D. Report on Certification Authority activities (Paul Gampe, APNIC) Paul Gampe gave a very interesting presentation on the use of X509 certificates for authentication when updating the APNIC database. The following points were noted: - Training at the next RIPE meeting might be useful, to provide a view of X509 vis-a-vis PGP. There appears to be a degree of convergence between the two systems. - It was noted that it will be soon possible to sign X509 keys with PGP signatures and vice versa. - The main objection to using X509 is the cost of the commercial licenses. The first phase of the implementation will sort out licenses for users. Much cheaper (free) approaches are on their way. E. Activity Plan for next year! It was noted that input to the RIPE-NCC activity plan was needed before September. Suggestions received from the WG included - Use of X509 signature for authentication (as per APNIC) - Support for other character sets than ASCII. (Joao noted that the new code is 8-bit clean, but that there is problem wit the reproduction of character sets. The best he felt able to do was to track progress by other sources, and to keep the code clean). - Removal of further domain objects from the database. The problem being that existing applications must not be affected. It was suggested that the RIPE-NCC could offer help to other ccTLDs to set up their own whois databases. It was suggested that we ask CENTR to produce a regular report and to try and get domain objects shifted out of the DB. [AP: Wilfried Woeber and Joao Damas] F. Input from other WGs - EIX-WG would like an object in the DB to describe IXs. It was also suggested that a peering contact in the aut-num object could be useful. There was some support for both these proposals and it was suggested that a formal request be made to the WG by email. - Routing WG. No further input had been received from the Routing WG re native multicast. It was felt that this would soon need looking at. The Routing WG needs to add an entry to the RPSL Draft. G. AOB - A suggestion (Joel Rowbottom) was made to use XML for registration templates. Suggestions as to how to do this would be gratefully received. - A suggestion to use a mail-to authentication scheme was received from Michael Battilana (IANA). The idea being that agreement to proceed with a modification would be obtained via a token and confirmation from a know mail mail address. It was agreed that this was not very easy to do as it is stateful and could lead to DOS attacks on the database. - A brief update was given on CERT/IRT-related issues (WW144/Jaques Schuurman). Ut was suggested that a pointer be added to inet-num object to point to the IRT role. Anyone interested in this work to contact the WG.

1 0

Re: ripe-db question
by Christian Storch 04 Sep '00

04 Sep '00

You're right! That number space wasn't registrated at RIPE - you have to look at ARIN: http://www.arin.net/cgi-bin/whois.pl?queryinput=NETBLK-SPRINT-CDF4C7 The AS of omnitel looks like the first upstream provider of Omnitel was SprintLink (USA) and the second is Telianet (Sweden). So the address space 205.244.196.0/24 seems to be registrated by SprintLink at ARIN. Later it becomes an LIR at RIPE and so on... So I think for that you would have to ask all RIR's for your purpose: RIPE, ARIN and APNIC. And you won't get always the right answer for your geographical question I think. Christian ---------- | Von: Andrius Kasparavicius <andrius(a)andrius.org> | An: Christian Storch <storch(a)infra.net> | Cc: 'mediaWays Hostmaster' <hostmaster(a)mediaways.net>; lir-wg(a)ripe.net; db-wg(a)ripe.net | Betreff: RE: ripe-db question | Datum: Samstag, 2. September 2000 14:01 | | On Wed, 30 Aug 2000, Christian Storch wrote: | | > Take a look at http://www.ripe.net/ripencc/mem-services/general/allocs4.html. | > - Perhaps that page could solve your question. | | hmm, look at lt.Omnitel: | lt.omnitel (OMNITEL Net) | 19951120 194.176.32/19 ALLOCATED PA | 19971010 195.22.160/19 ALLOCATED PA | 19990913 212.47.96/19 ALLOCATED PA | | querry ripe database for 205.244.196.0/24 or for 205.244.197.0/24 | | route: 205.244.197.0/24 | descr: OMNITEL | descr: Joint Lithuanian-USA Closed Stock Company | descr: Vilnius, Lithuania | descr: GSM communications and data networks | origin: AS5522 | mnt-by: AS5522-MNT | changed: daiva(a)kaunas.omnitel.net 19970605 | source: RIPE | | route: 205.244.196.0/24 | descr: OMNITEL | descr: Joint Lithuanian-USA Closed Stock Company | descr: Vilnius, Lithuania | descr: GSM communications and data networks | origin: AS5522 | mnt-by: AS5522-MNT | changed: daiva(a)kaunas.omnitel.net 19970605 | source: RIPE | | | it mean's that in allocation list, is not all ip blocks allocated to | LIR's. Why? | | Andrius

2 1

RE: ripe-db question
by Christian Storch 04 Sep '00

04 Sep '00

Take a look at http://www.ripe.net/ripencc/mem-services/general/allocs4.html. - Perhaps that page could solve your question. regards, Christian //========================== // Christian Storch // InfraNet AG // Niederlassung Muenchen // Hansastr. 136 // D-81373 Muenchen // phone: +49 89 743523-55 // fax: +49 89 743523-23 // E-mail: storch(a)infra.NET //========================== -----Original Message----- From: mediaWays Hostmaster [SMTP:hostmaster@mediaways.net] Sent: Wednesday, August 30, 2000 4:24 PM To: lir-wg(a)ripe.net; db-wg(a)ripe.net Subject: ripe-db question Hi, some strange question: we need a complete list of assigned IP-Addresses in the european part of ripe region sort by country for a customer. Is there any chance to get it per whois/some application or do we buy some part of whois-db from ripe? The background is that a Online-Service needs this part of information to display the right website (on his top-level Webserver wich are reached by every online user first) for every user by his language. We are grateful for each assistance. Kind regards, _____________________________ Stephan Mankopf Networks/Backbone +49 5241 80 88729 stephan.mankopf(a)mediaways.net

2 1

ripe-db question
by mediaWays Hostmaster 04 Sep '00

04 Sep '00

Hi, some strange question: we need a complete list of assigned IP-Addresses in the european part of ripe region sort by country for a customer. Is there any chance to get it per whois/some application or do we buy some part of whois-db from ripe? The background is that a Online-Service needs this part of information to display the right website (on his top-level Webserver wich are reached by every online user first) for every user by his language. We are grateful for each assistance. Kind regards, _____________________________ Stephan Mankopf Networks/Backbone +49 5241 80 88729 stephan.mankopf(a)mediaways.net

7 8

RE: asused question
by kevin.bates＠bt.com 04 Sep '00

04 Sep '00

Greetings Having a "mnt-by" in an object prevents anyone not in the maintainer group from changing the data for that object (i.e. an inetnum). Having a "mnt-lower" in an object prevents anyone not in the maintainer group from changing the data below that object. So, I believe, without the "mnt-lower" in an inetnum, it is possible for anyone to add additional inetnum objects into the RIPE database, below your inetnum record, and for them to put another maintainer into the addition. You could then end up with false records within your assignment that you would be unable to remove. kevin > -----Original Message----- > From: Jeroen Ruigrok van der Werven [SMTP:jruigrok@via-net-works.nl] > Sent: 03 September 2000 12:23 > To: Abdullah Saad Al-Ashry > Cc: lir-wg(a)ripe.net; db-wg(a)ripe.net > Subject: Re: asused question > > -On [20000902 10:05], Abdullah Saad Al-Ashry (abdullah(a)awalnet.net.sa) > wrote: > >When I use the utility "asused" > ftp://ftp.ripe.net/tools/asused-3.5.tar.gz > >It gives me this warning: > >**************** > >Please check the following WARNINGS: > >212.xx.xxx.0 - 212.xx.xxx.255 has mnt-lower xxxx attached > >**************** > > You probably have: > > mnt-by: MNT-BLAH > mnt-lower: MNT-BLAH > > which is ambiguous if memory serves me right. > > Just remove the mnt-lower. > > This is just a guess, since you are paranoia and removed the specifices > of your assignment [for which I really cannot find any justification > actually, the paranoia that is]. > > HTH, > > kind regards, > > -- > Jeroen Ruigrok van der Werven Network- and systemadministrator > <jruigrok(a)via-net-works.nl> VIA Net.Works The Netherlands > BSD: Technical excellence at its best http://www.via-net-works.nl > Come and take a good look deep into these thuggish ruggish eyes. See the > thugstas cry. And I'm askin' the good Lord "Why?" and sigh, He told me we > lived to die...

1 0

asused question
by Abdullah Saad Al-Ashry 04 Sep '00

04 Sep '00

Hi, When I use the utility "asused" ftp://ftp.ripe.net/tools/asused-3.5.tar.gz It gives me this warning: **************** Please check the following WARNINGS: 212.xx.xxx.0 - 212.xx.xxx.255 has mnt-lower xxxx attached **************** Could anybody explain this. Regards; ---------------------------------------------------------------------- Abdullah Saad M. Al-Ashry Al Faisaliah Internet Services and Technology Est. (AwalNet) Tel: +966-1-4600111 x 311 Fax: +966-1-4601110

3 2

Is this normal behaviour?
by Marco Davids 01 Sep '00

01 Sep '00

Hello, A routine check on as-macro AS-EURONET on the RIPE-database returned an unexpected result. The same check on the RADB whoisd (whois.raddb.net) however, returned the expected result together with two unexpected ones. Investigation learned us that someone deleted an unprotected as-macro on the RIPE-database. It seems it is fixed now. But what I would like to know is to what extend the several whois databases a synchronised, in other words; how reliable is the information retrieved from it? And... is the as-set object supposed to be unique or not? -- Marco Davids / SARA - Academic Computing Services Amsterdam Today's tip: ftp://ftp.ripe.net/rfc/rfc1925.txt

3 2

Near Real-Time Mirroring in the RIPE database v3.0
by Andrei Robachevsky 01 Sep '00

01 Sep '00

Dear Colleagues, Please find below the next in the series of documents concerning the new database software (v3.0). Now it is about near real-time mirroring. We will appreciate your comments and suggestions, Best regards, Andrei Robachevsky DB Group Manager RIPE NCC Near Real-Time Mirroring in the RIPE database v3.0 ================================================== 1. Near Real Time Mirroring (NRTM) server listens on a separate port (different from usual whoisd port - 43). 2. The following queries are supported by NRTM server: -q sources List all available sources. The format of the output is: <source>:<NRTM protocol version>:<mirroring>:<first>-<last> Where <source> - is the string that identifies the Database (e.g. RIPE) <NRTM protocol version> identifies the version of mirroring protocol. <mirroring> can take one of the following values: Y/N/X - can mirror/cannot mirror/obscured <first> is the lowest serial number available <last> is the most recent serial number available The following semantics apply: Y:<first>-<last> mirroring allowed, serials from range <first>-<last> available N:<first>-<last> mirroring not allowed for administrative reasons. Ask Database Administration for permission. N:0-<last> mirroring physically not possible (e.g. static snapshot of serial <last>) X:<msg> no mirroring allowed. An explanation is given in <msg>. -g <source>:<NRTM protocol version>:<first>-<last> Where <source> - is the string that identifies the Database (e.g. RIPE) <NRTM protocol version> identifies the version of mirroring protocol (currently 1). <first> is the lowest serial number requested . <last> is the most recent serial number requested or the keyword LAST which tells the server to send all updates upto the most recent serial number available at the time of the query. 3. The following errors may occur when querying NRTM server. %ERROR:1: Syntax error: <input> The format of the query is incorrect. %ERROR:2: Invalid range: Not within <first>-<last> This happens when the requested range or part of it is outside the serial numbers available at the server. <first> is the lowest serial number available <last> is the most recent serial number available. %ERROR:3: You are not authorized to mirror the database For more information one may use -q sources query. %ERROR:4: Unknown source The Database identified by the <source> is not served by the server. Use -q sources for a list of available sources.

1 0

Re: ripe-db question
by Brent_Frere＠ses-astra.com 31 Aug '00

31 Aug '00

We (SES, Societe Europeene des Satellites, operator of Astra satellite system) assign IP addresses to end-customers who are using our Internet access by satellite. The only geographic limit we are sure about them is that they are in the Astra satellite system footprint... Footprint is visible at http://www.ses-astra.com/multimedia/bbi So I think this might slighly change your statistics if you count all them as Luxembourg citizens... Brent Frere, SES (Astra) Chateau de Bezdorf L-6815 Betzdorf Grand-Duchy of Luxembourg General phone: +352-710.725-1 Direct phone: +352-710.725-401 E-mail: bfrere(a)ses-astra.com URL: http://www.ses-astra.com "mediaWays Hostmaster" To: lir-wg(a)ripe.net, db-wg(a)ripe.net <hostmaster@medi cc: aways.net> Subject: ripe-db question Sent by: owner-lir-wg@rip e.net 08/30/00 05:23 PM Hi, some strange question: we need a complete list of assigned IP-Addresses in the european part of ripe region sort by country for a customer. Is there any chance to get it per whois/some application or do we buy some part of whois-db from ripe? The background is that a Online-Service needs this part of information to display the right website (on his top-level Webserver wich are reached by every online user first) for every user by his language. We are grateful for each assistance. Kind regards, _____________________________ Stephan Mankopf Networks/Backbone +49 5241 80 88729 stephan.mankopf(a)mediaways.net

1 0