#!/bin/bash

VREME="$( date '+%Y%m%d-%H%M%S' )";
SQL_DUMP_PUTANJA="/root/SQL/${VREME}";
mkdir -pv "$SQL_DUMP_PUTANJA";

if [ ! -r "/root/.my.cnf.new" ]; then
SQL_PASS="$( \
if [ -r /root/passwords.txt ]; then sed -ne 's/^MySQL Root Password      : \(.*\)$/\1/p' "/root/passwords.txt"; \
elif [ -r /root/mns_passwords.txt ]; then sed -ne 's/^Mysql Root: \(.*\)$/\1/p' "/root/mns_passwords.txt" ; \
else echo 'ERROR'; exit 13; fi; )";

echo -e "[client]\nhost = localhost\nport = 3306\nuser = root\npassword = $SQL_PASS" | tee -a "/root/.my.cnf.new";
chown -c root:root "/root/.my.cnf.new";
chmod -c 600 "/root/.my.cnf.new";
fi;

mysqldump --defaults-file=/root/.my.cnf.new --skip-extended-insert sentora_core > "${SQL_DUMP_PUTANJA}/sentora_core.sql";

echo;
ls -la "$SQL_DUMP_PUTANJA";

############################################################################################################################################################################


if [ -z "$1" ]; then echo -e "\n# ERROR - no email adress"; exit 1; fi;
LE_EMAIL="$1"



# Унеси email за LE налог код LE
# LE_EMAIL='djordje@egida.rs'


cd /root
wget "http://mns-lebot.tinux.ha.rs/mns-lebot-sentora-setup" -O  "mns-lebot-sentora-setup.ORG"

sed \
-e "/^certbot@ha.rs\$/ s/^certbot@ha.rs\$/${LE_EMAIL}/" \
-e '/^mysqlpasswd=\$(grep Root / s/^mysqlpasswd=\$(grep Root .*$/mysqlpasswd=$(grep Root "$passwords_file" | cut -d ":" -f 2-)/' \
mns-lebot-sentora-setup.ORG > mns-lebot-sentora-setup

chmod -c 755 "mns-lebot-sentora-setup"

./mns-lebot-sentora-setup
if [ "$?" -ne 0 ]; then echo -e "\n# ERROR - MNS lebot install error"; exit 2; fi;
rm -fv mns-lebot-sentora-setup mns-lebot-sentora-setup.ORG

sed -i \
-e '/^[ \t]*mysqlpasswd=\$(grep Root / s/\(^[ \t]*\)mysqlpasswd=\$(grep Root .*$/\1mysqlpasswd=$(grep Root "$passwords_file" | cut -d ":" -f 2-)/' \
/usr/local/mns-lebot/mns-lebot-sentora-post-hook
grep 'mysqlpasswd=' /usr/local/mns-lebot/mns-lebot-sentora-post-hook

sed -i \
-e '/^[ \t]*mysqlpasswd=\$(grep Root / s/^\([ \t]*\)mysqlpasswd=\$(grep Root .*$/\1mysqlpasswd=$(grep Root "$passwords_file" | cut -d ":" -f 2-)/' \
/usr/local/mns-lebot/mns-lebot-sentora-pre-hook
grep 'mysqlpasswd=' /usr/local/mns-lebot/mns-lebot-sentora-pre-hook

# ERROR: Certificate was successfully generated but could not be found! Running post script '/usr/local/mns-lebot/mns-lebot-sentora-post-hook'...
#Tada je resenje:  otidji u "/etc/mns-lebot/". Tamo ces naci konfiguracioni fajl. U njemu promeni "VERBOSITY" na 4 pa ponovo pokreni mns-lebot.

sed -i.backup -e '/^VERBOSITY=/ s/^VERBOSITY=.*$/VERBOSITY=4/' /etc/mns-lebot/mns-lebot.conf


# Генерисање и постављање сертификата за DNS имена

echo 'mns-lebot get domen.com www.domen.com'
echo 'mns-lebot get xn--e1aaobily.xn--90a3ac www.xn--e1aaobily.xn--90a3ac'

