install-matomo.sh

#!/bin/bash 

#Colours
#RED="\033[31m"
#GREEN="\033[32m"
#BLUE="\033[34m"
#RESET="\033[0m"

#my prep
echo -e "\033[32mInstall some of my favorite general packages\033[0m"
yum update -y
yum install -y vim wget centos-release-scl

#install required packages
echo -e "\033[32mNow packages you need for Matomo\033[0m"
yum install -y rh-php71-php rh-php71-php-mysqlnd rh-php71-php-mbstring\
                rh-php71-php-dom rh-php71-php-xml rh-php71-php-gd sclo-php71-php-pecl-geoip rh-php71-php-devel\
                httpd24-httpd httpd24-mod_ssl httpd24-mod_proxy_html\
                mariadb-server mariadb

#download and prepare matomo
echo -e "\033[32mDonload and prepare latest version of Matomo package\033[0m"
wget https://builds.piwik.org/piwik.tar.gz
tar -xvf piwik.tar.gz
mkdir -p piwik/tmp/{assets,cache,logs,tcpdf,templates_c}
cp -r piwik /opt/rh/httpd24/root/var/www/matomo
cp -v CONF/httpd/matomo.conf /opt/rh/httpd24/root/etc/httpd/conf.d/
chown -R apache:apache /opt/rh/httpd24/root/var/www/matomo
chmod -R 0755 /opt/rh/httpd24/root/var/www/matomo/tmp

#Selinux config mode update to permissive

echo -e "\033[32mFor apache to work properly with ssl, change the mode to permissive"
echo -e "Press any key to update the config file or Ctrl-c to exit.\033[0m"
read -n1
echo
sed -i 's/^SELINUX=.*/SELINUX=permissive/' /etc/selinux/config && echo SUCCESS || echo FAILURE


#copy your ssl certificates
echo -e "For SSL certificates to work properly you need to copy the certificate files into the right location. I assume you have them in below addresses:"
echo -e "certificate file: /etc/pki/tls/certs/your_cert_file.crt"
echo -e "certificate key file: /etc/pki/tls/private/your_private_key_file.key"

read -p "Enter the ssl certification file name (localhost.crt):" ssl_crt
ssl_crt=${ssl_crt:-"localhost.crt"}
read -p "Enter the ssl certification private key file name (localhost.key):" ssl_key
ssl_key=${ssl_key:-"localhost.key"}

read -p "Enter your server address (youraddress.com):" server_add
server_add=${server_add:-"youraddress.com"}


sed -i "s|SSLCertificateFile.*|SSLCertificateFile /etc/pki/tls/certs/$ssl_crt|" /opt/rh/httpd24/root/etc/httpd/conf.d/matomo.conf  && echo "cert info added to matomo.conf file successfully" || echo "cert info update on matomo.conf file failed"
sed -i "s|SSLCertificateKeyFile.*|SSLCertificateKeyFile /etc/pki/tls/private/$ssl_key|" /opt/rh/httpd24/root/etc/httpd/conf.d/matomo.conf  && echo "ssl key info added to matomo.conf file successfully" || echo "ssl key info update on matomo.conf file failed"
sed -i "s|ServerName.*|ServerName $server_add|" /opt/rh/httpd24/root/etc/httpd/conf.d/matomo.conf  && echo "ServerName added to matomo.conf file successfully" || echo "ServerName update on matomo.conf file failed"
sed -i "s|ServerAlias.*|ServerAlias $server_add|" /opt/rh/httpd24/root/etc/httpd/conf.d/matomo.conf  && echo "ServerAlias added to matomo.conf file successfully" || echo "ServerAlias update on matomo.conf file failed"

echo "\033[32mWe are going to run the servers and services\033[0m"
systemctl enable httpd24-httpd mariadb
systemctl start httpd24-httpd
systemctl start mariadb
mysql_secure_installation


#prepare database: create database, user and grant permissions to the user
echo "now time to prepare the database. Keep record of your answers to next step questions. You will need them later when starting your server on GUI"
read -sp "What is your MariaDB root password: " db_root_pwd
echo
read -p "Enter the Matomo user name you want to create: (matomo_user) " matomo_user
matomo_user=${matomo_user:-matomo_user}
read -sp "Enter the new Matomo user password: " matomo_usr_pwd
echo
read -p "Enter the Matomo database you want to create (matomo_db) : " matomo_db
matomo_db=${matomo_db:-matomo_db}
mysql -u root -p$db_root_pwd -ve"CREATE DATABASE $matomo_db;"
mysql -u root -p$db_root_pwd -ve"CREATE USER '$matomo_user'@'localhost' IDENTIFIED BY '$matomo_usr_pwd';"
mysql -u root -p$db_root_pwd -ve"GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON $matomo_db.* TO '$matomo_user'@'localhost';"

echo -e "\033[32mGreat!!! Matomo installation completed successfully."
echo "Your system needs to be rebooted before you can continue to setup your system from GUI."
echo "After restart you need to complete the setup from a web browser. Navigate to: https://your-server-name.com"
echo -e "\033[31m=======Press Any Key to reboot the system!!!!!!!========\033[0m"
read -n1
echo
reboot