Date: February 27th, 2013

Tweak network configurations of OpenGeo Suite Server

A completely web-based architecture OGS architecture such as the OpenGeo Suite means that a change in the IP address of the server where it is installed impacts radically operations of applications and services. It often happens, however, that the server on which the prototype has been developed becomes a machine directly used in production or even when the network is forced to migrate toward a different configuration then the OGS IP address has to be changed. What does it happen to the deployed applications and how to proceed without having to reinstall all over again?

Base installation of OGS on Windows servers

When installing from scratch the package of the OpenGeo Suite on Windows the applications are deployed into the Jetty container whose configuration drives the way how they are published on the Web (default value for IP address is Therefore assuming that the target address for the OGS server will be for example, let’s see what are the steps to follow.

Step 1

  • Click on Start to go into command shell
  • Run “Cmd + Enter” and then
  • Edit the configuration file for the Jetty server
  • Change the IP address in the xml
  • Start the OpenGeo Suite from the Dashboard
  1. Open Start –> Programs –> OpenGeo Suite –> OpenSuite Dashboard
  2. Click on the Start button

OGS dashboard

    Once all services are up and running we can:

  • Verify the right behavior of OGS applications on the default port:
  1. Open a browser and enter the new URL GeoServer
  2. Login to GeoServer

It remains to remedy to the visualization of the map projects that have been stored and exported from the GeoExplorer application. In fact, each project uses the URL of OGS server at the time of saving the map, and therefore requires adjustments if you do not want to generate the same project from scratch.
GeoExplorer is a map viewer/composer developed from the OpenGeo SDK that uses a SQLite database to store configurations of map projects.
Assuming that a map was saved with an URL like (let’s keep in mind the last number) then what do we need to do for recovering the operation after a change of IP address?

Step 2

Download a SQLite editor

Download the free editor SQLite Studio for MS Windows. It’s a binary that can be directly executed with no need for installation

Edit GeoExplorer database
  • Backup SQLite database. From the command shell in the HOME of the user run:
  • Open SQLite Studio and connect to geoexplorer.db
  • Open SQL query editor and run the following query to find the configurations of the map with id 1

  • GeoExplorer database result

      From the resultset:

    • Go into edit mode on the config field of the row and then make Copy of the value
    • Config field value
      In a text editor:

    • Paste into a new window
    • Find “″ and replace with “″
    • Copy the whole modified text
    • Back to SQLite studio, paste and overwrite the config field value
    • Commit the change in the table maps
    • Open a browser, enter the new URL of the map stored in GeoExplorer and the trick is done!

    Read more