Local GPM Installation Instructions

Revision as of 22:41, 28 June 2010

1. Key
   1. Text written in fixed-space font denote text you will type in, as written.
   2. Text written in bold are directory paths.
2. Prerequisites
   1. A fully patched 32-bit version of a Windows operating system.
   2. A hard drive with several gigabytes of free space.
   3. PLEASE NOTE: The suggestions made below are a best-guess to get your local version of the GPM up and running. Your specific computing environment may require different values than those listed; if you have difficulty getting everything installed, please contact your local technical support.
3. Download ftp://ftp.thegpm.org/projects/localgpm/gpm-software.zip This is the directory structure, scripts and support files that will operate the local GPM version, as well as some tools to modify the scripts for your specific location.
4. Download Apache HTTP Server, ActiveState Perl and MySQL Community Edition.
   1. Apache: http://httpd.apache.org/download.cgi
   2. ActiveState Perl: http://www.activestate.com/activeperl/downloads
   3. MySQL: http://www.mysql.com/downloads/mirror.php?id=390181#mirrors
   4. Or, ftp://ftp.thegpm.org/projects/localgpm/apache-perl-mysql.zip This is a single archive file which contains Apache HTTP Server 2.2.15, ActiveState Perl 5.10.1.1007 and MySQL Server 5.1.48. After downloading, extract the three setup files to a temporary location; you will not need them after installation is complete.
5. Extract the contents of gpm-software.zip to the location you have chosen. E.g., if the E: drive on your computer has the free space an installation will require, extract gpm-software.zip to E:\.
6. Install Apache, Perl and MySQL, following the directions provided in the installation process. These directions assume that the versions of Apache, Perl and MySQL to be used were extracted from the archive available on the GPM FTP site.
   1. Apache (called httpd-2.2.15-win32-x86-openssl-0.9.8m-r2.msi)
      1. "Network domain" value should be the same as the end of the target computer's DNS name; e.g., if the target computer has a DNS entry of "science14.med.university.edu", enter "med.university.edu". If you need assistance with this step, contact your local support.
      2. "Server name" value should match the full DNS name of the target computer. E.g., if the computer onto which the local version of the GPM is being installed has a DNS name of "web3.university.edu", enter "web3.university.edu". If you need assistance with this step, contact your local support.
      3. "Administrator's email address" is the email displayed if the web server encounters problems displaying pages.
      4. Choose between having Apache run as a service (will be available whenever the computer is on; recommended), or being manually started and stopped.
      5. Use a "Typical" installation.
      6. Let installation complete.
      7. Navigate to the Apache installation directory (C:\Program Files\Apache Software Foundation\Apache2.2 by default). Go into the conf directory. Make a backup copy of httpd.conf.
      8. Edit httpd.conf as follows:
         1. The DocumentRoot value is based off wherever you extracted gpm-software.zip. Do a search and replace on everything between the quotes and substitute "<base_path>/thegpm", where <base_path> stands for the path in which you extracted gpm-software.zip. E.g., if you installed to E:\, write "E:/thegpm"; if you installed to "D:/websites/", write "D:/websites/thegpm".
         2. A few lines below the DocumentRoot entry is a line that begins <Directory "<drive_letter>:/path"> There is a note above it regarding changing that value to match the DocumentRoot path. Do so.
         3. In the section marked "<IfModule alias_module>", modify the ScriptAlias value, based off wherever you extracted gpm-software.zip. Make the line read: ScriptAlias /thegpm-cgi/ "<base_path>/thegpm/thegpm-cgi/", where <base_path> stands for the path in which you extracted gpm-software.zip. E.g., if you installed to 'E:\, write "E:/thegpm/thegpm-cgi/"; if you installed to "D:/websites/", write "D:/websites/thegpm/thegpm-cgi/".
      9. Save the changes and restart the Apache server. If it fails to start, use the command-line Apache tool: "apachectl configtest" in the /bin/ folder of the Apache install directory.
   2. Perl (called ActivePerl-5.10.1.1007-MSWin32-x86-291969.msi): choose a "typical" install using the recommended settings. Remember the drive letter in which Perl was installed; it will be needed later (the default perl installation directory is C:\perl).
   3. MySQL (called mysql-essential-5.1.48-win32.msi)
      1. Choose a "Typical" install.
      2. Choose "Configure the MySQL Server now".
         1. Choose "Detailed Configuration".
         2. Choose "Server Machine".
         3. Choose "Non-transactional Database".
         4. Choose "Decision Support (DSS)/OLAP".
         5. Choose "Include Bin Directory in Windows PATH".
         6. Enter a root password. Remember this password, as it will be needed later. Complete the configuration.
      3. Stop the MySQL service. Go to the installation directory of MySQL. Make a backup copy of the my.ini file. Open the my.ini file and locate the datadir value.
      4. Navigate to the default data directory specified in the datadir directory, and copy all contents of the default data folder (including all subfolders) to <base_path>/gpmdb/data/, where <base_path> is where the gpm-software.zip archive was extracted. Update the datadir value in the my.ini file to read datadir="<base_path>/gpmdb/data/", including the double quotes, where <base_path> is where the gpm-software.zip archive was extracted.
      5. Save the file and restart the MySQL service.
7. Run the script to edit the path information for all the Perl scripts used. Start a command-line window, and navigate to \thegpm\scripts\ directory. Run the script local_gpm_pathmod.pl by typing perl local_gpm_pathmod.pl <perl_path> where <perl_path> is the path to the Perl executable (by default, this is: c:/perl/bin/perl.exe). Ensure you use front slashes (/) instead of back slashes (\) when typing the path. This will edit scripts in both \thegpm\scripts\ and \thegpm\thegpm-cgi\.
8. In the \thegpm\thegpm-cgi\ directory, edit the hurricane.cfg file.
   1. This needs details.
9. Edit the \thegpm\thegpm-cgi\dbcommon.pl file. Define usernames and passwords for both the read-only database user and root-like user. NOTE: is is NOT recommended to use the root username and password you defined during MySQL setup in the dbcommon.pl file.
10. Edit the \thegpm\thegpm-cgi\defines.pl file.
11. Log inty MySQL as the root user you defined during its installation. Then, type: source <base_path>/thegpm/scripts/create_gpmdb.sql;. This will create the gpmdb database and table structure that will be populated after data files are submitted to the identification software.
12. Schedule the execution of the \thegpm\scripts\popGPMDB.pl script, which parses the XML files created by the search software and adds them to the database.