Jcrespo has submitted this change and it was merged.
Change subject: Add grants for new database designate_pool_manager
......................................................................
Add grants for new database designate_pool_manager
designate_pool_manage has been requested by Andrew,
with the same grants than designate.
I have also added designate_pool_manage and nodepool
to the mariadb backup process.
Bug: T112041
Change-Id: Ie3c072eb22c52ff70e31002938692abe15ffa678
---
M templates/mariadb/dumps-misc.sh.erb
M templates/mariadb/production-grants-m5.sql.erb
2 files changed, 6 insertions(+), 1 deletion(-)
Approvals:
Jcrespo: Looks good to me, approved
jenkins-bot: Verified
diff --git a/templates/mariadb/dumps-misc.sh.erb
b/templates/mariadb/dumps-misc.sh.erb
index ad725d0..fa19a78 100644
--- a/templates/mariadb/dumps-misc.sh.erb
+++ b/templates/mariadb/dumps-misc.sh.erb
@@ -23,7 +23,7 @@
--databases $($my "$sql" | tr '\n' ' ') | \
pigz > /srv/backups/m3-phabricator-phlegal-$(date +%Y%m%d%H%M%S).sql.gz
-$dump_master -h m5-slave --databases ceilometer glance keystone neutron nova
pdns designate | \
+$dump_master -h m5-slave --databases ceilometer glance keystone neutron nova
pdns designate designate_pool_manager nodepool | \
pigz > /srv/backups/m5-$(date +%Y%m%d%H%M%S).sql.gz &
sql="select schema_name from information_schema.schemata where schema_name
regexp '^(wik|flowdb)'"
diff --git a/templates/mariadb/production-grants-m5.sql.erb
b/templates/mariadb/production-grants-m5.sql.erb
index 046793b..1f1f92f 100644
--- a/templates/mariadb/production-grants-m5.sql.erb
+++ b/templates/mariadb/production-grants-m5.sql.erb
@@ -24,6 +24,11 @@
TABLES
ON `designate`.* TO 'designate'@'208.80.154.12';
+-- designate_pool_manager
+
+GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY
TABLES
+ ON `designate\_pool\_manager`.* TO 'designate'@'208.80.154.12';
+
-- labnodepool1001 backend database
CREATE USER 'nodepool'@'10.64.20.18' IDENTIFIED BY '<%= @nodepool_pass %>';
--
To view, visit https://gerrit.wikimedia.org/r/237339
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ie3c072eb22c52ff70e31002938692abe15ffa678
Gerrit-PatchSet: 2
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
