Deploying HP SIM 5.x on MSCS clusters on Windows 2003 with SQL Server 2005 Table of Contents Abstract.............................................................................................................................................. 3 Introduction......................................................................................................................................... 3 Getting started .................................................................................................
Creating the HP SIM 5.x generic service resource .......................................................................... 34 Creating the OpenSSH Services for HP SIM 5.x generic service resource .......................................... 35 Creating the Pegasus WMI Mapper generic service resource .......................................................... 36 Creating the PMP services for HP SIM 5.x generic service resource ..................................................
Abstract This white paper is intended to assist IT professionals in installing HP Systems Insight Manager (HP SIM) 5.x in a Microsoft Cluster Server configuration. Microsoft Windows 2003 Enterprise Server with HP SIM 5.x can be a simple way of obtaining redundancy and failover capability from this powerful management software. Introduction HP SIM 5.
Figure 1: The relationship between HP SIM 5.x, SQL Server 2005, and the cluster disks Getting started If you are installing HP SIM 5.x into an environment without a Microsoft SQL Server 200 5 Enterprise Edition instance already installed, go to for steps to install a clustered named instance of Microsoft SQL Server 2005 Enterprise Edition. This named instance can host the HP SIM 5.x databases and any other production databases you might require in your environment.
The secondary system is for running the HP SIM 5.x service and all the component services it requires. Storage configuration Figure 1 displays the relationship between Microsoft SQL Server 2005 Enterprise Edition instances and HP SIM 5.x. At least two logical drives must be available in the shared storage if your infrastructure does not have Microsoft SQL Server installed to which you can attach the HP SIM 5.x database.
5. MSCS secondary system IP address and name – Function: To serve as the TCP/IP address and name of the specific Microsoft Windows server host. – Suggested action: Any software that references system-specific functions uses this address to connect to this system. For the examples shown in this paper, the IP address is 140.110.240.61.
1. Insert the Microsoft Windows 2003 Enterprise Server CD into the CD-ROM drive of the target server. 2. Select Start>Settings>Control Panel. 3. Click Add/Remove Programs. 4. Click Add/Remove Windows Components. 5. Select Management and Monitoring Tools in the Windows Component Wizard window. 6. Click Details. Then select Simple Network Management Protocol if it is not selected by default. 7. Click OK. The Windows Component Wizard window appears. 8. Click Next. Wait for the file copying to complete. 9.
Installing a clustered instance of the Microsoft SQL Server 2005 Enterprise Edition 1. Insert the Microsoft SQL 2005 Extended Edition CD into your CD-ROM drive. This paper assumes that the SQL Server 2005 Installation setup window opens automatically. 2. Click Install. The installation begins. The user license agreement appears. 3. Accept the license agreement and then click Next. 4. After the configuration check is complete on all systems, a summary appears.
Figure 2 Microsoft SQL Server 2005 Setup 9. Click Advanced to ensure that Management Tools is selected. Note: The Management Tools option is not installed by default and must be selected. 10. Select Management Tools from client tools in the Feature selection window.
Figure 3: Feature selection 11. Click Next. The Instance name window appears. 12. Select Name Instance and enter one instance name. Note: Common instance name is required to install HP SIM and fail over for HP SIM. 13. Click Next. 14. Enter the Virtual Server name (SQL-SRV).
Figure 4: Domain groups for clustered services 15. Click Next. The Virtual Server Configuration window appears. 16. Enter the Virtual Server IP address. Note: If the system you are installing on is a two node MSCS box with a private and public network, you must select public when assigning a new public IP address to the SQL 2005 Virtual Server IP address. This can be selected in the Network to use field on the Virtual Server Configuration window. 17.
21. Enter the user name and password for an account with permission to run the service. For example, the domain administrator account. Note: Do not select the Customize for each service account information checkbox. 22. Enter the group names to run different services in the Domain Groups for Clustered Services window. Note: You must complete the remaining steps to enter the group names for services. Follow the steps and create one group in the domain and use the same group for all the services. 23.
Figure 6: Collation settings 29. Click Next in the Error and send Report Settings window. The Ready to Install window appears. 30. Verify that all selected components are displayed and then click Install. The Set Progress window appears where you can monitor the installation progress of each component on any of the nodes in the cluster by selecting the node from the dropdown list. After setup is complete, all of the components should have a green check beside them and show a status of Set Up Finished.
1. Ensure that both systems are up and running cluster services before installation. Also, be sure that the SQL server instance, to which you are installing the HP SIM 5.x database, is running. 2. Ensure that the cluster system that is to be installed with HP SIM 5.x owns the clustered disks. 3. Read the HP Systems Insight Manager 5.x Installation and Configuration guides to be sure that you have the right prerequisites for installation. 4. Read the HP Systems Insight Manager 5.x Release Notes.
c. The Domain field displays the user domain used to log into the system. d. Enter the name of the Microsoft SQL Server 2005 Enterprise Edition instance that you created. For this paper, HP-SIM-SQLSVR\HP_SIM_INSTANCE is used. Note: If the credentials specified cannot be validated, a message appears, stating You are not able to continue with the installation until the account information is validated.
v. Click Install to continue to the Installing Pegasus WMI Mapper v2.4 window. Note: A progress bar indicating files are being copied appears during the installation of this service. WMI Mapper is installed in c:\Program Files\The Open Group\WMI Mapper. At the end the Completing the Pegasus WMI Mapper v2.4 Setup Wizard window appears. vi. Click Finish to exit the WMI Mapper setup wizard. c. A new Welcome to the HP Systems Insight Manager Setup Wizard window appears. i. Click Next.
Note: Click Perform an initial repository population, if you have ProLiant Support Packs available. Alternatively, the repository can be populated later by copying the files to the repository directory. vi. Click Next. The Automatic Update window appears. vii. Make the appropriate selections for automatic download of latest support packs directory from the HP website. viii. Click Finish. The HP ProLiant Setup: Version Control Repository Manager window appears. ix. Click Close.
h. The Welcome to the HP Virtual Machine Management Pack Setup Wizard appears. Click Next to continue. The Available Components page appears with Virtual Machine Management Pack 3.1 selected and in a disabled state. i. Click Next to continue. The Service Account credentials page appears. ii. Enter the user name, password, and define the VMM port. The default is 40420. iii. Click Next. HP Virtual Machine Management Pack is installed. iv.
2. Open ~\HP Systems Insight Manager\config\databaseprops file and note the database name specified against the keyword hp.Database.databaseName. 3. Shutdown the secondary system. Adjusting the HP SIM 5.x data source name on the primary system 1. Start the primary system. 2. Click Control PanelAdministrative ToolsData Sources (ODBC). 3. Select System DSN. 4. Select Insight_v50_0 and click Configure.
Figure 7: ODBC Data Source Administrator 5. Update the Database Description field, referring to the database name created on the secondary system. Note: Use the database name noted in step 2 of the Installing HP SIM 5.x on the secondary system section. 6. Click Next. The Authentication mode selection window appears. 7. Click Next. The Microsoft SQL Server DSN Configuration window appears (Figure 5). 8. Select the database, which is created by the secondary system.
Figure 8: Adjusting the HP SIM 5.x data source name on the primary system 13. Go to the Adding the HP SIM 5.x cluster resources section. To complete the installation of HP SIM 5.x to the cluster, several cluster resources must be created using Cluster Administrator. Creating the HP SIM 5.x Generic Service Resource 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane. Click anywhere in the right pane and select NewResource from the dropdown menu. 2.
Figure 9: Creating the HP SIM 5.x service Upgrading HP SIM 5.1 to HP SIM 5.3 in a cluster environment This section assumes that HP SIM 5.0 is running in the failover mode in a two system Microsoft Windows 2003 Enterprise Server cluster environment, and these servers meet the pre -requisites detailed in the Hardware and Software Requirements section. For more details, see HP Systems Insight Manager 5.3 Installation and Configuration guides and the HP Systems Insight Manager 5.
enabled on the primary system, go to D:\autorun.exe. If this is the first time you are installing from this version of the HP Management CD, you must first accept the license agreement for the HP Management CD. 9. Select the Products tab. 10. Click HP SIM 5.x Windows Install. The HP Systems Insight Manager Setup window appears. 11. After completing the system inspection, the Database Configuration window appears with only the Use SQL option selected. a.
vi. Click Finish to exit the WMI Mapper setup wizard. b. A new Welcome to the HP Systems Insight Manager Setup Wizard window appears. i. Click Next. The Select Destination Directory window appears. ii. The destination directory is automatically chosen. iii. Click Next. The Ready to Install window appears. iv. Click Install. The Installing window appears. Note: A progress bar indicating files are being copied appears during the installation, which might take a few minutes.
Note: A progress bar appears indicating SMP is being uninstalled. The uninstall might take a few minutes. iv. A message appears, stating that SMP was successfully removed. Click OK. v. The Welcome to the HP Virtual Machine Management Pack Setup Wizard appears. Click Next. vi. The Database configuration window appears. Enter the password and then click Next. vii. VMM is installed at this time. The Completing the HP Virtual Machine Management Pack setup wizard window appears after the installation.
3. Select Start>Run. 4. Enter Regedit and then click OK. The Registry Editor page appears. 5. Expand and select HKEY_LOCAL_MACHINE\SOFTWARE\Hewlett-Packard, and then open Import Registry file from the Registry menu. 6. Enter the path to the file, such as F:\Hewlett that is saved on the shared disk from the primary system, and then click Open. A message appears indicating that the registry file has been imported successfully. 7. Expand and select HKEY_LOCAL_MACHINE\SOFTWARE\HP 8.
from this version of the HP Management CD, you must first accept the license agreement for the HP Management CD. 9. Select the Products tab. 10. Click HP SIM 5.x Windows Install. The HP Systems Insight Manager Setup window appears. 11. After completing the system inspection, the Database Configuration window appears statimg “Incompatible plug-in versions detected”. Click Close. Another window appears with only the Use SQL option selected. a. The Username field displays the user name that is logged in. b.
vi. Click Finish to exit the WMI Mapper setup wizard. b. A new Welcome to the HP Systems Insight Manager Setup Wizard window appears with the destination automatically selected. i. Click Next. The Ready to Install window appears. ii. Click Install. The Installing window appears. Note: A progress bar indicating files are being copied appears during the installation, which might take a few minutes. Note: It might take a few more minutes when the Initializing HP Systems Insight Manager window appears.
2. Enter the correct password in the Password field. 3. The Domain field is already populated with the user domain used to log in. The Database server name field displays the database name used during the HP SIM installation. 4. The Database server field is populated with the name of the Microsoft SQL Server 2005 Enterprise Edition instance that you created. See Error! Reference source not found.. (HP-SIMSQLSVR\HP_SIM_INSTANCE in this paper.) iii. Click Next. The Installing window appears.
vi. VMM is installed at this time. The Completing the HP Virtual Machine Management Pack setup wizard window appears. Click Finish to complete the installation. g. From the Management CD, select the Products tab and then click HP Server Migration Pack Install. A message appears stating that as part of the SMP installation, the HP SIM service must be stopped and restarted. Click OK. i. The Welcome to the HP Server Migration Pack Setup Wizard window appears. Click Next. ii.
Note: Be sure to log in with the same user name that you used to install the Microsoft SQL Server 2005 Enterprise Edition instance. 11. Be sure that the primary system owns all the cluster resources. 12. Start the secondary system and log in to Windows as a user with administrator rights. Note: Be sure to log in with the same user name that you used to install the Microsoft SQL Server 2005 Enterprise Edition instance. 13. Go to Adding the HP SIM 5.x cluster resources. Adding the HP SIM 5.
Note: It is not necessary to the functionality of HP SIM to change the names of these disk groups. It you used a pre-existing installation of Microsoft SQL Server 2005, the disk group containing these program files should already have an appropriate name. Creating the HP SIM 5.x IP address resource Note: The disk group containing the HP SIM 5.x program files can be used for other programs, but for the purpose of this paper, HP SIM 5.x is the only application installed to the disk. 1.
Figure 11: The New Resource window 5. The Possible Owners window appears. Be sure that the two systems in your cluster are listed in the Possible Owners pane. 6. Click Next. The Dependencies window appears. 7. Specify the other resources in this disk group that a new resource depends on. An IP address in cluster services is not required to establish any dependencies. 8. Click Next. The TCP/IP Address Parameters window appears.
4. Click Next. The Possible Owners window appears. 5. Be sure the two systems in your cluster are listed in the Possible Owners pane. 6. Click Next. The Dependencies window appears 7. Select HP SIM IP Address as a dependency for this new resource. 8. Click Add to add this resource to the dependencies list. 9. Click Next. The Network Name Parameters window appears. Give the resource network name (W2K-CLUS-HPSIM in this paper). Clients access the HP SIM 5.x service by this name.
Figure 12: Creating the HP SIM 5.x service Creating the OpenSSH Services for HP SIM 5.x generic service resource 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane. Click anywhere in the right pane and select NewResource from the dropdown menu. 2. In the Name field, enter OpenSSH Service and select Generic Service from the Resource type dropdown menu. 3. Click Next. The Possible Owners window appears. Be sure that both systems in your cluster are selected. 4.
Figure 13: Creating the OpenSSH Service Creating the Pegasus WMI Mapper generic service resource 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane. Click anywhere in the right pane and select NewResource from the dropdown menu. 2. In the Name field, enter WMI Mapper Service, and select Generic Service from the Resource type dropdown menu. 3. Click Next. The Possible Owners window appears. Be sure that both systems in your cluster are selected. 4. Click Next.
Figure 14: Creating the WMI Mapper Service Creating the PMP services for HP SIM 5.x generic service resource Note: This section is applicable only if PMP has been installed manually. 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane. Click anywhere in the right pane and select NewResource from the dropdown menu. 2. In the Name field, enter PMP Service, and select Generic Service from the Resource type dropdown menu. 3. Click Next.
9. Click Add and add the registry key. The Resource Creation Confirmation window appears. Note: ProLiant Performance Analyzer requires the specification of two registry keys to properly operate in a cluster. Add SOFTWARE\HP\ProLiant Essentials\Licensing\4 and SOFTWARE\HP\Performance Management Pack\4.0. 10. Click OK. Creating the PMP tools services for HP SIM 5.x generic service resources 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane.
Figure 15: Creating the VCRM service Creating the Virtual Machine Management Pack generic service resource Note: This section is applicable only if VMM has been installed manually. 1. In the Cluster Administrator window, select the HP SIM Disk Group from the left pane. In the right pane, right-click anywhere and select NewResource from the dropdown menu. 2. From the New Resource window, in the Name field, enter VMM Service and select Generic Service from the Resource type dropdown menu. 3. Click Next.
5. Click Next. The Dependencies window appears. 6. Set the HPSIM Service as a dependency. 7. Click Next. The Generic Service Parameters window appears. 8. In the Service name field enter hpvmmweb is the service name for the VMM. Parameters are not required. 9. Click Next. The Registry Replication window appears. 10. Click Finish. A Resource Creation Confirmation window appears. 11. Click OK. Bringing the virtual group containing the HP SIM 5.
2. In the Cluster Administrator window, on the left pane, right-click on the disk group containing the HP SIM 5.x program files. For example, HP SIM Disk Group is used in this paper. Select Move Group. Be sure that the group fails-over to the other system and that all of the HP SIM 5.x resources come online. 3. After the failover occurs on the second system restart the System Management Homepage service manually on the second system. 4. After waiting a few minutes to ensure that the HP SIM 5.
Figure 17: The HP SIM 5.x home page Note: Navigate to OptionsDiscovery. Select System Automatic Discovery task and click Edit. The Edit Discovery page appears. Take a look at the Ping inclusion ranges list box (on the left side of the right frame, near the bottom of the screen). Note that HP SIM 5.x automatically generates a range for each of the IP addresses the current system has. Because one of these ranges is based on the cluster heartbeat IP address (generally of the form 10.0.0.
indicating WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED appears. When that happens, simply use the name of the other system instead.
Troubleshooting Note: This section is applicable only if PMP has been installed manually. Problem: Error during MSA tool execution. Solution: Execution of MSA tools might fail due to SSH key mismatch. For proper execution of MSA tools, perform the following: 1. Make the primary system active and execute mxagentconfig to push the SSH key to primary system itself. AND 2. Make secondary system active and execute mxagentconfig to push the SSH key to secondary system itself.
For more information Refer to the following for more information regarding the topics referenced in this paper. Microsoft cluster services Clustering basics www.microsoft.com/windows2000/technologies/clustering/default.asp Steps to setting up a Microsoft cluster www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp HP ProLiant clusters http://h18000.www1.hp.com/solutions/enterprise/highavailability/microsoft/index.html Microsoft SQL Server 2005 Enterprise Edition System requirements www.