System requirements

To install OpenX you will need both:

• A web server that supports PHP
• A MySQL or PostgreSQL-configured database server

This page describes the following requirements:

• Web Server
• PHP Support
  • PHP versions
  • PHP modes
  • PHP configurations
  • PHP time zone configuration
• Database server
  • Database account
    • MySQL
      • Database versions
      • Database permissions
      • Table types
    • PostgreSQL
      • Database versions
      • Database permissions

Web Server

OpenX is tested with an Apache web server in a Linux environment. OpenX will work with other web servers that support PHP, but these are not tested or supported by OpenX.

PHP Support

OpenX is fully compatible with PHP 5.1.4 and higher, including when the "register_globals" setting is turned on.

PHP versions

PHP modes

You can install and run PHP in different modes, depending on your web server. Running PHP as an Apache module (Mod PHP) is more efficient than running in CGI-binary mode. Microsoft IIS is not supported. However, users report success using IIS 5.1 and IIS 6.0 with PHP running in Fast CGI mode.

PHP configurations

OpenX uses the default PHP settings. However, server administrators sometimes change these settings. Before you install OpenX check that the following settings are correct:

• magic_quotes_runtime must be off
• safe_mode must be off
• register_argc_argv must be on if you want to run maintenance via command line
• file_uploads need to be turned on to allow HTTP file uploads

OpenX requires the following PHP extensions:

• Either the "mysql" extension, or the "pgsql". The "mysqli" extension is not supported.
• The ZLib extension, to convert links inside compressed Flash files generated by Flash MX.
• The FTP extension. If this is not present OpenX will try to simulate it, which can be a less stable solution.
• The GD extension, to generate graphs on the Home page. If the extension is not enabled you will not be able to view graphs or statistics on your Home page.
• Either the openssl extension or an SSL-enabled curl extension are required in order to logon to the Home page. If SSL is not enabled you will receive an error message in the Home page, but there is no impact on operations.

If you intend to target delivery based on browser or operating system then phpSniff must be enabled.

PHP time zone configuration

OpenX performs many time-based operations which rely upon the server time zone. You can configure this in PHP:

• If you are using PHP 5.1 or 5.2 set the correct timezone in your php.ini file:date.timezone = Europe/London
• If you do not have access to set the time zone on your server, ask your system administrator or your hosting provider to set this up for you.
• Alternatively, you can call "date_timezone_default_set()" on PHP 5.1 and PHP 5.2, or you can set "date.timezone" in a .htaccess file.

OpenX can be installed without the PHP time zone setup. In this instance OpenX will make a best guess about which time zone your server is in. You can then select a time zone manually if it is wrong. However, OpenX strongly recommends that you set up the time zone in PHP correctly.

Accurate timing is especially important if you are running OpenX on more than one server. Configure you server with an NTP (Network Time Protocol) service to ensure that your server clocks are synchronized. Refer to your operating system documentation for more information.

Database Server

OpenX supports installation with either MySQL or PostgreSQL.

We recommend that you install OpenX on a database with UTF-8 encoding.

Database account

You can set up your database for OpenX in the following ways:

• Create a new database for OpenX
• Create a new database account for OpenX
• Use an existing database account and prefix the OpenX tables to distinguish them from other tables. This method is not recommended.

OpenX recommends that you create a database account specifically for use with OpenX.

MySQL

Database versions

OpenX is tested on the latest versions of MySQL.

• The latest stable version of MySQL (currently 5.0) is recommended
• The earliest supported version of MySQL is 4.1
• MySQL 3.x and 4.0 are not supported

Database permissions

• SELECT
• INSERT
• UPDATE
• DELETE
• CREATE TABLE
• DROP TABLE
• CREATE INDEX
• DROP INDEX
• LOCK TABLES

Table types

OpenX can use either the MyISAM or InnoDB table types. Please see the documentation on the different supported MySQL Table Types to ensure that you select a table type appropriate to your installation.

PostgreSQL

Database versions

OpenX is tested on the latest two versions of PostgreSQL.

• The latest stable version of PostgreSQL (currently version 8.3) is recommended.
• The earliest supported version of PostgreSQL is 8.2.

To be fully defined. For now it's safest to use the "root" PostgreSQL user.

OpenX requires that the PL/PgSQL language be installed onto the database you are going to use. Otherwise you need to install using the "root" PostgreSQL user so that this language can be created.