Differential D3667

Give read-only access to Rhyne-Wise to query Agora pages
Needs ReviewPublic
Actions

Authored by dereckson on Fri, Sep 12, 19:21.

Details

Reviewers

DorianWinty

Maniphest Tasks

T2124: Update reports automatically on Agora

Summary

Ref T2124

Test Plan

Connect to MariaDB

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Passed

Unit

No Test Coverage

Branch

rhyne-wyse-mariadb-access

Build Status

Buildable 5874
Build 6156: arc lint + arc unit

Event Timeline

dereckson created this revision.Fri, Sep 12, 19:21

Harbormaster completed remote builds in B5874: Diff 9495.Fri, Sep 12, 19:21

dereckson requested review of this revision.Fri, Sep 12, 19:21

Run against db-B-001:

Complector

$ salt db-B-001 state.apply roles/dbserver-mysql/content
[…]
          ID: dbserver_mysql_user_rhyne-wyse
    Function: mysql_user.present
        Name: rhyne-wyse                                                                                  
      Result: True                               
     Comment: The user rhyne-wyse@172.27.27.35 has been added
     Started: 21:31:20.297435                                                                             
    Duration: 200.302 ms     
     Changes:   
              ----------
              rhyne-wyse:
                  Present
[…]
        
          ID: dbserver_mysql_user_rhyne-wyse_privilege_1_page
    Function: mysql_grants.present                                                                        
      Result: True                
     Comment: Grant SELECT on nasqueron_wiki.page to rhyne-wyse@172.27.27.35 has been added
     Started: 21:31:20.627693                                                                                                                                                                                        
    Duration: 30.465 ms      
     Changes:   
              ----------
              dbserver_mysql_user_rhyne-wyse_privilege_1_page:
                  Present
[…]

Access works:

WindRiver

$ mysql -urhyne-wyse -p -hdb-B-001 < ./sql/db-B/agora/operations-grimoire-older-pages.sql                  
Enter password:                            
page_link       age                        
[[Operations grimoire/Mail|Mail]]       221
[[Operations grimoire/Decom|Decom]]     306
[[Operations grimoire/Who|Who]] 314                
[[Operations grimoire/Sites on Ysul|Sites on Ysul]]     321