[WebDNA] Re: anyone get MaxMind geolite city working?

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108648
interpreted = N
texte = This is a multi-part message in MIME format. --------------010208000705020406010400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Figured this out in case anyone want to use these 3.5 million row tables. This search works: [search db=/db/geolocation/GeoLiteCity-Blocks.db&geendIpNumdatarq=[thisnum]&endIpNumtype=num&max=1&rank=off] Olin Lagon wrote: > Trying to build a system to convert and IP address to a city. Here is > a free dataset: http://www.maxmind.com/app/geolitecity. The set has > 3.5 million records which I converted to tab d databases. I can search > it but the results are funky. > > thisnum = converted IP address > > This brings back a bad result: > [search > db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]] > found = [numfound]
> [foundItems] > [startipnum] - [thisnum] -[endipnum] > [/foundItems] > [/search] > > > Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167 > > The number in the middle should be between the left and right number. > When I add in the num data type, I get no results (search > db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]). > > Anyone work with this data set before? > > Thanks, Olin --------------010208000705020406010400 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Figured this out in case anyone want to use these 3.5 million row tables. This search works:

[search db=/db/geolocation/GeoLiteCity-Blocks.db&geendIpNumdatarq=[thisnum]&endIpNumtype=num&max=1&rank=off]

Olin Lagon wrote:
Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky.

thisnum = converted IP address

This brings back a bad result:
[search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]]
        found = [numfound]<br />
        [foundItems]
        [startipnum] - [thisnum] -[endipnum]
        [/foundItems]
[/search]
   

Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167

The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]).

Anyone work with this data set before?

Thanks, Olin
--------------010208000705020406010400-- Associated Messages, from the most recent to the oldest:

    
  1. [WebDNA] anyone get MaxMind geolite city working? (Olin Lagon 2012)
This is a multi-part message in MIME format. --------------010208000705020406010400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Figured this out in case anyone want to use these 3.5 million row tables. This search works: [search db=/db/geolocation/GeoLiteCity-Blocks.db&geendIpNumdatarq=[thisnum]&endIpNumtype=num&max=1&rank=off] Olin Lagon wrote: > Trying to build a system to convert and IP address to a city. Here is > a free dataset: http://www.maxmind.com/app/geolitecity. The set has > 3.5 million records which I converted to tab d databases. I can search > it but the results are funky. > > thisnum = converted IP address > > This brings back a bad result: > [search > db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]] > found = [numfound]
> [founditems] > [startipnum] - [thisnum] -[endipnum] > [/foundItems] > [/search] > > > Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167 > > The number in the middle should be between the left and right number. > When I add in the num data type, I get no results (search > db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]). > > Anyone work with this data set before? > > Thanks, Olin --------------010208000705020406010400 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Figured this out in case anyone want to use these 3.5 million row tables. This search works:

[search db=/db/geolocation/GeoLiteCity-Blocks.db&geendIpNumdatarq=[thisnum]&endIpNumtype=num&max=1&rank=off]

Olin Lagon wrote:
Trying to build a system to convert and IP address to a city. Here is a free dataset: http://www.maxmind.com/app/geolitecity. The set has 3.5 million records which I converted to tab d databases. I can search it but the results are funky.

thisnum = converted IP address

This brings back a bad result:
[search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]]
        found = [numfound]<br />
        [founditems]
        [startipnum] - [thisnum] -[endipnum]
        [/foundItems]
[/search]
   

Result is: 999,997,440 - 1,224,592,000 - 1,000,007,167

The number in the middle should be between the left and right number. When I add in the num data type, I get no results (search db=GeoLiteCity-Blocks.db&gestartIPnumdatarq=[thisnum]&leendIpNumdatarq=[thisnum]&startIPnumtype=num&endIpNumtype=num]).

Anyone work with this data set before?

Thanks, Olin
--------------010208000705020406010400-- Olin Lagon

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebCat2b12plugin - [search] is broken ... not! (1997) Grep help (2005) Re1000001: Setting up shop (1997) New Guestbook Source (1997) RE:It just Does't add up!!! (1997) [searchString] (1997) Garbage display after 100 records (was WebCatalog usage) (1997) Date stamp and purging (1998) Just a test - please ignore (1999) showif field is number (1997) Colors (2000) unable to launch acgi in WebCat (1997) convertchars and case? (1998) What's up with digger? (2004) WCS Newbie question (1997) UPDATE PROBLEM (1997) PCS Frames (1997) Hiding HTML and page breaks (1997) Bug Report, maybe (1997) WebCat2 Append problem (B14Macacgi) (1997)