Installing the database server, Choosing the appropriate database, Mysql – HP 3PAR System Reporter Software User Manual
Page 32: Sqlite, Mysql sqlite
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.
MySQL
MySQL is the recommended database. It must be obtained and installed separately. It supports
MyISAM tables. These tables do not support transactions (that are not required for System Reporter)
and are consequently somewhat higher performance than Oracle for sample insertion and deletion.
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
32
Installation, Configuration, Update, and Removal