In this tutorial we will show you how to install ProjectPier on Ubuntu 14.04. For those of you who didn’t know, ProjectPier is an open source community aimed at developing simple, powerful and intuitive software for web-based project management and group collaboration. ProjectPier gives you a flexible system for managing projects involving multiple organizations by providing a central place for all project activity and information while integrating with users’ existing tools. ProjectPier is freely available and licensed under the Gnu Affero General Public License (AGPL), which means you’re welcome to use and modify the software as long as any changes are distributed under the same license restrictions.
This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple. I will show you through the step by step installation ProjectPier on an Ubuntu 14.04 server.
Install ProjectPier on Ubuntu 14.04
Step 1. First of all make sure that all packages are up to date.
Step 2. Install LAMP server and include some PHP extension.
sudo apt-get install mysql-client mysql-server apache2 php5 php5-cli php5-gd php5-ldap php5-curl php5-gd php5-xml
Start service Apache web server and MySQL also enable it to start on boot of the server:
Step 3. Configuring MySQL for ProjectPier.
By default, MySQL is not hardened. You can secure MySQL using the mysql_secure_installation script. you should read and below each steps carefully which will set root password, remove anonymous users, disallow remote root login, and remove the test database and access to secure MySQL:
Next we will need to log in to the MySQL console and create a database for the ProjectPier. Run the following command:
mysql -u root -p
This will prompt you for a password, so enter your MySQL root password and hit Enter. Once you are logged in to your database server you need to create a database for ProjectPier installation:
mysql> create database projectpier CHARACTER SET utf8;
mysql> GRANT ALL PRIVILEGES ON projectpier. * TO projectpier@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;
mysql> flush privileges;
Configure your server to support InnoDB, if it is not set by default and increase the max_allowed_packet variable to 128MB:
### nano /etc/mysql/my.cnf
max_allowed_packet = 128M
Step 4. Install ProjectPier.
Download the latest stable version of ProjectPier, At the moment of writing this article it is version 0.8.8:
mkdir -p /var/www/html/projectpier
unzip -d /var/www/html/projectpier pp088wSP2*.zip
Step 5. Configure Apache web server for ProjectPier.
Create a new virtual host in Apache:
### nano /etc/apache2/sites-available/ProjectPier.conf
Options Indexes FollowSymLinks MultiViews
allow from all
CustomLog /var/log/apache2/your-domain.com-access_log common
Restart the Apache service for the changes to take effect:
We will need to change some folders permissions:
chown -R www-data:www-data /var/www/html/projectpier
Step 6. Accessing ProjectPier.
ProjectPier will be available on HTTP port 80 by default. Open your favorite browser and navigate to http://yourdomain.com/public/install or http://server-ip/public/install and complete the required the steps to finish the installation. If you are using a firewall, please open port 80 to enable access to the control panel.
Congratulation’s! You have successfully installed ProjectPier. Thanks for using this tutorial for installing ProjectPier in Ubuntu 14.04 system. For additional help or useful information, we recommend you to check the official ProjectPier web site.