$ 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

dereckson mentioned this in T2124: Update reports automatically on Agora.Sep 12 2025, 19:28

dereckson retitled this revision from Give read-only access to Rhyne-Wise to query Agora pages to Give read-only access to Rhyne-Wyse to query Agora pages.Sep 19 2025, 01:59

dereckson mentioned this in D3693: Give access to Vault to Rhyne-Wyse automated agent.Sep 19 2025, 02:03

DorianWinty accepted this revision.Mon, Oct 13, 17:13

This revision is now accepted and ready to land.Mon, Oct 13, 17:13

Closed by commit rOPS8f76eed4e761: Give read-only access to Rhyne-Wyse to query Agora pages (authored by dereckson). · Explain WhyTue, Oct 14, 17:09

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rOPS8f76eed4e761: Give read-only access to Rhyne-Wyse to query Agora pages.