Page MenuHomePhabricator
Create Task
Maniphest T188490

Prepare and check storage layer for hiwikimedia
Closed, ResolvedPublic
Actions

Description

The new wiki will be a fishbowl one.

Details

ProjectBranchLines +/-Subject
operations/puppetproduction+4 -0wiki replicas: add GRANT statement to $wiki_p database creation
Customize query in gerrit

Related Objects
Search...

Event Timeline

Jayprakash12345 changed the task status from Open to Stalled.Feb 28 2018, 10:36 AM
Jayprakash12345 created this task.
Restricted Application added a project: User-Jayprakash12345. · View Herald TranscriptFeb 28 2018, 10:36 AM
Jayprakash12345 moved this task from Triage to Blocked external/Not db team on the DBA board.Feb 28 2018, 10:36 AM
Marostegui added a subscriber: Marostegui.Feb 28 2018, 10:53 AM

Is this public? Does it need to be replicated to labs?

Jayprakash12345 added a comment.Feb 28 2018, 11:00 AM

@Marostegui See T168788, Same thing will be happen here.

Marostegui added a comment.Feb 28 2018, 11:02 AM

Thanks - let us know when it is created in production so we can:

Jayprakash12345 moved this task from Backlog to Watching on the User-Jayprakash12345 board.Mar 21 2018, 5:00 AM
Jayprakash12345 changed the task status from Stalled to Open.Apr 18 2018, 11:52 PM
Restricted Application added a project: Product-Analytics. · View Herald TranscriptApr 18 2018, 11:52 PM
Jayprakash12345 merged a task: T189124: Prepare and check storage layer for hiwikimedia.Apr 18 2018, 11:52 PM
Jayprakash12345 added subscribers: Suyash.dwivedi, YmKavishwar.
Phabricator_maintenance removed a project: Product-Analytics.Apr 19 2018, 12:18 AM
Capankajsmilyo added a subscriber: Capankajsmilyo.Apr 19 2018, 1:35 AM
MarcoAurelio added a subscriber: MarcoAurelio.Apr 20 2018, 8:46 AM

@Marostegui Wiki has been created. Thanks.

Marostegui claimed this task.Apr 20 2018, 8:46 AM
Marostegui moved this task from Triage to In Progress on the Cloud-Services board.

I will make sure it is filtered before sending it to cloud-services-team

Marostegui removed Marostegui as the assignee of this task.Apr 20 2018, 12:06 PM
Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.
Marostegui added a project: cloud-services-team.
Marostegui added a subscriber: bd808.

Ready for cloud-services-team

bd808 edited projects, added cloud-services-team (Kanban); removed cloud-services-team.Apr 20 2018, 1:21 PM

Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services

bd808 moved this task from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.Apr 20 2018, 1:22 PM
Bstorm claimed this task.Apr 23 2018, 6:57 PM
Bstorm added a comment.Apr 25 2018, 6:33 PM

The wiki replica views and DNS are set. -- and updated that document so it is now correct.

Bstorm closed this task as Resolved.Apr 25 2018, 6:56 PM
Urbanecm reopened this task as Open.Apr 26 2018, 1:18 PM

It do not work correctly.

urbanecm@tools-bastion-03 ~  
$ sql hiwikimedia
ERROR 1044 (42000): Access denied for user 'u13367'@'%' to database 'hiwikimedia_p'
urbanecm@tools-bastion-03 ~ 
$
Marostegui closed this task as Resolved.Apr 26 2018, 1:33 PM

Should be fixed now

marostegui@tools-bastion-03:~$ sql --cluster web hiwikimedia_p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11498489
Server version: 10.1.32-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [hiwikimedia_p]> Ctrl-C -- exit!
Aborted
marostegui@tools-bastion-03:~$ sql --cluster analytics hiwikimedia_p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 23238546
Server version: 10.1.32-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [hiwikimedia_p]> Ctrl-C -- exit!
Aborted
gerritbot added a subscriber: gerritbot.Apr 26 2018, 9:20 PM

Change 429349 had a related patch set uploaded (by Bstorm; owner: Bstorm):
[operations/puppet@production] wiki replicas: add GRANT statement to $wiki_p database creation

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

gerritbot added a project: Patch-For-Review.Apr 26 2018, 9:20 PM
Urbanecm added a comment.Apr 27 2018, 9:45 AM

Thanks! @Bstorm, are you sure this patch is directy related to this task? I think another task "Add GRANT statement to $wiki_p" should be created if a task is necessary.

Marostegui added a comment.Apr 27 2018, 9:46 AM
In T188490#4163459, @Urbanecm wrote:

Thanks! @Bstorm, are you sure this patch is directy related to this task? I think another task "Add GRANT statement to $wiki_p" should be created if a task is necessary.

It is directly related in the sense that it will fix future related tasks like this one.

Urbanecm added a comment.Apr 27 2018, 10:14 AM

Well, it isnt related to JUST this task but all task I reopened and you fixed.

Marostegui added a comment.Apr 27 2018, 10:17 AM
In T188490#4163506, @Urbanecm wrote:

Well, it isnt related to JUST this task but all task I reopened and you fixed.

That's why I said related tasks :)

Capankajsmilyo removed a subscriber: Capankajsmilyo.Apr 29 2018, 2:58 AM
gerritbot added a comment.May 4 2018, 7:54 PM

Change 429349 merged by Bstorm:
[operations/puppet@production] wiki replicas: add GRANT statement to $wiki_p database creation

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

bd808 moved this task from Clinic Duty to Done on the cloud-services-team (Kanban) board.May 6 2018, 6:46 PM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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