Page MenuHomePhabricator

Consider adding ContentTranslation (CX) tables to wiki replicas
Open, NormalPublic

Description

It would appear that CX tables are not available for Cloud Services users.

From what I could understand they are hosted in prod in the "wikishared" database. This one itself doesn't seem accessible.

Is it possible to add CX tables (or all this base if possible) to the replicas?

I suppose it would involve getting a security review of the schema to determine what fields can be exposed, and the need to figure out if there is space for the data.

Related: table sizes are exposed at T189088#4241980

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 30 2018, 9:04 PM
bd808 renamed this task from Consider adding CX tables to replica to Consider adding ContentTranslation (CX) tables to wiki replicas.May 30 2018, 9:13 PM
bd808 updated the task description. (Show Details)

There was a great job done by @Bawolff who did a security review already (T103011) and for the cx tables it is not completely clear their status: (cross posting from that ticket)

cx_corpora (Probably concerns that cxc_content could contain private data and wouldn't be revdeletable. Not really sure)
cx_drafts (Could contain private info that's not revdel'able. As well as assumption that drafts are private)
cx_lists (Presumably ok if cxl_public = 1, otherwise should be redacted)
cx_suggestions (Entries on cx_lists. Again fine if the list in question is public)
cx_translations (Seems to map user id to translation_ids. Don't really know what its used for, looks safe)
cx_translators (I really don't know if in progress translations are secret or public)

We will need to investigate the implications before doing this.

Vvjjkkii renamed this task from Consider adding ContentTranslation (CX) tables to wiki replicas to bybaaaaaaa.Jul 1 2018, 1:06 AM
Vvjjkkii triaged this task as High priority.
Vvjjkkii updated the task description. (Show Details)
Vvjjkkii removed a subscriber: Aklapper.
Marostegui renamed this task from bybaaaaaaa to Consider adding ContentTranslation (CX) tables to wiki replicas.Jul 1 2018, 7:55 PM
Marostegui lowered the priority of this task from High to Normal.
Marostegui updated the task description. (Show Details)
CommunityTechBot raised the priority of this task from Normal to Needs Triage.Jul 5 2018, 6:55 PM
Arrbee triaged this task as Normal priority.Aug 6 2018, 10:18 AM
Arrbee moved this task from Needs Triage to Enhancements on the ContentTranslation board.
bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Nov 2 2018, 11:34 PM