#! /bin/bash

sudo apt update -y
sudo apt upgrde -y

sudo apt install mysql-server mysql-client -y

echo "Enter password for zabbix user and press ENTER"
read -s zabbix_password
echo "Enter password for root MYSQL user and press ENTER"
sudo mysql -u root -p <<EOF
CREATE DATABASE zabbix character set utf8 collate utf8_bin;
GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@localhost IDENTIFIED BY '$zabbix_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EOF

sudo apt install apache2 -y

sudo apt install php-mbstring php-bcmath php-xml -y

sudo service apache2 reload

sudo wget http://repo.zabbix.com/zabbix/3.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.4-1+xenial_all.deb
sudo dpkg -i zabbix-release_3.4-1+xenial_all.deb
sudo apt-get update -y

sudo apt-get install zabbix-server-mysql -y
sudo apt-get install zabbix-frontend-php -y

sudo sed -i -E "s|.*php_value date.timezone.+|php_value date.timezone Europe/Moscow|" /etc/apache2/conf-available/zabbix.conf

sudo service apache2 reload

cd /usr/share/doc/zabbix-server-mysql
sudo gzip -d create.sql.gz
sudo mysql -u zabbix -p$zabbix_password zabbix < create.sql

# sudo sed -e -i -E "s|.*DBHost=.*|DBHost=localhost|; s|.*DBName=.*|DBName=zabbix|; s|.*DBUser=.*|DBUser=zabbix|; s|.*DBPassword=.*|DBPassword=$zabbix_password|" /etc/zabbix/zabbix_server.conf
sudo sed -i -E "s|.*DBHost=.*|DBHost=localhost|" /etc/zabbix/zabbix_server.conf
sudo sed -i -E "s|.*DBName=.*|DBName=zabbix|" /etc/zabbix/zabbix_server.conf
sudo sed -i -E "s|.*DBUser=.*|DBUser=zabbix|" /etc/zabbix/zabbix_server.conf
sudo sed -i -E "s|.*DBPassword=.*|DBPassword=$zabbix_password|" /etc/zabbix/zabbix_server.conf

sudo service zabbix-server start