Admin/cronjob/README
author wenzelm
Fri, 02 Mar 2018 20:32:39 +0100
changeset 67748 94a8fddc1e7c
parent 66995 9cb263dbb2f7
child 67766 603334230303
permissions -rw-r--r--
clarified README;
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
64148
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
     1
Administrative Isabelle cronjob at TUM
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
     2
======================================
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
     3
66995
9cb263dbb2f7 plain identify job for Isabelle + AFP, independent of any Isabelle technology;
wenzelm
parents: 64148
diff changeset
     4
- jobs: manual installation on target directory:
9cb263dbb2f7 plain identify job for Isabelle + AFP, independent of any Isabelle technology;
wenzelm
parents: 64148
diff changeset
     5
    cp "$ISABELLE_HOME/Admin/cronjob/self_update "$HOME/cronjob/self_update"
9cb263dbb2f7 plain identify job for Isabelle + AFP, independent of any Isabelle technology;
wenzelm
parents: 64148
diff changeset
     6
    cp "$ISABELLE_HOME/Admin/cronjob/plain_identify "$HOME/cronjob/plain_identify"
9cb263dbb2f7 plain identify job for Isabelle + AFP, independent of any Isabelle technology;
wenzelm
parents: 64148
diff changeset
     7
64148
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
     8
- crontab: manual update on target machine
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
     9
    crontab -l
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
    10
    crontab -e
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
    11
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
    12
- $HOME/cronjob/run/ -- run-time state
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
    13
bbf43b7c4d0d basic setup for Isabelle cronjob;
wenzelm
parents:
diff changeset
    14
- $HOME/cronjob/log/ -- cumulative log area
67748
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    15
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    16
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    17
Build Log Database Server
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    18
=========================
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    19
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    20
- Ubuntu 16.04 LTS Linux Server standard installation (e.g. on virtual host)
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    21
  https://help.ubuntu.com/lts/serverguide
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    22
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    23
- apt install unattended-upgrades
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    24
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    25
- special user account:
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    26
  useradd -m -s /bin/bash isatest
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    27
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    28
- SSH access for jsch (on each client):
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    29
  LOCALHOST$ ssh-keyscan -t rsa DBSERVER
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    30
  >> ~/.ssh/known_hosts
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    31
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    32
- PostgreSQL:
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    33
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    34
  $ apt install postgresql
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    35
  $ apt install postgresql-client
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    36
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    37
  $ sudo -u postgres psql template1
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    38
  ALTER USER postgres with encrypted password '***';
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    39
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    40
  $ edit /etc/postgresql/9.5/main/pg_hba.conf
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    41
  local all postgres md5
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    42
  local all all md5
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    43
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    44
  $ systemctl restart postgresql.service
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    45
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    46
  $ createuser -U postgres --interactive isatest
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    47
  ALTER USER isatest with encrypted password '***';
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    48
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    49
  $ createdb -E UTF8 -T template0 --locale=en_US.utf8 -U postgres -O isatest isatest
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    50
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    51
- Database backup or migration:
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    52
  https://www.postgresql.org/docs/9.5/static/backup-dump.html
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    53
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    54
     pg_dump -U postgres -Fc -v -d isatest > db.dump
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    55
  pg_restore -U postgres -Fc -v -d isatest < db.dump
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    56
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    57
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    58
Build Status Charts
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    59
===================
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    60
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    61
- Gentoo Linux might require gnuplot from original source
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    62
  (to avoid bad data interpolation)
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    63
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    64
  http://gnuplot.sourceforge.net/
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    65
  https://sourceforge.net/projects/gnuplot/files/gnuplot/5.0.6/
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    66
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    67
  $ cd gnuplot-5.0.6
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    68
  $ ./configure
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    69
  $ make
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    70
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    71
  edit $ISABELLE_HOME_USER/etc/settings
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    72
94a8fddc1e7c clarified README;
wenzelm
parents: 66995
diff changeset
    73
  ISABELLE_GNUPLOT=".../src/gnuplot"