Zabbix

/*

** Zabbix

** Copyright (C) 2001-2023 Zabbix SIA

**

** This program is free software; you can redistribute it and/or modify

** it under the terms of the GNU General Public License as published by

** the Free Software Foundation; either version 2 of the License, or

** (at your option) any later version.

**

** This program is distributed in the hope that it will be useful,

** but WITHOUT ANY WARRANTY; without even the implied warranty of

** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

** GNU General Public License for more details.

**

** You should have received a copy of the GNU General Public License

** along with this program; if not, write to the Free Software

** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

**/

​

#include "checks_db.h"

​

#ifdef HAVE_UNIXODBC

​

#include "log.h"

#include "zbxsysinfo.h"

​

#include "../odbc/odbc.h"

​

/******************************************************************************

 *                                                                            *

 * Purpose: retrieve data from database                                       *

 *                                                                            *

 * Parameters: item           - [IN] item we are interested in                *

 *             config_timeout - [IN]                                          *

 *             result         - [OUT] check result                            *

 *                                                                            *

 * Return value: SUCCEED - data successfully retrieved and stored in result   *

 *               NOTSUPPORTED - requested item is not supported               *

 *                                                                            *

 ******************************************************************************/

int get_value_db(const DC_ITEM *item, int config_timeout, AGENT_RESULT *result)

{

    AGENT_REQUEST       request;

    const char      *dsn, *connection = NULL;

    zbx_odbc_data_source_t  *data_source;

    zbx_odbc_query_result_t *query_result;

    char            *error = NULL;

    int         (*query_result_to_text)(zbx_odbc_query_result_t *query_result, char **text, char **error),

                ret = NOTSUPPORTED;

​

    zabbix_log(LOG_LEVEL_DEBUG, "In %s() key_orig:'%s' query:'%s'", __func__, item->key_orig, item->params);

​

    zbx_init_agent_request(&request);

​

    if (SUCCEED != zbx_parse_item_key(item->key, &request))

    {

        SET_MSG_RESULT(result, zbx_strdup(NULL, "Invalid item key format."));

        goto out;

    }

​

    if (0 == strcmp(request.key, "db.odbc.select"))

    {

        query_result_to_text = zbx_odbc_query_result_to_string;