Admin Manual - Installation

From PikaDocs

The following instructions detail the procedure for installing a Pika site on a Linux, Mac OS or Windows server. It assumes you are installing version 3.06. It also assumes you have a Windows desktop set up with a P: drive that points to the "htdocs" Apache web server document root folder on the Pika server. These instructions can be repeated if you need to install more than one Pika site on a single server. If you are installing an older version, please see Installing Older Versions.

Table of contents
1 Installing a Pika Site on a Linux Server
2 Installing a Pika Site on a Mac OS Server
3 Installing a Pika Site on a Windows Server
4 Troubleshooting Errors
[edit]

Installing a Pika Site on a Linux Server

  1. Download the .ZIP file for the most recent release of Pika 3 from www.pikasoftware.net (http://www.pikasoftware.com/files/releases/) to your desktop PC.
  2. Unzip the downloaded file. It will unzip to a folder named "pika_cms-306" and a folder named "pika_cms-306-custom".
  3. Choose a unique name for this site. Use only lowercase letters, no spaces. For the purposes of this document, the name "sitename" will be used.
  4. Connect to your Pika network drive. This is assumed to be P:.
  5. Rename the "pika_cms-306" folder that you just unzipped to "sitename".
  6. Move the "sitename" folder from your desktop PC to P:.
  7. Rename the "pika_cms-306-custom" folder on your desktop PC to "sitename-custom" and then move it to P:.
  8. Add following line to Apache's httpd.conf configuration file on the server:

Alias /sitename /home/pika/sitename On Linux, this file is usually at /etc/httpd/conf/httpd.conf.

  1. Restart Apache on the server with the following command:

> service httpd restart.

  1. Create a new MySQL database named sitename from the command line.

> mysqladmin -u root -p create sitename

  1. Load all SQL files in /home/pika/sitename/app/sql/install into the new database from the command line. The structure.sql file needs to loaded first otherwise the default-user.sql, default-groups.sql, and reset-counters.sql loads will fail.

> cat /home/pika/sitename/app/sql/install/structure.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-user.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-groups.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/reset-counters.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/menus.sql | mysql -u root -p sitename

  1. Set a new password for the default "amworley" account with the following SQL:

UPDATE users SET password=MD5('newpassword');

  1. Edit P:\sitename\app\config\settings.php, add the hostname of the MySQL server, the name of the new database, plus the MySQL username and password Pika should use to access it.
  2. Check the releases directory for any applicable patches for your version ex. 306 at www.pikasoftware.net (http://www.pikasoftware.com/files/releases/). Install those patches if necessary.
  3. If you have any customizations, copy the custom files into the P:/sitename/ folder, replacing the default files.
[edit]

Installing a Pika Site on a Mac OS Server

  1. Download the .ZIP file for the most recent release of Pika 3 from www.pikasoftware.net (http://www.pikasoftware.net/files/releases/) to the server.
  2. Unzip the downloaded file. It will unzip to a folder named "pika_cms-306" and a folder named "pika_cms-306-custom".
  3. Choose a unique name for this site. Use only lowercase letters, no spaces. For the purposes of this document, the name "sitename" will be used.
  4. Connect to your Pika network drive. This is assumed to be P:.
  5. Rename the "pika_cms-306" folder that you just unzipped to "sitename".
  6. Move the "sitename" folder from your desktop PC to P:.
  7. Rename the "pika_cms-306-custom" folder on your desktop PC to "sitename-custom" and then move it to P:.
  8. Add following line to Apache's httpd.conf configuration file:

Alias /sitename /home/pika/sitename On Mac OS, this file is at /etc/httpd/httpd.conf.

  1. Restart Apache; stop and restart Personal Web Sharing from the Sharing system preferences pane.
  2. Create a new MySQL database named sitename.
    • > mysqladmin -u root -p create sitename
  3. Load all SQL files in /home/pika/sitename/app/sql/install into the new database from the command line. The structure.sql file needs to loaded first otherwise the default-user.sql, default-groups.sql, and reset-counters.sql loads will fail.

> cat /home/pika/sitename/app/sql/install/structure.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-user.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-groups.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/reset-counters.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/menus.sql | mysql -u root -p sitename

  1. Set a new password for the default "amworley" account with the following SQL:
    • UPDATE users SET password=MD5('newpassword');
  2. Edit /Home/pika/sitename/app/config/settings.php, add the hostname of the MySQL server, the name of the new database, plus the MySQL username and password Pika should use to access it.
  3. Check the releases directory for any applicable patches for your version ex. 306 at www.pikasoftware.net (http://www.pikasoftware.com/files/releases/). Install those patches if necessary.
  4. If you have any customizations, copy the custom files into the /Users/pika/sitename/ folder, replacing the default files.
[edit]

Installing a Pika Site on a Windows Server

  1. Download the .ZIP file for the most recent release of Pika 3 from www.pikasoftware.net (http://www.pikasoftware.net/files/releases/) to the server.
  2. Unzip the downloaded file. It will unzip to a folder named "pika_cms-306" and a folder named "pika_cms-306-custom".
  3. Choose a unique name for this site. Use only lowercase letters, no spaces. For the purposes of this document, the name "sitename" will be used.
  4. Connect to your Pika network drive. This is assumed to be P:.
  5. Rename the "pika_cms-306" folder that you just unzipped to "sitename".
  6. Move the "sitename" folder from your desktop PC to P:.
  7. Rename the "pika_cms-306-custom" folder on your desktop PC to "sitename-custom" and then move it to P:.
  8. Add following line to Apache's httpd.conf configuration file:

Alias /sitename "C:\Program Files\Apache Group\Apache2\htdocs\sitename" On Windows, it is usually at C:\Program Files\Apache Group\Apache2\conf\httpd.conf.

  1. Restart Apache by restarting the Apache Web Server system service.
  2. Create a new MySQL database named sitename.
    • > mysqladmin -u root -p create sitename
  3. Load all SQL files in /home/pika/sitename/app/sql/install into the new database from the command line. The structure.sql file needs to loaded first otherwise the default-user.sql, default-groups.sql, and reset-counters.sql loads will fail.

> cat /home/pika/sitename/app/sql/install/structure.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-user.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/default-groups.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/reset-counters.sql | mysql -u root -p sitename
> cat /home/pika/sitename/app/sql/install/menus.sql | mysql -u root -p sitename

  1. Set a new password for the default "amworley" account with the following SQL:
    • UPDATE users SET password=MD5('newpassword');
  2. Edit C:\Program Files\Apache Group\Apache2\htdocs\sitename\app\config\settings.php, add the hostname of the MySQL server, the name of the new database, plus the MySQL username and password Pika should use to access it.
  3. Check the releases directory for any applicable patches for your version ex. 306 at www.pikasoftware.net (http://www.pikasoftware.com/files/releases/). Install those patches if necessary.
  4. If you have any customizations, copy the custom files into the C:\Program Files\Apache Group\Apache2\htdocs\sitename\ folder, replacing the default files.
[edit]

Troubleshooting Errors

If you see an error that looks like this: 

Cannot modify header information - headers already sent by (output started at /var/www/sitename-custom/config/settings.php:33)
File: /var/www/sitename/app/lib/pl.php
Line: 157

The problem is that the variable base_directory in the settings.php file has an incorrect path.


Preparing Your PC | Configuration

Table of Contents

Retrieved from "http://pikasoftware.com/docs/index.php/Admin_Manual_-_Installation"