Page MenuHomePhabricator

Prepare and check storage layer for arywiki
Closed, ResolvedPublic

Description

The new wiki is going to be public.

Event Timeline

Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.
Marostegui subscribed.

Let us know when the database is created

Thanks - I am going to sanitize it

Marostegui added subscribers: Bstorm, bd808.

Check_private_data came back clean:

_p_ database created.
Grants for labsdbuser role changed.
This is ready for views creation by the cloud-services-team on labsdb1009, 1010, 1011, 1012.

# for i in labsdb1009 labsdb1010 labsdb1011 labsdb1012; do echo "===$i==="; mysql.py -h$i -e "show databases;show grants for labsdbuser;" | egrep  "arywiki"; done
===labsdb1009===
arywiki
arywiki_p
GRANT SELECT, SHOW VIEW ON `arywiki\\_p`.* TO 'labsdbuser'
===labsdb1010===
arywiki
arywiki_p
GRANT SELECT, SHOW VIEW ON `arywiki\\_p`.* TO 'labsdbuser'
===labsdb1011===
arywiki
arywiki_p
GRANT SELECT, SHOW VIEW ON `arywiki\\_p`.* TO 'labsdbuser'
===labsdb1012===
arywiki
arywiki_p
GRANT SELECT, SHOW VIEW ON `arywiki\\_p`.* TO 'labsdbuser'
Bstorm claimed this task.

All set up from the cloud side and tested connection and auth from Toolforge.