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.