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 "zbxdbhigh.h"

​

#include "log.h"

#include "events.h"

#include "zbxthreads.h"

#include "cfg.h"

#include "zbxcrypto.h"

#include "zbxnum.h"

#include "zbx_host_constants.h"

#include "zbx_trigger_constants.h"

#include "zbx_dbversion_constants.h"

​

#define ZBX_DB_WAIT_DOWN    10

​

#define ZBX_MAX_SQL_SIZE    262144  /* 256KB */

#ifndef ZBX_MAX_OVERFLOW_SQL_SIZE

#   ifdef HAVE_ORACLE

        /* Do not use "overflowing" (multi-statement) queries for Oracle. */

        /* Zabbix benefits from cursor_sharing=force Oracle parameter */

        /* which doesn't apply to PL/SQL blocks. */

#       define ZBX_MAX_OVERFLOW_SQL_SIZE    0

#   else

#       define ZBX_MAX_OVERFLOW_SQL_SIZE    ZBX_MAX_SQL_SIZE

#   endif

#elif 0 != ZBX_MAX_OVERFLOW_SQL_SIZE && \

        (1024 > ZBX_MAX_OVERFLOW_SQL_SIZE || ZBX_MAX_OVERFLOW_SQL_SIZE > ZBX_MAX_SQL_SIZE)

#error ZBX_MAX_OVERFLOW_SQL_SIZE is out of range

#endif

​

#ifdef HAVE_ORACLE

#   if 0 == ZBX_MAX_OVERFLOW_SQL_SIZE

#       define  ZBX_SQL_EXEC_FROM   ZBX_CONST_STRLEN(ZBX_PLSQL_BEGIN)

#   else

#       define  ZBX_SQL_EXEC_FROM   0

#   endif

#else

#   define  ZBX_SQL_EXEC_FROM   0

#endif

​

#ifdef HAVE_MULTIROW_INSERT

#   define ZBX_ROW_DL   ","

#else

#   define ZBX_ROW_DL   ";\n"

#endif

​

#if defined(HAVE_POSTGRESQL)

extern char ZBX_PG_ESCAPE_BACKSLASH;

#endif

​

static int  connection_failure;

​

static const zbx_config_dbhigh_t    *zbx_cfg_dbhigh = NULL;

​

static zbx_dc_get_nextid_func_t             zbx_cb_nextid;

​

void    zbx_db_close(void)

{

    zbx_db_close_basic();

}

​

int zbx_db_validate_config_features(unsigned char program_type, const zbx_config_dbhigh_t *config_dbhigh)

{

    int err = 0;

​

#if !(defined(HAVE_MYSQL_TLS) || defined(HAVE_MARIADB_TLS) || defined(HAVE_POSTGRESQL))

    err |= (FAIL == check_cfg_feature_str("DBTLSConnect", config_dbhigh->config_db_tls_connect,

            "PostgreSQL or MySQL library version that support TLS"));

    err |= (FAIL == check_cfg_feature_str("DBTLSCAFile", config_dbhigh->config_db_tls_ca_file,

            "PostgreSQL or MySQL library version that support TLS"));

    err |= (FAIL == check_cfg_feature_str("DBTLSCertFile", config_dbhigh->config_db_tls_cert_file,

            "PostgreSQL or MySQL library version that support TLS"));

    err |= (FAIL == check_cfg_feature_str("DBTLSKeyFile", config_dbhigh->config_db_tls_key_file,