#!/bin/bash
. /var/lib/pacemaker-cloud/dep-wp/novacreds/novarc

MYSQL_IMAGE=`euca-describe-images | grep assy-wordpress-mysql-F16 | cut -f2`
MYSQL_IP=`euca-describe-instances | grep $MYSQL_IMAGE | cut -f4`
WORDPRESS_IMAGE=`euca-describe-images | grep assy-wordpress-F16 | cut -f2`
WORDPRESS_IP=`euca-describe-instances | grep $WORDPRESS_IMAGE | cut -f4`

echo "  MySql IP:     $MYSQL_IP"
echo "  Wordpress IP: $WORDPRESS_IP"

# configure wordpress
ssh root@$WORDPRESS_IP -i /var/lib/pacemaker-cloud/keys/assy-wordpress-F16 -o StrictHostKeyChecking=no \
    'cp /usr/share/wordpress/wp-config.orig /usr/share/wordpress/wp-config.php
     sed -i -e s/assy-wordpress-mysql-F16/'$MYSQL_IP'/ /usr/share/wordpress/wp-config.php'

cat > /tmp/mysql_wordpress_sec << EOF
GRANT ALL PRIVILEGES ON wordpress_database.* TO "wordpress_user"@"$WORDPRESS_IP"
IDENTIFIED BY "wordpress_password";
FLUSH PRIVILEGES;
use wordpress_database;
update wp_options set option_value="http://$WORDPRESS_IP/wordpress" where option_name="siteurl";
EXIT
EOF
scp -q -i /var/lib/pacemaker-cloud/keys/assy-wordpress-mysql-F16 -o StrictHostKeyChecking=no /tmp/mysql_wordpress_sec root@$MYSQL_IP:/tmp/mysql_wordpress_sec
ssh root@$MYSQL_IP -i /var/lib/pacemaker-cloud/keys/assy-wordpress-mysql-F16 -o StrictHostKeyChecking=no \
    'cat /tmp/mysql_wordpress_sec | mysql || { service mysqld restart; cat /tmp/mysql_wordpress_sec | mysql; }'