Werk #7700: mk_postgres: Fixed several problems
Component | Checks & agents |
Title | mk_postgres: Fixed several problems |
Date | May 31, 2019 |
Checkmk Edition | Checkmk Raw (CRE) |
Checkmk Version | 1.5.0p17 1.6.0b1 |
Level | Trivial Change |
Class | Bug Fix |
Compatibility | Compatible - no manual interaction needed |
Originally the version of the client tools was taken, but what really matters is the version of the server. Terminate the script, if the server can not be queried.
In postgresql 9.2 the column state was introduced, which has to be queried to find the state of the sessions. The column state can be NULL.
Here the order of the columns did not match with what the server side expects, with the result, that there was never any active connection shown in the web-gui.