LampConfiguration
From PikaDocs
| Table of contents |
What is LAMP?
There are so many website projects running on Linux/Apache/MySQL/PHP that someone dubbed the term LAMP to serve as a shorthand acronym for the platform. A common variation is WAMP, used for Apache/MySQL/PHP running on Windows.
In most cases Pika Software does the install for you, and the Pika users are blissfully unaware of the various software components humming away on the server. However, some power users prefer to do install the LAMP software on their own; this guide will document what configuration options the advanced techie will face when setting up LAMP (or WAMP) for Pika.
Apache
Apache 1.3 and Apache 2.0 both work equally well with Pika, so that is a matter of your personal preference. If I had to choose one, I'd pick Apache 2.0 because that's what I know best at this point. You shouldn't need any special options in the Apache configuration file for Pika to run well.
MySQL
Pika will run on MySQL versions 3.23 or later. 4.1 is the version used by Pika Software staff for development and testing, and it's the version recommended installing for use with Pika.
You don't need to set any special options in the MySQL configuration file for Pika to run well. Pika Software uses the following options on their production servers, but these are completely optional.
It's a good idea to limit the number of concurrent connections a MySQL user can have open. You will never run into the limit unless something has gone wrong, and the limit will prevent the server from failing in a non-graceful manner. Set the limit by running the following MySQL query as root:
SET GLOBAL max_user_connections=15;
If you use InnoDB, we recommend enabling multiple tablespaces by adding this line to the [mysqld] section of my.cnf:
innodb_file_per_table
PHP
Pika needs version 4.1 or later of PHP. I would not run version 5.00 or 5.01 of PHP 5 on a production site. Version 5.02 has stood up well to our tests and we recommend it. In fact version 3.04 of Pika will require PHP 5.
In your PHP configuration file, you will need to verify that the "register_globals" setting is enabled. Pika predates the addition of the superglobals feature to PHP, and there are still sections of code that rely on register_globals instead of the more secure superglobals. I've always fastidiously initialized these global variables where ever they are used, so I don't think they are causing much of a problem. Nonetheless, we are phasing out these sections and eventually you'll be able to run Pika with register_globals disabled.
