Minos and MySQL


    Installing MySQL

      If you possibly can, the easiest way to install MySQL is with RedHat's rpm system- detailed installation instructions are at

      http://www-numi.fnal.gov/fnal_minos/computing/srt_public_context/WebDocs/external_products.html

      You will also find instructions on setting up the permissions tables. Note that there are "database user accounts" which are not at all the same as "linux user accounts".

      The offline software needs to know where to read data from, and which database account to use to read it. These are supplied by environment variables, set up by SRT. At Minnesota, these are:

      ENV_TSQL_URL=mysql:odbc://urheim.hep.umn.edu/offline;mysql:odbc://urheim.hep.umn.edu/temp
      ENV_TSQL_USER=reader
      ENV_TSQL_PSWD=numi96
      
      At your institution, you should change the "urheim.hep.umn.edu" to the URL of your database machine.


      The mysql client
      Pete Border
      January 7, 2002