Fix for OpsCode mysql tag v3.0.13

perfectsine · perfectsine · commit f1d6262cba35 · 2013-11-01T13:54:55.000-05:00
Needed to restart mysql after creating databases.
diff --git a/recipes/mysql-cinder.rb b/recipes/mysql-cinder.rb
@@ -8,4 +8,5 @@
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['cinder']['db']['name']}.* TO '#{node['cinder']['db']['username']}'@'localhost' IDENTIFIED BY '#{node['cinder']['db']['password']}';"
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['cinder']['db']['name']}.* TO '#{node['cinder']['db']['username']}'@'#{node[:cinder][:private_ip]}' IDENTIFIED BY '#{node['cinder']['db']['password']}';"
   CODE
+  notifies :restart, resources(:service => 'mysql'), :immediately
 end
diff --git a/recipes/mysql-glance.rb b/recipes/mysql-glance.rb
@@ -8,4 +8,5 @@
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['glance']['db']['name']}.* TO '#{node['glance']['db']['username']}'@'localhost' IDENTIFIED BY '#{node['glance']['db']['password']}';"
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['glance']['db']['name']}.* TO '#{node['glance']['db']['username']}'@'#{node[:glance][:private_ip]}' IDENTIFIED BY '#{node['glance']['db']['password']}';"
   CODE
+  notifies :restart, resources(:service => 'mysql'), :immediately
 end
diff --git a/recipes/mysql-keystone.rb b/recipes/mysql-keystone.rb
@@ -8,4 +8,5 @@
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['keystone']['db']['name']}.* TO '#{node['keystone']['db']['username']}'@'localhost' IDENTIFIED BY '#{node['keystone']['db']['password']}';"
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['keystone']['db']['name']}.* TO '#{node['keystone']['db']['username']}'@'#{node[:keystone][:private_ip]}' IDENTIFIED BY '#{node['keystone']['db']['password']}';"
   CODE
+  notifies :restart, resources(:service => 'mysql'), :immediately
 end
diff --git a/recipes/mysql-neutron.rb b/recipes/mysql-neutron.rb
@@ -8,4 +8,5 @@
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['neutron']['db']['name']}.* TO '#{node['neutron']['db']['username']}'@'localhost' IDENTIFIED BY '#{node['neutron']['db']['password']}';"
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['neutron']['db']['name']}.* TO '#{node['neutron']['db']['username']}'@'#{node[:controller][:private_ip]}' IDENTIFIED BY '#{node['neutron']['db']['password']}';"
   CODE
+  notifies :restart, resources(:service => 'mysql'), :immediately
 end
diff --git a/recipes/mysql-nova.rb b/recipes/mysql-nova.rb
@@ -8,4 +8,5 @@
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['nova']['db']['name']}.* TO '#{node['nova']['db']['username']}'@'localhost' IDENTIFIED BY '#{node['nova']['db']['password']}';"
     mysql -uroot -p#{node['mysql']['server_root_password']} -e "GRANT ALL PRIVILEGES ON #{node['nova']['db']['name']}.* TO '#{node['nova']['db']['username']}'@'#{node[:controller][:private_ip]}' IDENTIFIED BY '#{node['nova']['db']['password']}';"
   CODE
+  notifies :restart, resources(:service => 'mysql'), :immediately
 end
