#!/bin/sh
export THIS_DIR="$(cd "$( dirname "$0" )" && pwd )"
. $THIS_DIR/../../sysbase/tools/export_php_config_to_shell.sh

#create database
API_DB_NAME=api_ws_log
echo "create database IF NOT EXISTS $API_DB_NAME" | mysql -f -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD 2> /dev/null

#create table
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/default_log_schema.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/default_log.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z01.sql"      2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z01a.sql"     2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z01b.sql"     2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z01b_d.sql"   2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z05.sql"      2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z05_orggroup.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z05_push.sql" 2> /dev/null
mysql -h $API_DB_HOST -u $API_DB_USER --password=$API_DB_PASSWD $API_DB_NAME < "$THIS_DIR/mysql/ws_z06.sql"      2> /dev/null

if [ -d /var/log/api/api_ws_log/ ];then
    chown apache:apache -R /var/log/api/api_ws_log/
fi

# To recursively give directories read&execute privileges:
find /var/log/api/api_ws_log -type d -exec chmod 755 {} +

mkdir -p /var/log/api_ws_logfile
chown apache:apache /var/log/api_ws_logfile/

mkdir -p /var/log/api_ws_logfile/others/
chown apache:apache /var/log/api_ws_logfile/others/

if [ -d /var/log/api_ws_logfile/others/ ];then
    chown apache:apache /var/log/api_ws_logfile/others/

    # To recursively give directories read&execute privileges:
    find /var/log/api_ws_logfile/others -type d -exec chmod 755 {} +
fi

#stop daemons
/bin/sh $THIS_DIR/killall_api_ws_log_collector.sh

rm -rf /var/lock/api_ws_log_rpm.lock

#start daemons
#待五分鐘後會自動執行 /etc/cron.per5min/api_ws_log_collector.sh