Differential D3211

Create db-B dereckson_www51 user
ClosedPublic
Actions

Authored by dereckson on Jun 27 2023, 20:22.

Details

Reviewers

dereckson

Maniphest Tasks

T1897: Provision development sites on WindRiver

Commits

rOPS72e1e293ba3c: Create db-B dereckson_www51 user

Summary

Database is currently share between prod and dev.

Ref T1897

Test Plan

Provision on db-B-001

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Jun 27 2023, 20:22

dereckson created this revision.

Harbormaster completed remote builds in B5052: Diff 8213.Jun 27 2023, 20:22

Currently for web-001, should be for WindRiver.

Complector

$ salt db-B-001 state.apply roles/dbserver-mysql/content
[…]
----------
          ID: dbserver_mysql_user_dereckson_www51
    Function: mysql_user.present
        Name: dereckson_www51
      Result: True
     Comment: The user dereckson_www51@172.27.27.10 has been added
     Started: 22:24:16.036215
    Duration: 17.239 ms
     Changes:
              ----------
              dereckson_www51:
                  Present
[…]
----------
          ID: dbserver_mysql_user_dereckson_www51_privilege_1_Dereckson
    Function: mysql_grants.present
      Result: True
     Comment: Grant all privileges on Dereckson.* to dereckson_www51@172.27.27.10 has been added
     Started: 22:24:16.200081
    Duration: 13.899 ms
     Changes:
              ----------
              dbserver_mysql_user_dereckson_www51_privilege_1_Dereckson:
                  Present
[…]

db-B-001

$ mysql
DROP USER dereckson_www51@172.27.27.10;
Query OK, 0 rows affected (0.002 sec)

complector

$ salt db-B-001 state.apply roles/dbserver-mysql/content
[…]
----------
          ID: dbserver_mysql_user_dereckson_www51
    Function: mysql_user.present
        Name: dereckson_www51
      Result: True
     Comment: The user dereckson_www51@172.27.27.35 has been added
     Started: 22:34:19.668323
    Duration: 18.678 ms
     Changes:
              ----------
              dereckson_www51:
                  Present
[…]
----------
          ID: dbserver_mysql_user_dereckson_www51_privilege_1_Dereckson
    Function: mysql_grants.present
      Result: True
     Comment: Grant all privileges on Dereckson.* to dereckson_www51@172.27.27.35 has been added
     Started: 22:34:19.832210
    Duration: 13.657 ms
     Changes:
              ----------
              dbserver_mysql_user_dereckson_www51_privilege_1_Dereckson:
                  Present
[…]