Jcrespo has uploaded a new change for review.

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

Change subject: grant phstats mysql user SELECT on phabricator_project on m3
......................................................................

grant phstats mysql user SELECT on phabricator_project on m3

m3 is the mysql shard for phabricator. I have included also
2 rules that were not puppetized.

Bug: T111200
Change-Id: I049c99ac7439b49876462777e004024e66db71ed
---
M templates/mariadb/production-grants-m3.sql.erb
1 file changed, 4 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/87/235687/1

diff --git a/templates/mariadb/production-grants-m3.sql.erb 
b/templates/mariadb/production-grants-m3.sql.erb
index 0e8a4c5..63aea07 100644
--- a/templates/mariadb/production-grants-m3.sql.erb
+++ b/templates/mariadb/production-grants-m3.sql.erb
@@ -30,6 +30,10 @@
 GRANT USAGE
     ON *.* TO 'phstats'@'10.64.32.150'
     IDENTIFIED BY PASSWORD '*FB8AA9D0E19A01A13E7FB1037FC964F7887D22F5';
+GRANT SELECT ON `phabricator_maniphest`.* TO 'phstats'@'10.64.32.150';
+GRANT SELECT ON `phabricator_user`.* TO 'phstats'@'10.64.32.150';
+GRANT SELECT ON `phabricator_project`.* TO 'phstats'@'10.64.32.150';
+
 
 GRANT SELECT
     ON `phabricator_maniphest`.* TO 'phstats'@'10.64.32.150';

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

Gerrit-MessageType: newchange
Gerrit-Change-Id: I049c99ac7439b49876462777e004024e66db71ed
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

Reply via email to