- db-help - mailman.ripe.net

Access Limit
by Nicolas Raux 06 Dec '04

06 Dec '04

Hi, where could we set the maximum of queries that a client identified by his IP address could do on a ripe-dbase ? Is there a way to build a kind of IP whitelist ? Thanks by advanced, N. RAUX

2 1

RIPE.DB import issue
by Nicolas Raux 02 Dec '04

02 Dec '04

Hi, I am trying to import the last ripe.db in the 3.2.0 version of the ripe-db. But I get an issue which crashes the import process. I have read Engin Gunduz's answer concerning this fact : /"... In fact, there are more things in the text dump that the release 3.2.0 does not handle (like organisation object) so it would be difficult to load the current text dumps using release 3.2.0. ..." /I would like to know if there is a way to import (with some kind of batch that could remove unsupported informations like organisation object) this base or an older one ? Thanks by advanced, N. RAUX ************************************************************ The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email in error please notify the system manager or the sender immediately and do not disclose the contents to anyone or make copies. * email scanned for viruses, vandals and malicious content * ************************************************************

1 0

FAQ table of contents
by DB Role Account 01 Dec '04

01 Dec '04

FREQUENTLY ASKED QUESTIONS ABOUT THE RIPE DATABASE ================================================== The answer to these questions can be found at the RIPE website: http://www.ripe.net/info/faq/db/main.html http://www.ripe.net/info/faq/db/security.html http://www.ripe.net/info/faq/db/lir-partitioned.html http://www.ripe.net/info/faq/db/abuse.html RIPE Whois Database FAQ http://www.ripe.net/info/faq/db/main.html 1. What is the RIPE Database? 2. What is acceptable use of the RIPE Database? 3. What is a netname? 4. What is a nic-hdl? 5. Can I use a nic-handle from another Regional Internet Registry in the RIPE Database? 6. What is a tech-c and what is an admin-c? 7. Can I register a domain in the RIPE Database? 8. How do I register a person/role object in the RIPE Database ? 9. Someone has created a person object with my name, address, telephone number, etc. in the RIPE Database. Why did they do this? 10. My information in the database is not correct, can you please update my object(s)? 11. How do I delete an object from the RIPE Database? 12. My update failed. Please explain why it failed. 13. What are the authorisation rules for route object creation? 14. Which date should be used as "changed-date" in a whois database-object? 15. I received a message with the subject "Notification of RIPE Database changes", but I didn't do anything and don't understand the message. What is it? 16. Why does my phone number appear in the RIPE Database? 17. Can I download the RIPE Database software? 18. Can I download the RIPE Database? 19. I cannot find any information about a network in the RIPE Database. Can I look somewhere else? 20. When one uses the RIPE NCC whois client, is it necessary to specify"-h whois.ripe.net" or is that pre-set by default? 21. How do I register reverse-delegations in the RIPE Database? 22. I want to have an IP->country conversion table; from where can I get it? 23. I want to peer with an AS. How do I do this? 24. Can I enter several contacts in one Database object? 25. How do I update an object in the RIPE Whois Database? 26. I cannot create a route object because the origin AS refers to an aut-num object that does not exist 27. Is the "changed" line updated automtically? 28. Can I use a nic-handle from another database? 29. Where can I find more information about the RIPE Whois Database? RIPE Whois Database Security FAQ http://www.ripe.net/info/faq/db/security.html 1. I have objects in the RIPE Whois Database. How can I protect them ? 2. How do I create a maintainer (mntner) object in the RIPE Whois Database ? 3. I have only one person object in the RIPE Whois Database. Can I create a mntner object to protect it? 4. We lost the password of our mntner. Can you please change it to xxxx? 5. My mntner password does not work. Why not ? 6. How can I encrypt a password for my mntner using CRYPT-PW? 7. What encryption algorithm should be used for the crypted password in the "auth:" attribute of a mntner object ? 8. How to use the MD5-PW auth scheme in my mntner ? 9. Why is the crypted-password published in the RIPE Whois Database ? Why not keep it secret ? 10. What software do I need to use PGP? 11. How can I use PGP with my mail software? 12. Getting started with PGP in RIPE Whois Database 13. What is a key-cert object, and how can I create it? 14. How should I modify my maintainer to use PGP? 15. How can I sign my update with PGP and send it? 16. How can I put two or more signatures in a message? 17. Can I create a maintainer with only PGP authentication? 18. What is the size of PGP key that can be used in a key-cert object in the RIPE Whois Database? LIR-PARTITIONED: The New "Status:" Attribute Value FAQ http://www.ripe.net/info/faq/db/lir-partitioned.html 1. What is "LIR-PARTITIONED"? 2. When would the LIR-PARTITIONED "status:" value be used? 3. How is such an object created in the RIPE Whois Database? 4. How can I protect an LIR-PARTITIONED object? 5. Do I have to seek approval from the RIPE NCC before entering an LIR-PARTITIONED object into the RIPE Whois Database? 6. Can I request reverse delegation for an LIR-PARTITIONED inetnum object? 7. Can I use the LIR-PARTITIONED "status:" value in an inet6num object?

