smithsson68@gmail.com
Jul 4, 2011
  6285
(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
Keynote Summary from Opticon 2024, Stockholm

At Opticon in Stockholm, marking the 30th anniversary of Optimizely, the company celebrated significant achievements. These included surpassing $40...

Luc Gosso (MVP) | Sep 11, 2024 | Syndicated blog

Introducing Search & Navigation Import/Export functionality

We introduce a small but helpful funcionality for customers which allow customers import/export list of Related Queries , Synonyms , Autocomplete a...

Manh Nguyen | Sep 11, 2024

SNAT - Azure App Service socket exhaustion

Did you know that using HttpClient within a using statement can cause SNAT (Source Network Address Translation) port exhaustion? This can lead to...

Oleksandr Zvieriev | Sep 9, 2024

Micro front-ends are massive for Optimizely One

Optimizely products have evolved. Their new generation of products changes the game.

Mark Everard | Sep 9, 2024 | Syndicated blog

Micro front-ends are massive for Optimizely One

Optimizely products have evolved. Their new generation of products changes the game.   A multi-year journey for Optimizely. They have engineered...

Mark Everard | Sep 9, 2024 | Syndicated blog

Handling Nynorsk and Bokmål in Optimizely CMS

Warning: Blog post about Norwegian language handling (but might be applicable to other languages and/or use cases). Optimizely have flexible and...

Haakon Peder Haugsten | Sep 5, 2024