Last modified: 2013-05-30 15:56: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 T50890, 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 48890 - no read access to s3 and s6 replication databases
no read access to s3 and s6 replication databases
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: High major
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks: labs-replication
  Show dependency tree / graph
 
Reported: 2013-05-28 11:45 UTC by merl
Modified: 2013-05-30 15:56 UTC (History)
2 users (show)

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

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

Description merl 2013-05-28 11:45:35 UTC 
$ sql frrwiki_p
MariaDB [frrwiki_p]> select * from page limit 1;
ERROR 1045 (28000): Access denied for user 'p12345g12345'@'%' (using password: YES)

Accessing tables on replication databases on s3 does not work. Other database server (e.g. s1, s5) are accessible without problems.
Comment 1 Peter Bena 2013-05-29 08:29:15 UTC 
needs to be solved by DBA
Comment 2 Alex Monk 2013-05-29 15:11:39 UTC 
Also appears to be unreadable on s6 (frwiki, jawiki, ruwiki).
Comment 3 Marc A. Pelletier 2013-05-30 15:45:10 UTC 
It would appear that service groups created before s3 and s6 went live may not all have gotten the appropriate grants when they did.

I've forcibly placed grants back; please checked to see if that fixed?
Comment 4 Marc A. Pelletier 2013-05-30 15:56:12 UTC 
Also, the viewmaster user (that owns the views) needs to actually have SELECT grants.  :-)
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