Installing Project Pier on Ubuntu Server

As of late, I have undertaken the quest in search of a small-business, open-source, project management/wiki/file storage solution.  Oh, and I hope the “open-source” adjective conveyed that it needs to be a free (as in beer) solution as well.

I initially thought JobsWorth was the solution I was looking for, but after many many many many many many many…many hours of getting the server setup, only to find it too buggy for my tastes, I gave up.  The installation for JobsWorth works however, and if you want to give it a try, I have the steps listed in this blog entry.

I have looked at many other options during my quest, such as Redmine, Trac, SugarCRM, TWiki, etc.  Without going into all that detail, the winner was Project Pier.  It fits all the criteria above, and while I immediately found a bug, I submitted an issue ticket, and BAM, WAP, ZOOM the developer is working to get it fixed, so I am very optimistic.  And since it is on GIThub, applying the fix, will be cake 🙂

All that said, here is a tutorial to get Project Pier, version 0.8.8, setup on Ubuntu 10.04 Server Edition.

These of course are taken from the Project Pier Installation page (http://www.projectpier.org/manual/installation/).

My Setup:

  • Ubuntu 10.04 Server Edition (32-bit)
    • JobsWorth Install - Server Settings
    • During Server Setup chose (as seen in screenshot):
      • LAMP Server
      • OpenSSH Server
      • SAMBA Server

Prerequisites:

  1. Webmin
    • This is for easy setup of apache – to install, follow the instructions here: http://www.webmin.com/deb.html.  Go to section “Using the Webmin APT repository”.
  2. GIT
    • sudo apt-get install git-core

The Steps:

  1. sudo apt-get install php5-gd
  2. sudo git clone git://github.com/phpfreak/Project-Pier.git /var/www/projectpier
  3. Locate the following directories and change the permissions to 777 (read/write/execute for all users):
    • sudo chmod -v 777 /var/www/projectpier/public/files;sudo chmod -v 777 /var/www/projectpier/cache;sudo chmod -v 777 /var/www/projectpier/upload;sudo chmod -v 777 /var/www/projectpier/config;sudo chmod -v 777 /var/www/projectpier/tmp
  4. Locate the following file(s) and change the permissions to 777 (read/write/execute for all users):
    • sudo chmod -v 777 /var/www/projectpier/cache/autoloader.php;sudo chmod -v 777 /var/www/projectpier/cache/log.php;sudo chmod -v 777 /var/www/projectpier/upload/attributes.php
  5. You MUST create tho database first
    • echo "CREATE DATABASE projectpier DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL ON projectpier.* TO 'projectpierDBA'@'localhost' IDENTIFIED BY 'keepitsecretkeepitsafe'; FLUSH PRIVILEGES;" | mysql -u root -p
  6. Create a Virtual Host on your Apache Server (see screenshots)
    • Create Virtual Host with Webmin
    • Create Project Pier Virtual Host
  7. Restart Apache
    • sudo /etc/init.d/apache2 restart
  8. Open up FireFox, and navigate to:
    • http://localhost/projectpier/public/install/
  9. Follow the instructions
    • When you get to “Step 3: Database configuration” (see screenshot)
      • Project Pier Installation - Step 3
    • If all goes well you’ll see:
      • Project Pier Installation - Success
  10. Locate the following file(s) and change the permissions to 777 (read/write/execute for all users):
    • sudo chmod -v 777 /var/www/projectpier/config/config.php
  11. In FireFox, navigate to:
    • http://localhost/projectpier/public/
  12. You will now be asked to set up an Admin user
  13. Get going, and enjoy Project Pier 🙂

Hope this was helpful.

Comments, questions, and corrections are always welcome 🙂  Just leave them below.

End Of Line.

Advertisements
  1. #1 by Richard on March 19, 2012 - 11:04

    Great article. Thanks for this. It is the first article for installing a linux app that worked right out of the box.

  2. #2 by Richard on March 19, 2012 - 12:24

    ok. I thought it was working… After I updated the ubuntu server, all of a sudden, I can’t access the page. Whenever I put in the url, it tries to download a file instead of loading a page. Can anybody help?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: