Ottomata has submitted this change and it was merged.
Change subject: Fixing email-blog-pageviews.erb
......................................................................
Fixing email-blog-pageviews.erb
Change-Id: Ic2f0fe59b130c0ae5d47525e8655e8df8cccbcd3
---
M templates/misc/email-blog-pageviews.erb
1 file changed, 1 insertion(+), 1 deletion(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
diff --git a/templates/misc/email-blog-pageviews.erb
b/templates/misc/email-blog-pageviews.erb
index 143423c..d2dfcd2 100644
--- a/templates/misc/email-blog-pageviews.erb
+++ b/templates/misc/email-blog-pageviews.erb
@@ -1,7 +1,7 @@
DATE=`date '+%Y-%m-%d'`;
OUTPUT=/tmp/blog_$DATE.tsv
-mysql log -h db1047.eqiad.wmnet -p<%=
scope.lookupvar('passwords::mysql::research::password') %>
+mysql log -h db1047.eqiad.wmnet -p<%=
scope.lookupvar('passwords::mysql::research::pass') %>
-u<%= scope.lookupvar('passwords::mysql::research::user') %> -e "select
count(event_requestUrl) as count, date(timestamp), event_requestUrl from
WikimediaBlogVisit_5308166 where date(timestamp)=date('$DATE') group by
event_requestUrl order by date(timestamp) desc, count desc;" > $OUTPUT
cat $OUTPUT | mailx -s "Daily Blog Pageviews" tba...@wikimedia.org
--
To view, visit https://gerrit.wikimedia.org/r/54476
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: Ic2f0fe59b130c0ae5d47525e8655e8df8cccbcd3
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Ottomata <o...@wikimedia.org>
Gerrit-Reviewer: Ottomata <o...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
