Try our conversational search powered by Generative AI!

smithsson68@gmail.com
Jul 4, 2011
  6168
(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 and the never-ending story of the missing globe!

I've worked with Optimizely CMS for 14 years, and there are two things I'm obsessed with: Link validation and the globe that keeps disappearing on...

Tomas Hensrud Gulla | Apr 18, 2024 | Syndicated blog

Visitor Groups Usage Report For Optimizely CMS 12

This add-on offers detailed information on how visitor groups are used and how effective they are within Optimizely CMS. Editors can monitor and...

Adnan Zameer | Apr 18, 2024 | Syndicated blog

Azure AI Language – Abstractive Summarisation in Optimizely CMS

In this article, I show how the abstraction summarisation feature provided by the Azure AI Language platform, can be used within Optimizely CMS to...

Anil Patel | Apr 18, 2024 | Syndicated blog

Fix your Search & Navigation (Find) indexing job, please

Once upon a time, a colleague asked me to look into a customer database with weird spikes in database log usage. (You might start to wonder why I a...

Quan Mai | Apr 17, 2024 | Syndicated blog