Storage Element (SE) name change

In case the FQDN of a SE changes, some entries need to be modified in the LFC databases.

This is taken care of automatically by the update-LFC-after-SE-renamed.pl script.

It is not yet included in any LFC RPM, but can be found in the gLite CVS repository :

  • LCG-DM module
  • under script/change-se-name

Note : the script only supports Oracle as a database backend for the moment.


Requirements

To run the update-LFC-after-SE-renamed.pl script, the following packages need to be installed :

  • perl
  • perl-DBI
  • perl-DBD (for Mysql or Oracle)

Note : if using Mysql >= 4.1, perl-DBD-mysql >= 2.9003 should be used.

Note2 : the script only supports Oracle as a database backend for the moment.


Example for Oracle

The dummy option only shows the SQL statements that will be executed in the LFC database. But no change will actually be made.

  • dummy mode :

./update-LFC-after-SE-renamed.pl --db LFC_SID --user lfc_user --pwd XXXXX --oldSE castorgrid.cern.ch --newSE castor.cern.ch --dummy

SQL : UPDATE Cns_file_replica SET host='castor.cern.ch' WHERE fileid=596 and sfn='sfn://castorgrid.cern.ch/castor/cern.ch/grid/atlas/bphys/
digit/017502.bb_mu6mu6X/data/bphys.017502.digit.bb_mu6mu6X._00048.pool.root.1'
SQL : UPDATE Cns_file_replica SET sfn='sfn://castor.cern.ch/castor/cern.ch/grid/atlas/bphys/digit/017502.bb_mu6mu6X/data/bphys.017502.digit
.bb_mu6mu6X._00048.pool.root.1' WHERE fileid=596 and sfn='sfn://castorgrid.cern.ch/castor/cern.ch/grid/atlas/bphys/digit/017502.bb_mu6mu6X/dat
a/bphys.017502.digit.bb_mu6mu6X._00048.pool.root.1'
...
Dummy run completed. 343 rows to change.

  • real mode :

./update-LFC-after-SE-renamed.pl --db LFC_SID --user lfc_user --pwd XXXXX --oldSE castorgrid.cern.ch --newSE
Update complete. 343 rows changed.


Troubleshooting

In case the script complains about NLS_XXXX parameters, just unset all the NLS_XXXX environment variables before running the script :

unset NLS_LANG
unset ORA_NLS33
unset NLS_DATE_FORMAT


Help !

In case of problems, contact helpdesk@ggusNOSPAMPLEASE.org (remove the NOSPAM !) : your ROC will help you and contact the appropriate experts if needed.


-- SophieLemaitre - 17 May 2006

Edit | Attach | Watch | Print version | History: r8 | r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2006-05-17 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback