ASN database files from LACNIC or AFRINIC?
Hello, I am currently looking for ASN databases from LACNIC and AFRINIC the same way they are provided at ftp://ftp.arin.net/pub/rr/arin.db ftp://ftp.ripe.net/ripe/dbase/ripe.db.gz ftp://ftp.apnic.net/apnic/whois-data/APNIC/apnic.RPSL.db.gz I've traversed their respective ftp.[lacnic|afrinic].net servers to no avail. I would appreciate any hints where to download this data if it exists. NB: we do know that looking up from a dowloaded file might not be up-to-date anymore the older the file gets. However, the application usually does more lookups than the online queries permit us to do. We will keep this updated asynchronously. Thanks, andreas -- Andreas Ott andreas@naund.org
ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-latest has IP space and ASN allocations. ASN lines look like this: lacnic|MX|asn|278|1|19890331|allocated lacnic|AR|asn|676|1|19900523|allocated lacnic|BR|asn|1251|1|19910405|allocated lacnic|MX|asn|1292|1|19910524|allocated They mirror similar information from other RIRs: ftp://ftp.lacnic.net/pub/stats/afrinic/delegated-afrinic-latest ftp://ftp.lacnic.net/pub/stats/arin/delegated-arin-latest My guess is the other RIRs mirror LACNIC's info as well... and it would be nice to have an all merged delegated-latest, wouldn't it ? I'll try to find one, or ask LACNIC folks if they can do one. Rubens On 10/28/05, Andreas Ott <andreas@naund.org> wrote:
Hello,
I am currently looking for ASN databases from LACNIC and AFRINIC the same way they are provided at
ftp://ftp.arin.net/pub/rr/arin.db ftp://ftp.ripe.net/ripe/dbase/ripe.db.gz ftp://ftp.apnic.net/apnic/whois-data/APNIC/apnic.RPSL.db.gz
I've traversed their respective ftp.[lacnic|afrinic].net servers to no avail. I would appreciate any hints where to download this data if it exists.
NB: we do know that looking up from a dowloaded file might not be up-to-date anymore the older the file gets. However, the application usually does more lookups than the online queries permit us to do. We will keep this updated asynchronously.
Thanks, andreas -- Andreas Ott andreas@naund.org
Hi, On Sat, Oct 29, 2005 at 01:30:23AM -0200, Rubens Kuhl Jr. wrote:
ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-latest has IP space and ASN allocations. ASN lines look like this:
lacnic|MX|asn|278|1|19890331|allocated ...
I found that one, but this is less helpful for what I need. I'd like to get a db record that has the AS number and the AS name. You know, for pretty printing things to screen in reports I was asked to name things with a name and not a number. If they instead had lacnic|MX|asn|278|1|19890331|EXAMPLE-CORPORATION that would be great and I could adjust the parser. Well, we might have to settle for telling in which country the AS is allocated. -andreas -- Andreas Ott andreas@naund.org
You could take every asn out of the delegated list, and query whois.lacnic.net for each one... just rate-limit the queries (1/min is ok, I think) and after a few hours you'll have pairs like this: aut-num: AS1251 owner: Fundacao de Amparo a Pesquisa do Estado de Sao Pau But I guess that was already your plan B... Rubens On 10/29/05, Andreas Ott <andreas@naund.org> wrote:
Hi, On Sat, Oct 29, 2005 at 01:30:23AM -0200, Rubens Kuhl Jr. wrote:
ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-latest has IP space and ASN allocations. ASN lines look like this:
lacnic|MX|asn|278|1|19890331|allocated ...
I found that one, but this is less helpful for what I need. I'd like to get a db record that has the AS number and the AS name. You know, for pretty printing things to screen in reports I was asked to name things with a name and not a number.
If they instead had lacnic|MX|asn|278|1|19890331|EXAMPLE-CORPORATION that would be great and I could adjust the parser. Well, we might have to settle for telling in which country the AS is allocated.
-andreas -- Andreas Ott andreas@naund.org
On Fri, 28 Oct 2005, Andreas Ott wrote:
Hi, On Sat, Oct 29, 2005 at 01:30:23AM -0200, Rubens Kuhl Jr. wrote:
ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-latest has IP space and ASN allocations. ASN lines look like this:
lacnic|MX|asn|278|1|19890331|allocated ...
I found that one, but this is less helpful for what I need. I'd like to get a db record that has the AS number and the AS name. You know, for pretty printing things to screen in reports I was asked to name things with a name and not a number.
LACNIC makes their data available through bulk-whois. But unlike ARIN and other RIRs their bulk whois data is limited and not as useful because it does not include address & contact information and just organization & network names and resources (basically just what you asked for above!). Unfortunately using this bulk data to generate publicly available list of the resources names would actually violate their service agreement. I'm however investigating possibility of doing single whois queries and then generating full list from these results updated once per day as needed (partially triggered on if net block/asn date has changed based on bulk whois which I think would not violate agreement). With AFRINIC you're out of luck except by doing single queries (and redoing every so often to catch any potential changes) as they still have no bulk whois policy. -- William Leibzon Elan Networks william@elan.net
For LACNIC the database is available under terms of a specific research-use agreement with LACNIC I am unsure if the Afrinic data is being made available regards, Geoff At 10:07 AM 29/10/2005, Andreas Ott wrote:
Hello,
I am currently looking for ASN databases from LACNIC and AFRINIC the same way they are provided at
ftp://ftp.arin.net/pub/rr/arin.db ftp://ftp.ripe.net/ripe/dbase/ripe.db.gz ftp://ftp.apnic.net/apnic/whois-data/APNIC/apnic.RPSL.db.gz
I've traversed their respective ftp.[lacnic|afrinic].net servers to no avail. I would appreciate any hints where to download this data if it exists.
NB: we do know that looking up from a dowloaded file might not be up-to-date anymore the older the file gets. However, the application usually does more lookups than the online queries permit us to do. We will keep this updated asynchronously.
Thanks, andreas -- Andreas Ott andreas@naund.org
participants (4)
-
Andreas Ott -
Geoff Huston -
Rubens Kuhl Jr. -
william(at)elan.net