Database Settings

Note: This article is for an old version of OpenX.

The latest OpenX documentation can be found at the following URLs:

Global database server settings
Before you can use OpenX you need to specify the type of database, username and password to use. You did this first during the installation process, but you can change those settings here. All of these settings are stored inside the configuration file, so if you want to change these settings the configuration file must be be unlocked.

Database hostname
Specify the hostname or the IP address of the database server.

Database port number
Specify the number of the port of the MySQL database server to which you are trying to connect. The default port number for a MySQL database is 3306.

Database username
Specify the username which OpenX must use to gain access to the database server.

Database password
Specify the password which OpenX must use to gain access to the database server.

Database name
A MySQL server usually contains a lot of different databases, for different users or projects. Each database has a unique name. You need to specify the name of the database which is used for OpenX.

Global database optimisation settings
If you want to use persistent connections to the database server check this option. The use of a persistent connection can speed up OpenX considerably and may even decrease the load on the server.

There is a potential disadvantage however, where on sites with a lot of visitors the load on the server can increase and become larger than when using normal connections. Whether you should use regular connections or persistent connections depends on the number of visitors anticipated and the hardware you are using. If OpenX is using too many resources, you should take a look at this setting first. Persistent connections are turned off by default.