Gogs

${shell}:~$ sudo apt-get install postgresql postgresql-contrib
${shell}:~$ sudo apt-get install mercurial git
${shell}:~$ wget https://dl.gogs.io/0.11.66/gogs_0.11.66_linux_amd64.tar.gz
${shell}:~$ tar -zxf gogs_0.11.66_linux_amd64.tar.gz
${shell}:~$ mv gogs* /opt/gogs
${shell}:~$ sudo chown $USER:$USER /opt/gogs -R

## test installation
${shell}:~$ /opt/gogs/gogs web
${shell}:~$ curl localhost:3000

See PostgreSQL to

1. install
2. create user
3. create databases
4. grant user privileges to the databases

See APACHE to install, configure, and enable site

Configuration file: /etc/apache2/sites-available/gogs.conf

http:

<VirtualHost *:80>
  DocumentRoot /var/www/html/gogs/
  ServerName localhost
  <Directory /var/www/html/gogs/>
    Options +FollowSymLinks
    AllowOverride All
    Require all granted
    <IfModule mod_dav.c>
       Dav off
    </IfModule>
    SetEnv HOME /var/www/html/gogs
    SetEnv HTTP_HOME /var/www/html/gogs
  </Directory>
  ProxyPreserveHost on
  ProxyRequests off
  ProxyPass / http://127.0.0.1:3000
  ProxyPassReverse / http://127.0.0.1:3000
  ErrorLog ${APACHE_LOG_DIR}/gogs_error.log
  CustomLog ${APACHE_LOG_DIR}/gogs_access.log combined
</VirtualHost>

https:

<VirtualHost *:80>
  DocumentRoot /var/www/html/gogs/
  ServerName localhost
  ErrorLog ${APACHE_LOG_DIR}/gogs_error.log
  CustomLog ${APACHE_LOG_DIR}/gogs_access.log combined
  <Location />
    RewriteEngine on
    RewriteCond %{HTTPS} off
    RewriteRule (.*) https://${HTTP_HOST}%{REQUEST_URI} [R]
  </Location>
</VirtualHost>
<VirtualHost *:443>
  DocumentRoot /var/www/html/gogs/
  ServerName localhost
  ErrorLog ${APACHE_LOG_DIR}/gogs_error.log
  CustomLog ${APACHE_LOG_DIR}/gogs_access.log combined
  SSLEngine On
  SSLCertificateFile /etc/apache2/ssl/crt/gogs.crt
  SSLCertificateKeyFile /etc/apache2/ssl/key/gogs.key
  <Location />
    SSLRequireSSL On
    SSLVerifyClient optional
    SSLVerifyDepth 1
    SSLOptions +StdEnvVars +StrictRequire
  </Location>
  <Directory /var/www/html/gogs/>
    Options +FollowSymLinks
    AllowOverride All
    Require all granted
    <IfModule mod_dav.c>
       Dav off
    </IfModule>
    SetEnv HOME /var/www/html/gogs
    SetEnv HTTP_HOME /var/www/html/gogs
  </Directory>
  ProxyPreserveHost on
  ProxyRequests off
  ProxyPass / http://127.0.0.1:3000
  ProxyPassReverse / http://127.0.0.1:3000
</VirtualHost>

autostart:
  ## add init info for LSB tags and overrides
  $ sudo nano /etc/init.d/gogs
    < /etc/init.d/gogs >
      #!/bin/bash
      ### BEGIN INIT INFO
      # Provides:          gogs
      # Required-Start:    $local_fs $network postgresql
      # Required-Stop:     $local_fs
      # Default-Start:     2 3 4 5
      # Default-Stop:      0 1 6
      # Short-Description: gogs
      # Description:       gogs pop & imap daemon
      ### END INIT INFO
      PID=`id -u user1`
      PIDFILE=/var/run/gogs.pid
      WORKDIR="/opt/gogs"
      CMD=`su $USERNAME - -c "cd $WORKDIR; PATH=$PATH:$WORKDIR gogs web"`
      case "$1" in
        start)
        start-stop-daemon --start --user $PID --pidfile $PIDFILE --chuid $PID --exec $CMD
        ;;
        stop)
        start-stop-daemon --stop --user $PID --pidfile $PIDFILE --chuid $PID
        ;;
      esac
      exit 0

  $ sudo chmod +x /etc/init.d/gogs

  $ sudo nano /lib/systemd/system/gogs.service
    < /lib/systemd/system/gogs.service >
      [Unit]
      Description=Gogs
      After=postgresql.service

      [Service]
      Type=oneshot
      ExecStart=/etc/init.d/gogs start
      RemainAfterExit=no
      User=user1
      Group=user1

      [Install]
      WantedBy=multi-user.target

  $ sudo update-rc.d gogs defaults
  $ sudo systemctl enable gogs

## backup
$ /opt/gogs/gogs backup
$ PGPASSWORD="62oCDajIgcjSXgCumh2A" pg_dump -c -d gogs -U gogsuser -h localhost > /home/user1/Documents/Backups/databases/dump_gogs_`date +%Y-%m-%d`.sql

## restore
$ /opt/gogs/gogs restore
$ psql -d gogs -f /home/user1/Documents/Backups/databases/dump_gogs_`date +%Y-%m-%d`.sql
## $psql gogs < /home/user1/Documents/Backups/databases/dump_gogs_`date +%Y-%m-%d`.sql

## empty repository showing in gogs
## fix: change IS_BARE field of the REPOSITORY table to f
$ psql --host=localhost --dbname=gogs --username=gogsuser --password
psql~$ \d+ repository
psql~$ UPDATE repository SET is_bare = 'f' WHERE is_bare = 't';