dotProject
This guide outlines how to install dotProject on Ubuntu Edgy
server (6.10). dotProject is a web based project management solution.
Contents
Install and configure Ubuntu
Install and configure
dotProject
jpgraph
Task owner on import
Task assignee on import
Credit
Install and configure Ubuntu
Download and install Ubuntu Edgy - During install choose to install the LAMP server components.After install edit the sources list (sudo nano /etc/apt/sources.list) uncomment the universe sources, add a source for multiverse. comment out the cd source if you plan to be distant from the server.
do an source list update and system upgrade (sudo aptitude update && sudo aptitude upgrade)
configure a static IP for the server
install some needed packages (sudo aptitude install openssh-server phpmyadmin msttcorefonts php5-gd)
reboot for sanity purposes (sudo shutdown -r now)
edit php.ini (sudo nano /etc/php5/apache2/php.ini) with the following:
un-comment (remove the ;) from "extension=mysql.so" and "extension=gd.so"
change memory_limit = 8M to 128M
restart apache (sudo /etc/init.d/apache2 restart)
Set a mysql password for root:
sudo mysqladmin -u root password newrootsqlpassword
sudo mysqladmin -p -u root -h localhost password newrootsqlpassword
create database and user on mysql command.
Install and configure dotProject
download dotproject (latest is 2.1 rc1) and download the php 5 version of jpgraphuncompress both files: tar -zxvf *.tar.gz
copy dotPoject to /var/www:
cd into dotproject folder
sudo cp -r * /var/www
copy jpgraph to /var/www/lib/jpgraph
cd into jpgraph folder you just uncompressed
sudo cp -r * /var/www/lib/jpgraph
follow jpgraph to solve a language use issue
create a config.php file and set permissions:
cd /var/www
touch includes/config.php
chmod 777 includes/config.php files/ files/temp /locales/en
load a web browser and go to servers set ip to start installation
click start installation
populate the database name, user and password you set earlier.
click install db & write cfg
remove the install directory - sudo rm -r /var/www/install/
log in to dotProject with the username admin and the password passwd
configure dotProject to meet your requirements.
jpgraph
jpgraph is available as a separate download for people using php >= 5.1.x it is just the case of replacing the contents of ./lib/jpgraph with the version you download from the link.When installed, you will get an error about not being able to use en_AU when trying to generate a Gantt chart, the remedy to this is to do the following:
in ./lib/jpgraph/src/jpgraph.php add the code in bold below:
function Set($aLocale) {
$query = "SELECT 'config_value' FROM 'config' WHERE 'config_name = host_locale'";
$aLocale = mysql_query ($query);
if ( in_array($aLocale, array_keys($this->iDayAbb)) ){
Task owner on import
My requirement was to use template projects, the issue, was that I wanted the imported tasks' "Task Owner" to change to the "Project Owner" of the project being created, to do this:in ./modules/projects/project.class.php add:
$destTask->task_owner = $this->project_owner;
underneath:
$destTask = $objTask->copy($this->project_id);
Task assignee on import
I also wanted the task assignee to be remembered on import, so that we could create a template project with dummy users with roles; to help the project managers easily see who did what task. To do this:in ./modules/projects/project.class.php replace the import functionality with the contents of this: import code
the code is all commented, so you should find where to put this ok.
The code is from the HEAD branch of dotproject.
Credit where credit is due:
None of this could be done without the support of the developers and community at http://www.dotproject.netThe solution is absolutely fantastic and should be considered when reviewing project management functionality.
