Added simple endpoint to view system logs. api/system/log/{service}/{file} allows to retrieve the raw log file content for a selected set of services (currently "apache2" and "postgresql"). The result is a JSON with two fields: "path:" contains the fully qualified path of the retrieved log file in the servers file system and "content:" provides the verbatim content of the requested log file.

--
-- Primary GEMMA roles
--
CREATE ROLE waterway_user;
CREATE ROLE waterway_admin IN ROLE waterway_user;
CREATE ROLE sys_admin IN ROLE waterway_admin;

--
-- Special roles
--

-- A role that is intended to be used for backend- or
-- GeoServer-connections on which SET ROLE has to be used to
-- gain privileges of a specific role
CREATE ROLE metamorph NOINHERIT;