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