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 2022-01-10, Richard Dubois 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.

  1. change the password, account SpBureau via https://crowd.slac.stanford.edu/crowd/console/user/viewchangepassword.action
  2. Update the password in Oracle:

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 /@glastgenprod

SQL*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 - Production

SQL> 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

  • No labels