5.6
Table Of Contents
- VMware vCenter Operations Manager Administration Guide
- Contents
- VMware vCenter Operations Manager Administration Guide
- Configuring and Managing vCenter Operations Manager
- Configuring Adapters
- Configuring Resources
- Configuring Attribute Packages
- Configuring Applications
- Configuring and Managing Users
- Configuring Alert Notifications
- Performing Basic System Administration Tasks
- View Performance Information
- View Status Information
- vCenter Operations Manager Service Names
- Start or StopvCenter Operations Manager Services
- Viewing and Managing System Log Files
- Delete Old Data in the File System Database
- Run the Audit Report
- Modify Global Settings
- Modify Global Settings for Virtual Environments
- Create a Support Bundle
- Resolving Administrative System Alerts
- Analytics FSDB Overloaded
- Analytics Threshold Checking Overloaded
- Collector Is Down
- Controller Is Unable to Connect to MQ
- DataQueue Is Filling Up
- Describe Failed
- Failed to Connect to Replication MQ
- Failed to Repair Corrupted FSDB Files
- File Queue Is Full
- FSDB Files Corrupted for Resources
- FSDB Storage Drive Free Space Is Less Than 10%
- No DT Processors Connected
- One or More Resources Were Not Started
- Outbound Alert Send Failed
- Replication MQ Sender Is Blocked
- Backing Up and Recovering Data
- Using System Tools
- Summary of System Tools
- Check the FSDB and Repair Problems
- Move the FSDB
- View Resources in the FSDB
- Remove System-Generated Metrics from the FSDB
- Monitor vCenter Operations Manager Services in JConsole
- Verify Server to Collector Communication
- Configuring and Running the Repository Adapter
- conf.properties File
- Configure Database Connections for the Repository Adapter
- Set the Repository Adapter Schedule
- Configure the Source and Destination Columns for the Repository Adapter
- Set Operation Options for the Repository Adapter
- Configure Data Export Values for the Repository Adapter
- Start the Repository Adapter
- Configuring and Running runvcopsServerConfiguration
- Managing Dashboards and Dashboard Templates
- Using the FSDB JDBC Driver
- Index
Configure SQuirreL SQL to Use the FSDB JDBC Driver
If you have SQuirreL SQL, you can configure it to use the FSDB JDBC driver.
Prerequisites
If you are configuring SQuirreL SQL on a remote server, copy the common.jar file from the
vcenter-
ops
\common\lib directory on the vCenter Operations Manager server to the local
vcenter-ops
\common\lib
directory.
Procedure
1 In the SQuirreL SQL Client, select Drivers > New Driver.
2 Configure the driver settings.
a In the Name text box, type a name for the FSDB JDBC driver.
For example: FSDB JDBC
b In the Example URL text box, type the URL that the FSDB JDBC driver uses to connect to the
vCenter Operations Manager DBMS.
For example: rmi://localhost:1199/DBMS
c On the Extra Class Path tab, add the full paths to the common.jar, log4j-1.2.9.jar, and
FSDBJDBCDriver.jar files.
For example:
vcenter-ops
\common\lib\common.jar
vcenter-ops
\common\lib\log4j-1.2.9.jar
vcenter-ops
\tools\FSDBJDBCDriver\FSDBJDBCDriver.jar
IMPORTANT Do not specify the common.jar file in the FSDBJDBCDriver\lib folder.
d In the Class Name text box, type the name of the FSDB JDBC driver class.
For example: com.integrien.fsdbjdbcdriver.FSDBJDBCDriver.
3 Click OK to save the new driver.
4 Stop and restart SQuirreL SQL.
5 In the SQuirreL SQL Client, select Aliases > New Alias.
6 Configure the alias settings.
a In the Name text box, type a name for the alias.
For example: FSDBJDBC Driver RMI
b From the Driver drop-down menu, select the driver that you created.
For example: FSDB JDBC
c In the URL text box, type the URL that the FSDB JDBC driver uses to connect to the
vCenter Operations Manager DBMS.
For example: rmi://localhost:1199/DBMS
NOTE You do not need to type a user name or password.
7 Click Test.
VMware vCenter Operations Manager Administration Guide
156 VMware, Inc.