summaryrefslogtreecommitdiffstats
path: root/compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2
diff options
context:
space:
mode:
authorbaigk <baiguoku@huawei.com>2015-06-11 14:13:24 +0800
committerbaigk <baiguoku@huawei.com>2015-06-16 10:40:49 +0800
commit12019717d3be5b4cfa42751cd19cbd42f82bc04a (patch)
tree66f3c45485439dbd3f26c0c77a079344536cec91 /compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2
parenteb887812da568cfb4908f6ae14449b2ceaeb5bc0 (diff)
Add openstack HA installer code with ansible for compass adapter
patch 2: add service monitor and adjust monitor timelen BGS-25 Change-Id: I4239576b3888a0a7f6b697fe7fffffb677ef7dab Signed-off-by: baigk <baiguoku@huawei.com>
Diffstat (limited to 'compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2')
-rw-r--r--compass/deploy/ansible/openstack_juno/roles/database/templates/data.j239
1 files changed, 39 insertions, 0 deletions
diff --git a/compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2 b/compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2
new file mode 100644
index 0000000..c894b32
--- /dev/null
+++ b/compass/deploy/ansible/openstack_juno/roles/database/templates/data.j2
@@ -0,0 +1,39 @@
+#!/bin/sh
+mysql -uroot -Dmysql <<EOF
+drop database if exists keystone;
+drop database if exists glance;
+drop database if exists neutron;
+drop database if exists nova;
+drop database if exists cinder;
+
+CREATE DATABASE keystone;
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON keystone.* TO 'keystone'@'{{ host }}' IDENTIFIED BY '{{ KEYSTONE_DBPASS }}';
+{% endfor %}
+
+CREATE DATABASE glance;
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON glance.* TO 'glance'@'{{ host }}' IDENTIFIED BY '{{ GLANCE_DBPASS }}';
+{% endfor %}
+
+CREATE DATABASE neutron;
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON neutron.* TO 'neutron'@'{{ host }}' IDENTIFIED BY '{{ NEUTRON_DBPASS }}';
+{% endfor %}
+
+CREATE DATABASE nova;
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON nova.* TO 'nova'@'{{ host }}' IDENTIFIED BY '{{ NOVA_DBPASS }}';
+{% endfor %}
+
+CREATE DATABASE cinder;
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON cinder.* TO 'cinder'@'{{ host }}' IDENTIFIED BY '{{ CINDER_DBPASS }}';
+{% endfor %}
+
+{% if WSREP_SST_USER is defined %}
+{% for host in ['%', 'localhost', inventory_hostname] %}
+GRANT ALL ON *.* TO '{{ WSREP_SST_USER }}'@'{{ host }}' IDENTIFIED BY '{{ WSREP_SST_PASS }}';
+{% endfor %}
+{% endif %}
+EOF