Trying to use Macro in oracle query

[btayl]

trying to use a Macro for username and password and get the following error

CRITICAL - cannot connect to schp.mcit.med.umich.edu:1521/schp.world. ORA-01017: invalid username/password: logon denied (DBD ERROR: OCISessionBegin)

This is what I did for the username and password

--username $user12$ --password $user13$

[benjaminsmith]

Hi,

That should work. Did you re-start Nagios core after adding those to /usr/local/nagios/etc/resource.cfg?.

Code: Select all

systemctl restart nagios

Did you define the macros as uppercase or lowercase, make sure that matches as its case sensitive? As a matter of convention, they are normally uppercase.

Documentation: https://assets.nagios.com/downloads/nag ... ponent.pdf

[btayl]

I changed the Macro to uppercase and now it works just fine

[benjaminsmith]

Hi,

Glad that took care of it.

We'll go ahead a close this topic, but feel free to open another ticket if have any new issues.

--Benjamin