Download this ISO file (CD image) and write it to a CD. This gives you all our data in SQL format as well as all scripts used to generate the webpage. Follow the below instructions for installation.

You can download the whole database and recreate it in a few steps, regardless of your computer system.

We achieve this by providing the database in form of a file of SQL commands. Executing those commands in your SQL server recreates the database.

The following steps assume the MySQL database. It is a high-quality, free and portable database system that can be downloaded free of charge at www.mysql.com. We run it under Linux.

1. Install a MySQL database on your system. The default installation is sufficient.
2. Create a database named "rock".
   > mysqladmin -u root create rock
3. Download the file rock.sql.gz. This file is approximately 4MB big.
4. Decompress it and feed it to MySQL:
   > gzip -dc rock.sql.gz | mysql -u root rock
5. Following the MySQL manual, create administrator and user accounts for your MySQL installation. Don't leave users without passwords. If you want to run CommonGround from your own webpages with our software, make sure to create a user "inet" from localhost with only "Select" privileges and without a password.
6. Restart MySQL with:
   > mysqladmin -u root -p reload
7. Test the MySQL configuration and the database.
8. If it still won't run we are happy to help.
9. We like to get feedback, but best we like error reports! If you notice anything you don't like, tell us!

You may download the scripts used in creating this webpage and use them in any way you wish.

Because there are so many webserver applications available we can't give exact instructions as to how to install them on your system. We use Apache which is free, portable and very powerfull. With Apache on Unix it works like this:

1. Install and configure Apache. You can find information in many places, the most authoritative at the master webpage.
2. Test the Apache configuration on some static pages.
3. Test the Apache configuration on some CGI scripts.
4. Download and install the database according to the above steps. Make sure it works and allows read ("Select") access without password to the user "inet". Make sure this user does not have any other privileges.
5. Make sure you have a recent version of Perl in /usr/bin/perl. Version 5.6 will do nicely.
6. The scripts need several Perl modules like MIME::Base64, CGI and Mysql. If modules are missing you should be able to see the error messages in your log files and install them. See www.perl.com for details. You probably want to use the CPAN.pm module (get it from www.cpan.org) to install missing modules.
7. Download code.tar.gz.
8. Un-archive it into a directory below your web document root.
9. Make sure all scripts (ending in .cgi) have executable permission
10. Configure Apache so that it automatically executes CGI scripts with the .cgi extension. The following lines in your httpd.conf will do:
    AddType application/x-httpd-cgi .cgi
AddHandler cgi-script .cgi
11. Tell Apache to take the file index.cgi as its directory index with a line like
    DirectoryIndex index.html index.txt index.cgi
12. Allow execution of CGI scripts with a line like
    Options +ExecCGI
13. Make sure the user Apache runs as can read and/or execute all our files. Nowadays Apache runs mostly as user nobody, group nobody (or group nogroup). Apache should only run as root if you know exactly what you are doing. Make sure Apache can execute /usr/bin/perl and /usr/bin/perl. Make sure Apache has write permission in data/ and graph/.
14. Adjust variables in help/start.pl. The main thing to adjust is $CG_HTTP_ROOT
15. If it still won't run we are happy to help.
16. We like to get feedback, but best we like error reports! If you notice anything you don't like, tell us!

Please mail any Comments, Questions, Suggestions, and Bugreports to the webmaster.
Copyright 1998-2001 Colorado School of Mines