#!/bin/bash

cp -r /home/mwconfig/ssh/* /etc/ssh
sed -i 's/^PasswordAuthentication no/PasswordAuthentication yes/g' /etc/ssh/sshd_config
sed -i 's/#PasswordAuthentication yes/PasswordAuthentication yes/g' /etc/ssh/sshd_config

rm -f /var/run/nologin /etc/nologin

sed -i 's/account    required     pam_nologin.so/# account    required     pam_nologin.so/g' /etc/pam.d/sshd

killall sshd
/usr/sbin/sshd

for FILE in `ls -1 /home/mwconfig/init/*.sql | sort -g`
do
    echo "CONNECT TO MWCONFIG~" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE~" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -td~ -qvf /tmp/migrate.sql"
done

TEMP=""

# for FILE in /home/mwconfig/storeprocedure/merge*.db2
for FILE in `ls -1 /home/mwconfig/storeprocedure/*.db2 | sort -g`
do
    TEMP+="echo $FILE;"
    TEMP+="db2 -td@ -f $FILE;"
done

TEMP=${TEMP%;}

su - db2inst1 -c "db2 connect to mwconfig > /dev/null 2>&1;
                  db2 set schema mwconfig > /dev/null 2>&1;
                  $TEMP; 
                  db2 terminate > /dev/null 2>&1;"

for FILE in `ls -1 /home/mwconfig/migration/*.sql | sort -g`
do
    echo "CONNECT TO MWCONFIG;" > /tmp/migrate.sql
    cat $FILE >> /tmp/migrate.sql
    echo -e "\n\nTERMINATE;" >> /tmp/migrate.sql
    su - db2inst1 -c "db2 -qtvf /tmp/migrate.sql"
done
touch /var/migrate.done