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. You might find this article useful in setting up backspace inside sqlplus.
As of 2024-07-03, Seth Digel is the owner of the spbureau confluence account and receives the change notices. The instructions assume the ability to take on the passwordless glast identity via ssh.
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 $ 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