some documentation;
authorwenzelm
Sat, 29 Apr 2017 19:43:04 +0200
changeset 65635 0a025b8496a2
parent 65634 e85004302c83
child 65636 df804cdba5f9
some documentation;
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