~gandelman-a/charms/quantal/mysql/trunk

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#!/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