Looking at the project tables for sharing project data turned out to not be enough. We also need information like whether a project or release it actually published. Unpublished projects and releases should not be sycned, since we have nothing to do with them. Also, when a release or project is unpublished on drupal.org we should take appropriate action on localize.drupal.org.

So here is a request to get read access to the node table for the localize_ro DB user.

Comments

nnewton’s picture

Assigned: Unassigned » nnewton
Status: Active » Fixed

I just granted select on node to localize_ro. Let me know if it doesn't work for you.

gábor hojtsy’s picture

Thanks, works well.

gábor hojtsy’s picture

Title: Also need read access to drupal.org node table » Also need read access to drupal.org files table
Status: Fixed » Needs work

Uhm, looks like for the release file information, we also need the files table. Sorry for only noticing now, but I just got to syncing the release info, now that syncing the project info works well.

gábor hojtsy’s picture

Title: Also need read access to drupal.org files table » Also need read access to drupal.org files & term_data tables

Should never promise that those were the last ;)

The project tables have no information on the project type, and we should not syndicate the translation projects obviously. So we'd need access to the taxonomy tables, or actually at least "term_data", so we can join projects through this table to identify projects under http://drupal.org/taxonomy/term/29 which should not be handled by the localization server.

gábor hojtsy’s picture

Title: Also need read access to drupal.org files & term_data tables » Also need read access to drupal.org files & term_node tables

Huh, thank God Narayan did not have time ;) I meant files and term_node (not term_data).

nnewton’s picture

Title: Also need read access to drupal.org files & term_node tables » Also need read access to drupal.org files & term_data tables

Done. I got you files and term_data, let me know if you need anymore of the term tables.

gábor hojtsy’s picture

Title: Also need read access to drupal.org files & term_data tables » Also need read access to drupal.org files & term_node tables

Ugm, you did got me term_data but I've updated the issue a nice 14 hours before you to ask for term_node *instead*, realizing my mistake. Please fix.

nnewton’s picture

Status: Needs work » Fixed

Hoora for old tabs in firefox :), fixed. let me know if you need anything else.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

gábor hojtsy’s picture

Project: Drupal.org infrastructure » localize.drupal.org
Component: localize.drupal.org » Infrastructure

Moving to new queue (sorry for issue-bombing).