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

Contents
1 Introduction.............................................................................................18
User Interfaces.......................................................................................................................18
Related Documentation............................................................................................................18
Typographical Conventions......................................................................................................19
Advisories..............................................................................................................................19
2 Overview and Features.............................................................................20
About System Reporter............................................................................................................20
Configuring System Reporter Policy Settings................................................................................20
Choosing a Method for Accessing Reports.................................................................................21
Creating Customized Reports...................................................................................................21
Formatting Reports for Presentation...........................................................................................23
Customizing the Reporting Format.............................................................................................23
Generating Email Alerts..........................................................................................................23
Accessing Report Data using Web Queries................................................................................23
Using the Database Schema to Build Custom Reports..................................................................24
Analyzing and Optimizing Storage Utilization............................................................................24
3 Installation, Configuration, Update, and Removal..........................................25
Before You Begin....................................................................................................................25
System Reporter CD Contents...................................................................................................25
System Requirements...............................................................................................................26
Using the System Reporter Sizing Spreadsheet............................................................................27
System Reporter Components...................................................................................................28
Installing the System Reporter Components.................................................................................30
Required Components........................................................................................................30
Optional Components........................................................................................................30
Installing the Web Server.........................................................................................................31
Installing the Database Server..................................................................................................32
Choosing the Appropriate Database....................................................................................32
SQLite.........................................................................................................................32
Microsoft SQL...............................................................................................................33
MySQL........................................................................................................................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).......................................................38
Installing MySQL Server.................................................................................................38
Configuring the MySQL Database...................................................................................39
Setting the max_allowed_packet parameter......................................................................40
Creating MySQL Users and Schema................................................................................40
Setting Up the Oracle Database (Optional)...........................................................................41
Creating an Oracle database.........................................................................................41
Creating the Oracle Users for System Reporter..................................................................42
Creating the Oracle Net Service.....................................................................................42
Installing or Upgrading the System Reporter Tools.......................................................................43
Installing or Upgrading System Reporter Tools on Windows.....................................................43
Installing System Reporter Tools on Linux...............................................................................46
Adding Storage Systems.....................................................................................................47
Setting File Permissions (Optional)...................................................................................48
Verifying Installation......................................................................................................48
Installing the Excel Client (Optional)..........................................................................................48
8 Contents