serverあれこれ: VagrantでEspoCRM、MySQLをインストールした仮想マシン(Ubuntu16.04)を構築する

EspoCRMはPHP製のCRMソフトウェアです。
以下のVagrantfileを使用して、EspoCRM、MySQLがインストールされた仮想マシン(Ubuntu16.04)を構築する事ができます。
仮想マシン構築後、http://192.168.55.105/にアクセスして初期設定を行います。

Vagrantfile

VAGRANTFILE_API_VERSION = "2"

Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
  config.vm.box = "bento/ubuntu-16.04"
  config.vm.hostname = "ub1604espocrm"
  config.vm.provider :virtualbox do |vbox|
     vbox.name = "ub1604espocrm"
     vbox.cpus = 2
     vbox.memory = 2048
     vbox.customize ["modifyvm", :id, "--nicpromisc2","allow-all"]
  end
config.vm.network "private_network", ip: "192.168.55.105", :netmask => "255.255.255.0"
config.vm.network "public_network", ip:"192.168.1.105", :netmask => "255.255.255.0"
  config.vm.provision "shell", inline: <<-SHELL
# update packages
apt-get update
#DEBIAN_FRONTEND=noninteractive apt-get -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" upgrade


# install mysql
echo "mysql-server-5.7 mysql-server/root_password password root" | sudo debconf-set-selections
echo "mysql-server-5.7 mysql-server/root_password_again password root" | sudo debconf-set-selections
apt-get -y install mysql-server-5.7
mysql -uroot -proot -e "CREATE DATABASE espocrm DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER espocrm@localhost IDENTIFIED BY 'espocrm';"
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON espocrm.* TO 'espocrm'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"


# install EspoCRM
apt-get -y install apache2 libapache2-mod-php7.0 php7.0 php7.0-mysql php7.0-mbstring php7.0-xml php7.0-gd php7.0-zip php7.0-curl unzip php7.0-mcrypt php7.0-json php7.0-imap

wget https://www.espocrm.com/downloads/EspoCRM-5.0.5.zip
unzip EspoCRM-5.0.5.zip
mv EspoCRM-5.0.5 /opt/espocrm
sed -i -e 's/upload_max_filesize = 2M/upload_max_filesize = 20M/'  /etc/php/7.0/apache2/php.ini
sed -i -e 's#;date.timezone =#date.timezone = Asia/Tokyo#'  /etc/php/7.0/apache2/php.ini
sed -i -e 's#max_execution_time = 30#max_execution_time = 180#'  /etc/php/7.0/apache2/php.ini
sed -i -e 's#max_input_time = 60#max_input_time = 180#'  /etc/php/7.0/apache2/php.ini
sed -i -e 's#memory_limit = 128M#memory_limit = 256M#'  /etc/php/7.0/apache2/php.ini
sed -i -e 's#post_max_size = 8M#post_max_size = 20M#'  /etc/php/7.0/apache2/php.ini


chown -R www-data:www-data /opt/espocrm
#ln -s  /opt/espocrm /var/www/html
cat << EOF > /etc/apache2/sites-available/espocrm.conf
<VirtualHost *:80>
    ServerName 192.168.55.105
    DocumentRoot /opt/espocrm
    <Directory /opt/espocrm>
        AllowOverride All
        Require all granted
    </Directory>
</VirtualHost>
EOF
a2enmod rewrite
a2ensite espocrm.conf
a2dissite 000-default.conf
systemctl restart apache2.service

echo '* * * * * cd /opt/espocrm; /usr/bin/php -f cron.php > /dev/null 2>&1' >> /var/spool/cron/crontabs/www-data

echo 'access http://192.168.55.105/'
SHELL
end

○EspoCRMの初期設定画面1