Installing the database server, Choosing the appropriate database, Mysql – HP 3PAR System Reporter Software User Manual

Page 32: Sqlite, Mysql sqlite

Advertising
background image

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:

http://httpd.apache.org/docs/2.2/ssl/ssl_intro.HTML

http://httpd.apache.org/docs/2.2/ssl/ssl_howto.HTML

http://httpd.apache.org/docs/2.1/ssl/ssl_faq.HTML

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

Table 6 (page 33)

.

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

Advertising