Page MenuHomePhabricator

Create read-only user for civicrm devdb on staging
Closed, ResolvedPublic

Description

@Jgreen @cwdent I see there is an extension for us to test the read only db thing on now

https://github.com/totten/mysql-rpow/tree/master-civi

I guess we'll need a staging user with only readonly permissions to start to give it a go

Event Timeline

@Eileenmcnaughton sure, looking at the grants, would that be just select on dev_*?

@cwdent yep - not sure about drupal db - assume we'll still use the normal drupal user on that side

I am going to a sprint in June where Tim (civi core team who wrote this) will be there - would be good to get this done in May so I can poke around & discuss any issues with him

Jgreen triaged this task as Medium priority.

I created user dev_civicrm_read with select & create temporary tables on the dev_civicrm database. I'm not sure where this will be configured, so ping me for the password.

@Jgreen I keep thinking about this at times when you are not around - can you put the password in a text file in my home dir on staging?

Jgreen moved this task from Triage to Done on the fundraising-tech-ops board.

This is done, please reopen if there's any issue with the new mysql user.