Global settings - database

When you install OpenX you specify which username, password and type of database to use. You can change those settings in the Global settings > Database page. They are stored in the configuration file, and this file must be unlocked to make any changes.

• Database Type: This field contains the database type you set up for your OpenX installation. OpenX 2.6 supports MySQL and PostgreSQL database types.
• Database Hostname: This field contains the hostname or the IP address of the database server.
• Database Port Number: This field contains the port number of the database server. The default port number for a MySQL database is 3306.
• Database Username: This field contains the username to enter when you want to login to the database.
• Database Password: This field contains the password to enter when you want to login to the database.
• Database Name: A database server typically contains a number of databases used for different users and projects. This field contains the name of the database that is set up for your OpenX system.
• Database Optimisation: If you tick the Use Persistent Connections checkbox you can improve OpenX delivery and even decrease the load on the server. However, this option is not suitable for websites with a lot of visitors because the load on the server can actually increase and become larger than when using normal connections. The benefit of using regular or persistent connections depends on the number of anticipated visitors and the hardware you are using. If OpenX is using too many resources, check this setting. Persistent connections are turned off by default.