SOS 4.x Frequently Asked Questions
Why is the namespace not properly declared in , e.g. xsi:type="ns:DataArrayPropertyType"
- This is because of technical reasons. The 52N SOS uses XMLBeans for the XML encoding and if an element is defined as anyType in the XML schema, XMLBeans has problems with the declaration of the default prefixes in the inserted element. But the prefix/namespace mapping is declared in the associated element and the XML document is valid.
Why does the SOS not return observations for
2015-01-05T10:00:00.000Z if I send a request with
During temporal filter for
ISO 19108:2002, Geographic Information — Temporal schema defines that the time stamps of a
During temporal filter are excluded. To get the observations for
2015-01-05T10:00:00.000Z, the time stamps of the filter should look like this
How do I change the administrator password?
The admin password can be changed via the admin interface of the 52°North SOS.
- Open the 52°North SOS URL in a browser
- Select Admin and enter the credentials
- Select Settings
- Select the Credentials tab and change the password
How do I disable the administrator login?
The administrator login can be disabled by simply deleting any existing user from the settings database. To do so follow the these steps:
How can I reset my password if I forgot it or deleted my user acount!
Just insert a default administrator user with the username
and the password
(below is the hash for "password" that is stored in the database):
- go to the directory of the deployed service (e.g.
- open the
configuration.db file with the SQLite tool of your choice (e.g. https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/ or the
sqlite3 CLI interface)
- issue the query
INSERT OR REPLACE INTO administrator_user(id, username, password) VALUES (1, 'admin', '$2a$10$vbp9aXCDMP/fXwEsqe/1.eon44mMdUyC4ub2JfOrkPfaer5ciLOly');
How to apply Tomcat HTTP basic authentication together with administrator login?
This section describes a simple and quick solution how to secure the SOS via HTTP basic authentication. Because the SOS uses Spring Security to secure the admin GUI, some adjustments are necessary. A small issue of this solution is that you have to enter the admin GUI credentials twice.
, and MY_REALM_NAME
are palceholders and can be replaced with your favorite values.
Add the role and user to the
1 <role rolename="MY_ROLE"/>
2 <user name="MY_NAME" password="MY_PASSWORD" roles="MY_ROLE" />
Add the following to the
file of you SOS webapp ( [TOMCAT_HOME]\webapps\[SOS_NAME]\WEB-INF
3 <web-resource-name>all resources</web-resource-name>
18 <role-name>MY_ROLE </role-name>
and change the
<!-- Spring security filter -->
81 <!-- Spring security filter -->
In the Transactional Security
section you can find some information about the support of secure transactional operations.
Advanced security features including more control over the other operations can be established using the 52°North Web Security Service
from our Security community
. A documentation how to set up the 52°North Web Security Service can be found on the SecuringSOS
Increase the shared_buffers
value is very low, especially in versions prior to 9.3, because on some platforms requires invasive action like recompiling the kernel (PostgreSQL Wiki
value can be found in the
file (PostgreSQL data folder) and information about the optimal setting can be found here in the PostgreSQL Wiki
Some more information about tuning PostgreSQL can be found in this blog post
Analyzing the PostgreSQL SQL queries
Analyzing slow queries can also be helpful to find out what is going on. Some SQL queries can be found in the SOS log files (TOMCAT_LOG_FOLGER\SOS_NAME.log) if the log level is
(Admin interface). Another option is to cheange the PostgreSQL logging settings by changing the
settings value in the
and remove the
in front of the parameter. After restarting PostgreSQL all SQL queries sent to the server are logged into the PostgreSQL /data/pg_log folder.
To analyze a SQL query copy the query and execute it with preceded
EXPLAIN ANALYZE select * from observation
The result of the
can be pasted to http://explain.depesz.com/
which will expose slow operations.
Thanks to Shane who has pointed out this.