8 installing the database server, 1 choosing the appropriate database, 1 sqlite – HP 3PAR System Reporter Software User Manual

Page 50: Installing the database server, Choosing the appropriate database, Sqlite, 8 installing the, Database server

Advertising
background image

3.14

Installing the Database Server

3PAR System Reporter User’s Guide

System Reporter 2.8

3.8 Installing the Database Server

3PAR System Reporter supports three database servers: SQLite, MySQL and Oracle. Before

beginning the installation, select the database based on the considerations described below

and summarized in

Table 3-4

.

3.8.1 Choosing the Appropriate Database

Before beginning, you want to choose the right database for your particular installation.

3.8.1.1 SQLite

SQLite is an embedded database that is included with System Reporter. It does not run as a

separate application but rather as a module within the sampling tool and web server. Since it

requires no installation or configuration, it is very simple to use but it has several limitations

that make it only suitable for small database sizes and limited concurrency.

NOTE: If SELinux (Security Enhanced Linux) is implemented at your site, you may

need to either disable SELinux entirely or temporarily grant permissive access to

the system to install the System Reporter tools. Please consult your Linux

documentation for details on how to grant permissive access.

NOTE: It is recommended that you increase the default Timeout parameter to at

least 360 seconds (or more for installations with very large databases) in the

appropriate apache configuration file (typically httpd.conf) and then restart

apache to let this change take effect. This is to ensure that CGI calls that take a

long time to generate a report do not timeout.

On Windows, by default the Timeout parameter is specified in the following file:

C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd-

default.conf

On Linux, by default the Timeout parameter is specified in the following file:

/etc/httpd/conf/httpd.conf

Advertising