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

Also, you shouldn' t forget to configure Apache for ProjectPier, which is why you need to edit the httpd.conf file. So open the file by running the following command.

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

Here, configure the file by making the following changes.

< 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> 

Now save the file and exit.

After the changes, you should restart the Apache web server.

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

Also, you should change ownership for the projectpier directory. Do as follows.

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

Next, open your web browser and navigate to http://192.168.7.203/projectpier. There select public/install to start the installation procedure.

Check out all the system requirements mentioned there and the installation steps, and then click Next.

Then the Server check is done. Click Next when done.

Here you need to configure the Database. Click on Next once done.

Finally click on Finish. The installation has now been completed.

We still need to create the admin account, so create one.

After that, the Login page appears on the screen. Enter the login credebtials and click Login.

Once you log into ProjectPier, you will be taken to the Dashboard.

You can add new projects from the My projects option.

There are also plenty of Administration options for managing your account.

If you want o add plugins, you can choose Administration --> Plugins.

Also, through View admin option, you can edit your admin account.

With this the installation of ProjectPier on CentOS 7 gets completed.