1 0

Error!
by raghu.d＠tcs.com 24 Nov '04

24 Nov '04

Hi, i am creating a new object into RIPE Test database authenticated by a PGP signature. but the update is FAILING with the following error. Can you please let me know why this is happenning! ***Error: The following PGP credentials were not correct: 48317D6B ***Error: Authorisation failed ***Info: Syntax check passed Thanks! Raghu Divi Tata Consultancy Services Limited Plot B-1Sector 5, Salt Lake Electronics Complex, Kolkata - 700 091,West Bengal India Mailto: raghu.d(a)tcs.com Website: http://www.tcs.com DISCLAIMER: The information contained in this message is intended only and solely for the addressed individual or entity indicated in this message and for the exclusive use of the said addressed individual or entity indicated in this message (or responsible for delivery of the message to such person) and may contain legally privileged and confidential information belonging to Tata Consultancy Services Limited. It must not be printed, read, copied, disclosed, forwarded, distributed or used (in whatsoever manner) by any person other than the addressee. Unauthorized use, disclosure or copying is strictly prohibited and may constitute unlawful act and can possibly attract legal action, civil and/or criminal. The contents of this message need not necessarily reflect or endorse the views of Tata Consultancy Services limited on any subject matter. Any action taken or omitted to be taken based on this message is entirely at your risk and neither the originator of this message nor Tata Consultancy Services Limited takes any responsibility or liability towards the same. Opinions, conclusions and any other information contained in this message that do not relate to the official business of Tata Consultancy Services limited shall be understood as neither given nor endorsed by Tata Consultancy Services Limited or any affiliate of Tata Consultancy Services Limited. If you have received this message in error, you should destroy this message and may please notify the sender by e-mail. Thank you.

1 0

working with WHOIS?
by Наумов Дмитрий 22 Nov '04

22 Nov '04

Hi. Sorry for my bad english I'm writing a subprogram which mast ressive information about internet host (from IP). This server return needed information from internet form. I have to connect with your server over WhoIs service. Connection success (i think . Server whois.ripe.net, port 43. Server retuns "This is the RIPE Whois tertiary server. % The objects are in RPSL format. % % Rights restricted by copyright. % See http://www.ripe.net/db/copyright.html"") How can i ressive information about server from it' s IP? (if i connect to whois.ripe.net) Can i ressive not all available information abot host. Moust of all i'm interested in location of this host (city), organization and contact information, such as phone and e-mail). Dmitry A. Naumov.

1 0

problem importing ripe dbase
by Xiao Tencas 18 Nov '04

18 Nov '04

I've been trying to install the ripe database (v.3.2.0) for personal use. When I start loading the ripe object file, everything seems to go smooth. However, after a while I get this segmentation fault: [0] 0.03s OK [aut-num:AS20871][U:ADD] 0 rows affected [ INSERT mnt_routes SELECT 0, 19812, mntner.object_id, 2 FROM mntner WHERE mntner.mntner='Shokofa-MNT' ] died: +1411 ud_core.c ./load_all.sh: line 1: 29813 Broken pipe cat ./load_all.sh: line 72: 29810 Broken pipe ${UNZIP1} ${object_file} 29811 Done(141) | eval ${FILTER} 29812 Segmentation fault | $LOADER -L $1 -p ${PROPERTIES} -s ${SOURCE} *** ERROR: Loader failure [139]. Exiting\n ************** ERROR *************** *** 11:34:31 Error loading database=RIPEDB for source=RIPE, ./make_db exiting ************************************ Any help would be much appreciated -- NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl GMX DSL-Netzanschluss + Tarif zum superg�nstigen Komplett-Preis!

2 1

