I got a notification in the Status Report for my site that the IP2CC data was out of date and needed updating.

I ran the fetchdb.sh script, and noticed the timestamp on the ip-to-country.csv file was 14th December 2010. That surprised me, so I went to http://ip-to-country.webhosting.info/ to check that the URL hadn't altered. It hasn't, and fetchdb.sh had retrieved the most recent data. http://ip-to-country.webhosting.info/ reports that "The database was last updated on December 14 2010".

Is the data source for this project no longer being updated? Are there any alternatives if so?

CommentFileSizeAuthor
#8 ip2cc-new-db-source-v2.patch8.97 KBLuRcH@www.daihatsu-drivers.co.uk
#5 ip2cc-new-db-source.patch8.84 KBLuRcH@www.daihatsu-drivers.co.uk

Comments

drupalina’s picture

drupalina commented

subscribing - I have the same issue: after the update of database it still says that it is more than 2 months old.

anavarre’s picture

anavarre
Primary language French
Location 🇪🇺
commented

Subsribing

jamesoakley’s picture

jamesoakley
Primary language English
Location North Yorkshire, UK
commented

Just to say: I've posted an issue in the queue for the project IP to Locale - WebHosting.info, because that module is the planned successor for the relevant part of this project, and so that module needs to handle this issue too.

See: #1290138: Only as good as its data feed

LuRcH@www.daihatsu-drivers.co.uk’s picture

LuRcH@www.daihatsu-drivers.co.uk commented

I have only recently realised that the database is no longer updated. Wouldn't it be possible to update the module to recognise and use the database from http://software77.net/geo-ip/ instead?

LuRcH@www.daihatsu-drivers.co.uk’s picture

LuRcH@www.daihatsu-drivers.co.uk commented
StatusFileSize
new ip2cc-new-db-source.patch8.84 KB

I have edited the module and updated everything I could find to now retrieve and use the database from Software77 as they appear to update theres almost on a daily basis.

jamesoakley’s picture

jamesoakley
Primary language English
Location North Yorkshire, UK
commented

I've been working on using MaxMind's offering. They offer a free, "lite" version of their GeoIP database. The great thing is, that it can plug straight into PHP, so that there's no need for a custom module at all. The only downside is that it needs the web host to install the relevant PECL package, so that could be a problem with some shared hosts, but at least the data is current.

Does your update work? I guess it all depends on whether the other data source uses close enough the same format?

LuRcH@www.daihatsu-drivers.co.uk’s picture

LuRcH@www.daihatsu-drivers.co.uk commented

It can import the data from the .csv file from the new source. However have noticed that the new source has a commented out header which causes it to fail until you remove it in a text editor. I am working on seeing if can get ip2cc to skip it so it works without needing to touch the csv.

LuRcH@www.daihatsu-drivers.co.uk’s picture

LuRcH@www.daihatsu-drivers.co.uk commented
StatusFileSize
new ip2cc-new-db-source-v2.patch8.97 KB

Have managed to fix the issue with the header in the CSV from the new source. Have tested and have been able to use fetchdb and then the update database option within the admin area :)

mrfelton’s picture

mrfelton commented

I was going to apply this patch today, but the source at http://software77.net/geo-ip seems to be unavailable. I've been unable to contact hat host all day.

jamesoakley’s picture

jamesoakley
Primary language English
Location North Yorkshire, UK
commented

Not available how? - the page loads fine for me, and it says that the DB is 3 hours old.

I have to qualify that by saying that I've not tested the patch to switch sources, so I can't confirm that it works - but the source's website is up from here.

mrfelton’s picture

mrfelton commented

Not available as in, it just times out. I can't make a connection to http://software77.net at all, but can connect to everywhere else on the net without any issues. I'll try again later or tomorrow.

LuRcH@www.daihatsu-drivers.co.uk’s picture

LuRcH@www.daihatsu-drivers.co.uk commented

The structure of the MySQL table itself is not changed, so if you want you can safely use the patch, and if it not work in your case for whatever reason you can revert back to using the original 6.x-1.2 version.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

Why don't we go ahead and get the software77 patch in there. Looks like it's still being updated.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Version: 6.x-1.2 » 6.x-1.x-dev
Issue summary: View changes
Status: Active » Needs work

Software77.net is long gone, so this issue has no resolution, and the patches are invalid.

http://ip-to-country.webhosting.info/ still shows last update in 2010.

Has anybody had success with other approaches? Modern web browsers want to do html5-type geolocation, which would be far better.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Title: Is the database for IP2CC no longer being updated » Database for IP2CC no longer being updated
Category: Support request » Bug report
jamesoakley’s picture

jamesoakley
Primary language English
Location North Yorkshire, UK
commented

I'd forgotten about this issue, it was so old. To be honest, I had long ago changed tack entirely. I now use MaxMind's GeoLite database, which is free, and use it with Apache's mod_geoip module and/or the GeoIP PECL extension.

Both can be queried in Drupal. For the PECL, there are a number of well-documented functions to return various geographical attributes; for the Apache module, the country and continent are accessible as server variables.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Needs work » Closed (outdated)

I am closing this issue, as Drupal 6 is now not supported.