#!/bin/bash

echo -e "\n"
echo -e "************************************************************"
echo -e "*                         Bienvenidos                      *"
echo -e "*   Al ejecutar este Script usted dara acceso a la base de *"
echo -e "*             datos de MariaDB al programa Telecap         *"
echo -e "*    Debe de agregar la IP donde esta instalado Teletax    *"
echo -e "************************************************************"
while [[ $veryfy_info != yes && $veryfy_info != no ]]
do
    read -p "Esta seguro de continuar?? (yes,no) > " veryfy_info 
done

if [ "$veryfy_info" = yes ] ;then
	echo -e "************************************************************"
	echo -e "*              Direccion IP del Capturador                 *"
	echo -e "************************************************************"
	while [[ $ip_teletax == '' ]]
	do
    		read -p "IP Teletax................ > " ip_teletax 
	done 
else
    	exit;
fi

echo -e "************************************************************"
echo -e "*            Creando privilegios en la base de datos       *"
echo -e "************************************************************"
mysql -uroot asterisk -e "GRANT ALL PRIVILEGES ON asterisk.* TO Teletax2010@'$ip_teletax' IDENTIFIED BY 'Teletax2010@@';"
mysql -uroot asterisk -e "ALTER TABLE cdr ADD COLUMN telecap enum('yes','no') DEFAULT 'no';"
echo -e "************************************************************"
echo -e "*              Recuerde configurar el Firewall             *"
echo -e "*              para dar acceso al puerto 3306              *"
echo -e "************************************************************"
echo -e "*              Tambien configurar el archivo:              *"
echo -e "*           /etc/mysql/mariadb.conf.d/50-server.cnf        *"
echo -e "*         Para permitir accesos remoto, cambiando el       *"
echo -e "*                 bind-address = 127.0.0.1                 *"
echo -e "*                          Por                             *"
echo -e "*                 bind-address = 0.0.0.0                   *"
echo -e "************************************************************"
echo -e "*              Y despues reinicia el servicio:             *"
echo -e "*               sudo systemctl restart mariadb             *"
echo -e "************************************************************"
echo -e "*                Ya puede conectar Telecap                 *"
echo -e "************************************************************"