August 2000 - db-wg - mailman.ripe.net

<auto-dbm@ripe.net> is slow this afternoon.
by RIPE Database Administration 16 May '18

16 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

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

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

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

RE: ripe-db question
by Stefan.Gasteiger＠Gendorf.de 30 Aug '00

30 Aug '00

You should use MIME content negotiation for this purpose. Have a look at: http://www.apache.org/docs/mod/mod_mime.html#multipleext Stefan Gasteiger SG5599-RIPE I+K Betrieb (zertifiziert nach DIN EN ISO 9001) InfraServ Gendorf Tel.: +49 8679 7 5599 Fax: +49 8679 7 39 5599 Mobiltel.: +49 172 8649205 E-Mail: Stefan.Gasteiger(a)gendorf.de > -----Original Message----- > From: mediaWays Hostmaster [mailto: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 > > > > >

1 0

Draft Minutes of the DB WG meeting RIPE 36
by Nigel Titley 29 Aug '00

29 Aug '00

Gentlefolk, Here are the draft minutes to the DB WG meeting at RIPE 36, in Budapest. Due to a fit of spring-cleaning, I ended up deleting my notes of the first part of the meeting. Please feel free to fill any gaps and correct any errors. best regards Nigel Draft Minutes for the Database Working Group Meeting RIPE-36, May 2000, Budapest, HU 1. Draft 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. [AP: Joao Damas to produce a presentation for the RIPE 37 meeting] - 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

Whois queries in the RIPE database v3.0
by Andrei Robachevsky 28 Aug '00

28 Aug '00

Dear Colleagues, Please find below an inventory of the query part of the new database software (v3.0). I tried to highlight the differences from the current RIPE Database implementation, but also to explicitly mention some features of the current software that were not documented before. Most of this document is a summary from a more detailed documentation, which is available from http://www/ripencc/pub-services/db/reimp/queries.ps However, some features, like '-d' or '-q sources' flags, are new and we would like to know your opinion and comments on these. Almost all functionality is already implemented, although some minor parts are missing, mainly because we would like to receive your comments first. We will appreciate your comments and suggestions, Best regards, Andrei Robachevsky DB Group Manager RIPE NCC Whois queries in the RIPE database v3.0 ======================================= 1. New queries -------------- -l <ip range> One level less specific. Does NOT return the exact match but only the smallest of the IP ranges that is bigger than the user supplied range and that fully contains it. -x <ip range> Exact match. Returns the inetnum or route object with the ip range matching exactly the user supplied range. If no matching object is found nothing is returned. -K Requests that only primary keys of the objects are to be returned. The exception is a set object, where the members attribute is also returned. -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 (currently 1). <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>. -q version Displays version number of the server software. -d Triggers inclusion of in-addr.arpa and ip6.int domain objects in the result of IP lookup. By default in-addr.arpa and ip6.int domain objects are not included in the output. With -d flag it is possible to have More/less specific lookups for in-addr.arpa and ip6.int domains. Their use is similar to those for IP numbers except that lookups have to be on 8 bit boundaries for IPv4 lookups and 4 bit boundaries for IPv6 lookups. 2. Inverse queries. ------------------ The following inverse queries are supported by v3.0 software: -iac (or -iadmin-c) <nic-handle|name> Returns all objects whose admin-c attribute matches the query argument. -itc (or -itech-c) <nic-handle|name> Returns all objects whose tech-c attribute matches the query argument. -izc (or -izone-c) <nic-handle|name> Returns all objects whose zone-c attribute matches the query argument. -iah (or -iauthor) <nic-handle|name> Returns all objects whose author attribute matches the query argument. -icn (or -icross-nfy) <nic-handle|name> Returns all objects whose cross_nfy attribute matches the query argument. -ipn (or -iperson) <nic-handle|name> Equivalent to -iac,tc,zc,ah,cn (or -iadmin-c,tech-c,zone-c,author,cross-nfy). -iny (or -inotify) <e-mail address> Returns all objects whose notify attribute matches the query argument. -idt (or -iupd-to) <e-mail address> Returns all objects whose upd-to attribute matches the query argument. -imb (or -imnt-by) <maintainer name> Returns all objects whose mnt-by attribute matches the query argument. -iml (or -imnt-lower) <maintainer name> Returns all objects whose mnt-lower attribute matches the query argument. -imr (or -imbrs-by-ref) <maintainer name> Returns all objects whose mbrs-by-ref attribute matches the query argument. -imn (or -imnt-nfy) <e-mail address> Returns all objects whose mnt-nfy attribute matches the query argument. -imu (or -imnt-routes) <maintainer name> Returns all objects whose mnt-routes attribute matches the query argument. -ict (or -icross-mnt) <maintainer name> Returns all objects whose cross-mnt attribute matches the query argument. -ior (or -iorigin) <AS key> Returns all objects whose origin attribute matches the query argument. -ila (or -ilocal-as) <AS key> Returns all objects whose local-as attribute matches the query argument. -imo (or -imember-of) <set name> Returns all objects whose member-of attribute matches the query argument and their claim is validated by mbrs-by-ref attribute of the set. Absence of mbrs-by-ref attribute means that the membership is only defined by the members attribute of the set. -irz (or -irev-srv) <hostname|IP address> Returns all objects whose rev-srv attribute matches the query argument. -ins (or -inserver) <hostname|IP address> Returns all objects whose nserver attribute matches the query argument. -isd (or -isub-dom) <domain name> Returns all objects whose sub-dom attribute matches the query argument. -irb (or -ireferral-by) <maintainer name> Returns all objects whose referral-by attribute matches the query argument. 3. Other differences from v2.x software --------------------------------------- -iro (or -irole) <nic-handle|name> This query is not supported. -k Is accepted without an argument. In this case it just opens a persistent connection to a server. The next -k without argument will close the connection.

