Installing the database server, Choosing the appropriate database, Sqlite – HP 3PAR System Reporter Software User Manual
Page 30
NOTE:
System Reporter 2.9 and beyond supports secure connections on Apache servers using
the SSL protocol. For details on implementing the SSL protocol on Apache servers, please consult
the following links:
Use the Apache HTTP Server Installation Wizard to complete a typical installation, accepting all
defaults (with possibly the exception of the Administrator’s Email address).
To verify successful installation of Apache HTTP Server, open a Web browser and point it at the
Web server (or localhost if the browser is on the same machine).
If the installation was successful, you will see a message in the Web browser that confirms that
your installation was successful.
NOTE:
On Linux, Apache should be configured to run as the default apache user and the
sampleloop daemon will also be configured to run as the apache user. The default locations for
HTML files (/var/www/HTML) and CGI files (/var/www/cgi-bin) should be used because the
sysrptwebsrv package installs files in these directories.
Please note that System Reporter has not been tested with virtual domains in Apache.
NOTE:
If Security Enhanced Linux (SELinux) 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
Installing the Database Server
System Reporter supports several database servers: Microsoft SQL, SQLite, MySQL and Oracle.
Before beginning the installation, select the database based on the considerations described below
and summarized in
.
Choosing the Appropriate Database
Before beginning, you want to choose the right database for your particular installation.
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.
SQLite supports only limited database concurrency because it relies on a single file lock for the
entire database. The sampling process needs exclusive access to the database when inserting new
samples. If the database is very large or if there are a large number of concurrent web requests,
30
Installation, Configuration, Update, and Removal