How To Install ProjectPier on CentOS 7

To Install ProjectPier on CentOS 7

ProjectPier is a free and open-source self-hosted PHP application for managing tasks, projects and teams through an web interface. With ProjectPier, you can communicate, collaborate and get things done within your organization. It is to be noted that ProjectPier is licensed under the Gnu Affero General Public License (AGPL). It is very easy to install ProjectPier on CentOS 7 and this tutorial covers the ground on the same procedure.

Before installing ProjectPier, you need to have LAMP stack installed in your system.

Installing ProjectPier

You shall download the installation package from the official website. Make use of the wget command to fetch the installation package for ProjectPier.

[root@localhost Desktop]# wget https://excellmedia.dl.sourceforge.net/project/projectpier/projectpier/projectpier-0.8.8/pp088.zip
--2017-09-23 15:24:14-- https://excellmedia.dl.sourceforge.net/project/projectpier/projectpier/projectpier-0.8.8/pp088.zip
Resolving excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)... 202.153.32.19
Connecting to excellmedia.dl.sourceforge.net (excellmedia.dl.sourceforge.net)|202.153.32.19|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3033616 (2.9M) [application/octet-stream]
Saving to: ‘ pp088.zip’ 
100%[================================================================================> ] 30,33,616 815KB/s in 3.6s
2017-09-23 15:24:18 (819 KB/s) - ‘ pp088.zip’  saved [3033616/3033616]

After downloading the package, you should create projectpier directory inside /var/www/html/ directory. Run the following command for the same purpose.

[root@localhost Desktop]# mkdir -p /var/www/html/projectpier

Now, extract the downloaded package to newly created projectpier directory as follows.

[root@localhost Desktop]# unzip pp088.zip -d /var/www/html/projectpier
Archive: pp088.zip
creating: /var/www/html/projectpier/pp088/
inflating: /var/www/html/projectpier/pp088/.htaccess
creating: /var/www/html/projectpier/pp088/application/
inflating: /var/www/html/projectpier/pp088/application/application.php
&hellip 
&hellip 
&hellip 
extracting: /var/www/html/projectpier/pp088/upload/attributes.php
extracting: /var/www/html/projectpier/pp088/upload/empty.txt
inflating: /var/www/html/projectpier/pp088/utf8bom.php
inflating: /var/www/html/projectpier/pp088/version.php

Here you need to make some important modifications in the my.cnf file. So, open the file as follows.

[root@localhost Desktop]# vim /etc/my.cnf

Add the following line to the file.

max_allowed_packet = 128M

Save the file and exit from it once it is done.

Another essential thing to do in this procedure is the creation of a database for ProjectPier. So login to the MySQL server through root user. And then, do all the essential things as follows.

[root@localhost Desktop]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with   or g.
Your MariaDB connection id is 2
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type ' help '  or ' h'  for help. Type ' c'  to clear the current input statement.
MariaDB [(none)]>  CREATE DATABASE projectpier CHARACTER SET utf8 
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]>  GRANT ALL PRIVILEGES ON projectpier.* TO ' projectpier' @' localhost'  IDENTIFIED BY ' password'  
Query OK, 0 rows affected (0.03 sec)
MariaDB [(none)]>  FLUSH PRIVILEGES 
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]>  exit
Bye

[root@localhost Desktop]# vim /etc/httpd/conf/httpd.conf

< VirtualHost *:80> 
DocumentRoot " /var/www/html" 
ServerName test.linuxhelp1.com
ErrorLog " /var/log/httpd/projectpier-error_log" 
CustomLog " /var/log/httpd/projectpier-access_log"  combined
< Directory " /var/www/html/projectpier/pp088" > 
DirectoryIndex index.html index.php
Options FollowSymLinks
AllowOverride All
Require all granted
< /Directory> 
< /VirtualHost> 

[root@localhost projectpier]# service httpd restart
Redirecting to /bin/systemctl restart httpd.service

[root@localhost projectpier]# chown apache:apache -R /var/www/html/projectpier