Page MenuHomePhabricator
Create Task
Maniphest T174706

Fix path to mysql credentials file in reportupdater query repositories
Closed, ResolvedPublic3 Estimated Story Points
Actions

Description

After the migration to stat1006, the active reportupdater jobs are still pointing to the old /a/.my.cnf.research symlink.
This makes all reports fail, because of connection permissions.
We should update all paths to the credential file in all config files in the following repos:

  • limn-flow-data
  • limn-edit-data
  • limn-language-data
  • limn-ee-data
  • limn-multimedia-data
  • discovery-stats
  • reportupdater-queries

Details

SubjectRepoBranchLines +/-
Correct path to credentials fileanalytics/discovery-statsmaster+2 -2
Correct path to credentials fileanalytics/reportupdater-queriesmaster+1 -1
Correct path to credentials fileanalytics/limn-multimedia-datamaster+1 -1
Correct path to credentials fileanalytics/limn-ee-datamaster+4 -4
Correct path to credentials fileanalytics/limn-language-datamaster+1 -1
Correct path to credentials fileanalytics/limn-edit-datamaster+2 -2
Correct path to credentials fileanalytics/limn-flow-datamaster+4 -4
Customize query in gerrit

Related Objects

Event Timeline

mforns created this task.Aug 31 2017, 5:50 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 31 2017, 5:50 PM
gerritbot subscribed.Aug 31 2017, 5:51 PM

Change 375035 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/limn-flow-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375035

gerritbot added a project: Patch-For-Review.Aug 31 2017, 5:51 PM
gerritbot added a comment.Aug 31 2017, 5:55 PM

Change 375037 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/limn-edit-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375037

gerritbot added a comment.Aug 31 2017, 5:58 PM

Change 375040 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/limn-language-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375040

Ottomata added a comment.Aug 31 2017, 5:59 PM

Mforns, +1 from me on all of these changes.

gerritbot added a comment.Aug 31 2017, 6:01 PM

Change 375041 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/limn-ee-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375041

gerritbot added a comment.Aug 31 2017, 6:04 PM

Change 375042 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/limn-multimedia-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375042

gerritbot added a comment.Aug 31 2017, 6:10 PM

Change 375043 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/discovery-stats@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375043

gerritbot added a comment.Aug 31 2017, 6:13 PM

Change 375044 had a related patch set uploaded (by Mforns; owner: Mforns):
[analytics/reportupdater-queries@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375044

mforns added a comment.Aug 31 2017, 6:14 PM

@Ottomata OK will merge them, to unbreak the reports.

gerritbot added a comment.Aug 31 2017, 6:15 PM

Change 375035 merged by Mforns:
[analytics/limn-flow-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375035

gerritbot added a comment.Aug 31 2017, 6:15 PM

Change 375037 merged by Mforns:
[analytics/limn-edit-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375037

gerritbot added a comment.Aug 31 2017, 6:15 PM

Change 375040 merged by Mforns:
[analytics/limn-language-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375040

gerritbot added a comment.Aug 31 2017, 6:16 PM

Change 375041 merged by Mforns:
[analytics/limn-ee-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375041

gerritbot added a comment.Aug 31 2017, 6:16 PM

Change 375042 merged by Mforns:
[analytics/limn-multimedia-data@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375042

gerritbot added a comment.Aug 31 2017, 6:17 PM

Change 375044 merged by Mforns:
[analytics/reportupdater-queries@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375044

gerritbot added a comment.Aug 31 2017, 6:18 PM

Change 375043 merged by Ottomata:
[analytics/discovery-stats@master] Correct path to credentials file

https://gerrit.wikimedia.org/r/375043

mforns mentioned this in T170850: Visualize page create events for all wikis .Aug 31 2017, 7:12 PM
mforns moved this task from Next Up to Done on the Analytics-Kanban board.Aug 31 2017, 7:27 PM

I checked in stat1006, and now all reports seem to be getting updated.
Will move to done.

mforns set the point value for this task to 3.Aug 31 2017, 7:27 PM
• Nuria closed this task as Resolved.Sep 12 2017, 8:43 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL