Every 6 months the password needs updating - the account is SpBureau. This account and its password are used by the Speakers Bureau web app, with the password stored in the Oracle database.
ssh glast@fermilnx-v14
glast@fermilnx-v14 $ pwd
/afs/slac.stanford.edu/u/gl/glast
glast@fermilnx-v14 $ source oracle/bin/setup-11g-j7.csh glast@fermilnx-v14 $ sqlpl
sqlplus sqlplus32 sqlplus32O sqlplusO
glast@fermilnx-v14 $ sqlplus /@glastgenprodSQL*Plus: Release 11.1.0.7.0 - Production on Fri Jan 7 17:18:33 2022
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionSQL> update application_variable set variable_value = 'NEW_PASSWORD_HERE' where variable_name = 'spBureauConfluencePasswd’;
SQL> select * from application_variable where variable_name='spBureauConfluencePasswd';Â (check that the update worked)
3. Bounce the SpBureau web app here: https://glast-ground.slac.stanford.edu/ServerMonitoring/exp/Fermi/applications.jsp