SOS database reset does not work via Admin GUI

[justb4]

Sometimes one wants to emtpy the DB. This does not work via the Admin GUI (400 or 500 error).

The procedure below works:

See data and scripts at https://github.com/Geonovum/sospilot/tree/master/data/sosdb. Using this procedure, no
reinstall of the .war file is requried or any other Admin reset (somehow an Admin reset did not work).

As root do

• Stop Tomcat (command /opt/bin/tcdown)
• Clean DB: reinstall PG schema using: https://github.com/Geonovum/sospilot/blob/master/data/sosdb/empty-dm-dump.sql
• Remove /var/www/sensors.geonovum.nl/webapps/sos/cache.tmp.
• Start Tomcat (command /opt/bin/tcup)