run.sh

#!/bin/bash

# temp. start mysql to do all the install stuff
/usr/bin/mysqld_safe > /dev/null 2>&1 &

# ensure mysql is running properly
sleep 20 

# install pimcore if needed
if [ ! -d /var/www/pimcore ]; then
  # download & extract
  cd /var/www
  rm -r /var/www/*
  sudo -u www-data wget https://www.pimcore.org/download/pimcore-data.zip -O /tmp/pimcore.zip 
  sudo -u www-data unzip /tmp/pimcore.zip -d /var/www/
  rm /tmp/pimcore.zip 
  
  # create demo mysql user
  mysql -u root -e "CREATE USER 'pimcore_demo'@'%' IDENTIFIED BY 'secretpassword';"
  mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'pimcore_demo'@'%' WITH GRANT OPTION;"
  
  # setup database 
  mysql -u pimcore_demo -psecretpassword -e "CREATE DATABASE pimcore_demo_pimcore charset=utf8mb4;"; 
  mysql -u pimcore_demo -psecretpassword pimcore_demo_pimcore < /var/www/pimcore/modules/install/mysql/install.sql
  mysql -u pimcore_demo -psecretpassword pimcore_demo_pimcore < /var/www/website/dump/data.sql
  
  # 'admin' password is 'demo' 
  mysql -u pimcore_demo -psecretpassword -D pimcore_demo_pimcore -e "UPDATE users SET id = '0' WHERE name = 'system'"
  
  sudo -u www-data mv /var/www/website/var/config/system.template.php /var/www/website/var/config/system.php
  sudo -u www-data cp /tmp/cache.php /var/www/website/var/config/cache.php
  
  sudo -u www-data php /var/www/pimcore/cli/console.php reset-password -u admin -p demo
fi

# stop temp. mysql service
mysqladmin -uroot shutdown

exec supervisord -n