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
|
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** 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., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
#ifndef ZABBIX_DB_H
#define ZABBIX_DB_H
/* time_t */
#include <time.h>
#include "config.h"
#include "common.h"
#ifdef HAVE_MYSQL
#include "mysql.h"
#include "errmsg.h"
#include "mysqld_error.h"
#define DB_HANDLE MYSQL
#endif
#ifdef HAVE_PGSQL
#include "libpq-fe.h"
#endif
extern char *CONFIG_DBHOST;
extern char *CONFIG_DBNAME;
extern char *CONFIG_DBUSER;
extern char *CONFIG_DBPASSWORD;
extern char *CONFIG_DBSOCKET;
#define DB_HOST struct host_type
#define DB_ITEM struct item_type
#define DB_TRIGGER struct trigger_type
#define DB_ACTION struct action_type
#define DB_ALERT struct alert_type
#define DB_FUNCTION struct function_type
#define DB_MEDIA struct media_type
#define DB_MEDIATYPE struct mediatype_type
#ifdef HAVE_MYSQL
#define DB_RESULT MYSQL_RES
#define DBfree_result mysql_free_result
#endif
#ifdef HAVE_PGSQL
#define DB_RESULT PGresult
#define DBfree_result PQclear
#endif
#define MAX_HOST_HOST_LEN 64
DB_HOST
{
int hostid;
char *host;
int useip;
char *ip;
};
#define MAX_ITEM_KEY_LEN 64
#define MAX_ITEM_IP_LEN 15
#define MAX_ITEM_SNMP_COMMUNITY_LEN 64
#define MAX_ITEM_SNMP_OID_LEN 255
DB_ITEM
{
int itemid;
int hostid;
int type;
char *description;
char *key;
char *host;
int host_status;
int host_available;
int host_network_errors;
int useip;
char *ip;
char *shortname;
char *snmp_community;
char *snmp_oid;
int snmp_port;
char *trapper_hosts;
int port;
int delay;
int history;
int trends;
double prevorgvalue;
int prevorgvalue_null;
double lastvalue;
int lastclock;
char *lastvalue_str;
int lastvalue_null;
double prevvalue;
char *prevvalue_str;
int prevvalue_null;
time_t lastcheck;
time_t nextcheck;
int value_type;
int delta;
int multiplier;
char *units;
char *snmpv3_securityname;
int snmpv3_securitylevel;
char *snmpv3_authpassphrase;
char *snmpv3_privpassphrase;
char *formula;
};
DB_FUNCTION
{
int functionid;
int itemid;
int triggerid;
double lastvalue;
int lastvalue_null;
char *function;
/* int parameter;*/
char *parameter;
};
DB_MEDIA
{
int mediaid;
/* char *type;*/
int mediatypeid;
char *sendto;
int active;
int severity;
};
DB_MEDIATYPE
{
int mediatypeid;
int type;
char *description;
char *smtp_server;
char *smtp_helo;
char *smtp_email;
char *exec_path;
};
DB_TRIGGER
{
int triggerid;
char *expression;
char *description;
int status;
int value;
int priority;
};
DB_ACTION
{
int actionid;
int triggerid;
int userid;
int scope;
int severity;
int good;
int delay;
int lastcheck;
int recipient;
char subject[MAX_STRING_LEN];
char message[MAX_STRING_LEN];
};
DB_ALERT
{
int alertid;
int actionid;
int clock;
/* char *type;*/
int mediatypeid;
char *sendto;
char *subject;
char *message;
int status;
int retries;
};
void DBconnect(void);
#ifdef ZABBIX_THREADS
void DBconnect_thread(MYSQL *database);
void DBclose_thread(MYSQL *database);
int DBexecute_thread(MYSQL *database,char *query );
DB_RESULT *DBselect_thread(MYSQL *database, char *query);
void DBdelete_item_thread(MYSQL *database, int itemid);
void DBdelete_triggers_by_itemid_thread(MYSQL *database, int itemid);
void DBdelete_history_by_itemid_thread(MYSQL *database, int itemid);
void DBdelete_trends_by_itemid_thread(MYSQL *database, int itemid);
void DBdelete_trigger_thread(MYSQL *database, int triggerid);
void DBdelete_services_by_triggerid_thread(MYSQL *database, int triggerid);
void DBdelete_host_thread(MYSQL *database, int hostid);
void DBvacuum_thread(MYSQL *database);
void DBdelete_service_thread(MYSQL *database, int serviceid);
void DBdelete_sysmaps_links_by_shostid_thread(MYSQL *database, int shostid);
void DBupdate_host_availability_thread(MYSQL *database, int hostid,int available,int clock,char *error);
int DBupdate_item_status_to_notsupported_thread(MYSQL *database, int itemid, char *error);
int DBadd_history_thread(MYSQL *database, int itemid, double value, int clock);
int DBadd_trend_thread(MYSQL *database, int itemid, double value, int clock);
int DBadd_history_str_thread(MYSQL *database, int itemid, char *value, int clock);
int DBupdate_trigger_value_thread(MYSQL *database,int triggerid,int value,int clock);
int add_alarm_thread(MYSQL *database, int triggerid,int status,int clock);
int latest_alarm_thread(MYSQL *database,int triggerid, int status);
int DBadd_service_alarm_thread(MYSQL *database, int serviceid,int status,int clock);
int latest_service_alarm_thread(MYSQL *database, int serviceid, int status);
int DBget_prev_trigger_value_thread(MYSQL *database, int triggerid);
int DBadd_alert_thread(MYSQL *database, int actionid, int mediatypeid, char *sendto, char *subject, char *message);
int DBget_function_result_thread(MYSQL *database, double *result,char *functionid);
int DBget_items_count_thread(MYSQL *database);
int DBget_items_unsupported_count_thread(MYSQL *database);
int DBget_history_count_thread(MYSQL *database);
int DBget_history_str_count_thread(MYSQL *database);
int DBget_trends_count_thread(MYSQL *database);
int DBget_triggers_count_thread(MYSQL *database);
int DBget_queue_count_thread(MYSQL *database);
#endif
void DBclose(void);
void DBvacuum(void);
int DBexecute( char *query );
DB_RESULT *DBselect(char *query);
char *DBget_field(DB_RESULT *result, int rownum, int fieldnum);
int DBnum_rows(DB_RESULT *result);
int DBget_function_result(double *result,char *functionid);
void DBupdate_host_availability(int hostid,int available,int clock,char *error);
int DBupdate_item_status_to_notsupported(int itemid, char *error);
int DBadd_trend(int itemid, double value, int clock);
int DBadd_history(int itemid, double value, int clock);
int DBadd_history_str(int itemid, char *value, int clock);
int DBadd_service_alarm(int serviceid,int status,int clock);
int DBadd_alert(int actionid, int mediatypeid, char *sendto, char *subject, char *message);
void DBupdate_triggers_status_after_restart(void);
int DBget_prev_trigger_value(int triggerid);
int DBupdate_trigger_value(int triggerid,int value,int clock);
void DBdelete_item(int itemid);
void DBdelete_host(int hostid);
int DBget_items_count(void);
int DBget_items_unsupported_count(void);
int DBget_history_count(void);
int DBget_history_str_count(void);
int DBget_trends_count(void);
int DBget_triggers_count(void);
int DBget_queue_count(void);
void DBescape_string(char *from, char *to, int maxlen);
void DBget_item_from_db(DB_ITEM *item,DB_RESULT *result, int row);
#endif
|
