November Happy Hour will be moved to Thursday December 5th.

smithsson68@gmail.com
Jul 4, 2011
  6349
(1 votes)

Automatically Updating the Geo-IP Database

Last week, David Knipe blogged about how to update the MaxMind GeoIP database that ships with the EPiServer Framework.

This inspired me to create an EPiServer Scheduled Job to do this automatically:

image

As the job needs to download a file from the internet, which could be a lengthy operation, I made it a ‘stoppable’ job. You can read more about stoppable scheduled jobs here.

The job also has a settings page where you can adjust the URL of the downloadable database file as well as a couple of other settings:

image

It seems that MaxMind update their ‘Lite’ database on the 1st of every month so it’s probably a good idea to schedule the job for the 2nd of every month.

You can obtain a Deployment Center Zip Module here to add the functionality to a site or if you want the source code then download the EPiServer.Extensions.GeoIPUpdate.1.0.nupkg package from nuget.episerver.com.

The code has been tested but of course if you find any bugs or have any suggestions for improvements then please let me know.

Happy updating!

Jul 04, 2011

Comments

Jul 4, 2011 08:02 PM

Great stuff! Thanks Paul. I've updated my original post :)

Jul 18, 2011 11:06 PM

Nice! We had a question about this shortly after the R2 release and now a more complete answer.

Jørgen Helgheim
Jørgen Helgheim Mar 12, 2014 11:02 AM

Nice.

One fix to the code:
You should replace the line _liveDatabaseFileName = maxmindProviderConfig.Parameters["databaseFileName"]; with _liveDatabaseFileName = Web.VirtualPathUtilityEx.RebasePhysicalPath(maxmindProviderConfig.Parameters["databaseFileName"]); in the property LiveDatabaseFileName in the file UpdateDatabase.cs. To take acount of the appdata path.

For thoose wanting to use this code in CMS 7 or 7.5 you should make GeoIPUpdateAdmin.aspx.cs inherit WebFormsBase instead of SystemPageBase. and then you do not need to override Page_PreInit to set MasterPageFile, because this is already part of the WebFormsBase class.

valdis
valdis Jan 27, 2015 05:54 PM

Is it open sourced?

Please login to comment.
Latest blogs
Optimizely SaaS CMS + Coveo Search Page

Short on time but need a listing feature with filters, pagination, and sorting? Create a fully functional Coveo-powered search page driven by data...

Damian Smutek | Nov 21, 2024 | Syndicated blog

Optimizely SaaS CMS DAM Picker (Interim)

Simplify your Optimizely SaaS CMS workflow with the Interim DAM Picker Chrome extension. Seamlessly integrate your DAM system, streamlining asset...

Andy Blyth | Nov 21, 2024 | Syndicated blog

Optimizely CMS Roadmap

Explore Optimizely CMS's latest roadmap, packed with developer-focused updates. From SaaS speed to Visual Builder enhancements, developer tooling...

Andy Blyth | Nov 21, 2024 | Syndicated blog

Set Default Culture in Optimizely CMS 12

Take control over culture-specific operations like date and time formatting.

Tomas Hensrud Gulla | Nov 15, 2024 | Syndicated blog