Thank you again.
We have analysed the debug output and came to some conclusions:
- The DB accepts the connection but returns no data:
At the bottom can be seen the DB prompt, which indicates that the connection to the DB has been established. - The query from inside the database - returns the desired data (but not with syntax that is used in the query):
- The syntax used in the query returns an error:
At the bottom can be seen the log for correct query (in black) and for the query with incorrect syntax (in red).
Could that be the reason for not getting the correct output?
Additionally, the DB admin does not wish to use userstorekey for this purpose - so I have to use just the usr/pwd option, which results in:
**static service deactivating (user@1001)CRIT
Service ‘check-mk-agent@24-IPmasked:6556-IPmasked:52610’ activating for: 0.00 s
What are the options?