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
|
<?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";
include "include/bulkloader.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_page_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;
}
// Now that we have all the values we need process them for this host
$result=add_host($tmpHost,$hostPort,$hostStat,$hostUseIP,$tmpHostIP,$hostTemplate,'','');
show_messages($result,'Host added: '. $tmpHost,'Cannot add host: '. $tmpHost);;
// Here we update the hosts_groups manually. This will create new groups if needed
// And add this host to any group listed.
$row=DBfetch(DBselect("select distinct(hostid) from hosts where host='$tmpHost'"));
$tmpHostID=$row["hostid"];
if($tmpHostID)
{
foreach(explode(',',rtrim(rtrim($tmpHostGroups," "),"\n")) as $tmpGroup)
{
$tmpGroupID=create_Host_Group($tmpGroup);
add_Host_To_Group($tmpGroupID,$tmpHostID);
}
add_template_linkage($tmpHostID,$hostTemplate,7,7,7,7,7);
sync_host_with_template($tmpHostID,$hostTemplate,7,7,7,7,7);
}
break;
case "USER":
list($tmpName,$tmpSurname,$tmpAlias,$tmpPasswd,$tmpURL,$tmpAutologout,$tmpLang,$tmpRefresh,$tmpUserGroups) = explode(",",$tmpField,9);
$autologout=@iif($tmpAutologout==NULL,900,$tmpAutologout);
$lang=@iif($tmpLang==NULL,'en_gb',$tmpLang);
$refresh=@iif($tmpRefresh==NULL,30,$tmpRefresh);
$passwd=@iif($tmpPasswd==NULL,md5($tmpAlias),md5($tmpPasswd));
$result=@iif($tmpAlias==NULL,0,add_user($tmpName,$tmpSurname,$tmpAlias,$passwd,$tmpURL,$autologout,$lang,$refresh));
show_messages($result, S_USER_ADDED .': '. $tmpAlias, S_CANNOT_ADD_USER .': '. $tmpAlias);
$row=DBfetch(DBselect("select distinct(userid) from users where alias='$tmpAlias'"));
$tmpUserID=$row["userid"];
if($tmpUserID)
{
foreach(explode(',',rtrim(rtrim($tmpUserGroups," "),"\n")) as $tmpGroup)
{
$tmpGroupID=create_User_Group($tmpGroup);
add_User_To_Group($tmpGroupID,$tmpUserID);
}
}
break;
case "PERM":
echo "Importing User Permissions 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(
'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_row(array(
'User Entry Format.',
'USER,<User First Name>,<User Surname>,<Login Name>,<Password>,<URL>,<Auto Logout Time>,<Language>,<Screen Refresh Time>,<Host Group(s)><BR>'.
' <STRONG>USER</STRONG>: This is the command to tell the bulk loader that this entry is a User<BR>'.
' <STRONG>User First Name</STRONG>: This is the users first name<BR>'.
' <STRONG>User Surname</STRONG>: This is the users last name<BR>'.
' <STRONG>Login Name</STRONG>: This is the name the user will login with. NOTE: User will not be created if this is blank.<BR>'.
' <STRONG>Password</STRONG>: This is the password that user will login with. If blank, this will default to the login name.<BR>'.
' <STRONG>URL</STRONG>: This is the URL the user is redirected to upon login.<BR>'.
' <STRONG>Auto Logout Time</STRONG>: This is the number of seconds before an idle user will be logged off. If blank, this will default to 900 seconds.<BR>'.
' <STRONG>Language</STRONG>: This is the the language that that Zabbix will display to the user. If blank, this will default to en_gb. Valid Choices are;<BR>'.
' > en_gb -- English<BR>'.
' > fr_fr -- French<BR>'.
' > de_de -- German<BR>'.
' > it_it -- Itallian<BR>'.
' > ja_ja -- Japanese<BR>'.
' > lv_lv -- Latvian<BR>'.
' > ru_ru -- Russian<BR>'.
' > sp_sp -- Spanish<BR>'.
''.
' <STRONG>Screen Refresh Time</STRONG>: This is the number of seconds before monitoring pages will refresh. If blank, this will default to 30 seconds.<BR>'.
' <STRONG>User Group(s)</STRONG>: This is a comma separated list of user groups that the user belongs to. If this contains one or more groups that are not in the Zabbix Server, the groups will be created and user 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_page_footer();
?>
|
