← Back to branch summary

~openstack-charm-testers/+junk/neutron-snabbswitch

« back to all changes in this revision

Viewing changes to db-grant-check.sh

  • Committer: Edward Hope-Morley
  • Date: 2015-05-12 08:49:33 UTC
  • Revision ID: edward.hope-morley@canonical.com-20150512084933-ll0olnott54l1bjx
updates for 2015.5 build

Show diffs side-by-side

added added

removed removed

Lines of Context:
db-grant-check.sh
1
 
#!/bin/bash -eu
2
 
if (($#<1)); then
3
 
    echo "ERROR: need db type [mysql|percona]"
4
 
    exit 1
5
 
fi
6
 
db_type="$1"
7
 
 
8
 
echo "Installing percona-toolkit (used for mysql and percona)"
9
 
juju ssh db/0 sudo apt-get install percona-toolkit --yes &>/dev/null
10
 
 
11
 
if [ "$db_type" = "mysql" ]; then
12
 
    juju ssh db/0 'mysql -uroot -p`sudo cat /var/lib/mysql/mysql.passwd` -e "show databases;"'
13
 
fi
14
 
 
15
 
echo "Checking grants"
16
 
for db in cinder neutron glance nova keystone; do
17
 
    echo -e "\n== $db =="
18
 
    if [ "$db_type" = "percona" ]; then
19
 
        juju ssh db/0 pt-show-grants -uroot -pagoodpassword| grep $db
20
 
    else
21
 
        juju ssh db/0 'pt-show-grants -uroot -p`sudo cat /var/lib/mysql/mysql.passwd`'| grep $db
22
 
    fi
23
 
    echo -e "\nNext? [ENTER]"
24
 
    read
25
 
done
26