Dampfklon dampfklon

Dashboard with a Raspberry Pi

Run Raspberry 3 in digital signage mode with Chromium Web browser on a TV screen

Pre-work

socat with sslv2 and sslv3 support

This script downloads and builds OpenSSL v1.0.2q and socat v1.7.3.2 in /usr/local/src. Once complete, a symlink at /usr/local/bin/socat-ssl23 is created so that you can run it with socat-ssl23.

install

Tested on Kali Linux:

curl -fsSL https://git.io/vFBDA | bash

	-- Revoke default permissions
	REVOKE ALL ON SCHEMA public FROM public
	GRANT ALL ON SCHEMA public TO writeuser

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	/**
	* Creates a "logging" schema with an "history" table where are stored records in JSON format
	*
	* Requires PostgreSQL >= 9.3 since data is stored in JSON format
	*
	* Credits: http://www.cybertec.at/2013/12/tracking-changes-in-postgresql/
	*/

	/* Create a schema dedicated to logs */
	CREATE SCHEMA logging;