Installing Projectory on a Mac OS X/Unix/Linux/BSD Server ------------------------------------------------------------ This installation document assumes that you are installing Projectory on a *NIX server with Apache. It has been tested under Mac OS X 10.3. If you have trouble or find an error in this installation, please visit projectory.sourceforge.net to contact the author. ------------------------------------------------------------ 1: Install MySQL - Download and install MySQL 4.x from www.mysql.com - Follow the installation procedures for your flavor of *NIX - Make sure that MySQL is configured to automatically start at boot-up. 2: Configure MySQL - Set the root password [~/]: mysql -u root mysql> UPDATE user SET Password=PASSWORD("your password") WHERE user="root"; - Create an empty database for Projectory mysql> create database projectory_db; - Create a user account for Projectory mysql> grant all on projectory_db.* to projectory@localhost identified by "projectory password"; mysql> exit; 3: Create the Projectory database - Locate the file projectory_db_init.sql - Use it to create the stub Projectory database [~/]: mysql -u root -p projectory_db < /path/to/install/directory/projectory_db_init.sql 4: Install the Projectory Web Application - Locate the file projectory.cgi and the folder projectory_images - Copy them to the desired location within the web site root folder (e.g. /wwwroot/projectory/) - Make sure that Perl is installed and configured on the server - Use CPAN (sudo perl -MCPAN -e shell) to install all necessary Perl modules: - Date::Manip - DBI - DBD::MySQL - Crypt::Rijndael - Be sure to change the default password used to connect to the MySQL database in setGlobalParams in projectory.cgi. 5: Configure Apache to Recognize Projectory - Open the Apache configuration file using sudo pico /etc/httpd/httpd.conf (or vi or whatever) - Make sure that this line is uncommented: LoadModule cgi_module libexec/httpd/mod_cgi.so - Make sure that this line is uncommented: AddModule mod_cgi.c - In the Document Types section, after , uncomment AddHandler cgi-script .cgi - Add these lines after the DocumentRoot directory entry. Options ExecCGI AddHandler cgi-script cgi AllowOverride Options Order allow,deny Allow from all - If Projectory is installed somewhere else in your web root, adjust the lines above accordingly. - Restart Apache using sudo apachectl restart 6: Test Your Installation - Access Projectory through a web browser. If you installed it in a folder called projectory in the web root of your server, the URL will be http://your_server_address/projectory/projectory.cgi - If you see a dump of Projectory's source code, or get a server error, then you have not correctly configured Apache to run CGI at the location where Projectory is installed. 7: Configure Projectory - Please see the document "GettingStarted.txt" for information on configuring Projectory.