nic-hdl: PA1939-RIPE
by Подворко Александр 16 Nov '04

16 Nov '04

Good day, I want to change information for following object: inetnum: 82.147.64.0 - 82.147.95.255 But i don't know Authorisation for org: ORG-Tc5-RIPE and mnt-by: RIPE-NCC-HM-MNT. How i may change information and how get to know Authorisation password. Regid: ru.sibtel.ru NIC-HDL: PA1939-RIPE Best regards, Podworko Alexander

2 1

RE: help on maintainer object
by Koepp, Karsten 11 Nov '04

11 Nov '04

Hello Andreas, I am reading this by accident. Seems, you have already done your job. You should be able to simply delete the old maintainer yourself, as there is no object refering to the old mnt: 11/11/04 10:47:06 whois -imb sczn-db-mnt(a)whois.ripe.net whois -h whois.ripe.net -imb sczn-db-mnt ... % This is the RIPE Whois tertiary server. % The objects are in RPSL format. % % Rights restricted by copyright. % See http://www.ripe.net/db/copyright.html mntner: sczn-db-mnt descr: maintainer for all sczn objects admin-c: AS3037-RIPE admin-c: TW975-RIPE upd-to: lir(a)sczn.de auth: md5-pw $1$3f6QLMHH$LsJhKz6dET9u85AdqBSqt/ notify: lir(a)sczn.de mnt-by: sczn-db-mnt referral-by: RIPE-DBM-MNT changed: hostmaster(a)ripe.net 20040616 source: RIPE I guess, you will have to do this in two steps, first change the mnt of the old object, then delete it. regards Karsten > -----Original Message----- > From: andreas_s [mailto:lir@sczn.de] > Sent: Wednesday, November 10, 2004 6:49 PM > To: db-help(a)ripe.net > Subject: help on maintainer object > > > dear colleagues, > on this time, in the ripe-db are the following maintainer > objects present: > > old --> > > mntner: sczn-db-mnt > descr: maintainer for all sczn objects > admin-c: AS3037-RIPE > admin-c: TW975-RIPE > upd-to: lir(a)sczn.de > auth: md5-pw $1$3f6QLMHH$LsJhKz6dET9u85AdqBSqt/ > notify: lir(a)sczn.de > mnt-by: sczn-db-mnt > referral-by: RIPE-DBM-MNT > changed: hostmaster(a)ripe.net 20040616 > source: RIPE > > > new --> > > mntner: SCZN-MNT > descr: Maintainer for all SCZN objects > admin-c: AS3037-RIPE > admin-c: TW975-RIPE > upd-to: lir(a)sczn.de > auth: md5-pw $1$3f6QLMHH$LsJhKz6dET9u85AdqBSqt/ > notify: lir(a)sczn.de > mnt-by: SCZN-MNT > referral-by: RIPE-DBM-MNT > changed: hostmaster(a)ripe.net 20040616 > source: RIPE > > > ... sorry that i have created two mnt objects. i had intended > that i can > update the old mnt object. > > can you change please all objects with "sczn-db-mnt" links to > SCZN-MNT. > > after this, can you delete please the old mnt object sczn-db-mnt from > the ripe-db. > > many thanks and sorry for my mistake. > > > kind regards, > > andreas schneider > de.sczn lir staff > > +49 431 7171 5152 >

4 3

help on maintainer object
by andreas_s 10 Nov '04

10 Nov '04

dear colleagues, on this time, in the ripe-db are the following maintainer objects present: old --> mntner: sczn-db-mnt descr: maintainer for all sczn objects admin-c: AS3037-RIPE admin-c: TW975-RIPE upd-to: lir(a)sczn.de auth: md5-pw $1$3f6QLMHH$LsJhKz6dET9u85AdqBSqt/ notify: lir(a)sczn.de mnt-by: sczn-db-mnt referral-by: RIPE-DBM-MNT changed: hostmaster(a)ripe.net 20040616 source: RIPE new --> mntner: SCZN-MNT descr: Maintainer for all SCZN objects admin-c: AS3037-RIPE admin-c: TW975-RIPE upd-to: lir(a)sczn.de auth: md5-pw $1$3f6QLMHH$LsJhKz6dET9u85AdqBSqt/ notify: lir(a)sczn.de mnt-by: SCZN-MNT referral-by: RIPE-DBM-MNT changed: hostmaster(a)ripe.net 20040616 source: RIPE ... sorry that i have created two mnt objects. i had intended that i can update the old mnt object. can you change please all objects with "sczn-db-mnt" links to SCZN-MNT. after this, can you delete please the old mnt object sczn-db-mnt from the ripe-db. many thanks and sorry for my mistake. kind regards, andreas schneider de.sczn lir staff +49 431 7171 5152

