SNO-STR-96-018
Contents
1. snodb perl help to see a list of the snodb perl command options Note that in what follows com mand options are given one at a time but that they can be entered simultaneously if you wish keeping in mind that the order may matter 3 2 Creating the directory structure for SNODB The first step is to create the directory structure Type 2 09 scripts snodb perl dir This will create the required directory structure and set the proper ownerships for each of them You should now have 3 directory structure l The official database directory with permission 750 2 The test database directory with permission 750 3 The server directory This is set by default to be hepdb cdsno It should have the following minimum structure hepdb cdsno bad dir where the server places bad updates exes dir for SNODB binaries log dir where the server logs are written queue dir where HEPDB clients place new updates save dir where server saves old updates todo dir which server scans for new updates writeto_dbase Top dir for ascii titles files writes readfrom dbase Top dir for ascii titles files reads 3 3 Making the binaries Next compile and link the various SNODB tools and the server program by issuing the command 2_09 scripts snodb perl make_tools You should now have the minimum following files under the hepdb cdsno exes directory In some institutions where the system administrator does not allo2. SNO STR 96 018 June 12 1996 Installing SNODB The SNO Database SNODB Code v2 09 D Cowen Penn G Jonkmans CRL R Komar UBC i OO Contents 1 Introduction 1 Lil Geringe PERD aao ea bee 8 ea eA ee ee ee ee crete amp 2 2 Getting Started 2 3 Shipping and Installing the Programs 3 1 Defining Your Local SNODB Configuration 2 aaa 3 2 Creating the directory structure for SNODB 5 3 3 Making the binaries 2 oe ee ee 5 3 4 Creating the hepdb names fille 2 2 2 0020 500005 6 3 5 Starting the server 2 2 ee ee 6 4 Building the database 6 4 1 Building the database files and structure Sey bs 6 4 2 Loading the database with the SNOMAN titles files 7 5 Setting up for a Networked Database 7 6 Running SNOMAN with the static database 7 7 Post mortem 9 8 Contacts 9 9 Acknowledgements 9 1 Introduction The current version of SNODB is supported on UNIX platforms The VMS plat form will be supported in the near future but if you have a choice it is strongly recommended that you install SNODB on a UNIX platform Before you can use the SNO database you must obtain and install at least 95a and preferably 95b or 96a PACKLIB part of CERNIib Even 96a currently has some bugs cdfrst edfsnd aid cdsopn but a set of cd f routines is supplied with SNODB and fixes bugs in 95a 95b and 96a The main engine for installing SNODB is a PERL script PERL is a language for easily manipula
3. base SNOMAN 2 09 does not require a database to run Indeed by default it will not even initialise the database software unless the symbolic command enable database is issued Even that is insufficient to get it to read from the database as ti tles banks coming from titles files take priority As SNOMAN comes with a complete set of title files so by default it will not search the database for them To force loading from the database it is necessary to remove the TI TLES commands from the cmd files and the file read_universal titles cmd 7 To test out the database you could try commenting out lines in this file assuming that the files have been loaded into the database However do NOT comment out the following files job control dat This contains the TMTT titles bank which controls enabling of the database As such it could hardly be useful if the database had to be accessed to get it ntuple dat SNOMAN does not demand NTPR ntuple request banks instead it just uses those that the user has provided via titles files Do NOT load the pmt_positions seattle dat files into the database as the GEDP banks they contain will overwrite the SNO ones and you will end up with rather few PMTs This will not be a problem in the longer term miniSNO data from the Seattle tank will have a different data type to SNO and the access to the database will be data type sensitive For now to run miniSNO data will require the use of the TITLES com
4. f routines If your platform is not there modify SNO_TOOLS get platform varia accordingly make a subdirectory with this platform name and then make symbolic links to the f files in the SUN subdirectory At present none of the routines are platform dependent so we arbitrarily chose the SUN subdirectory to hold all the files 3 1 Defining Your Local SNODB Configuration The database setup proceeds throught a single perl script cdsno 2_09 scripts snodb perl But prior to running snodb perl you need to edit the file cdsno 2_09 scripts snodb config to specify the location of various directories and various snodb initializations The final step is to set an environmental variable CDSERV which tells HEPDB where your server resides It is located under the parent directory with the name you have choosen for your server The default is hepdb cdsno and it is set by the snodb perl script as needed However users other than cdsno will need to edit their login file and define the variable CDSERV to point to the server directory setenv CDSERV hepdb cdsno The setup script automatically loads in the compiling and linking flags defined for your platform in the SNOMAN file SNO_TOOLS get_platform_variables scr For this to work you must have edited the contents of that file as needed and defined SNO TOOLS and SNO_PLATFORM see the SNOMAN installation procedure You are now ready to run snodb perl Type the command 2_09 scripts
5. l man and at least one user group comp lang perl 2 Getting Started Before shipping and installing the code on your computer you will need to create one account with name cdsno This account will host the SNODB code and will run the database server to process updates We strongly recommend that you adhere to the following steps in creating this accounts If you don t it may be very difficult to include your institution in the networked version of the database due out shortly Many of the items below must be done by the system manager e Create an account with name cdsno This is the account under which the various database management servers will run and will be used for database maintenance purposes e Create a sno group which will be used to control who gets read access to the SNO database Every account owned by someone affiliated with SNO should probably be in this group cdsno should also be a member of this group Create a snodbw group which will be used to control who gets write privileges to the SNO database cdsno should be a member of this group Only people officially responsible for putting data into the database should be members of this group Others in general should not be allowed to write to the SNO database in order to protect the integrity of your local database e Create a hepdb directory owned by cdsno with permission 0750 some where with at leas
6. mand to load in the required PMT position files In short you can run SNOMAN with the database by removing all dat files from the prod area except ntuple dat job control dat pegs4_10 dat and symbol_table dat Then a simple command file such as L a a a II IM III nT ifile member RUN_SNODB library SNOMAN language cmd file DATE 30 Jun 1995 echo Standard Command File run_snodb cmd 22 May 1996 noecho Contact G Jonkmans CRL Perform standard run enable_database titles ntuple dat titles job_control dat Terminate command processing end tendfile member RUN_SNODB 7 Post mortem Oh and congratulations vou have just been nominated local database Czar for your node Send your name and e mail to cowenGupennd hep upenn edu along with the internet address of the machine where vou have installed SNODB 8 Contacts D Cowen Penn cowen upennd hep upenu edu G Jonkmans CRL jonkmanscrl aecl ca R Komar UBC robk physics ube ca 9 Acknowledgements The authors would like to thank Nick West for many useful suggestions References 1 Schwartz Learning PERL O Reilly amp Associates http www ora com 1994 Recommended starting point Wall and Schwartz Programming PERL O Reilly amp Associates 1992 A good reference
7. ogram sndirs creates internal structure as requested by sndirs dat in each of these files snalia is then run to create HEPDB aliases as requested in sndirs dat 4 2 Loading the database with the SNOMAN titles files Finally vou can load the database with the SNOMAN 2 09 titles files 2 09 scripts snodb perl load tz This loads the 2 09 title files in the database file sm dbs in the test database directory The loading is performed by running the program sn_input_titles 2 09 This is a dedicated program for the version 2 09 release of SNOMAN 5 Setting up for a Networked Database The following changes must be made by your system manager in order to enable SNODB to update the database on your node and accept database updates from your node via ftp Note that SNODB will not be running in networked mode in this release but that it will be in the near future 1 Add the following line to etc services zserv 346 tcp server for zftp w Add the following line to etc inetd conf zserv stream tcp nowait root lt path to zserv gt zserv zerv 3 Reset inetd by finding its Process ID PID with ps and issuing the command kill HUP lt PID gt se 6 Running SNOMAN with the static database Here are the relevent excerpts from the SNOMAN user manual SNOMAN 2 09 has an interface to the SNO Database which is imple mented using the CERN package HEPDB To allow people time to get an up to date CERNIib and set up a data
8. t a few hundred MB of space There should be a link to this directory in the root directory and it should be called hepdb This is the directory which will contain all of the files and directories required by the HEPDB database servers This directory is refered to as the parent directory You are now ready to ship and install the programs 3 Shipping and Installing the Programs From your cdsno account pick up snodb_2_09 tar gz via anonymous ftp from the distribution site Site upennd hep upenn edu Directory pub cowen snodb From this directory copy the tar file snodb_n_nn tar gz where n nn is the version number i e 2 09 into the cdsno root directory e g hepdb cdsno Run gunzip and tar xvf snodb_n_nn tar to expand it You should now have the following directory structure on cdsno cdsno 2_09 cernmodsf Debugged CERN packlib routines dbs_toolsf The database tools doc Documentation includes include files common to dbs tools_f and snomanf scripts The main perl script plus other scripts snomanf SNOMAN subroutines alter at your own peril Go to the xxx_f directories and remove the o files If needed go to the xxxf directories and rename the f files to for The snoman f directory is special in that it contains several subdirectories for each SNO platform They in turn contain our platform dependent debugged versions of the CERN cd
9. ting text files and processes Many UNIX system managers use PERL to control complex system related tasks PERL is freeware and widely available and mav already be present on your UNIX site To find out if it is type which perl Typically you will get an answer like usr bin perl If you do not PERL is either not in your path or it is not present on your machine The next step is therefore to ask your system manager if PERL is on your system If it isn t have it installed by following the instructions in the subsection 1 1 If PERL is present but isn t in ust bin perl please have your system manager set up softlink so that usr bin perl points to wherever your PERL is located If PERL is present you can skip to section 2 1 1 Getting PERL PERL is freeware You can get it via anonymous ftp from any of the following sites e ftp uu net e archive cis ohio state edu o jpl devvax jpl nasa gov Each of these machines keep things in a slightly different way so the best strategy is to look fora README file and follow the local instructions At this writing the most recent version of PERL was gt 5 0 We are currently running v5 000 Please install PERL in usr bin perl or set up a softlink from there to wherever it is installed For those of you who wish to know more about PERL there are two excellent books 1 web sites containing on line manuals http www eleves ens fr 8080 cgi bin perl man and http www cs cmu edu 8001 htbin per
10. w the parent directory to belong to the cdsno account you will need to reset the group assignment and some permissions of all the created directories and files we cdserv The server program from CERN plus bug fixes sncreate Will create the database files sndirs t Will create the directory structure in the database file snalia Will create alias definition for the diretories sn_input titles2 09 Loads the SNOMAN 2 09 titles in the database 3 4 Creating the hepdb names file Next create the hepdb names file 2 09 scripts snodb perl names This file is created on CDSERV and it contains the server configuration It con tains such information as the location of the database file s the location of the servers directories the write and read autorizations the wake up interval for the server nodes locations etc 3 5 Starting the server You then need to start the database server before building the database 2_09 scripts snodb perl server You may verify that the server is running with the ps command You are now ready to build the database l 4 Building the database 4 1 Building the database files and structure Now that the server is running and ready to receive updates type the command 2_09 scripts snodb perl build test This builds the test database files When run the sncreate program causes the server to create the database files requested and listed in the sncreate dat file The pr
Download Pdf Manuals
Related Search
SNO STR 96 018