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
|
<?php
/*
** 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.
**/
include "include/config.inc.php";
include "include/forms.inc.php";
$page["file"] = "bulkloader.php";
$page["title"] = "S_BULKLOADER_MAIN";
$fileuploaded=0;
show_header($page["title"],0,0);
if(!check_anyright("Default permission","U"))
{
show_table_header("<font color=\"AA0000\">".S_NO_PERMISSIONS."</font>");
show_footer();
exit;
}
insert_confirm_javascript();
if(isset($_FILES['uploadfile']))
{
$fileName = $_FILES['uploadfile']['name'];
$fileTmpName = $_FILES['uploadfile']['tmp_name'];
$listing=file($fileTmpName);
}
if(isset($_REQUEST["register"])&&($_FILES['uploadfile']['size']>0)&&($_REQUEST["register"]=="Import"))
{
foreach($listing as $element_number => $element)
{
list($inportFunc,$tmpField) = explode(",",$element,2);
switch($inportFunc)
{
case "HOST":
// HOST entry must be of the form;
// Hostname,HostIP,HostPort,HostStatus,HostTemplate,HostZabbixServer,HostGroup(s)
// If HostIP contains anything, it will be used as the IP address for this host.
// If HostPort is empty, then the default port of 10050 is used.
// HostStatus can be Template, Monitored, or Not Monitored. Any other value is assumed to be Not Monitored.
// HostTeample is the full name of the Template host. If this is blank or if the host does not exist in the DB, the
// Bulk Loader assumes no template.
// HostZabbixServer is the full name of the Zabbix server which will be responsible for monitoring this host.
// If this is blank or if the server does not exist in the DB, the Bulk Loader assumes that you have only a single
// Zabbix server.
// HostGroup(s) contains the name of the group or groups, comma seperate, that this host belongs to. If this field is
// empty then the Bulk Loader assumes that this host belongs to no groups. If this contains one or more groups
// that are not in the DB, the bulk loader will create new groups with the names defined in this field.
list($tmpHost,$tmpHostIP,$tmpHostPort,$tmpHostStat,$tmpHostTemplate,$tmpHostServer,$tmpHostGroups) = explode(",",$tmpField,7);
$hostName=@iif($tmpHost==NULL,'Unknown',$tnpHost);
$hostUseIP=@iif($tmpHostIP==NULL,'off','on');
$hostPort=@iif($tmpHostPort==NULL,10050,$tmpHostPort);
// Determine what type of host this is
switch($tmpHostStat)
{
case "Template":
case "template":
case "3":
$hostStat=3;
break;
case "Monitored":
case "monitored":
case "0":
$hostStat=0;
break;
default:
$hostStat=1;
}
// Determine which template, if any this host is linked to
$sql="select distinct(hostid) from hosts where status<>". HOST_STATUS_DELETED ." and host='$tmpHostTemplate'";
$sqlResult=DBselect($sql);
if(DBnum_rows($sqlResult)==1)
{
$row=DBfetch($sqlResult);
$hostTemplate=$row["hostid"];
}
else
{
$hostTemplate=0;
}
// Determine which Zabbix server this host defaults to
$sql="select distinct(serverid) from servers where host='$tmpHostServer'";
$sqlResult=DBselect($sql);
if(DBnum_rows($sqlResult)==1)
{
$row=DBfetch($sqlResult);
$hostServer=$row["serverid"];
}
else
{
$hostServer=1;
}
// Determine which group(s) this host belongs to, create any group(s) necessary;
$hostGroups=array();
$groupnum=0;
// $tmpGroupList=explode(',',rtrim(rtrim($tmpHostGroups," "),"\n"));
foreach(explode(',',rtrim(rtrim($tmpHostGroups," "),"\n")) as $tmpGroup)
{
$groupnum++;
$sqlResult=DBSelect("select distinct(groupid) from groups where name='$tmpGroup'");
if(DBnum_rows($sqlResult)==0)
{
// Create new group
$hostGroups=array_merge($hostGroups,array(add_group($tmpGroup)));
}
else
{
// Found Existing Group;
$row=DBFetch($sqlResult);
$hostGroups=array_merge($hostGroups,array($row["groupid"]));
}
}
// Now that we have all the values we need process them for this host
$result=add_host($tmpHost,$hostPort,$hostStat,$hostUseIP,$tmpHostIP,$hostTemplate,'',$hostGroups);
show_messages($result,'Host added: '. $tmpHost,'Cannot add host: '. $tmpHost);;
DBselect("update hosts set serverid=$hostServer where host='$tmpHost'");
break;
case "USER":
echo "Importing Users is not yet implemented";
break;
case "ITEM":
echo "Importing Items is not yet implemented";
break;
case "TRIG":
echo "Importing Triggers is not yet implemented";
break;
case "ACTN":
echo "Importing Actions is not yet implemented";
break;
case "SVC":
echo "Importing IT Services is not yet implemented";
break;
default:
echo "$importFunc is an unknown Function";
}
}
}
table_begin();
table_row(array(
"Currently, The bulk loader, only loads Host Entries."
), 0);
table_end();
table_begin();
table_row(array(
'Host Entry Format.',
'HOST,<Hostname>,<Host IP>,<Host Port>,<Host Status>,<Template Host>,<Zabbix Server>,<Host Group(s)><BR>'.
' <STRONG>HOST</STRONG>: This is the command to tell the bulk loader that this entry is a host<BR>'.
' <STRONG>Hostname</STRONG>: This is the hostname you wish to use in the Zabbix UI<BR>'.
' <STRONG>Host IP</STRONG>: If Host IP contains anything, it will be used as the IP address for this host, otherwise the host will use Hostname.<BR>'.
' <STRONG>Host Port</STRONG>: If HostPort contains anything it will be used as the port for the Zabbix agent, otherwise it will default to 10050.<BR>'.
' <STRONG>Host Status</STRONG>: This field can be Template, Monitored, or Not Monitored. Any thing else will be considered Not Monitored.<BR>'.
' <STRONG>Template Host</STRONG>: This field contains the full name of the Template host, otherwise the host will not use a template.<BR>'.
' <STRONG>Zabbix Server</STRONG>: This field contains the full name of the Zabbix server. If it is blank or the server does not exist, it is assumed that this host in on the default Zabbix Server.<BR>'.
' <STRONG>Host Group(s)</STRONG>: This field contains the name of the group or groups, comma seperated, that this host belongs to. If this field is empty then it it assumed that this host belongs to no groups. If this contains one or more groups that are not in the Zabbix Server, the groups will be created and this host added to those groups.<BR>'.
''
), 2);
table_end();
table_begin();
table_row(array(
"<form method='post' enctype='multipart/form-data' action='". $page["file"] ."'><input type='hidden' name='MAX_FILE_SIZE' value='2000000' />",
"Please select the CSV file you wish to import ",
"<input class='button' type='file' name='uploadfile' />"
), 5);
table_end();
table_begin();
table_row(array(
"<input class='button' type='submit' name='register' value='Import' onClick=\"return Confirm('Are you sure you wish to import this file?');\" />",
"</form>"
), 1);
table_end();
show_footer();
?>
|
