Ryan Lane has submitted this change and it was merged. Change subject: Add localhost permissions for labs testing. ......................................................................
Add localhost permissions for labs testing. Change-Id: I30b9c8dd54aa9493a22e0ec6c1f8c45e43d926ff --- M templates/openstack/common/controller/glance-user.sql.erb M templates/openstack/common/controller/keystone-user.sql.erb M templates/openstack/common/controller/nova-user.sql.erb M templates/openstack/common/controller/puppet-user.sql.erb 4 files changed, 12 insertions(+), 0 deletions(-) Approvals: Ryan Lane: Looks good to me, approved jenkins-bot: Verified diff --git a/templates/openstack/common/controller/glance-user.sql.erb b/templates/openstack/common/controller/glance-user.sql.erb index dc6450c..6c25ffa 100644 --- a/templates/openstack/common/controller/glance-user.sql.erb +++ b/templates/openstack/common/controller/glance-user.sql.erb @@ -1,2 +1,5 @@ GRANT USAGE ON *.* to '<%= glance_db_user %>'@'%' IDENTIFIED BY '<%= glance_db_pass %>'; +GRANT USAGE ON *.* to '<%= glance_db_user %>'@'127.0.0.1' IDENTIFIED BY '<%= glance_db_pass %>'; +GRANT USAGE ON *.* to '<%= glance_db_user %>'@'localhost' IDENTIFIED BY '<%= glance_db_pass %>'; GRANT ALL PRIVILEGES ON <%= glance_db_name %>.* to '<%= glance_db_user %>'@'%'; +FLUSH PRIVILEGES; diff --git a/templates/openstack/common/controller/keystone-user.sql.erb b/templates/openstack/common/controller/keystone-user.sql.erb index 1789808..39577cf 100644 --- a/templates/openstack/common/controller/keystone-user.sql.erb +++ b/templates/openstack/common/controller/keystone-user.sql.erb @@ -1,2 +1,5 @@ GRANT USAGE ON *.* to '<%= keystone_db_user %>'@'%' IDENTIFIED BY '<%= keystone_db_pass %>'; +GRANT USAGE ON *.* to '<%= keystone_db_user %>'@'127.0.0.1' IDENTIFIED BY '<%= keystone_db_pass %>'; +GRANT USAGE ON *.* to '<%= keystone_db_user %>'@'localhost' IDENTIFIED BY '<%= keystone_db_pass %>'; GRANT ALL PRIVILEGES ON <%= keystone_db_name %>.* to '<%= keystone_db_user %>'@'%'; +FLUSH PRIVILEGES; diff --git a/templates/openstack/common/controller/nova-user.sql.erb b/templates/openstack/common/controller/nova-user.sql.erb index 375e8bf..4cb3042 100644 --- a/templates/openstack/common/controller/nova-user.sql.erb +++ b/templates/openstack/common/controller/nova-user.sql.erb @@ -1,2 +1,5 @@ GRANT USAGE ON *.* to '<%= nova_db_user %>'@'%' IDENTIFIED BY '<%=nova_db_pass %>'; +GRANT USAGE ON *.* to '<%= nova_db_user %>'@'127.0.0.1' IDENTIFIED BY '<%=nova_db_pass %>'; +GRANT USAGE ON *.* to '<%= nova_db_user %>'@'localhost' IDENTIFIED BY '<%=nova_db_pass %>'; GRANT ALL PRIVILEGES ON <%= nova_db_name %>.* to '<%= nova_db_user %>'@'%'; +FLUSH PRIVILEGES; diff --git a/templates/openstack/common/controller/puppet-user.sql.erb b/templates/openstack/common/controller/puppet-user.sql.erb index 1baa3bf..01d0937 100644 --- a/templates/openstack/common/controller/puppet-user.sql.erb +++ b/templates/openstack/common/controller/puppet-user.sql.erb @@ -1,2 +1,5 @@ GRANT USAGE ON *.* to '<%= puppet_db_user %>'@'%' IDENTIFIED BY '<%= puppet_db_pass %>'; +GRANT USAGE ON *.* to '<%= puppet_db_user %>'@'127.0.0.1' IDENTIFIED BY '<%= puppet_db_pass %>'; +GRANT USAGE ON *.* to '<%= puppet_db_user %>'@'localhost' IDENTIFIED BY '<%= puppet_db_pass %>'; GRANT ALL PRIVILEGES ON <%= puppet_db_name %>.* to '<%= puppet_db_user %>'@'%'; +FLUSH PRIVILEGES; -- To view, visit https://gerrit.wikimedia.org/r/102214 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I30b9c8dd54aa9493a22e0ec6c1f8c45e43d926ff Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Ryan Lane <rl...@wikimedia.org> Gerrit-Reviewer: Ryan Lane <rl...@wikimedia.org> Gerrit-Reviewer: jenkins-bot _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits