Jcrespo has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/235416

Change subject: Fix mysql grant issues on m5 (Followup to gerrit:235412)
......................................................................

Fix mysql grant issues on m5 (Followup to gerrit:235412)

Wrong permissions were granted on m5-master (db1009). This should
fix and provide the right access to labnodepool1001.

Bug: T110693
Change-Id: I5f9538ba7ce434b5be6ff54201f3051c578b7083
---
M templates/mariadb/production-grants-m5.sql.erb
1 file changed, 1 insertion(+), 1 deletion(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/16/235416/1

diff --git a/templates/mariadb/production-grants-m5.sql.erb 
b/templates/mariadb/production-grants-m5.sql.erb
index 6aff947..2aa0d6e 100644
--- a/templates/mariadb/production-grants-m5.sql.erb
+++ b/templates/mariadb/production-grants-m5.sql.erb
@@ -26,7 +26,7 @@
 
 -- libnodepool1001 backend database
 
-CREATE USER 'nodepool'@'10.64.48.17' IDENTIFIED BY '<%= @nodepool_pass %>';
+CREATE USER 'nodepool'@'10.64.20.18' IDENTIFIED BY '<%= @nodepool_pass %>';
 GRANT ALL ON `nodepooldb`.* TO 'nodepool'@'10.64.20.18';
 
 -- backups to dbstore1001

-- 
To view, visit https://gerrit.wikimedia.org/r/235416
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I5f9538ba7ce434b5be6ff54201f3051c578b7083
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to