During the installation process for both the
Opsview Monitor and Opsview modules, you will be asked if you wish to install a
remote database, as we illustrate in the example below. Opsview Monitor and the
Opsview modules are typically installed locally, but if you select to install on
a remote database, you will need to provide connection information for the
However, if you wish the module databases to be installed
separately from Opsview (local or remote) you will need to run the install
command separately for each module. For further information about planning your
database setup, refer to Section 126.96.36.199. Databases
During the installation process, you will be asked if you wish to install a remote
Install Opsview using a remote database? [y/N]
For larger systems we recommend relocating
the Opsview Data Warehouse (ODW) onto a remote server, which will help with overall performance. Nevertheless, if
you wish to install the reports database onto an alternative server, the
automated installation process will allow you to do this but, following
installation, you will need to update the JasperServer configuration for generating reports (see
the section below, “Adding ODW connection”).
Adding ODW connection
If you have chosen to install the Reports
database on an alternative server, you will need to update the JasperServer to
First, you will need to retrieve the
password from ODW that’s contained in /usr/local/nagios/etc/opsview.conf.
Next, log in to JasperServer using an account that has REPORTADMIN privileges.
Once logged in, locate Folders and
right-click Data Sources
Now click Add Resource and then select Data Source, as shown below.
In the form shown below, you will need to
update the fields with the following data:
Type: JDBC Data Source
JDBC Driver: com.mysql.jdbc.Driver
URL: (if ODW
resides on a different database server)
Save Location: /datasources (example).
You will need to update these fields.
Now, click Test connection to ensure you have entered
your connection details correctly. Finally, click Save to proceed.