Gateway2 Akka / Scala / Play

This is the Sensor Gateway.

Build

To create the release package just run (activator.bat under Windows)

./activator dist

Preparing Postgres Database for use with Gateway

Create User gateway and database gateway2db. Database will be empty as schema is created via evolutions by the gateway itself. Login with psql as postgres (or any admin user) and run the following SQL

CREATE USER gateway WITH
	LOGIN
	NOSUPERUSER
	NOCREATEDB
	NOCREATEROLE
	INHERIT
	NOREPLICATION
	CONNECTION LIMIT 50
	PASSWORD '<password>';
	
	CREATE DATABASE gateway2db
        WITH 
        OWNER = postgres
        ENCODING = 'UTF8'
        CONNECTION LIMIT = -1;
    
    GRANT ALL ON DATABASE gateway2db TO gateway;
    
    -- CONNECT TO gateway2db DATABASE NOW ('\c gateway2db' when in psql) AND THEN EXECUTE
    -- CREATE EXTENSION postgis;    

All needed tables etc will be created on first start of gateway. Initial data must be imported. See initial-data directory.

Installation

This package is meant to be installed on Raspberry PI using Raspian. Should work on any other Linux distribution as well. For Windows and MacOS no guarantee :-)

Copy archive to Raspberry and unzip

    $ unzip gateway2-1.1.zip
    $ cd gateway2-1.1
    $ chmod +x service_installer/h2server/*.sh
    $ chmod +x service_installer/snw_gateway/*.sh

Install H2 database service (NOTE: at that point in time the installer HAS to be run from within its directory)

    $ cd service_installer/h2server/
    $ sudo ./install_h2_service.sh
    $ sudo systemctl start h2server.service   # start database
    $ systemctl status h2server.service       # check if started correctly
    $ cd ../..

You should be able to connect to the database service with your browser http://<hostname_or_ip>:8082/.

Install SnwGateway service (NOTE: at that point in time the installer HAS to be run from within its directory)

    $ cd service_installer/snw_gateway/
    $ sudo ./install_snw_gateway_service.sh
    $ sudo systemctl start snw_gateway.service  # start service
    $ systemctl status snw_gateway.service      # check if service started (may take a while)
    $ tail -f /opt/snw_gateway/logs/application.log  # follow logfile to see if anything went wrong

You should be able to connect to the gateway service with your browser http://<hostname_or_ip>:9000/. By default every function (MQTT, Upload, XBEE) and the database is an in memory database - so it will be deleted on reboot. See Configuration section on how to enable functions and persist database.

After first gateway start the database should be empty (for example look under inventory/list nodes) so we need to fill it with initial data. Find database url and username / password in /opt/snw_gateway/conf/application.conf.

    $ cd /opt/snw_gateway/conf/
    $ runscript_h2.sh ... (TODO) 
    
    update sensormeasurements set soserrorcode = -1, sostransmitted = false;

• Run inital-data.sql script by connecting to H2 database, when installing the gateway for the first time.

Updating from older Versions

Transfer the zip file containing the new version of the gateway to your Raspberry PI.

    $ sudo systemctl status snw_gateway.service  ## stop gateway service before updating
    $ sudo /opt/snw_gateway/bin/_gateway.sh <gateway zipfile> 

The updater will update the libraries etc. but not the configuration and binary files. Check /opt/snw_gateway/bin_new and /opt/snw_gateway/conf_new for the binary and configuration files provided with the new version and update the old ones if necessary.

TODO explain database update (H2) and how to check service installer unit.

Configuration

TODO Change node_equivalent = "0013A20040C5407F" to correct value!

Notes for Developers

Virtual serial (COM) ports for testing

MacOS X / Linux

Install socat using home brew brew install socat or in your Linux distribution using their package manager (e.g. sudo apt install socat).

    $ SOCAT_PORT_USER=<username>
    $ SOCAT_PORT_MASTER=master
    $ SOCAT_PORT_SLAVE=slave
    $ sudo socat -d -d -d -d -lf /tmp/socat pty,link=/dev/$SOCAT_PORT_MASTER,raw,echo=0,user=$SOCAT_PORT_USER,group=staff pty,link=/dev/$SOCAT_PORT_SLAVE,raw,echo=0,user=$SOCAT_PORT_USER,group=staff &

The last command should output something like [1] 44636 and two new devices /dev/master and /dev/slave should have been created. To test simply cat /dev/slave, open a new terminal and echo "hello world" > /dev/master. You should see hello world printed to the screen. To shutdown the port sudo kill <PID> and replace the PID with the number after [1] from the output above. If you need more than one port, just replace master/slave with something else.

Windows

There's very likely a tool that can do that :-)

Licenses

This software is distributed under the Apache Software License 2.0.

• Xbee-Api is distributed under GNU General Public License v3.0

• Play Framework is distributed under the Apache Software License 2.0.

• All additional documentation is distributed under

Copyright (c) 2011-2017 Interfaculty Department of Geoinformatics, University of Salzburg (Z_GIS) & Institute of Geological and Nuclear Sciences Limited (GNS Science) in the SMART Aquifer Characterisation (SAC) programme funded by the New Zealand Ministry of Business, Innovation and Employment (MBIE)

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Acknowledgments

The authors wish to acknowledge the six year funding (07/2011-06/2017) of the Ministry of Business, Innovation, and Employment (MBIE), New Zealand, contract number C05X1102, for the SMART Aquifer characterisation (SAC) programme.