hip_all.sql file not up-to-date?

General Discussion about IP Address Lookup caveats, technology, ideas, etc.

Moderator: Moderators

hip_all.sql file not up-to-date?

Postby mrok on Wed Apr 18, 2007 12:04 pm

Hi,

my service is using hostip.info for internet address decoding and I have encourages all my users who decode wrong to submit corrections directly to hostip.info website. I use rsync for updating my database every 3 days and load the changes into MySQL database later read with PHP API.

A customer reported to me a couple days ago that his IP address (89.100.8.101) is not decoded properly. On hostip.info website, it proprely decodes as Dublin, but the PHP script when provided with the same IP tells me:

Array
(
[a] => 89
[b] => 100
[c] => 8
[country] =>
[city] =>
[countryName] => (Unknown Country?)
[cityName] => (Unknown City?)
[countryCode] => XX
)

My database is apparently quite fresh, as the following SQL statements returns some timestamps from today:

mysql> select * from ip4 where cron>'2007-04-18';
+------------+---------+------+---------------------+
| ip | country | city | cron |
+------------+---------+------+---------------------+
| 1195157248 | 226 | 6870 | 2007-04-18 00:08:52 |
| 1224648704 | 226 | 143 | 2007-04-18 01:20:12 |
| 1287490304 | 226 | 6800 | 2007-04-18 02:05:40 |
| 1250387456 | 226 | 199 | 2007-04-18 02:20:21 |
+------------+---------+------+---------------------+

However, the ip4_89 table does not have any fresh entries since February:

mysql> select * from ip4_89 order by cron desc limit 1;
+-----+-----+---------+------+---------------------+
| b | c | country | city | cron |
+-----+-----+---------+------+---------------------+
| 111 | 255 | 27 | 8133 | 2007-02-28 06:29:08 |
+-----+-----+---------+------+---------------------+

I looked through some other ip4_* tables and the latest timestamps were from end of february 07.



regards,

Michal
Last edited by mrok on Sun Sep 14, 2008 3:03 pm, edited 1 time in total.
mrok
n00b
 
Posts: 1
Joined: Wed Apr 18, 2007 11:57 am

Return to IP Address Lookup

Who is online

Users browsing this forum: No registered users and 2 guests

cron