This virtual machine is based on Debian GNU/Linux 9.8 (stretch) (without graphic Desktop Environment) and it runs on VMware ESXi v6.5, but you can run it on VMware Workstation Player. As a prerequisite for using this virtual machine, it is necessary to download and install the free VMware Workstation Player (tested with version 15). With this tool you can launch the VM, which by default was created with the following specifications (which can be modified in the VMware "Settings" configuration panel):
number of processor: 8 (you can increase when needed)
RAM: 8 GB (it can be easily increased)
Hard-Disk: 500 GB (thin provisioning) you need at least 34 Gbyte at the first running on your HD
Access to the Operating System, credentials
IP: static à verify into your system (ifconfig from Debian shell)
Operating system: Debian v9.8
username: debian, password: debian, password of super user (su): debian
You must modify the file /etc/hosts and update the local IP of the machine “GISGeoServer”.
This VM consists of the following components:
- GeoServer (http://geoserver.org/)
- PostgreSQL 9.6.15
- MySQL 5.7.27
- Heatmap API for inserting map related data
The url and credentials for GeoServer are:
- (http://GISGeoServer:8080/geoserver/web, username: admin, password: password)
The credentials for PostgreSQL are
- username: snap4city, password: ubuntu
The credentials for MySQL are
- Username: root
- Password: ubuntu
GeoServer writes in the PostgreSQL’s schema “gisdata”, which features the postgis extension.
The Heatmap API and the GeoServer indexer service are run through cron.
@reboot sleep 30 && /home/debian/heatmap-API --port 8000 --address 0.0.0.0 > /dev/null 2>&1
@reboot sleep 60 && /home/debian/run.sh > /dev/null 2>&1
To insert map data into MySQL you must use the Heatmap API (https://www.km4city.org/swagger/external/?urls.primaryName=Heatmap%20API)
To remove maps from the GeoServer you have to
- delete the relative store from the “Data” menu from the GeoServer’s web interface
- drop the PostgreSQL table related to the image’s layer from the gisdata schema
- Remove the map’s folder of the gfeoserver web application from Apache Tomcat in /var/lib/tomcat8/webapps/geoserver/data/data/Snap4City/[folder_to_remove]
--- end ---