Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[kitz]

Thanks everyone for the comments so far
Keep them coming - I still have a few formatting things to do before it goes live too.

[tickmike]

All worked for me, it will be a useful tool. 

[Astral]

I didn't hit any snags on my first look. I'll have another go. If you hear nothing it's OK.

[kitz]

Thanks guys
- appreciated

[Floydoid]

Yay it now works for me.

(I tried to be as honest as possible without using any expletives)

[roseway]

Just tried it again. It worked perfectly.

[UncleUB]

Just rated again,no problems. 

[guest]

Its just unfortunate that the particular IP that theyve allocated you is showing as belonging to UK-TELINCO and they put down their organisation as TUL3-RIPE . Even the RDNS is showing as dynamic.dsl.as9105.com.  Its a bit hard to resolve something if the ISP doesnt declare who they are :/

But they do - and they do it in the best possible way by listing the Autonomous System number in the rdns.

12/05/07 09:17:36 whois as9105@whois.ripe.net

whois -h whois.ripe.net as9105 ...
% This is the RIPE Whois query server #1.
% The objects are in RPSL format.
%
% Rights restricted by copyright.
% See http://www.ripe.net/db/copyright.html

% Note: This output has been filtered.
%       To receive output for a database update, use the "-B" flag.

% Information related to 'AS8192 - AS9215'

as-block:     AS8192 - AS9215
descr:        RIPE NCC ASN block
remarks:      These AS Numbers are further assigned to network
              operators in the RIPE NCC service region. AS
              assignment policy is documented in:
              <http://www.ripe.net/ripe/docs/asn-assignment.html>
              RIPE NCC members can request AS Numbers using the
              form located at:
              <http://lirportal.ripe.net/lirportal/liruser/resource_request/draw.html?name=as-number>
org:          ORG-NCC1-RIPE
admin-c:      CREW-RIPE
tech-c:       OPS4-RIPE
mnt-by:       RIPE-NCC-HM-MNT
mnt-lower:    RIPE-NCC-HM-MNT
source:       RIPE # Filtered

organisation:   ORG-NCC1-RIPE
org-name:       RIPE NCC
org-type:       RIR
address:        RIPE Network Coordination Centre
address:        P.O. Box 10096
address:        1001 EB Amsterdam
address:        The Netherlands
phone:          +31 20 535 4444
fax-no:         +31 20 535 4445
admin-c:        CREW-RIPE
tech-c:         CREW-RIPE
mnt-ref:        RIPE-NCC-RIS-MNT
mnt-ref:        RIPE-NCC-HM-MNT
mnt-by:         RIPE-NCC-HM-MNT
source:         RIPE # Filtered

role:           RIPE NCC Registration Services Department
address:        RIPE Network Coordination Centre
address:        P.O. Box 10096
address:        1001 EB Amsterdam
address:        the Netherlands
phone:          +31 20 535 4444
fax-no:         +31 20 535 4445
org:            ORG-NCC1-RIPE
admin-c:        AdlH1-RIPE
admin-c:        FdMP2-RIPE
tech-c:         TH2221-RIPE
tech-c:         KL1200-RIPE
tech-c:         TIM4-RIPE
tech-c:         ACM2-RIPE
tech-c:         IW112-RIPE
tech-c:         PINK1-RIPE
tech-c:         XAV
tech-c:         AKA
tech-c:         SD1131-RIPE
tech-c:         SLON-RIPE
tech-c:         ALEX
tech-c:         AM11077-RIPE
tech-c:         DIRK1-RIPE
tech-c:         NT1031-RIPE
tech-c:         AK5348-RIPE
nic-hdl:        CREW-RIPE
abuse-mailbox:  abuse@ripe.net
mnt-by:         RIPE-NCC-HM-MNT
source:         RIPE # Filtered

role:           RIPE NCC Operations
address:        Singel 258
address:        1016 AB Amsterdam
address:        The Netherlands
phone:          +31 20 535 4444
fax-no:         +31 20 535 4445
admin-c:        AMR68-RIPE
admin-c:        BRD-RIPE
tech-c:         GL7321-RIPE
tech-c:         MG241-RIPE
tech-c:         JA47
tech-c:         MENN1-RIPE
tech-c:         EMIL-RIPE
tech-c:         SSIE-RIPE
tech-c:         RCO-RIPE
tech-c:         kk1297-RIPE
tech-c:  DH2398-RIPE
tech-c:         APZ-RIPE
tech-c:  JLOK-RIPE
nic-hdl:        OPS4-RIPE
mnt-by:         RIPE-NCC-MNT
source:         RIPE # Filtered

% Information related to 'AS9105'

aut-num:        AS9105
as-name:        TISCALI-UK
descr:          Tiscali UK
descr:          ISP Network, UK
import:         from AS3257
         action pref=100;
         accept ANY AND NOT {0.0.0.0/0}
import:         from AS5378
         action pref=100;
         accept ANY AND NOT {0.0.0.0/0}
import:         from AS6765
         action pref=100;
         accept ANY AND NOT {0.0.0.0/0}
import:         from AS8372
         action pref=100;
         accept ANY AND NOT {0.0.0.0/0}
import:         from AS8553
         action pref=100;
         accept AS-GEMSOFT AND NOT {0.0.0.0/0}
import:         from AS8575
         action pref=100;
         accept AS-WINWEB AND NOT {0.0.0.0/0}
import:         from AS12519
         action pref=100;
         accept AS12519 AND NOT {0.0.0.0/0}
import:         from AS12707
         action pref=100;
         accept AS12707 AND NOT {0.0.0.0/0}
