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

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 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 32) .
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.
10. After clicking Finish, check the settings in the confirmation screen and click OK.
11. Click Exit after the database has been created.
Creating the Oracle Users for System Reporter
Use the instructions that follow to create two users: cliuser and webuser. These users have different
privilege levels that correspond with optional Apache HTTP Server privilege levels, as described
in
“About Apache HTTP Server Authorization and Access Control” (page 48) .
•
cliuser is the default user name for the sampler and policy change user. The System Reporter
tables are created in the cliuser schema. This user can create and edit database tables and
change database sampling policies (see
“Editing Sampling Policies” (page 117) ).
•
webuser is the default user name for the Web reports user. This user has select privileges only
for the tables in the cliuser schema.
As part of installing the System Reporter tools (see “Installing or Upgrading the System Reporter
Tools” (page 42) ), the installer creates two Apache HTTP Server config.tcl files to store the
40 Installation, Configuration, Update, and Removal