1 0

FAQ table of contents
by DB Role Account 01 Nov '04

01 Nov '04

FREQUENTLY ASKED QUESTIONS ABOUT THE RIPE DATABASE ================================================== The answer to these questions can be found at the RIPE website: http://www.ripe.net/ripencc/faq/database GENERAL QUESTIONS What is the RIPE Database? Where can I get more information about the RIPE Database? What is acceptable use of the RIPE Database? What is a netname? What is a nic-hdl? What is a tech-c and what is an admin-c? Can I register a domain in the RIPE Database? Can I enter several contacts in one database object? Someone has created a person object with my name, address, telephone number, etc. in the RIPE Database. Why did they do this? My information in the database is not correct, can you please update my object(s)? I received a message with the subject "Notification of RIPE Database changes", but I didn't do anything and don't understand the message. What is it? Why does my phone number appear in the RIPE Database??? Can I download the RIPE Database software? Can I download the RIPE Database? Can I gather e-mail addresses or personal information from the RIPE Database to send spam, or other types of commercial messages? HOW TO FIND OBJECTS IN THE RIPE DATABASE I cannot find any information about a network in the RIPE Database. Can I look somewhere else? Can I gather e-mail addresses or personal information from the RIPE Database to send spam, or other types of commercial messages? When one uses the RIPE NCC whois client, is it necessary to specify"-h whois.ripe.net" or is that pre-set by default? HOW TO PUT OBJECTS IN THE RIPE DATABASE (CREATING, UPDATING AND DELETING OBJECTS) How do I register a person/role object in the RIPE Database? How do I update an object in the RIPE Database? What are the authorisation rules for route object creation? I cannot creat a route object because the origin AS refers to an aut-num object that does not exist in the RIPE Database. What should I do? My update failed. Please explain why it failed. Is the "changed" line updated automatically? Can I use a nic-handle from another Regional Internet Registry in the RIPE Database? How do I delete an object from the RIPE Database ? PROTECTING YOUR OBJECTS IN THE RIPE DB I have objects in the RIPE Database. How can I protect them? How do I create a maintainer (mntner) object in the RIPE Database ? I have only one person object in the RIPE Database. Can I create a mntner object to protect it? We lost the password of our mntner. Can you please change it to xxxx? My mntner password does not work. Why not ? How can I encrypt a password for my mntner using CRYPT-PW? What encryption algorithm should be used for the crypted password in the "auth:" attribute of a mntner object ? How to use the MD5-PW auth scheme in my mntner ? Why is the crypted-password published in the RIPE Database ? Why not keep it secret ? What software do I need to use PGP? How can I use PGP with my mail software? Getting started with PGP in RIPE Database What is a key-cert object, and how can I create it? How should I modify my maintainer to use PGP? How can I sign my update with PGP and send it? How can I put two or more signatures in a message? Can I create a maintainer with only PGP authentication? What is the size of PGP key that can be used in a key-cert object in the RIPE Database? ADVANCED USE OF THE RIPE DATABASE How do I register reverse-delegations in the RIPE Database? I want to have an IP->country conversion table; from where can I get it? I want to peer with an AS. How do I do this? LIR-PARTITIONED: THE NEW "STATUS" ATTRIBUTE VALUE What is "LIR-PARTITIONED"? When would the LIR-PARTITIONED "status:" value be used? How is such an object created in the RIPE Database? How can I protect an LIR-PARTITIONED object? Do I have to seek approval from the RIPE NCC before entering an LIR-PARTITIONED object into the RIPE Database? Can I request reverse delegation for an LIR-PARTITIONED inetnum object? Can I use the LIR-PARTITIONED "status:" value in an inet6num object? SPAM, ABUSE AND THE RIPE DATABASE What is the RIPE NCC Copyright statement? I have evidence that someone is using a computer with the IP address x.x.x.x to send Unsollicited Commercial E-mail (UCE, so-called "spam") or is otherwise acting in an iresponsible manner. Can you stop him? (or how can I stop him?) Can I gather e-mail addresses or personal information from the RIPE Database to send spam, or other types of commercial messages?

1 0