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

Contents
1 Overview and Features.............................................................................17
User Interfaces.......................................................................................................................17
About System Reporter............................................................................................................17
Configuring System Reporter Policy Settings................................................................................18
Choosing a Method for Accessing Reports.................................................................................18
Creating Customized Reports...................................................................................................19
Formatting Reports for Presentation...........................................................................................21
Customizing the Reporting Format.............................................................................................21
Generating Email Alerts..........................................................................................................21
Accessing Report Data using Web Queries................................................................................21
Using the Database Schema to Build Custom Reports..................................................................22
Analyzing and Optimizing Storage Utilization............................................................................22
2 Installation, Configuration, Update, and Removal..........................................23
Before You Begin....................................................................................................................23
System Reporter CD Contents...................................................................................................23
System Requirements...............................................................................................................24
Using the System Reporter Sizing Spreadsheet............................................................................25
System Reporter Settings in a Highly Scaled Environment.............................................................26
Storage System Components and Recommended High Resolution Sampling Interval....................27
Sampling Parameters..........................................................................................................27
Best Practises for Managing HP 3PAR Arrays.........................................................................27
System Reporter Components...................................................................................................28
Installing the System Reporter Components.................................................................................29
Required Components........................................................................................................29
Optional Components........................................................................................................30
Installing the Web Server.........................................................................................................31
Installing the Database Server..................................................................................................32
Choosing the Appropriate Database....................................................................................32
MySQL........................................................................................................................32
SQLite.........................................................................................................................32
Microsoft SQL...............................................................................................................33
Oracle.........................................................................................................................33
Installing and Setting Up the Microsoft SQL Server Database (Optional)....................................34
System Reporter Host Configuration.................................................................................34
Installing and Setting Up the MySQL Database (Optional).......................................................39
Installing MySQL Server.................................................................................................39
Configuring the MySQL Database...................................................................................40
Setting the max_allowed_packet parameter......................................................................41
Creating MySQL Users and Schema................................................................................41
Setting Up the Oracle Database (Optional)...........................................................................42
Creating an Oracle database.........................................................................................42
Creating the Oracle Users for System Reporter..................................................................42
Creating the Oracle Net Service.....................................................................................43
Installing or Upgrading the System Reporter Tools.......................................................................44
Installing or Upgrading System Reporter Tools on Windows.....................................................44
Installing System Reporter Tools on Linux...............................................................................47
Adding Storage Systems.....................................................................................................48
Setting File Permissions (Optional)...................................................................................50
Verifying Installation......................................................................................................50
Installing the Excel Client (Optional)..........................................................................................50
About Apache HTTP Server Authorization and Access Control......................................................51
Contents 7