Installing ProjectPier 0.8.8 SP2

Who should perform the installation?

Installing ProjectPier requires an understanding of how to install PHP/MySQL based software applications. If you have installed other PHP/MySQL software applications (example: Wordpress or Joomla) you will find the instructions below easy to follow. If you have never installed a PHP/MySQL application but are familiar with how basic linux web hosting accounts work (for example you have used C-Panel based web hosting) then you should be able to understand the instruction and successfully install ProjectPier on your server. If most of this paragraph has not been understandable, then you should probably not attempt to perform the installation yourself. In this case you may want to consider contacting your Information Technology department for help, or purchasing a web hosting package with and automated ProjectPier installer.

Requirements

To install ProjectPier you need a web server that meets the following requirements

Apache HTTP web server 2.0 or greater
PHP 5.2 or 5.3 (MySQL, GD and SimpleXML extensions are required)
MySQL 4.1 or greater with InnoDB support
Please note that you cannot use ProjectPier with PHP 4. Please contact your provider if and how you have to configure your settings to use PHP 5.

Enabling InnoDB Support

Some installations of MySQL don't support InnoDB by default. The ProjectPier installer will tell you if your server is not configured to support InnoDB. This is easy to fix on a dedicated server or virtual server if you have root access. If you are attempting to use a shared web hosting account you probably don’t have access to the files required. In that case contact your hosting provider.

Open your MySQL options file, the file name is my.cnf (Linux) - usually at /etc/my.cnf or my.ini (Windows) - usually at c:/windows/my.ini. If you are using the Uniform Server on Windows, the file will be named 'my-small' and will need to be edited with a unix compatible editor such as Notepad++ or PSPad.
Comment the skip-innodb line by adding # in front of it (like #skip-innodb).
It would also be good to increase max_allowed_packet to ensure that you will be able to upload files larger than 1MB. Just add this line bellow #skip-innodb line:
set-variable = max_allowed_packet=64M

Alternatively, just install without InnoDB support. The installer will allow you.

Download ProjectPier

Download ProjectPier from the Projects page (http://www.projectpier.org/project/ProjectPier). You can also download your language and themes from that page.

If you have shell access to your server and want to download directly to your server use the following command. First, ensure you are in your web hosting home directory, then type:

wget http://www.projectpier.org/files/pp088.zip

Unzip the file using the command

unzip pp088.zip

If you wish, you may rename the directory (defaults to pp088) or move the files up to the home directory.

Installing

Unzip the file pp088.zip to a temporary location on your hard drive. Using an FTP client software application such as FileZilla (http://filezilla-project.org/), transfer the files to your web hosting home directory. If you prefer that ProjectPier be installed in a subdirectory (example: /projectpier or /projects), first create the subdirectory on your server, then upload the files there. If you have downloaded the files directly to your server using wget (as described above) then this is not necessary. Regardless of how you have accomplished the task of placing the files on your server, continue with the steps below.

ProjectPier will need to write to certain files on your file system as outlined in the two sub-items below. On Windows systems there is generally no special settings required. On *nix systems file permissions will need to be set accordingly. Taking these steps in advance is optional; the installer will let you know if it needs write access to a file or directory to which it does not have proper access at the time the installer is run.
- Locate the following directories and change the permissions such that they are writable by the web server (755 will work on most *nix systems):
  - /public/files
  - /cache
  - /upload
  - /config
  - /tmp
- Locate the following files and change the permissions such that they are writable by the web server (644 will work on most *nix systems):
  - /cache/autoloader.php
  - /cache/log.php
Log into your MySQL database management tool through your preferred method (example: phpMyAdmin) and create a new database and a new username and password for that database. Write these down, the ProjectPier installer will ask you to enter this information. Alternatively, the ProjectPier installer can create the database for your, but you will still need to know a MySQL username and password with appropriate permissions to create a new database.
Run the ProjectPier installer. To do this, in your browser navigate to the "/public/install" URL. For example, if you uploaded the ProjectPier installation files to a subdirectory named “projectpier” in your web hosting home directory, then navigate to “http://www.domain.com/projectpier/public/install”.
Follow the installer's instructions.

Install Service Pack 1

Download Service Pack 1 from: http://www.projectpier.org/files/pp088sp1.zip

Unzip the files to a temporary location on your hard drive. Using an FTP client software application transfer the files to your web server at the root of your ProjectPier’s installation directory. Note: this will overwrite some existing files with newer versions.

Install Service Pack 2

Download Service Pack 2 from: http://www.projectpier.org/files/pp088sp2.zip

Using a web browser, open the URL http://YOUR-SITE.com/public/patch/patch.php?id=086-088-a which will run a script that will make the necessary database changes. Replace YOUR-SITE.com with your site url and possibly path (e.g. www.yourdomain.com/projects).

Manual - Installation