Hey! These docs are for version 6.3, which is no longer officially supported. Click here for the latest version, 6.7!

Reports - optional module

Learn how to install Opsview Monitor Reporting module

Overview

In this section, we offer step-by-step instructions providing you with specific guidance to successfully install the Opsview Monitor Reports software module.

It’s important that you have reviewed section Prerequisites to ensure that any software and hardware dependencies, along with any limitations are fully understood prior to installation.

Package Installation

Run the following command to update your OS packages, setup Opsview Monitor repositories on your server and install opsview-deploy package:

curl -sLo- https://deploy.opsview.com/6 | sudo bash -s -- -A boot

Installing Reports Module Using the advanced deployment

To install Reports, you need to edit /opt/opsview/deploy/etc/user_vars.yml file and add or uncomment the following opsview_module_reporting line:

## Uncomment below to activate these optional modules
opsview_module_reporting: True

For a Fresh install, follow the instructions in the Advanced Automated Installation page.

If, however, you are installing Reporting on an existing system, run the following command as root:

# install and configure the Reports
cd /opt/opsview/deploy
./bin/opsview-deploy lib/playbooks/reporting-install.yml
./bin/opsview-deploy lib/playbooks/setup-infrastructure.yml
./bin/opsview-deploy lib/playbooks/setup-opsview.yml

When running the reporting-install playbook, you may be prompted for a password. If you are prompted for a password, cancel the playbook execution (Ctrl-C) and run the below command to add the reporting database password to your user_secrets.yml file:

/opt/opsview/deploy/bin/gen_secrets | grep reporting_database_p >> /opt/opsview/deploy/etc/user_secrets.yml

Importing ODW DB

Reports rely on data stored within the ODW database. You must ensure ODW imports are enabled in the UI accessible via Configuration > My System, on the 'ODW' tab.

492492

The data will be imported at 4 minutes past every hour via the opsview user's crontab. The process can also be run manually as the opsview user with the command:

/opt/opsview/coreutils/bin/import_runtime -v

Logging into JasperServer

Opsview can use a ‘single sign-on’ method and, as such, a correctly authenticated user with the REPORTUSER access will be created in JasperServer. If the user also has REPORTADMIN, then they will receive additional privileges, specifically ROLE_ADMINISTRATOR in JasperServer.

A user that previously had ROLE_ADMINISTRATOR privileges will still retain that role even if REPORTADMIN is removed from them since the user databases are not synchronised. In this instance, a JasperServer administrative user will have to manually remove the role if required.

Setting up Emails

Emails are sent via the local machine (where the Reports module is installed) by default and you should verify that the current email system works.

date | /usr/bin/Mail -s 'test email for Opsview Reports' [email protected]

The email server configuration is stored in the file

/opt/opsview/jasper/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties

To set the email server up, edit the following lines in the configuration to match your required config. The below example shows off emailing from the local machine.

report.scheduler.mail.sender.host=mail.localhost.com
report.scheduler.mail.sender.username=admin
report.scheduler.mail.sender.password=password
[email protected]
report.scheduler.mail.sender.protocol=smtp
report.scheduler.mail.sender.port=25

If you change this file, then you will need to restart JasperServer:

/opt/opsview/watchdog/bin/opsview-monit restart opsview-reportingmodule

If you experience any issues, you should review the logs that is located in

/opt/opsview/jasper/apache-tomcat/webapps/jasperserver/WEB-INF/logs/jasperserver.log