Dzahn has submitted this change and it was merged. (
https://gerrit.wikimedia.org/r/359639 )
Change subject: wikistats: add XML dumps for all tables, fix db access
......................................................................
wikistats: add XML dumps for all tables, fix db access
Bug: 165879
Change-Id: Ife133dbcaaac31ccdd3bee2c4f9cb45e5e0e4e3b
---
M modules/wikistats/manifests/cronjob/xmldump.pp
M modules/wikistats/manifests/updates.pp
2 files changed, 37 insertions(+), 1 deletion(-)
Approvals:
jenkins-bot: Verified
Dzahn: Looks good to me, approved
diff --git a/modules/wikistats/manifests/cronjob/xmldump.pp
b/modules/wikistats/manifests/cronjob/xmldump.pp
index a820c1b..c350f16 100644
--- a/modules/wikistats/manifests/cronjob/xmldump.pp
+++ b/modules/wikistats/manifests/cronjob/xmldump.pp
@@ -9,7 +9,7 @@
){
$query = $table ? {
- 'wikipedias' => 'SELECT *,good/total AS ratio FROM wikipedias WHERE
lang NOT LIKE \"%articles%\" ORDER BY good desc,total desc',
+ 'wikipedias' => 'SELECT *,good/total AS ratio FROM wikipedias WHERE
lang NOT LIKE "%articles%" ORDER BY good desc,total desc',
default => "SELECT *,good/total AS ratio FROM ${table} ORDER BY
good desc,total desc",
}
diff --git a/modules/wikistats/manifests/updates.pp
b/modules/wikistats/manifests/updates.pp
index 4c51ed0..467165f 100644
--- a/modules/wikistats/manifests/updates.pp
+++ b/modules/wikistats/manifests/updates.pp
@@ -21,6 +21,15 @@
group => 'wikistatsuser',
}
+ # db pass for [client] for dumps
+ file { '/usr/lib/wikistats/.my.cnf':
+ ensure => present,
+ mode => '0400',
+ owner => 'wikistatsuser',
+ group => 'wikistatsuser',
+ content => "[client]\npassword=${db_pass}\n"
+ }
+
# update table data: usage: <project prefix>@<hour>
wikistats::cronjob::update { [
'wp@0', # Wikipedias
@@ -61,6 +70,33 @@
wikistats::cronjob::xmldump {
'wp' : db_pass => $db_pass, table => 'wikipedias', minute => '3';
'wt' : db_pass => $db_pass, table => 'wiktionaries', minute => '5';
+ 'wq' : db_pass => $db_pass, table => 'wikiquotes', minute => '7';
+ 'wb' : db_pass => $db_pass, table => 'wikibooks', minute => '9';
+ 'wn' : db_pass => $db_pass, table => 'wikinews', minute => '11';
+ 'ws' : db_pass => $db_pass, table => 'wikisources', minute => '13';
+ 'wy' : db_pass => $db_pass, table => 'wikivoyage', minute => '15';
+ 'wx' : db_pass => $db_pass, table => 'wmspecials', minute => '17';
+ 'wi' : db_pass => $db_pass, table => 'wikia', minute => '19';
+ 'et' : db_pass => $db_pass, table => 'editthis', minute => '23';
+ 'wr' : db_pass => $db_pass, table => 'wikitravel', minute => '25';
+ 'mw' : db_pass => $db_pass, table => 'mediawikis', minute => '32';
+ 'mt' : db_pass => $db_pass, table => 'metapedias', minute => '37';
+ 'sc' : db_pass => $db_pass, table => 'scoutwiki', minute => '39';
+ 'os' : db_pass => $db_pass, table => 'opensuse', minute => '41';
+ 'un' : db_pass => $db_pass, table => 'uncyclomedia', minute => '43';
+ 'wf' : db_pass => $db_pass, table => 'wikifur', minute => '45';
+ 'an' : db_pass => $db_pass, table => 'anarchopedias', minute => '47';
+ 'si' : db_pass => $db_pass, table => 'wikisite', minute => '51';
+ 'ne' : db_pass => $db_pass, table => 'neoseeker', minute => '53';
+ 'wv' : db_pass => $db_pass, table => 'wikiversity', minute => '34';
+ 're' : db_pass => $db_pass, table => 'referata', minute => '57';
+ 'ro' : db_pass => $db_pass, table => 'rodovid', minute => '1';
+ 'lx' : db_pass => $db_pass, table => 'lxde', minute => '59';
+ 'sw' : db_pass => $db_pass, table => 'shoutwiki', minute => '36';
+ 'w3' : db_pass => $db_pass, table => 'w3cwikis', minute => '27';
+ 'ga' : db_pass => $db_pass, table => 'gamepedias', minute => '29';
+ 'sf' : db_pass => $db_pass, table => 'sourceforge', minute => '24';
+ 'mh' : db_pass => $db_pass, table => 'miraheze', minute => '6';
}
# imports (fetching lists of wikis itself) usage: <project name>@<weekday>
--
To view, visit https://gerrit.wikimedia.org/r/359639
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ife133dbcaaac31ccdd3bee2c4f9cb45e5e0e4e3b
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Dzahn <dz...@wikimedia.org>
Gerrit-Reviewer: Dzahn <dz...@wikimedia.org>
Gerrit-Reviewer: Giuseppe Lavagetto <glavage...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
