[monitoring-plugins] - fix for issue #1562

[Jan Wagner]

    Module: monitoring-plugins
    Branch: wip-2.3.1
    Commit: 7c32e6454000436086385be924dee74ee0fe1e8d
    Author: ghciv6 <ghciv6@localhost>
 Committer: Jan Wagner <w...@cyconet.org>
      Date: Tue Sep 15 21:36:27 2020 +0200
       URL: 
https://www.monitoring-plugins.org/repositories/monitoring-plugins/commit/?id=7c32e64

- fix for issue #1562
  1st compare then free up resources

---

 plugins/check_mysql_query.c | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/plugins/check_mysql_query.c b/plugins/check_mysql_query.c
index 49a14dd..ac2fb15 100644
--- a/plugins/check_mysql_query.c
+++ b/plugins/check_mysql_query.c
@@ -136,18 +136,18 @@ main (int argc, char **argv)
                die (STATE_CRITICAL, "QUERY %s: Fetch row error - %s\n", 
_("CRITICAL"), error);
        }
 
-       /* free the result */
-       mysql_free_result (res);
-
-       /* close the connection */
-       mysql_close (&mysql);
-
        if (! is_numeric(row[0])) {
                die (STATE_CRITICAL, "QUERY %s: %s - '%s'\n", _("CRITICAL"), 
_("Is not a numeric"), row[0]);
        }
 
        value = strtod(row[0], NULL);
 
+       /* free the result */
+       mysql_free_result (res);
+
+       /* close the connection */
+       mysql_close (&mysql);
+
        if (verbose >= 3)
                printf("mysql result: %f\n", value);