Last modified: 2013-07-10 02:37:12 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T51069, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 49069 - Grant read privileges to all users on databases that end with "_p"
Grant read privileges to all users on databases that end with "_p"
Status: RESOLVED INVALID
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks: labs-replication
  Show dependency tree / graph
 
Reported: 2013-06-02 21:23 UTC by Tim Landscheidt
Modified: 2013-07-10 02:37 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Tim Landscheidt 2013-06-02 21:23:53 UTC 
On Toolserver, the convention is that databases with names that end with "_p" are publicly readable.  This rule should be implemented on Tools as well (replicated databases and tools-db) as otherwise data can't be shared inside the database.  Users could then create databases named "u1234__test_p".

Cf. bug #45895 for the same issue on Bots.
Comment 1 Marc A. Pelletier 2013-06-03 17:13:09 UTC 
Fixed.
Comment 2 Tim Landscheidt 2013-06-04 07:18:59 UTC 
Worked yesterday, but not any longer (related to the reboot/NFS?).
Comment 3 Tim Landscheidt 2013-06-04 07:24:48 UTC 
To be more precise: I can connect from other tool accounts (p50380g50440) to p50380g50450__checkwiki_p, but not from my user account (u2267).  Now.  And maybe yesterday I tested only tools <-> tools?  Hmmm.

It should work for everyone's databases and everyone's accounts.
Comment 4 Peter Bena 2013-06-04 07:34:39 UTC 
are you talking about tools-db server? that one wasn't affected because it run on gluster
Comment 5 Peter Bena 2013-06-04 07:36:54 UTC 
I don't see u2267 on tools-db
Comment 6 Marc A. Pelletier 2013-06-12 16:25:09 UTC 
User accounts do not get access to the local (tools-db) database.

They currently get access to the replicas only as a concession to the toolserver use case of "a quick query against production database", and even that I would generally discourage -- access is intended for service groups only in principle.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links