Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
autorun
Posts: 9
Joined: Thu Aug 29, 2019 7:22 am

Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9

Post by autorun »

In Nagios XI (v5.6.6) Configuration Wizards => Oracle Tablespace Wizard (v1.5.9)
The wizard take the info: Address, Port, SID, ...., Database.
The bug is that the wizard is not taking the "Database" info into account! and ignore it.
Because the result of this wizard is 6 services each of these is monitoring all the Tablespaces in the Oracle Database no matter what we provided in the "Database" field.
The solution is that each service should monitor just the Tablespace provided in the wizard (ie. In Database field).
And this can be done if you look at "check_oracle_health" plugin Docs and use "--name" parameter in the wizard generations of services commands.
And secondly, the "Database" field should be renamed to "Tablespace" because the database in Oracle refers to the whole Oracle server.
User avatar
cdienger
Support Tech
Posts: 5045
Joined: Tue Feb 07, 2017 11:26 am

Re: Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9

Post by cdienger »

We'll fix this in a wizard update, but in the meantime you can change this(starting on line 492):

Code: Select all

// common plugin opts
            if (have_value($sid) == false) {
                $commonopts = "--connect '{$address}:{$port}' --username '{$username}' --password '{$password}' ";
            } else {
                $commonopts = "--connect '{$address}:{$port}/{$sid}' --username '{$username}' --password '{$password}' ";
            }
to:

Code: Select all

// common plugin opts
            if (have_value($sid) == false) {
                $commonopts = "--connect '{$address}:{$port}' --username '{$username}' --password '{$password}' --name '{$database}' ";
            } else {
                $commonopts = "--connect '{$address}:{$port}/{$sid}' --username '{$username}' --password '{$password}' --name '{$database}' ";
            }
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Locked