#!/bin/bash

DBNAME=$(/sbin/e-smith/db configuration getprop freepbx DbName)
DBUSER=$(/sbin/e-smith/db configuration getprop freepbx DbUser)
DBPASS=$(/sbin/e-smith/db configuration getprop freepbx DbPassword)
CDRDBNAME=$(/sbin/e-smith/db configuration getprop freepbx CdrDbName)
MANAGERPASSWORD=$(/sbin/e-smith/db configuration getprop freepbx ManagerPassword)
DomainName=$(/sbin/e-smith/db configuration get DomainName)

if [ $(mysqlshow | grep -c $DBNAME) -lt 1 ]; then
        mysql -e "create database $DBNAME CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;"
        mysql -e "grant all privileges on $DBNAME.* to '$DBUSER'@'localhost' identified by '$DBPASS';"
        mysql -e 'flush privileges;'

        if [ -e /usr/share/freepbx/sql/asterisk.sql ]; then
                mysql $DBNAME < /usr/share/freepbx/sql/asterisk.sql
        else
                echo "Error: file /usr/share/freepbx/sql/asterisk.sql doesn't exists"
                exit 1
        fi
fi

if [ $(mysqlshow | grep -c $CDRDBNAME) -lt 1 ]; then
        mysql -e "create database $CDRDBNAME CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;"
        mysql -e "grant all privileges on $CDRDBNAME.* to '$DBUSER'@'localhost' identified by '$DBPASS';"
        mysql -e 'flush privileges;'
        if [ -e /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql ]; then
                mysql $CDRDBNAME < /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql
        else
                echo "Error: file /usr/share/freepbx/sources/freepbx/installlib/SQL/cdr.sql doesn't exists"
                exit 1
        fi
fi

# set user and passwords
/usr/bin/mysql $DBNAME -e "INSERT INTO \`admin\` (\`variable\`, \`value\`) VALUES ('email', 'admin\@$DomainName') ON DUPLICATE KEY UPDATE \`value\` = 'admin\@$DomainName';"
/usr/bin/mysql $DBNAME -e "INSERT INTO \`ampusers\` (\`username\`, \`password_sha1\`, \`extension_low\`, \`extension_high\`, \`deptname\`, \`sections\`) VALUES
('admin', sha1('$MANAGERPASSWORD '), '', '', '', 0x2a) ON DUPLICATE KEY UPDATE \`password_sha1\` = sha1('$ManagerPassword ');"

# Chown dir to allow user asterisk to create its files
chown asterisk:asterisk /var/lib/asterisk

# workaround as freepbx is expecting them in /var not /usr/share
cd /var/lib/asterisk
if [[ ! -d /var/lib/asterisk/documentation ]];  then ln -s /usr/share/asterisk/documentation  ; fi
if [[ ! -d /var/lib/asterisk/moh ]];  then ln -s /usr/share/asterisk/moh  ; fi
if [[ ! -d /var/lib/asterisk/sounds ]];  then ln -s /usr/share/asterisk/sounds/ ; fi
mkdir -p /usr/share/asterisk/sounds/tmp
chown asterisk: /usr/share/asterisk/sounds/tmp
chown asterisk: /usr/share/asterisk/sounds/ /usr/share/asterisk/moh

# Run the install script only if it's a new install
# Upgrades have to be done through freePBX and the online repository
if [ ! -d /opt/freepbx/admin ]; then
    mkdir -p /opt/freepbx
    if [ -e /usr/share/freepbx/sources/freepbx/ ]; then
        cd /usr/share/freepbx/sources/freepbx/
	echo "Starting Asterisk..." > /root/freepbx_install.log
        ./start_asterisk start >> /root/freepbx_install.log 2>&1
	echo "" >> /root/freepbx_install.log
	echo "Installing FreePBX..." >> /root/freepbx_install.log
	echo "a" | ./install --webroot="/opt/freepbx" \
		--dbengine="mysql" --dbname="freepbxdb" --dbuser="freepbxuser" --dbpass="$DBPASS" -n \
		--cdrdbname="$CDRDBNAME" --astmoddir=/usr/lib64/asterisk/modules/ \
		--astagidir=/usr/share/asterisk/agi-bin/ --ampsbin=/usr/sbin --ampcgibin=/opt/freepbx/cgi-bin \
		>> /root/freepbx_install.log 2>&1
	else
		echo "error: /usr/share/freepbx/sources/freepbx/ doesn't exists"
		exit 1
	fi
else
    if [ -x /var/lib/asterisk/bin/freepbx_engine ]; then
	/var/lib/asterisk/bin/freepbx_engine chown > /dev/null 2>&1
    else
	echo "error: /var/lib/asterisk/bin/freepbx_engine is not executable"
        exit 1
    fi
    if [ -x /var/lib/asterisk/bin/retrieve_conf ]; then
        /var/lib/asterisk/bin/retrieve_conf > /dev/null 2>&1
    else
        echo "error: /var/lib/asterisk/bin/freepbx_engine is not executable"
        exit 1
    fi
fi

if [ ! -d /opt/freepbx/digium_phones ]; then
    mkdir -p /opt/freepbx/digium_phones
    chown asterisk:asterisk /opt/freepbx/digium_phones
fi

# update modules
/usr/sbin/fwconsole ma upgrade framework
/usr/sbin/fwconsole ma upgradeall -R standard -R extended
/usr/sbin/fwconsole ma refreshsignatures
/usr/sbin/fwconsole ma downloadinstall userman certman ucp
exit 0 
