1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
|
/*
** Zabbix
** Copyright (C) 2001-2019 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.
**/
#ifndef ZABBIX_DB_H
#define ZABBIX_DB_H
#include "common.h"
#include "zbxalgo.h"
#include "zbxdb.h"
#include "dbschema.h"
extern char *CONFIG_DBHOST;
extern char *CONFIG_DBNAME;
extern char *CONFIG_DBSCHEMA;
extern char *CONFIG_DBUSER;
extern char *CONFIG_DBPASSWORD;
extern char *CONFIG_DBSOCKET;
extern int CONFIG_DBPORT;
extern int CONFIG_HISTSYNCER_FORKS;
extern int CONFIG_UNAVAILABLE_DELAY;
typedef enum
{
GRAPH_TYPE_NORMAL = 0,
GRAPH_TYPE_STACKED = 1
}
zbx_graph_types;
typedef enum
{
CALC_FNC_MIN = 1,
CALC_FNC_AVG = 2,
CALC_FNC_MAX = 4,
CALC_FNC_ALL = 7
}
zbx_graph_item_calc_function;
typedef enum
{
GRAPH_ITEM_SIMPLE = 0,
GRAPH_ITEM_AGGREGATED = 1
}
zbx_graph_item_type;
struct _DC_TRIGGER;
#define ZBX_DB_CONNECT_NORMAL 0
#define ZBX_DB_CONNECT_EXIT 1
#define ZBX_DB_CONNECT_ONCE 2
/* type of database */
#define ZBX_DB_UNKNOWN 0
#define ZBX_DB_SERVER 1
#define ZBX_DB_PROXY 2
#define TRIGGER_URL_LEN 255
#define TRIGGER_DESCRIPTION_LEN 255
#define TRIGGER_EXPRESSION_LEN 2048
#define TRIGGER_EXPRESSION_LEN_MAX (TRIGGER_EXPRESSION_LEN + 1)
#if defined(HAVE_IBM_DB2) || defined(HAVE_ORACLE)
# define TRIGGER_COMMENTS_LEN 2048
#else
# define TRIGGER_COMMENTS_LEN 65535
#endif
#define TAG_NAME_LEN 255
#define TAG_VALUE_LEN 255
#define GROUP_NAME_LEN 255
#define HOST_HOST_LEN MAX_ZBX_HOSTNAME_LEN
#define HOST_HOST_LEN_MAX (HOST_HOST_LEN + 1)
#define HOST_NAME_LEN 128
#define HOST_ERROR_LEN 2048
#define HOST_ERROR_LEN_MAX (HOST_ERROR_LEN + 1)
#define HOST_IPMI_USERNAME_LEN 16
#define HOST_IPMI_USERNAME_LEN_MAX (HOST_IPMI_USERNAME_LEN + 1)
#define HOST_IPMI_PASSWORD_LEN 20
#define HOST_IPMI_PASSWORD_LEN_MAX (HOST_IPMI_PASSWORD_LEN + 1)
#define HOST_PROXY_ADDRESS_LEN 255
#define HOST_PROXY_ADDRESS_LEN_MAX (HOST_PROXY_ADDRESS_LEN + 1)
#define INTERFACE_DNS_LEN 255
#define INTERFACE_DNS_LEN_MAX (INTERFACE_DNS_LEN + 1)
#define INTERFACE_IP_LEN 64
#define INTERFACE_IP_LEN_MAX (INTERFACE_IP_LEN + 1)
#define INTERFACE_ADDR_LEN 255 /* MAX(INTERFACE_DNS_LEN,INTERFACE_IP_LEN) */
#define INTERFACE_ADDR_LEN_MAX (INTERFACE_ADDR_LEN + 1)
#define INTERFACE_PORT_LEN 64
#define INTERFACE_PORT_LEN_MAX (INTERFACE_PORT_LEN + 1)
#define ITEM_NAME_LEN 255
#define ITEM_KEY_LEN 255
#define ITEM_DELAY_LEN 1024
#define ITEM_HISTORY_LEN 255
#define ITEM_TRENDS_LEN 255
#define ITEM_UNITS_LEN 255
#define ITEM_SNMP_COMMUNITY_LEN 64
#define ITEM_SNMP_COMMUNITY_LEN_MAX (ITEM_SNMP_COMMUNITY_LEN + 1)
#define ITEM_SNMP_OID_LEN 512
#define ITEM_SNMP_OID_LEN_MAX (ITEM_SNMP_OID_LEN + 1)
#define ITEM_ERROR_LEN 2048
#define ITEM_ERROR_LEN_MAX (ITEM_ERROR_LEN + 1)
#define ITEM_TRAPPER_HOSTS_LEN 255
#define ITEM_TRAPPER_HOSTS_LEN_MAX (ITEM_TRAPPER_HOSTS_LEN + 1)
#define ITEM_SNMPV3_SECURITYNAME_LEN 64
#define ITEM_SNMPV3_SECURITYNAME_LEN_MAX (ITEM_SNMPV3_SECURITYNAME_LEN + 1)
#define ITEM_SNMPV3_AUTHPASSPHRASE_LEN 64
#define ITEM_SNMPV3_AUTHPASSPHRASE_LEN_MAX (ITEM_SNMPV3_AUTHPASSPHRASE_LEN + 1)
#define ITEM_SNMPV3_PRIVPASSPHRASE_LEN 64
#define ITEM_SNMPV3_PRIVPASSPHRASE_LEN_MAX (ITEM_SNMPV3_PRIVPASSPHRASE_LEN + 1)
#define ITEM_SNMPV3_CONTEXTNAME_LEN 255
#define ITEM_SNMPV3_CONTEXTNAME_LEN_MAX (ITEM_SNMPV3_CONTEXTNAME_LEN + 1)
#define ITEM_LOGTIMEFMT_LEN 64
#define ITEM_LOGTIMEFMT_LEN_MAX (ITEM_LOGTIMEFMT_LEN + 1)
#define ITEM_IPMI_SENSOR_LEN 128
#define ITEM_IPMI_SENSOR_LEN_MAX (ITEM_IPMI_SENSOR_LEN + 1)
#define ITEM_USERNAME_LEN 64
#define ITEM_USERNAME_LEN_MAX (ITEM_USERNAME_LEN + 1)
#define ITEM_PASSWORD_LEN 64
#define ITEM_PASSWORD_LEN_MAX (ITEM_PASSWORD_LEN + 1)
#define ITEM_PUBLICKEY_LEN 64
#define ITEM_PUBLICKEY_LEN_MAX (ITEM_PUBLICKEY_LEN + 1)
#define ITEM_PRIVATEKEY_LEN 64
#define ITEM_PRIVATEKEY_LEN_MAX (ITEM_PRIVATEKEY_LEN + 1)
#define ITEM_JMX_ENDPOINT_LEN 255
#define ITEM_JMX_ENDPOINT_LEN_MAX (ITEM_JMX_ENDPOINT_LEN + 1)
#define ITEM_TIMEOUT_LEN 255
#define ITEM_TIMEOUT_LEN_MAX (ITEM_TIMEOUT_LEN + 1)
#define ITEM_URL_LEN 2048
#define ITEM_URL_LEN_MAX (ITEM_URL_LEN + 1)
#define ITEM_QUERY_FIELDS_LEN 2048
#define ITEM_QUERY_FIELDS_LEN_MAX (ITEM_QUERY_FIELDS_LEN + 1)
#define ITEM_STATUS_CODES_LEN 255
#define ITEM_STATUS_CODES_LEN_MAX (ITEM_STATUS_CODES_LEN + 1)
#define ITEM_HTTP_PROXY_LEN 255
#define ITEM_HTTP_PROXY_LEN_MAX (ITEM_HTTP_PROXY_LEN + 1)
#define ITEM_SSL_KEY_PASSWORD_LEN 64
#define ITEM_SSL_KEY_PASSWORD_LEN_MAX (ITEM_SSL_KEY_PASSWORD_LEN + 1)
#define ITEM_SSL_CERT_FILE_LEN 255
#define ITEM_SSL_CERT_FILE_LEN_MAX (ITEM_SSL_CERT_FILE_LEN + 1)
#define ITEM_SSL_KEY_FILE_LEN 255
#define ITEM_SSL_KEY_FILE_LEN_MAX (ITEM_SSL_KEY_FILE_LEN + 1)
#if defined(HAVE_IBM_DB2) || defined(HAVE_ORACLE)
# define ITEM_PARAM_LEN 2048
# define ITEM_DESCRIPTION_LEN 2048
# define ITEM_POSTS_LEN 2048
# define ITEM_HEADERS_LEN 2048
#else
# define ITEM_PARAM_LEN 65535
# define ITEM_DESCRIPTION_LEN 65535
# define ITEM_POSTS_LEN 65535
# define ITEM_HEADERS_LEN 65535
#endif
#define HISTORY_STR_VALUE_LEN 255
#ifdef HAVE_IBM_DB2
# define HISTORY_TEXT_VALUE_LEN 2048
# define HISTORY_LOG_VALUE_LEN 2048
#else
# define HISTORY_TEXT_VALUE_LEN 65535
# define HISTORY_LOG_VALUE_LEN 65535
#endif
#define HISTORY_LOG_SOURCE_LEN 64
#define HISTORY_LOG_SOURCE_LEN_MAX (HISTORY_LOG_SOURCE_LEN + 1)
#define ALERT_ERROR_LEN 2048
#define ALERT_ERROR_LEN_MAX (ALERT_ERROR_LEN + 1)
#define GRAPH_NAME_LEN 128
#define GRAPH_ITEM_COLOR_LEN 6
#define GRAPH_ITEM_COLOR_LEN_MAX (GRAPH_ITEM_COLOR_LEN + 1)
#define DSERVICE_VALUE_LEN 255
#define HTTPTEST_HTTP_USER_LEN 64
#define HTTPTEST_HTTP_PASSWORD_LEN 64
#define PROXY_DHISTORY_VALUE_LEN 255
#define ITEM_PREPROC_PARAMS_LEN 255
#define EVENT_NAME_LEN 2048
#define FUNCTION_PARAM_LEN 255
#define ZBX_SQL_ITEM_FIELDS "i.itemid,i.key_,h.host,i.type,i.history,i.hostid,i.value_type,i.delta," \
"i.units,i.multiplier,i.formula,i.state,i.valuemapid,i.trends,i.data_type"
#define ZBX_SQL_ITEM_TABLES "hosts h,items i"
#define ZBX_SQL_TIME_FUNCTIONS "'nodata','date','dayofmonth','dayofweek','time','now'"
#define ZBX_SQL_ITEM_FIELDS_NUM 15
#define ZBX_SQL_ITEM_SELECT ZBX_SQL_ITEM_FIELDS " from " ZBX_SQL_ITEM_TABLES
#ifdef HAVE_ORACLE
#define DBbegin_multiple_update(sql, sql_alloc, sql_offset) zbx_strcpy_alloc(sql, sql_alloc, sql_offset, "begin\n")
#define DBend_multiple_update(sql, sql_alloc, sql_offset) zbx_strcpy_alloc(sql, sql_alloc, sql_offset, "end;")
#define ZBX_SQL_STRCMP "%s%s%s"
#define ZBX_SQL_STRVAL_EQ(str) '\0' != *str ? "='" : "", \
'\0' != *str ? str : " is null", \
'\0' != *str ? "'" : ""
#define ZBX_SQL_STRVAL_NE(str) '\0' != *str ? "<>'" : "", \
'\0' != *str ? str : " is not null", \
'\0' != *str ? "'" : ""
#else
#define DBbegin_multiple_update(sql, sql_alloc, sql_offset)
#define DBend_multiple_update(sql, sql_alloc, sql_offset)
#define ZBX_SQL_STRCMP "%s'%s'"
#define ZBX_SQL_STRVAL_EQ(str) "=", str
#define ZBX_SQL_STRVAL_NE(str) "<>", str
#endif
#define ZBX_SQL_NULLCMP(f1, f2) "((" f1 " is null and " f2 " is null) or " f1 "=" f2 ")"
#define ZBX_DBROW2UINT64(uint, row) if (SUCCEED == DBis_null(row)) \
uint = 0; \
else \
is_uint64(row, &uint)
#define ZBX_DB_MAX_ID (zbx_uint64_t)__UINT64_C(0x7fffffffffffffff)
typedef struct
{
zbx_uint64_t druleid;
zbx_uint64_t unique_dcheckid;
char *iprange;
char *name;
}
DB_DRULE;
typedef struct
{
zbx_uint64_t dcheckid;
char *ports;
char *key_;
char *snmp_community;
char *snmpv3_securityname;
char *snmpv3_authpassphrase;
char *snmpv3_privpassphrase;
char *snmpv3_contextname;
int type;
unsigned char snmpv3_securitylevel;
unsigned char snmpv3_authprotocol;
unsigned char snmpv3_privprotocol;
}
DB_DCHECK;
typedef struct
{
zbx_uint64_t dhostid;
int status;
int lastup;
int lastdown;
}
DB_DHOST;
typedef struct
{
zbx_uint64_t dserviceid;
int status;
int lastup;
int lastdown;
char *value;
}
DB_DSERVICE;
typedef struct
{
zbx_uint64_t triggerid;
char *description;
char *expression;
char *recovery_expression;
char *url;
char *comments;
char *correlation_tag;
unsigned char value;
unsigned char priority;
unsigned char type;
unsigned char recovery_mode;
unsigned char correlation_mode;
}
DB_TRIGGER;
typedef struct
{
zbx_uint64_t eventid;
DB_TRIGGER trigger;
zbx_uint64_t objectid;
char *name;
int source;
int object;
int clock;
int value;
int acknowledged;
int ns;
int severity;
unsigned char suppressed;
zbx_vector_ptr_t tags;
#define ZBX_FLAGS_DB_EVENT_UNSET 0x0000
#define ZBX_FLAGS_DB_EVENT_CREATE 0x0001
#define ZBX_FLAGS_DB_EVENT_NO_ACTION 0x0002
zbx_uint64_t flags;
}
DB_EVENT;
typedef struct
{
zbx_uint64_t mediatypeid;
zbx_media_type_t type;
char *description;
char *smtp_server;
char *smtp_helo;
char *smtp_email;
char *exec_path;
char *exec_params;
char *gsm_modem;
char *username;
char *passwd;
unsigned short smtp_port;
unsigned char smtp_security;
unsigned char smtp_verify_peer;
unsigned char smtp_verify_host;
unsigned char smtp_authentication;
}
DB_MEDIATYPE;
typedef struct
{
zbx_uint64_t conditionid;
zbx_uint64_t actionid;
char *value;
char *value2;
int condition_result;
unsigned char conditiontype;
unsigned char op;
}
DB_CONDITION;
typedef struct
{
zbx_uint64_t alertid;
zbx_uint64_t actionid;
int clock;
zbx_uint64_t mediatypeid;
char *sendto;
char *subject;
char *message;
zbx_alert_status_t status;
int retries;
}
DB_ALERT;
typedef struct
{
zbx_uint64_t housekeeperid;
char *tablename;
char *field;
zbx_uint64_t value;
}
DB_HOUSEKEEPER;
typedef struct
{
zbx_uint64_t httptestid;
char *name;
char *agent;
char *http_user;
char *http_password;
char *http_proxy;
char *ssl_cert_file;
char *ssl_key_file;
char *ssl_key_password;
char *delay;
int authentication;
int retries;
int verify_peer;
int verify_host;
}
DB_HTTPTEST;
typedef struct
{
zbx_uint64_t httpstepid;
zbx_uint64_t httptestid;
char *name;
char *url;
char *posts;
char *required;
char *status_codes;
int no;
int timeout;
int follow_redirects;
int retrieve_mode;
int post_type;
}
DB_HTTPSTEP;
typedef struct
{
zbx_uint64_t escalationid;
zbx_uint64_t actionid;
zbx_uint64_t triggerid;
zbx_uint64_t itemid;
zbx_uint64_t eventid;
zbx_uint64_t r_eventid;
zbx_uint64_t acknowledgeid;
int nextcheck;
int esc_step;
zbx_escalation_status_t status;
}
DB_ESCALATION;
typedef struct
{
zbx_uint64_t actionid;
char *name;
char *shortdata;
char *longdata;
char *r_shortdata;
char *r_longdata;
char *ack_shortdata;
char *ack_longdata;
int esc_period;
unsigned char eventsource;
unsigned char pause_suppressed;
unsigned char recovery;
unsigned char status;
}
DB_ACTION;
typedef struct
{
zbx_uint64_t acknowledgeid;
zbx_uint64_t userid;
char *message;
int clock;
int action;
int old_severity;
int new_severity;
}
DB_ACKNOWLEDGE;
int DBinit(char **error);
void DBdeinit(void);
int DBconnect(int flag);
void DBclose(void);
#ifdef HAVE_ORACLE
void DBstatement_prepare(const char *sql);
#endif
#ifdef HAVE___VA_ARGS__
# define DBexecute(fmt, ...) __zbx_DBexecute(ZBX_CONST_STRING(fmt), ##__VA_ARGS__)
# define DBexecute_once(fmt, ...) __zbx_DBexecute_once(ZBX_CONST_STRING(fmt), ##__VA_ARGS__)
#else
# define DBexecute __zbx_DBexecute
# define DBexecute_once __zbx_DBexecute_once
#endif
int __zbx_DBexecute(const char *fmt, ...) __zbx_attr_format_printf(1, 2);
int __zbx_DBexecute_once(const char *fmt, ...) __zbx_attr_format_printf(1, 2);
#ifdef HAVE___VA_ARGS__
# define DBselect_once(fmt, ...) __zbx_DBselect_once(ZBX_CONST_STRING(fmt), ##__VA_ARGS__)
# define DBselect(fmt, ...) __zbx_DBselect(ZBX_CONST_STRING(fmt), ##__VA_ARGS__)
#else
# define DBselect_once __zbx_DBselect_once
# define DBselect __zbx_DBselect
#endif
DB_RESULT __zbx_DBselect_once(const char *fmt, ...) __zbx_attr_format_printf(1, 2);
DB_RESULT __zbx_DBselect(const char *fmt, ...) __zbx_attr_format_printf(1, 2);
DB_RESULT DBselectN(const char *query, int n);
DB_ROW DBfetch(DB_RESULT result);
int DBis_null(const char *field);
void DBbegin(void);
int DBcommit(void);
void DBrollback(void);
void DBend(int ret);
const ZBX_TABLE *DBget_table(const char *tablename);
const ZBX_FIELD *DBget_field(const ZBX_TABLE *table, const char *fieldname);
#define DBget_maxid(table) DBget_maxid_num(table, 1)
zbx_uint64_t DBget_maxid_num(const char *tablename, int num);
/******************************************************************************
* *
* Type: ZBX_GRAPH_ITEMS *
* *
* Purpose: represent graph item data *
* *
* Author: Eugene Grigorjev *
* *
******************************************************************************/
typedef struct
{
zbx_uint64_t itemid; /* itemid should come first for correct sorting */
zbx_uint64_t gitemid;
char key[ITEM_KEY_LEN * ZBX_MAX_BYTES_IN_UTF8_CHAR + 1];
int drawtype;
int sortorder;
char color[GRAPH_ITEM_COLOR_LEN_MAX];
int yaxisside;
int calc_fnc;
int type;
unsigned char flags;
}
ZBX_GRAPH_ITEMS;
typedef struct
{
zbx_uint64_t triggerid;
unsigned char value;
unsigned char state;
unsigned char priority;
int lastchange;
int problem_count;
char *error;
#define ZBX_FLAGS_TRIGGER_DIFF_UNSET 0x0000
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE_VALUE 0x0001
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE_LASTCHANGE 0x0002
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE_STATE 0x0004
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE_ERROR 0x0008
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE \
(ZBX_FLAGS_TRIGGER_DIFF_UPDATE_VALUE | ZBX_FLAGS_TRIGGER_DIFF_UPDATE_LASTCHANGE | \
ZBX_FLAGS_TRIGGER_DIFF_UPDATE_STATE | ZBX_FLAGS_TRIGGER_DIFF_UPDATE_ERROR)
#define ZBX_FLAGS_TRIGGER_DIFF_UPDATE_PROBLEM_COUNT 0x1000
#define ZBX_FLAGS_TRIGGER_DIFF_RECALCULATE_PROBLEM_COUNT 0x2000
zbx_uint64_t flags;
}
zbx_trigger_diff_t;
void zbx_process_triggers(zbx_vector_ptr_t *triggers, zbx_vector_ptr_t *diffs);
void zbx_db_save_trigger_changes(const zbx_vector_ptr_t *diffs);
void zbx_trigger_diff_free(zbx_trigger_diff_t *diff);
void zbx_append_trigger_diff(zbx_vector_ptr_t *trigger_diff, zbx_uint64_t triggerid, unsigned char priority,
zbx_uint64_t flags, unsigned char value, unsigned char state, int lastchange, const char *error);
int DBget_row_count(const char *table_name);
int DBget_proxy_lastaccess(const char *hostname, int *lastaccess, char **error);
char *DBdyn_escape_field(const char *table_name, const char *field_name, const char *src);
char *DBdyn_escape_string(const char *src);
char *DBdyn_escape_string_len(const char *src, size_t length);
char *DBdyn_escape_like_pattern(const char *src);
zbx_uint64_t DBadd_host(char *server, int port, int status, int useip, char *ip, int disable_until, int available);
int DBadd_templates_to_host(int hostid, int host_templateid);
int DBadd_template_linkage(int hostid, int templateid, int items, int triggers, int graphs);
int DBadd_trigger_to_linked_hosts(int triggerid, int hostid);
void DBdelete_sysmaps_hosts_by_hostid(zbx_uint64_t hostid);
int DBadd_graph_item_to_linked_hosts(int gitemid, int hostid);
int DBcopy_template_elements(zbx_uint64_t hostid, zbx_vector_uint64_t *lnk_templateids, char **error);
int DBdelete_template_elements(zbx_uint64_t hostid, zbx_vector_uint64_t *del_templateids, char **error);
void DBdelete_items(zbx_vector_uint64_t *itemids);
void DBdelete_graphs(zbx_vector_uint64_t *graphids);
void DBdelete_hosts(zbx_vector_uint64_t *hostids);
void DBdelete_hosts_with_prototypes(zbx_vector_uint64_t *hostids);
int DBupdate_itservices(const zbx_vector_ptr_t *trigger_diff);
int DBremove_triggers_from_itservices(zbx_uint64_t *triggerids, int triggerids_num);
int zbx_create_itservices_lock(char **error);
void zbx_destroy_itservices_lock(void);
void DBadd_condition_alloc(char **sql, size_t *sql_alloc, size_t *sql_offset, const char *fieldname,
const zbx_uint64_t *values, const int num);
void DBadd_str_condition_alloc(char **sql, size_t *sql_alloc, size_t *sql_offset, const char *fieldname,
const char **values, const int num);
int zbx_check_user_permissions(const zbx_uint64_t *userid, const zbx_uint64_t *recipient_userid);
const char *zbx_host_string(zbx_uint64_t hostid);
const char *zbx_host_key_string(zbx_uint64_t itemid);
const char *zbx_user_string(zbx_uint64_t userid);
void DBregister_host(zbx_uint64_t proxy_hostid, const char *host, const char *ip, const char *dns,
unsigned short port, const char *host_metadata, int now);
void DBregister_host_prepare(zbx_vector_ptr_t *autoreg_hosts, const char *host, const char *ip, const char *dns,
unsigned short port, const char *host_metadata, int now);
void DBregister_host_flush(zbx_vector_ptr_t *autoreg_hosts, zbx_uint64_t proxy_hostid);
void DBregister_host_clean(zbx_vector_ptr_t *autoreg_hosts);
void DBproxy_register_host(const char *host, const char *ip, const char *dns, unsigned short port,
const char *host_metadata);
int DBexecute_overflowed_sql(char **sql, size_t *sql_alloc, size_t *sql_offset);
char *DBget_unique_hostname_by_sample(const char *host_name_sample);
const char *DBsql_id_ins(zbx_uint64_t id);
const char *DBsql_id_cmp(zbx_uint64_t id);
zbx_uint64_t DBadd_interface(zbx_uint64_t hostid, unsigned char type,
unsigned char useip, const char *ip, const char *dns, unsigned short port);
const char *DBget_inventory_field(unsigned char inventory_link);
void DBset_host_inventory(zbx_uint64_t hostid, int inventory_mode);
void DBadd_host_inventory(zbx_uint64_t hostid, int inventory_mode);
int DBtxn_status(void);
int DBtxn_ongoing(void);
int DBtable_exists(const char *table_name);
int DBfield_exists(const char *table_name, const char *field_name);
#ifndef HAVE_SQLITE3
int DBindex_exists(const char *table_name, const char *index_name);
#endif
int DBexecute_multiple_query(const char *query, const char *field_name, zbx_vector_uint64_t *ids);
int DBlock_record(const char *table, zbx_uint64_t id, const char *add_field, zbx_uint64_t add_id);
int DBlock_records(const char *table, const zbx_vector_uint64_t *ids);
#define DBlock_hostid(id) DBlock_record("hosts", id, NULL, 0)
#define DBlock_druleid(id) DBlock_record("drules", id, NULL, 0)
#define DBlock_dcheckid(dcheckid, druleid) DBlock_record("dchecks", dcheckid, "druleid", druleid)
#define DBlock_hostids(ids) DBlock_records("hosts", ids)
void DBdelete_groups(zbx_vector_uint64_t *groupids);
void DBselect_uint64(const char *sql, zbx_vector_uint64_t *ids);
/* bulk insert support */
/* database bulk insert data */
typedef struct
{
/* the target table */
const ZBX_TABLE *table;
/* the fields to insert (pointers to the ZBX_FIELD structures from database schema) */
zbx_vector_ptr_t fields;
/* the values rows to insert (pointers to arrays of zbx_db_value_t structures) */
zbx_vector_ptr_t rows;
/* index of autoincrement field */
int autoincrement;
}
zbx_db_insert_t;
void zbx_db_insert_prepare_dyn(zbx_db_insert_t *self, const ZBX_TABLE *table, const ZBX_FIELD **fields,
int fields_num);
void zbx_db_insert_prepare(zbx_db_insert_t *self, const char *table, ...);
void zbx_db_insert_add_values_dyn(zbx_db_insert_t *self, const zbx_db_value_t **values, int values_num);
void zbx_db_insert_add_values(zbx_db_insert_t *self, ...);
int zbx_db_insert_execute(zbx_db_insert_t *self);
void zbx_db_insert_clean(zbx_db_insert_t *self);
void zbx_db_insert_autoincrement(zbx_db_insert_t *self, const char *field_name);
int zbx_db_get_database_type(void);
/* agent (ZABBIX, SNMP, IPMI, JMX) availability data */
typedef struct
{
/* flags specifying which fields are set, see ZBX_FLAGS_AGENT_STATUS_* defines */
unsigned char flags;
/* agent availability fields */
unsigned char available;
char *error;
int errors_from;
int disable_until;
}
zbx_agent_availability_t;
#define ZBX_FLAGS_AGENT_STATUS_NONE 0x00000000
#define ZBX_FLAGS_AGENT_STATUS_AVAILABLE 0x00000001
#define ZBX_FLAGS_AGENT_STATUS_ERROR 0x00000002
#define ZBX_FLAGS_AGENT_STATUS_ERRORS_FROM 0x00000004
#define ZBX_FLAGS_AGENT_STATUS_DISABLE_UNTIL 0x00000008
#define ZBX_FLAGS_AGENT_STATUS (ZBX_FLAGS_AGENT_STATUS_AVAILABLE | \
ZBX_FLAGS_AGENT_STATUS_ERROR | \
ZBX_FLAGS_AGENT_STATUS_ERRORS_FROM | \
ZBX_FLAGS_AGENT_STATUS_DISABLE_UNTIL)
#define ZBX_AGENT_ZABBIX (INTERFACE_TYPE_AGENT - 1)
#define ZBX_AGENT_SNMP (INTERFACE_TYPE_SNMP - 1)
#define ZBX_AGENT_IPMI (INTERFACE_TYPE_IPMI - 1)
#define ZBX_AGENT_JMX (INTERFACE_TYPE_JMX - 1)
#define ZBX_AGENT_UNKNOWN 255
#define ZBX_AGENT_MAX INTERFACE_TYPE_COUNT
typedef struct
{
zbx_uint64_t hostid;
zbx_agent_availability_t agents[ZBX_AGENT_MAX];
}
zbx_host_availability_t;
int zbx_sql_add_host_availability(char **sql, size_t *sql_alloc, size_t *sql_offset,
const zbx_host_availability_t *ha);
int DBget_user_by_active_session(const char *sessionid, zbx_user_t *user);
typedef struct
{
zbx_uint64_t itemid;
zbx_uint64_t lastlogsize;
unsigned char state;
int mtime;
int lastclock;
const char *error;
zbx_uint64_t flags;
#define ZBX_FLAGS_ITEM_DIFF_UNSET __UINT64_C(0x0000)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_STATE __UINT64_C(0x0001)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_ERROR __UINT64_C(0x0002)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_MTIME __UINT64_C(0x0004)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_LASTLOGSIZE __UINT64_C(0x0008)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_LASTCLOCK __UINT64_C(0x1000)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE_DB \
(ZBX_FLAGS_ITEM_DIFF_UPDATE_STATE | ZBX_FLAGS_ITEM_DIFF_UPDATE_ERROR |\
ZBX_FLAGS_ITEM_DIFF_UPDATE_MTIME | ZBX_FLAGS_ITEM_DIFF_UPDATE_LASTLOGSIZE)
#define ZBX_FLAGS_ITEM_DIFF_UPDATE (ZBX_FLAGS_ITEM_DIFF_UPDATE_DB | ZBX_FLAGS_ITEM_DIFF_UPDATE_LASTCLOCK)
}
zbx_item_diff_t;
/* event support */
void zbx_db_get_events_by_eventids(zbx_vector_uint64_t *eventids, zbx_vector_ptr_t *events);
void zbx_db_free_event(DB_EVENT *event);
void zbx_db_get_eventid_r_eventid_pairs(zbx_vector_uint64_t *eventids, zbx_vector_uint64_pair_t *event_pairs,
zbx_vector_uint64_t *r_eventids);
void zbx_db_trigger_clean(DB_TRIGGER *trigger);
typedef struct
{
zbx_uint64_t hostid;
unsigned char compress;
int version;
int lastaccess;
#define ZBX_FLAGS_PROXY_DIFF_UNSET __UINT64_C(0x0000)
#define ZBX_FLAGS_PROXY_DIFF_UPDATE_COMPRESS __UINT64_C(0x0001)
#define ZBX_FLAGS_PROXY_DIFF_UPDATE_VERSION __UINT64_C(0x0002)
#define ZBX_FLAGS_PROXY_DIFF_UPDATE_LASTACCESS __UINT64_C(0x0004)
#define ZBX_FLAGS_PROXY_DIFF_UPDATE ( \
ZBX_FLAGS_PROXY_DIFF_UPDATE_COMPRESS | \
ZBX_FLAGS_PROXY_DIFF_UPDATE_VERSION | \
ZBX_FLAGS_PROXY_DIFF_UPDATE_LASTACCESS)
zbx_uint64_t flags;
}
zbx_proxy_diff_t;
int zbx_db_lock_maintenanceids(zbx_vector_uint64_t *maintenanceids);
#endif
|