import:         from AS12295
         action pref=100;
         accept AS12295 AND NOT {0.0.0.0/0}
import:         from AS21099
         action pref=100;
         accept AS21099 AND NOT {0.0.0.0/0}
import:         from AS28861
         action pref=100;
         accept AS28861 AND NOT {0.0.0.0/0}
import:         from AS35716
         action pref=100;
         accept AS35716 AND NOT {0.0.0.0/0}
export:         to AS3257
         announce AS-TISCALIUK
export:         to AS5378
         announce AS-TISCALIUK
export:         to AS6765
         announce AS-TISCALIUK
export:         to AS8372
         announce AS-TISCALIUK
export:         to AS8553
         announce ANY
export:         to AS8575
         announce ANY
export:         to AS12519
         announce ANY
export:         to AS12707
         announce ANY
export:         to AS12295
         announce AS9105
export:         to AS21099
         announce AS-TISCALIUK
export:         to AS28861
         announce AS-TISCALIUK
export:         to AS35716
         announce AS-TISCALIUK
default:        to AS3257
        action pref=100;
        networks ANY
admin-c:        TU935-RIPE
tech-c:         TU935-RIPE
mnt-by:         TU935-RIPE-MNT
source:         RIPE # Filtered

role:           Tiscali UK
address:        Tiscali UK Limited
address:        20 Broadwick Street
address:        London W1F 8HT
phone:          +44 207 087 2000
remarks:        Information: http://www.tiscali.com
org:            ORG-TUL3-RIPE
admin-c:        DC-RIPE
admin-c:        GD9105-RIPE
tech-c:         DC-RIPE
nic-hdl:        TU935-RIPE
remarks:        Hostmaster Role Account
mnt-by:         TU935-RIPE-MNT
source:         RIPE # Filtered
abuse-mailbox:  abuse@uk.tiscali.com

Or did you not know you could do a whois on an AS number?

I assume you know about ftp.ripe.net?

If not then go have a browse around as you might find things like ftp://ftp.ripe.net/ripe/stats/delegated-ripencc-20071203 useful If nothing else it'll be a damn sight quicker than querying the whois system

[guest]

It can't find my ISP so you have some of the UKO/Sky ranges missing I assume?

[kitz]

It can't find my ISP so you have some of the UKO/Sky ranges missing I assume?

Thats my fault -  I was using EASYNET-CONSUMER-DSL when (with hindsite) I should have perhaps used EASYNET-CONSUMER-DSL% in my code.
- Amended.

Thanks for the list - not sure how I can import that yet - need to think ........ 

chriiiiiiiiiiiiiiiis ? 

[guest]

Would you mind if I suggested what you should do - tough if you don't You probably won't like it but it is the best way

First of all go to ftp://ftp.ripe.net/ripe/dbase/split where manageable sized database files exist. Download everything. There is a huge db one directory up but given it decompresses to just over 1GB I'd use the smaller ones

Then compile a list/db/whatever of AS Number -> ISP. This is the ONLY way to retain your sanity in future The reason is that AS numbers are used for routing so nobody goes changing them on a regular basis (if ever). You'll find some AS numbers cease being used as big ISPs gobble up little ISPs but in general all you'd need to do is download the RIPE monthly db and run a check to see if anything has altered. The Tiscali example earlier shows some of the AS numbers they've gobbled up.

So you have your AS number -> ISP sorted with perhaps a monthly run of a script to ensure all is well. Edit - depending on what you're using for the backend you might just be able to do a simple replacement of the database if yours is compatible with the RIPE db formats.

This means that all you have to do is take the RIPE IP->AS data on a monthly basis and replace the previous months data. That will give you the ability to link an IP address to any European ISP/LIR.

I suspect this might mean a major rethink/redesign

* rizla runs away

[guest]

One problem with this approach might be the vISPs but I assume you've worked out how to "detect" them?

[kitz]

Just to let you know whats happening on this and it hasnt been ignored.

Thanks for the comments rizla

I have found a way to pull in the AS number - but tying up that up with the ISP needs a heck of a lot more work.
Those databases are huge so the first step is pulling out all the GB ones.  It will then be a matter of compiling a cross ref - in a similar way to which I already have with the netname -> ISP.
Although some things look immediately obvious to the human eye - computers wont tie something up unless its an exact match. :/

lol know I know why the likes of TBB rely on the ISPs to inform them of their ranges.

All this stuff is backend - so wont make any difference to the front end stuff. Everything is modularised so if I am able to do it differently then its simply a case of replacing one section.   
Bear in mind that I haven't been programming in php that long and therefore Im hoping that I can discuss some of the options this w/e with chris if he has a bit of free time..  to see what can be done

So comments etc are still appreciated on the user side of things etc - whilst I see if the backend stuff can be changed.

[kitz]

a lil update on this..  for the time being Im leaving the original interface up whilst all the backend stuff is being re-done.  With a lil help from chris at the w/e we erm gave the ripe database a bit of a trawling through and have extracted all the UK ASnames and numbers.

The stage Im at now is creating a database which links the AS names to a real ISP name.  Theres no way round it but manually creating a table which links all the ISP names to the ASname - there isnt any way it can be done automatically since the ripe AS name doesnt automatically make it obvious for a computer to see which ISP is which. 
Theres also some ISPs that would appear to have a few different AS names and some ISPs dont make it obvious until you look as the AS description.  Im also addressing the stuff like IC24 which is now part of the MAAF/brightview group.. so theres no easy way other than compiling my own personal lookup table.

Once thats done then I can look at integrating the new modules into the existing stuff.

[Floydoid]

What does ASP name mean?