Page 1 of 1

hip_all.sql file not up-to-date?

PostPosted: Wed Apr 18, 2007 12:04 pm
by mrok
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