templates/import/phpbb3.template.yml

   1 # This template installs MariaDB and all dependencies needed for importing from phpBB3.
   2
   3 params:
   4   home: /var/www/discourse
   5
   6 hooks:
   7   after_web_config:
   8     - exec:
   9         cd: /etc/service
  10         cmd:
  11           - rm -R unicorn
  12           - rm -R nginx
  13           - rm -R cron
  14
  15     - exec:
  16         cd: /etc/runit/3.d
  17         cmd:
  18           - rm 01-nginx
  19           - rm 02-unicorn
  20
  21     - file:
  22         path: /etc/apt/preferences.d/mariadb
  23         contents: |
  24           Package: *
  25           Pin: release o=MariaDB
  26           Pin-Priority: 1000
  27
  28     - file:
  29         path: /etc/mysql/conf.d/import.cnf
  30         contents: |
  31           [mysqld]
  32           # disable InnoDB since it is extremly slow in Docker container
  33           default-storage-engine=MyISAM
  34           default-tmp-storage-engine=MyISAM
  35           innodb=OFF
  36           sql_mode=NO_AUTO_CREATE_USER
  37
  38           datadir=/shared/import/mysql/data
  39
  40           skip-host-cache
  41           skip-name-resolve
  42
  43     - exec:
  44         cmd:
  45           - mkdir -p /shared/import/mysql/data
  46           - apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
  47           - add-apt-repository 'deb [arch=amd64,i386] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial main'
  48           - apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y nano libmariadbclient-dev mariadb-server
  49           - sed -Ei 's/^log/#&/' /etc/mysql/my.cnf
  50
  51     - file:
  52         path: /etc/service/mysql/run
  53         chmod: "+x"
  54         contents: |
  55           #!/bin/bash
  56           # Make sure the datadir exists, is accessible and contains all system tables
  57           mkdir -p /shared/import/mysql/data
  58           chown mysql -R /shared/import/mysql/data
  59           /usr/bin/mysql_install_db --user=mysql
  60
  61           # Shamelessly copied from http://smarden.org/runit1/runscripts.html#mysql
  62           exec 2>&1
  63           exec /usr/sbin/mysqld -u mysql
  64
  65     - file:
  66         path: /etc/runit/3.d/99-mysql
  67         chmod: "+x"
  68         contents: |
  69           #!/bin/bash
  70           sv stop mysql
  71
  72     - file:
  73         path: /usr/local/bin/import_phpbb3.sh
  74         chmod: "+x"
  75         contents: |
  76           #!/bin/bash
  77           set -e
  78
  79           chown discourse /shared/import/settings.yml
  80           chown discourse -R /shared/import/data
  81
  82           if [ -f "/shared/import/data/phpbb_mysql.sql" ]; then
  83             if [ -f "/shared/import/mysql/imported" ] && ! sha256sum --check /shared/import/mysql/imported &>/dev/null ; then
  84               echo "Checksum of database dump changed..."
  85               rm /shared/import/mysql/imported
  86             fi
  87
  88             if [ ! -f "/shared/import/mysql/imported" ]; then
  89               echo "Loading database dump into MySQL..."
  90               mysql -uroot -e "DROP DATABASE IF EXISTS phpbb"
  91               mysql -uroot -e "CREATE DATABASE phpbb"
  92               mysql -uroot --default-character-set=utf8 --database=phpbb < /shared/import/data/phpbb_mysql.sql
  93               sha256sum /shared/import/data/phpbb_mysql.sql > /shared/import/mysql/imported
  94             fi
  95           else
  96             sv stop mysql
  97           fi
  98
  99           cd $home
 100           echo "The phpBB3 import is starting..."
 101           echo
 102           su discourse -c 'bundle exec ruby script/import_scripts/phpbb3.rb /shared/import/settings.yml'
 103
 104     - exec:
 105         cd: $home
 106         cmd:
 107           - mkdir -p /shared/import/data
 108           - chown discourse -R /shared/import
 109           - cp -n script/import_scripts/phpbb3/settings.yml /shared/import/settings.yml
 110
 111   after_bundle_exec:
 112     - exec:
 113         cd: $home
 114         cmd:
 115           - echo "gem 'mysql2'" >> Gemfile
 116           - echo "gem 'ruby-bbcode-to-md', :github => 'nlalonde/ruby-bbcode-to-md'" >> Gemfile
 117           - su discourse -c 'bundle install --no-deployment --path vendor/bundle --jobs 4 --without test development'