1 1

RE: ccTLD data moving from RIPE db
by Wilfried Woeber, UniVie/ACOnet 17 Aug '00

17 Aug '00

[ editorial: I think this should move from lir-wg(a)ripe.net to db-wg(a)ripe.net So, for any follow-up, please use db-wg and remove lir-wg. Thanks. ] Alex, >Then today I got a mail from the .IE domain registry, asking me to remove >entries from the RIPE DB for some .ie domains I have. The RIPE NCC, or the RIPE community never had any authority over the ccTLD name tree in the RIPE-DB. The individual sub-trees were (some still are) managed by the respective TLDs. So, from that point of view, the request in itself is probably valid. > So far so good, >except that the .ie domain registry does not have a functional whois >database to which we can move this data. If I comply, the data will no >longer be accessible from any whois databse. Well, not necessarily so. What "we" (the people and groups involved to migrate the name sub-trees to dedicated registries, maintined by the TLDs) had in mind was to preserve the "single point of entry" for the RIPE region to query domain names. To that end, the DB software was extended to support a referral mechanism. Assuming that this technology is deployed, you could still send your query to whois.ripe.net and the software would try to find a referred-to server which is authoritative for the name-tree. The RIPE server would then forward the request and send the answer back to the client. Quite a few TLD registries, which already have moved away from using the RIPE DataBase have completed that setup. Others are in the process of fixing migration problems. Other, obviously, have decided to _not_ use that option. Sigh. I'm still working with the RIPE NCC's DB group and CENTR to fixing deployment problems related to the referral mechanism. A couple of days ago, a summary page has become available on CENTR's server: http://www.centr.org/technical/ripe-db.html >Is this therefore a valid request? > >Thanks, Best regards Wilfried (DB-WG chair) _________________________________:_____________________________________ 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The strange thing about common sense is that it is so uncommon. Buddah

1 0

RIPE-181 server to be decommissioned
by gerald＠merit.edu 10 Aug '00

10 Aug '00

As many of you know, Merit began a production RPSL service on 11/1/99. RIPE-181 and RPSL coexisted on our production server until 1/1/00; after that date, RIPE-181 updates were no longer accepted and only queries were available on the special RIPE-181 server. Merit will now complete the final stage of its transition to RPSL by decommissioning its RADB RIPE-181 server on Wednesday, August 23, between 5:00-8:00 A.M. EDT. Query activity has been extremely light on the RIPE-181 server and the remaining users have been notified by private email about the termination of this service. This change will not impact our production RPSL service. Please send your questions and comments to db-admin(a)radb.net. IRRd Team --Gerald Winters

1 0