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
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
.
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