Allow dev access to db-B-001 for dereckson
ClosedPublic
Actions

Authored by dereckson on May 24 2023, 15:40.

Details

Reviewers

dereckson

Commits

rOPSbafe08036063: Allow dev access to db-B-001 for dereckson

Summary

Temptatively introduce privileges separation to allow regular dev
maintenance work without using root account.

Allow to connect with MySQL workbench through a SSH tunnel
proxied by WindRiver.

Permissions on database with a % doesn't match a specific database,
and could match not-yet-existing databases, as such, drop requisite.

Test Plan

mysql -h db-B-001 -e "SHOW DATABASES;" -p

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.May 24 2023, 15:40

dereckson created this revision.

Harbormaster completed remote builds in B4926: Diff 7965.May 24 2023, 15:40

dereckson accepted this revision.May 24 2023, 15:51

This revision is now accepted and ready to land.May 24 2023, 15:51

Closed by commit rOPSbafe08036063: Allow dev access to db-B-001 for dereckson (authored by dereckson). · Explain WhyMay 24 2023, 15:52

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rOPSbafe08036063: Allow dev access to db-B-001 for dereckson.

Revision Contents
Changeset List

Path

Size

pillar/

dbserver/

cluster-B.sls

17 lines

roles/

dbserver-mysql/

content/

init.sls

2 lines

Diff 7966

View Options

pillar/dbserver/cluster-B.sls