~clint-fewbar/charms/precise/mysql/trunk

#!/bin/sh

 

ROOTARGS="-uroot -p`cat /var/lib/juju/mysql.passwd`"

remote_ip=`relation-get ip`

mysql $ROOTARGS -e "REVOKE PRIVILEGES ON *.* FROM `$JUJU_REMOTE_UNIT`@`$remote_ip`"

# find allow lines

for aline in `augtool ls /files/etc/apache2/sites-available/default/VirtualHost/Directory[2]|grep " = allow"|cut -d' ' -f1` ; do

  ip=`augtool get /files/etc/apache2/sites-available/default/VirtualHost/Directory[2]/$aline/arg[2]`

  if [ "$ip" = "$remote_ip/32" ] ; then

    echo -e "rm /files/etc/apache2/sites-available/default/VirtualHost/Directory[2]/$aline\nsave" | augtool -b

    echo removed $aline from /files/etc/apache2/sites-available/default/VirtualHost/Directory[2]

    service apache2 reload

    break

  fi

done