Jcrespo has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/365035 )
Change subject: [WIP]mariadb: Add grants for rddmark to m1
......................................................................
[WIP]mariadb: Add grants for rddmark to m1
Add user account and backups for rddmark.
Blocked on missing source ip/ips and predicted traffic to confirm
it should go to m1.
Bug: T170158
Change-Id: I87878898b24d0688cf67e6b945cab9e6fbcd9421
---
M modules/role/manifests/mariadb.pp
M modules/role/templates/mariadb/backups/dumps-misc.sh.erb
M modules/role/templates/mariadb/grants/production-m1.sql.erb
3 files changed, 5 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/35/365035/1
diff --git a/modules/role/manifests/mariadb.pp
b/modules/role/manifests/mariadb.pp
index f22bac9..23ef20c 100644
--- a/modules/role/manifests/mariadb.pp
+++ b/modules/role/manifests/mariadb.pp
@@ -66,6 +66,7 @@
$striker_admin_pass = $passwords::striker::admin_db_password
$labspuppet_pass = hiera('labspuppetbackend_mysql_password')
$labsdbaccounts_pass = $passwords::labsdbaccounts::db_password
+ $rddmark_pass = $passwords::rddmark::db_password
file { '/etc/mysql/production-grants-shard.sql':
ensure => present,
diff --git a/modules/role/templates/mariadb/backups/dumps-misc.sh.erb
b/modules/role/templates/mariadb/backups/dumps-misc.sh.erb
index 3fc977a..1d02b65 100644
--- a/modules/role/templates/mariadb/backups/dumps-misc.sh.erb
+++ b/modules/role/templates/mariadb/backups/dumps-misc.sh.erb
@@ -5,7 +5,7 @@
my="/usr/local/bin/mysql --skip-column-names --skip-ssl"
dump="/usr/local/bin/mysqldump --single-transaction --quick --master-data=2
--skip-ssl"
-$dump -h m1-slave --databases bacula etherpadlite librenms puppet racktables
rt | \
+$dump -h m1-slave --databases bacula etherpadlite librenms puppet racktables
rt rddmarc | \
pigz > /srv/backups/m1-$(date +%Y%m%d%H%M%S).sql.gz
$dump -h m2-slave --databases iegreview reviewdb scholarships | \
diff --git a/modules/role/templates/mariadb/grants/production-m1.sql.erb
b/modules/role/templates/mariadb/grants/production-m1.sql.erb
index 29e9132..ff96ad6 100644
--- a/modules/role/templates/mariadb/grants/production-m1.sql.erb
+++ b/modules/role/templates/mariadb/grants/production-m1.sql.erb
@@ -112,4 +112,6 @@
SELECT, TRIGGER, UPDATE
ON `puppet`.* TO 'servermon'@'10.64.16.159';
-
+-- rddmarc
+GRANT ALTER, CREATE, SELECT, INSERT, UPDATE, DELETE
+ ON rddmarc.* TO 'rddmarc'@'<missing ip>' IDENTIFIED BY
'<%=@rddmark_pass%>';
--
To view, visit https://gerrit.wikimedia.org/r/365035
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I87878898b24d0688cf67e6b945cab9e6fbcd9421
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
