Jcrespo has submitted this change and it was merged.
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, 2 insertions(+), 2 deletions(-)
Approvals:
Jcrespo: Looks good to me, approved
jenkins-bot: Verified
diff --git a/templates/mariadb/production-grants-m5.sql.erb
b/templates/mariadb/production-grants-m5.sql.erb
index 6aff947..046793b 100644
--- a/templates/mariadb/production-grants-m5.sql.erb
+++ b/templates/mariadb/production-grants-m5.sql.erb
@@ -24,9 +24,9 @@
TABLES
ON `designate`.* TO 'designate'@'208.80.154.12';
--- libnodepool1001 backend database
+-- labnodepool1001 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: merged
Gerrit-Change-Id: I5f9538ba7ce434b5be6ff54201f3051c578b7083
Gerrit-PatchSet: 4
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
