HP 3PAR System Reporter Software - Manual (Page 41)

These users have different privilege levels that correspond with optional Apache HTTP Server
privilege levels, as described in
“Installing or Upgrading the System Reporter Tools” (page 43) .
•
cliuser is the default user name for the sampler and policy change user. This user can
create and edit database tables and change database sampling policies (see
“Editing
Sampling Policies” (page 114) ).
•
webuser is the default user name for the Web reports user. This user has database read
privileges only.
As part of installing the System Reporter tools (see “Installing or Upgrading the System Reporter
Tools” (page 43) ), the installer creates two Apache HTTP Server config.tcl files to store
the user names and passwords for the cliuser and the webuser. See for instructions on editing
these config.tcl files if you change the MySQL usernames and passwords at a later time.
NOTE: When creating the users, you must assign them passwords in order for System
Reporter to function properly.
4. Grant the two users the privilege levels described above by running the commands below:
use inservstats
grant all on * to cliuser;
grant select on * to webuser;
exit;
5. Exit the mysql command line by running the following command:
exit;
Setting Up the Oracle Database (Optional)
System Reporter supports the use of MySQL® Database Server or Oracle 11g Database Server.
To use Oracle, you must set up Oracle, following the instructions provided in this section. To use
and install MySQL go to
“Installing and Setting Up the Microsoft SQL Server Database (Optional)”
(page 34) .
Oracle is optional third-party software and is not provided by HP.
Installing the Oracle database server is beyond the scope of this guide. We assume that you
already have an Oracle database server. In this section we describe how to create a database
and users on that server for the System Reporter and how to set up a connection to the database
from the System Reporter.
NOTE: To ensure that all environment variables are properly updated, install Oracle prior to
installing the Apache Web Server. If Apache is already installed, be sure to restart it after the
Oracle client is installed.
Creating an Oracle database
On the Oracle database server:
1.
Start the Oracle Database Configuration Assistant.
2. Click Next at the welcome screen.
3. Select the Create a Database radio button and click Next.
4. Select the radio button for the Data Warehouse template and click Next.
5. Enter a name for the database and Oracle System Identifier (SID) and click Next.
6. Keep defaults for Configure Enterprise Manager, and click Next.
7. Select passwords for various Oracle users and click Next.
8. Select the desired storage mechanism and click Next.
9. At this point you can click Finish or continue to set further options.
Installing the Database Server 41