Werk #7700: mk_postgres: Fixed several problems

Component

Checks & agents

Title

mk_postgres: Fixed several problems

Date

May 31, 2019

Level

Trivial Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

1.6.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.5.0p17	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

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.

To the list of all Werks