#!/bin/bash
## Variaveis
dbUserZbx=zabbix
dbRootPass=zabbix
dbZbxPass=zabbix
dbUserRoot=root
dbSchemaZbx=zabbix
fileConfNginx="/vagrant/nginx/nginx"
fileConfPhpFpm="/vagrant/nginx/php-fpm.d/zabbix.conf"
dirBackupSql="/vagrant/sqlexa/schema_zabbix_20180621.sql"
zbxWebFile="/etc/zabbix/web/"
phpLibDir="/var/lib/php/zabbix_php-fpm/"
phpConfDir="/etc/php-fpm.d/"
phpConfPhpIni="/vagrant/php/php.ini"
zbxWebConfFile="/vagrant/zabbix/conf/zabbix.conf.php"

#Adicionando Repositórios:
sudo rpm -ivh https://repo.zabbix.com/zabbix/3.4/rhel/7/x86_64/zabbix-release-3.4-2.el7.noarch.rpm
sudo yum-config-manager --enable rhel-7-server-optional-rpms

# Instalação do Server/Front/Agent
sudo yum install zabbix-server-mysql  zabbix-web-mysql zabbix-agent -y

#------------- MariaDB -------------#
#criando repositorio MariaDB.repo
sudo cat >  /etc/yum.repos.d/MariaDB.repo <<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF

#instalando MariaDB
sudo yum update -y
sudo yum install MariaDB-server MariaDB-client -y

#Iniciando e habilitando o serviço
sudo systemctl start mysql
sudo systemctl enable mysql

#Removendo usuário anonymous
sudo mysql -u root <<-EOF
UPDATE mysql.user SET Password=PASSWORD('$dbRootPass') WHERE User='root';
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.db WHERE Db='test' OR Db='test_%';
FLUSH PRIVILEGES;
EOF

#Criando database para zabbix
sudo mysql -u"${dbUserRoot}" -p"${dbRootPass}" <<MY_QUERY
create database zabbix character set utf8 collate utf8_bin;
grant all privileges on zabbix.* to zabbix@localhost identified by '${dbZbxPass}';
MY_QUERY

#Exportando o backup
sudo mysql -p$dbRootPass -u$dbUserRoot $dbSchemaZbx < $dirBackupSql

#------------- Nginx -------------#

#Install epel-releases
sudo yum install epel-release -y
sudo yum install nginx php-fpm php-common -y

#Remover e copiar os arquivos do Nginx
sudo rm -rf /etc/nginx/*
sudo cp -r $fileConfNginx /etc/

#PHP-FPM
sudo mkdir $phpLibDir
sudo chmod 770 $phpLibDir
sudo chown root:nginx $phpLibDir
sudo chown nginx:nginx $zbxWebFile
sudo cp $fileConfPhpFpm $phpConfDir

#iniciando e habilitando
sudo systemctl enable nginx
sudo systemctl enable php-fpm

#------------- Zabbix Front -------------#
sudo rm /etc/php.ini
sudo cp $phpConfPhpIni /etc/php.ini
sudo cp $zbxWebConfFile /etc/zabbix/web/
sudo systemctl restart php-fpm
sudo systemctl restart nginx

#------------- Zabbix -------------#