# HG changeset patch # User wenzelm # Date 1493487784 -7200 # Node ID 0a025b8496a26e037ebb6ddb985a09c63ab796c9 # Parent e85004302c83818b52f593bbd4ccd9ced8c6f145 some documentation; diff -r e85004302c83 -r 0a025b8496a2 Admin/build_log/README --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Admin/build_log/README Sat Apr 29 19:43:04 2017 +0200 @@ -0,0 +1,33 @@ +Build Log Database Server +========================= + +- Ubuntu 16.04 LTS Linux Server standard installation (e.g. on virtual host) + https://help.ubuntu.com/lts/serverguide + +- apt install unattended-upgrades + +- special user account: + useradd -m -s /bin/bash isatest + +- SSH access for jsch: + LOCALHOST$ ssh-keyscan -t rsa DBSERVER + >> ~/.ssh/known_hosts + +- PostgreSQL: + + $ apt install postgresql + $ apt install postgresql-client + + $ sudo -u postgres psql template1 + ALTER USER postgres with encrypted password '***'; + + $ edit /etc/postgresql/9.5/main/pg_hba.conf + local all postgres md5 + local all all md5 + + $ systemctl restart postgresql.service + + $ createuser -U postgres --interactive isatest + ALTER USER isatest with encrypted password '***'; + + $ createdb -E UTF8 -T template0 --locale=en_US.utf8 -U postgres -O isatest isatest