Opsview - ODW Datasource Configuration

Whenever a customer runs a report, there's an instance that they would get an error below:

There was an error on the server. Try again or contact site administrators. (Error UID: 1ffc5913-b7f6-4566-8fb8-c9f5c577ea64)

This may be down due to the ODW connectivity issue or database is just offline. Therefore, when this happens check if your connection is OK.

- To do this, use the "Test Connection" option to validate connectivity.

- navigate the window and do the following:

Monitoring > Reports > View > Repository > "Folders: root > Data Sources" > select ODW > Edit

Edit window will look like this:

The URL

The URL must be correct:

- if you use an "unmanaged ODW" database, then the URL may be the IP address of that server and a different port, likely 3306

- for the below example, this is correct for most customers

Example:

jdbc:mysql://127.0.0.1:13306/odw

The Username

Obtain the Username from within your mysql database inside the sql server itself:

MariaDB [jasperserver]> use mysql;
MariaDB [mysql]> select Host,User from user;

- The username we are looking for should be opsviewreports, which is a read-only user

- version 5 of Opsview used "odwro"

The output would be like this:

+---------------+----------------+
| Host          | User           |
+---------------+----------------+
| %             | dashboard      |
| %             | jasper         |
| %             | nagios         |
| %             | odw            |
| %             | opsview        |
| %             | opsviewreports |
| 10.140.1.242  | root           |
| 10.140.3.219  | root           |
| 10.140.3.3    | root           |
| 10.140.4.97   | root           |
| 127.0.0.1     | root           |
| ::1           | root           |
| lax-db-thassa |                |
| lax-db-thassa | root           |
| localhost     |                |
| localhost     | dashboard      |
| localhost     | jasper         |
| localhost     | nagios         |
| localhost     | odw            |
| localhost     | opsview        |
| localhost     | opsviewreports | 
| localhost     | root           |
+---------------+----------------+

The Password

- To obtain the value we need, run the command below in the orchestrator:

#grep opsview_reporting_database_ro_password /opt/opsview/deploy/etc/user_secrets.yml | awk '{print $2}'

After all of the steps are completed, click on "Test Connection" again. Once, a status message "Connection Passed" was received, save the changes an rerun the report.