Jcrespo has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/367708 )
Change subject: rddmarc: enable database connection only from the m1 dbproxies ...................................................................... rddmarc: enable database connection only from the m1 dbproxies Instead of limiting connections from the hosts themselves, limit them from the proxy for easier failover. Bug: T170158 Change-Id: Iafe956263da3de5a3c8f5bbbd3ef2860fde34f1a --- M modules/role/templates/mariadb/grants/production-m1.sql.erb 1 file changed, 2 insertions(+), 2 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/08/367708/1 diff --git a/modules/role/templates/mariadb/grants/production-m1.sql.erb b/modules/role/templates/mariadb/grants/production-m1.sql.erb index e1650df..3e8fd0d 100644 --- a/modules/role/templates/mariadb/grants/production-m1.sql.erb +++ b/modules/role/templates/mariadb/grants/production-m1.sql.erb @@ -114,6 +114,6 @@ -- rddmarc GRANT ALTER, CREATE, SELECT, INSERT, UPDATE, DELETE - ON rddmarc.* TO 'rddmarc'@'208.80.153.17' IDENTIFIED BY '<%=@rddmarc_pass%>'; + ON rddmarc.* TO 'rddmarc'@'10.64.0.165' IDENTIFIED BY '<%=@rddmarc_pass%>'; GRANT ALTER, CREATE, SELECT, INSERT, UPDATE, DELETE - ON rddmarc.* TO 'rddmarc'@'208.80.154.24' IDENTIFIED BY '<%=@rddmarc_pass%>'; + ON rddmarc.* TO 'rddmarc'@'10.64.16.159' IDENTIFIED BY '<%=@rddmarc_pass%>'; -- To view, visit https://gerrit.wikimedia.org/r/367708 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Iafe956263da3de5a3c8f5bbbd3ef2860fde34f1a Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Jcrespo <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
