aboutsummaryrefslogtreecommitdiffstats
path: root/deploy/adapters/ansible/openstack_newton_xenial/roles/database/templates/data.j2
blob: 66c2fead6b15fb744e561e4461a7a07c227db208 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
#!/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;
drop database if exists heat;
drop database if exists aodh;

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 %}

CREATE DATABASE heat;
{% for host in ['%', 'localhost', inventory_hostname] %}
GRANT ALL ON heat.* TO 'heat'@'{{ host }}' IDENTIFIED BY '{{ HEAT_DBPASS }}';
{% endfor %}

CREATE DATABASE aodh;
{% for host in ['%', 'localhost', inventory_hostname] %}
GRANT ALL ON aodh.* TO 'aodh'@'{{ host }}' IDENTIFIED BY '{{ AODH_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