CustomSQL mix information when running checks

[KevinZ15]

Hi.

I am currently checking/monitoring 2 services using the "CustoSQL" function. However, the information from one check is mixed with the other from time to time. For example, I have a CPU monitor and a message monitor that are defined under querys in the CustomSQL.xml file. When the CPU monitor does a check, it may return the correct CPU information or it may return the output of the message check query.

In my opinion, the solution could be to use various .xml files with the functions of each check and thus avoid combining information, but the plugin always points to /usr/local/nagios/etc/objects/CustomSQL.xml and does not allow using another path or different file.

Is there a way to solve it?

[williamlea1]

Hi,
Check the function ID of each custom SQL is unique and not contain special characters would be the first thing maybe.

Cheers Will.

[KevinZ15]

Hi, i have this on my CustomSQL.xml:

CPU Utilization single-value 80 90 Message Problems single-value 1 2

[williamlea1]

is your function ID ok though?

[KevinZ15]

I think the previous comment is copied wrong. I leave you a link with the content of CustomSQL.xml: https://pastebin.com/ReG0gBj6

Regarding the operation of the functions: Yes, the queries return the information I need.