1 # This template installs MariaDB and all dependencies needed for importing from phpBB3.
4 home: /var/www/discourse
22 path: /etc/apt/preferences.d/mariadb
25 Pin: release o=MariaDB
29 path: /etc/mysql/conf.d/import.cnf
32 # disable InnoDB since it is extremly slow in Docker container
33 default-storage-engine=MyISAM
34 default-tmp-storage-engine=MyISAM
37 datadir=/shared/import/mysql/data
44 - mkdir -p /shared/import/mysql/data
45 - apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
46 - add-apt-repository 'deb [arch=amd64,i386] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.1/ubuntu xenial main'
47 - apt-get update && DEBIAN_FRONTEND=noninteractive apt-get install -y nano libmariadbclient-dev mariadb-server
48 - sed -Ei 's/^log/#&/' /etc/mysql/my.cnf
51 path: /etc/service/mysql/run
55 # Make sure the datadir exists, is accessible and contains all system tables
56 mkdir -p /shared/import/mysql/data
57 chown mysql -R /shared/import/mysql/data
58 /usr/bin/mysql_install_db --user=mysql
60 # Shamelessly copied from http://smarden.org/runit1/runscripts.html#mysql
62 exec /usr/sbin/mysqld -u mysql
65 path: /etc/runit/3.d/99-mysql
72 path: /usr/local/bin/import_phpbb3.sh
76 chown discourse /shared/import/settings.yml
77 chown discourse -R /shared/import/data
79 if [ -f "/shared/import/data/phpbb_mysql.sql" ]; then
80 if [ ! -f "/shared/import/mysql/imported" ]; then
81 echo "Loading database dump into MySQL..."
82 mysql -uroot -e "DROP DATABASE IF EXISTS phpbb"
83 mysql -uroot -e "CREATE DATABASE phpbb"
84 mysql -uroot --default-character-set=utf8 --database=phpbb < /shared/import/data/phpbb_mysql.sql
85 touch /shared/import/mysql/imported
92 echo "The phpBB3 import is starting..."
94 su discourse -c 'bundle exec ruby script/import_scripts/phpbb3.rb /shared/import/settings.yml'
99 - mkdir -p /shared/import/data
100 - chown discourse -R /shared/import
101 - cp -n script/import_scripts/phpbb3/settings.yml /shared/import/settings.yml
107 - echo "gem 'mysql2'" >> Gemfile
108 - echo "gem 'ruby-bbcode-to-md', :github => 'nlalonde/ruby-bbcode-to-md'" >> Gemfile
109 - su discourse -c 'bundle install --no-deployment --without test --without development --path vendor/bundle'