Page MenuHomePhabricator

access to database cluster S6.labsdb (ruwiki, jawiki, frwiki) broken / denied
Closed, ResolvedPublic

Description

Author: metatron

Description:
No access to databases on s6.labsdb. ACCESS DENIED. Other slices ar fine. Occurs since friday, 13th (of course!) after db maintenance took place.


Version: unspecified
Severity: critical
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=61847

Details

Reference
bz58480

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:22 AM
bzimport added a project: Toolforge.
bzimport set Reference to bz58480.
bzimport added a subscriber: Unknown Object (MLST).

Works for me from user and tool accounts:

scfc@tools-login:~$ mysql -h s6.labsdb -e 'SELECT MAX(rc_timestamp) FROM recentchanges;' ruwiki_p
+-------------------+
MAX(rc_timestamp)
+-------------------+
20131214201632
+-------------------+
scfc@tools-login:~$ become wikilint
local-wikilint@tools-login:~/$ mysql -h s6.labsdb -e 'SELECT MAX(rc_timestamp) FROM recentchanges;' ruwiki_p
+-------------------+
MAX(rc_timestamp)
+-------------------+
20131214201700
+-------------------+
local-wikilint@tools-login:~/$

Which commands do you use to access the DB?

There was, indeed, credentials were lost after what seems to be a database wipe and restart. I did, however, restore them since.