March 2006 - db-help - mailman.ripe.net

How to obtain country codes?
by bendt/sea-point 27 Mar '06

27 Mar '06

Dear Sirs, I would like to develop an internet site for visitors in different countries. In order to present the right language and the right currency to the persons visiting my website I would like to know in which country my visitor lives in. I know how to obtain the visitors ip address. Can I get the wanted country information somehow using the ip address? I am interested even if it includes payment of a fee. Hoping for your kind reply, Best regards, Bendt Schalman sea-point marine equipment as/ marineworld Stat-Ene-Vej 68, Tietgenbyen, Dk-5220 Odense SO - Denmark tlf.: +45 6612 5500 - fax.: +45 6612 5548 mail: <mailto:bendt@sea-point.dk> <mailto:bendt@sea-point.dk> bendt(a)sea-point.dk <mailto:bendt@sea-point.dk> web.: www.sea-point.dk <http://www.sea-point.dk/> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> _____ Jeg beskyttes af den gratis SPAMfighter til privatbrugere. Den har indtil videre sparet mig for at få 1113 spam-mails Betalende brugere får ikke denne besked i deres e-mails. Hent en gratis SPAMfighter her <http://www.spamfighter.com/Lang_DA/Product_Info.asp> . -- Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.2.2/280 - Release Date: 13-03-2006

2 1

Re: inetnums, country origin issues
by Trudy Prins 14 Mar '06

14 Mar '06

Hi Mark, Well, I'm glad this is sorted out now :) Let me know if you have any more questions, Cheers, -- Trudy Prins RIPE NCC Mark Tohill wrote: >Trudy, > >Thanks for your reply! > >IT turns out our problem is we have been allocated our space, but it has >not been assigned, as yet, hence the RIPE Maintainer. I assumed it had >been assigned :( > >I'll have to put in PA Assignment requests first, then hopefully I'll be >able to create separate inetnums, with appropriate differing country >codes. > >It's all beginning to make sense now.... > >Thanks again, >Mark. > >inetnum: 194.46.0.0 - 194.46.255.255 >org: ORG-UTVI1-RIPE >netname: UK-GENESIS-940228 >descr: UTV Internet >country: GB >admin-c: CS667-RIPE >tech-c: CS667-RIPE >status: ***ALLOCATED*** PA >mnt-by: RIPE-NCC-HM-MNT >mnt-lower: AS2873-MNT >mnt-routes: AS2873-MNT >mnt-domains: AS2873-MNT >source: RIPE # Filtered > > > > >-----Original Message----- >From: Trudy Prins [mailto:trudy@ripe.net] >Sent: 13 March 2006 10:58 >To: Mark Tohill >Subject: Re: [sed] inetnums, country origin issues > >Mark Tohill wrote: > > > >>Hi, >> >>I'm new to list so please be patient. >> >>I saw a thread dating back to 2003 titled "Change of country enties in >>the database" and have an issue with country codes. >> >>We are in an ISP which serves users in both Northern Ireland and the >>Republic of Ireland. Our main inetnum /16 has a country code of GB. >> >>It seems some of our RoI customers suffer from this regarding >>redirection of search engines etc. >> >>We do have a some degree of address consolidation for PoP's in both >>countries. >> >>Should we have separate inetnum's for these PoP's and get rid of the >> >> >/16? > > >>What is the best way to handle this? >> >>Any help appreciated. >> >>Mark >> >> >> >Hello Mark, > >Well, you could put several Country codes in a separate <country: > >attribute. >As you can see, it is 'multiple': > >whois -t inetnum > >inetnum: [mandatory] [single] [primary/look-up key] >netname: [mandatory] [single] [lookup key] >descr: [mandatory] [multiple] [ ] >country: [mandatory] [multiple] [ ] >org: [optional] [single] [inverse key] >admin-c: [mandatory] [multiple] [inverse key] >tech-c: [mandatory] [multiple] [inverse key] >rev-srv: [optional] [multiple] [inverse key] >status: [mandatory] [single] [ ] >remarks: [optional] [multiple] [ ] >notify: [optional] [multiple] [inverse key] >mnt-by: [mandatory] [multiple] [inverse key] >mnt-lower: [optional] [multiple] [inverse key] >mnt-domains: [optional] [multiple] [inverse key] >mnt-routes: [optional] [multiple] [inverse key] >mnt-irt: [optional] [multiple] [inverse key] >changed: [mandatory] [multiple] [ ] >source: [mandatory] [single] [ ] > >You can also make several 'Assignments' under your /16 Allocation, to >different organisations, >with different Country codes. > >Does this answer your question somewhat? > >Regards, > >Trudy Prins >RIPE NCC > > > > -- Trudy

