Sonora Communications, Inc.

These are some basic notes that will be filled out over time.  In the mean time, these will help me remember what I have learned so far...  This is not a complete howto, but it's pretty close.

Description 

dotProject is a web-based project management system.  It is considered the best open source project management system available by many.  You can get it here.

Prerequisites

• Apache
• PHP
• MySQL 

Create a Database and Database User

On your Centos web server at the command line as root:

mysql -p        # skip the '-p' if the root user does not need a password

mysql> create database dotproject;

mysql> grant all privileges on dotproject.* to dotproject@"localhost" identified by 'yourpassword';

mysql> exit

This will create a database named 'dotproject' and a user also named 'dotproject' with a password of 'yourpassword'.  Adjust as desired.

Installing dotProject

On your Centos web server at the command line as root:

cd /var/www/html      # web root

wget http://superb-east.dl.sourceforge.net/sourceforge/\
dotproject/dotproject_2.1-rc2.tar.gz

tar -xzvf ~/dotproject_2.1-rc2.tar.gz

chown -R root.root dotproject

chown apache.apache dotproject/includes/config.php

chown apache.apache dotproject/files

chown apache.apache dotproject/files/temp

chown apache.apache dotproject/locales/en

From a web browser, browse to the following URL:

 http://your.host.name/dotproject/install/

You will be presented with the installer. 

Take some time to check all of the items and fix all anything needing fixing before clicking next.

Enter the database name, user name and password created above when prompted.

Securing dotProject

It is recommended to delete or rename the 'install' directory.

It is recommended to immediately change the admin password.

It is recommended to use SSL (encrypted) connections when accessing dotProject via the Internet.

You can force the use of SSL for all connections by adding something like this to your /etc/httpd/http.conf file:

Alias /dotproject /var/www/html/dotproject/
<Directory /var/www/html/dotproject>
  SSLRequireSSL on
  AllowOverride All
  AddHandler cgi-script .pl
  Options ExecCGI Includes FollowSymlinks
  Order Allow,Deny
  Allow from All
</Directory>

Using dotProject

Using a web browser, browse to: 

http://your.host.name/dotproject

The default admin credentials are 'admin' and 'passwd'.  You should change the password immediately.