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 127.0.0.1). Therefore assuming that the target address for the OGS server will be for example 192.168.0.10, 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 http://192.168.0.10:8080/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 http://127.0.0.1:8080/geoexplorer/viewer/#maps/1 (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 “127.0.0.1″ and replace with “192.168.0.10″
    • 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 http://192.168.0.10:8080/geoexplorer/viewer/#maps/1 and the trick is done!

    Read more

RIOS helps move enterprise to lean professional Open Source

Finally we can announce this new business initiative. We are proudly among all amazing RIOS companies committed to the open source software strategy indeed.

It might seem just a commercial gimmick, however there is something more. The need to provide all-in-one integrated and ready to use solutions with the reliability of proven professional support services.

Professional open source is the driving factor for a safe IT path which can get rid of vendor lock-in. We are believing in RIOS as a primary entity that can foster the path away from traditional software integration in which large organizations are concerned and come up to the customer satisfaction within the scope of geospatial and security applications easier to maintain at affordable cost.

Hereafter a brief introduction (in Italian) of RIOS and at the bottom the link for the registration page to attending the launch event here in Rome.

Il 19 febbraio 2013 a Roma (alle ore 18.00 presso Rec23 www.reteitalianaopensource.net/it/rios-19febbraio) verrà presentata la Rete Italiana Open Source (RIOS), un ecosistema di imprese, fra i principali operatori italiani del settore, che hanno deciso di mettere a fattore comune esperienze, risorse e servizi professionali sui prodotti Open Source.
Promossa da Marco Ciarletti, Flavia Marzano e Carlo Vaccari, RIOS è una realtà che aggrega system integrator e maintainer di prodotti Open Source con oltre 450 addetti e sedi in gran parte del territorio nazionale.Rete Italiana Open Source si presenta al mercato come un nuovo soggetto capace di offrire una gamma completa di soluzioni, in un mercato ICT che oggi vede l’Open Source come uno dei pochi settori in costante crescita per gli evidenti vantaggi che offre (investire unicamente per i servizi professionali ricevuti, contrastare la sindrome del “vendor lock-in”, abbattere i costi di progetto pur puntando a soluzioni di altissima qualità e leader di mercato).
L’obiettivo di RIOS è quello di essere un punto di riferimento in Italia per Aziende, Pubbliche Amministrazioni Centrali e Locali, Public Utilities, System Integrator e chiunque intenda godere appieno dei benefici dell’Open Source senza rinunciare a sicurezza, servizi, supporto e garanzia di soluzioni di livello Enterprise.
La Rete vanta ampie competenze applicative: dal documentale all’ERP, dalla geolocalizzazione all’e-learning, dalla business intelligence agli open data. Attraverso uno stack di tecnologie Open Source unico in Italia, RIOS offre servizi di storage, infrastructure, middleware fino al cloud e al mobile. RIOS offre approcci “smart consulting” che possono dare risultati in tempi brevi, grazie al know-how acquisito in anni di esperienza con clienti nazionali ed internazionali. In un mercato dove il capitale umano e le competenze diventano prioritarie, RIOS sposta l’asse dalla competizione alla collaborazione, mettendo a disposizione soluzioni integrate, un’esperienza più che ventennale nel mercato dell’ICT, l’utilizzo di metodologie agili di progettazione e sviluppo.
Tutte le informazioni sulle aziende che costituiscono RIOS e sull’offerta di riferimento sono reperibili sul sito www.reteitalianaopensource.net.

Read more

SnowMonit premiato come Best Service 2012 nella competizione GMES

Read more