#!/bin/bash
a=`mysql -uroot -ppassw0rd asterisk <<EOF
SHOW DATABASES;
EOF`

echo "Auto-generating /etc/odbc.ini and /etc/asterisk/res_odbc.conf for the following databases:" 
echo ${a:28}

cd /root
echo "" > odbc.ini
echo "" > res_odbc.conf
for DB in ${a:28}
do

  echo "[MySQL-$DB]" >> odbc.ini
  echo "Description     = $DB MySQL ODBC" >> odbc.ini
  echo "Driver          = MySQL" >> odbc.ini
  echo "Socket          = /var/lib/mysql/mysql.sock" >> odbc.ini
  echo "Server          = localhost" >> odbc.ini
  echo "User            = root" >> odbc.ini
  echo "Password        = passw0rd" >> odbc.ini
  echo "Database        = $DB" >> odbc.ini
  echo "Option          = 3" >> odbc.ini
  echo " " >> odbc.ini

  echo "[MySQL-$DB]" >> res_odbc.conf
  echo "enabled => yes" >> res_odbc.conf
  echo "dsn => MySQL-$DB" >> res_odbc.conf
  echo "username => root" >> res_odbc.conf
  echo "password => passw0rd" >> res_odbc.conf
  echo "preconnect => yes" >> res_odbc.conf
  echo " " >> res_odbc.conf

done

cp /etc/odbc.ini /etc/odbc.old
sed '1d' odbc.ini > /etc/odbc.ini

cp /etc/asterisk/res_odbc.conf /etc/asterisk/res_odbc.conf.old
sed '1d' res_odbc.conf > /etc/asterisk/res_odbc.conf
chown asterisk:asterisk /etc/asterisk/res_odbc.conf
chmod 664 /etc/asterisk/res_odbc.conf

amportal restart

echo " "
echo " "
echo "Contents of /etc/odbc.ini..."
echo " "
cat /etc/odbc.ini
echo " "
echo "--------------------------"
echo " "
echo "Contents of /etc/asterisk/res_odbc.conf..."
echo " "
cat res_odbc.conf

echo "Done."