1 0

[Re: [sed] inetnums, country origin issues]
by Trudy Prins 13 Mar '06

13 Mar '06

Mark Tohill wrote: > Hi, > > I’m new to list so please be patient. > > I saw a thread dating back to 2003 titled “Change of country enties in > the database” and have an issue with country codes. > > We are in an ISP which serves users in both Northern Ireland and the > Republic of Ireland. Our main inetnum /16 has a country code of GB. > > It seems some of our RoI customers suffer from this regarding > redirection of search engines etc. > > We do have a some degree of address consolidation for PoP’s in both > countries. > > Should we have separate inetnum’s for these PoP’s and get rid of the /16? > > What is the best way to handle this? > > Any help appreciated. > > Mark > Hello Mark, Well, you could put several Country codes in a separate <country: > attribute. As you can see, it is 'multiple': whois -t inetnum inetnum: [mandatory] [single] [primary/look-up key] netname: [mandatory] [single] [lookup key] descr: [mandatory] [multiple] [ ] country: [mandatory] [multiple] [ ] org: [optional] [single] [inverse key] admin-c: [mandatory] [multiple] [inverse key] tech-c: [mandatory] [multiple] [inverse key] rev-srv: [optional] [multiple] [inverse key] status: [mandatory] [single] [ ] remarks: [optional] [multiple] [ ] notify: [optional] [multiple] [inverse key] mnt-by: [mandatory] [multiple] [inverse key] mnt-lower: [optional] [multiple] [inverse key] mnt-domains: [optional] [multiple] [inverse key] mnt-routes: [optional] [multiple] [inverse key] mnt-irt: [optional] [multiple] [inverse key] changed: [mandatory] [multiple] [ ] source: [mandatory] [single] [ ] You can also make several 'Assignments' under your /16 Allocation, to different organisations, with different Country codes. Does this answer your question somewhat? Regards, Trudy Prins RIPE NCC

1 0

automatic queries
by Herbert M. Harrell 13 Mar '06

13 Mar '06

We would like our server to be able to query Ripe automatically to obtain the name of the owner of an IP address. Such a query would occur whenever our server receives an http request from an unknown remote address. We would program the function in Java. Could you point me to a place in your documentation that will show us how to use the Ripe database in this way? Thank you very much. Herb Harrell Herbert M. Harrell Harrell Associates Inc Alexandria, Virginia +44 20 7870 2632

2 1

inetnums, country origin issues
by Mark Tohill 09 Mar '06

09 Mar '06

Hi, I'm new to list so please be patient. I saw a thread dating back to 2003 titled "Change of country enties in the database" and have an issue with country codes. We are in an ISP which serves users in both Northern Ireland and the Republic of Ireland. Our main inetnum /16 has a country code of GB. It seems some of our RoI customers suffer from this regarding redirection of search engines etc. We do have a some degree of address consolidation for PoP's in both countries. Should we have separate inetnum's for these PoP's and get rid of the /16? What is the best way to handle this? Any help appreciated. Mark

1 0

WHOIS changes
by Dr. Marie-Luise Hansen 04 Mar '06

04 Mar '06

Hallo, I tried to trace back some suspicous adresses - but This is what I got from the WHOIS request: % This is the RIPE Whois query server #2. % The objects are in RPSL format. % % Note: the default output of the RIPE Whois server % is changed. Your tools may need to be adjusted. See % http://www.ripe.net/db/news/abuse-proposal-20050331.html % for more details. % % Rights restricted by copyright. % See http://www.ripe.net/db/copyright.html following the information, I got this: "These changes alter the default output of the Whois server. If you need the old output, you can get it by using the "-B" and "-G" flags, like this: whois -B -G 193.0.1.17:" But how and where do I change the settings? best regards, Marie-Luise Hansen

1 0

FAQ table of contents
by DB Role Account 01 Mar '06

01 Mar '06

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