tools_monitor.inc.php 19.8 KB
Newer Older
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
<?php
/*
Copyright (c) 2007-2008, Till Brehm, projektfarm Gmbh and Oliver Vogel www.muv.com
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

class tools_monitor {

32
33
	function showServerLoad() {
		global $app;
34

35
		/* fetch the Data from the DB */
36
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'server_load' AND server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
37

38
39
		if(isset($record['data'])) {
			$data = unserialize($record['data']);
40

41
			/*
42
43
            Format the data
            */
44
45
46
			if (strlen($data['up_minutes']) == "1") $data['up_minutes'] = "0".$data['up_minutes'];
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
47
48
49
50
51
52
53
54
55
56
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
                <table>
                <tr>
                <td>' . $app->lng("Server online since").':</td>
                <td>' . $data['up_days'] . ' days, ' . $data['up_hours'] . ':' . $data['up_minutes'] . ' hours</center></td>
                </tr>
                <tr>
                <td>' . $app->lng("Users online").':</td>
                <td>' . $data['user_online'] . '</td>
                </tr>' .
57
				'<tr>
58
59
60
61
62
63
64
65
66
67
68
69
70
71
                <td>' . $app->lng("System load 1 minute") . ':</td>
                <td>' . $data['load_1'] . '</td>
                </tr>
                <tr>
                <td>' . $app->lng("System load 5 minutes") . ':</td>
                <td>' . $data['load_5'] . '</td>
                </tr>
                <tr>
                <td>'.$app->lng("System load 15 minutes").':</td>
                <td>' . $data['load_15'] . '</td>
                </tr>
                </table>
                </div>
                </div>';
72
73
74
		} else {
			$html = '<p>'.$app->lng("no_data_serverload_txt").'</p>';
		}
75

76
77
		return $html;
	}
78

79
80
	function showDiskUsage () {
		global $app;
81

82
		/* fetch the Data from the DB */
83
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'disk_usage' AND server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
84

85
86
		if(isset($record['data'])) {
			$data = unserialize($record['data']);
87

88
			/*
89
90
            Format the data
            */
91
92
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
93
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
94
95
                <table class="table">
                <thead class="dark">
96
                <tr>
97
98
99
100
101
102
103
104
105
                <th>'.$app->lng("monitor_diskusage_filesystem_txt").'</th>
            <th class="small-col">'.$app->lng("monitor_diskusage_type_txt").'</th>
                <th class="tiny-col">'.$app->lng("monitor_diskusage_size_txt").'</th>
                <th class="tiny-col">'.$app->lng("monitor_diskusage_used_txt").'</th>
                <th class="tiny-col">'.$app->lng("monitor_diskusage_available_txt").'</th>
                <th class="tiny-col">'.$app->lng("monitor_diskusage_usage_txt").'</th>
                <th>'.$app->lng("monitor_diskusage_mounted_txt").'</th>
                </tr></thead>
                <tbody>';
106
107
108
109
110
111
112
			foreach($data as $line) {
				$html .= '<tr>';
				foreach ($line as $item) {
					$html .= '<td>' . $item . '</td>';
				}
				$html .= '</tr>';
			}
113
			$html .= '</tbody></table>';
114
115
116
117
118
119
120
121
122
123
124
125
			$html .= '</div></div>';
		} else {
			$html = '<p>'.$app->lng("no_data_diskusage_txt").'</p>';
		}


		return $html;
	}

	function showDatabaseSize () {
		global $app;
		/* fetch the Data from the DB */
126
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'database_size' AND server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
127
128
		if(isset($record['data'])) {
			$data = unserialize($record['data']);
129
			//* format the data
130
131
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
132
	                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
133
134
135
136
137
138
139
                	<table class="table"><thead class="dark"><tr>
                	<th>'.$app->lng("monitor_database_name_txt").'</th>
	                <th class="tiny-col">'.$app->lng("monitor_database_size_txt").'</th>
        	        <th>'.$app->lng("monitor_database_client_txt").'</th>
					<th>'.$app->lng("monitor_database_domain_txt").'</th>
                	</tr></thead>
                	<tbody>';
140
141
142
			foreach($data as $line) {
				$html .= '<tr>';
				if ($line['size'] > 0) $line['size'] = $app->functions->formatBytes($line['size']);
143
144

				//* get the client
145
146
				$tmp = $app->db->queryOneRecord("SELECT client.username FROM web_database, sys_group, client WHERE web_database.sys_groupid = sys_group.groupid AND sys_group.client_id = client.client_id AND web_database.database_name=?", $line['database_name']);
				$line['client'] = $tmp['username'];
147
148

				//* get the domain
Florian Schaal's avatar
Florian Schaal committed
149
				$tmp = $app->db->queryOneRecord("SELECT domain FROM web_domain WHERE domain_id=(SELECT parent_domain_id FROM web_database WHERE database_name=?)", $line['database_name']);
150
				$line['domain'] = $tmp['domain'];
151
152
153
154

				//* remove the sys_groupid from output
				unset($line['sys_groupid']);

155
156
157
				foreach ($line as $item) {
					$html .= '<td>' . $item . '</td>';
				}
158
				$html .= '</tr>';
159
			}
160
			$html .= '</tbody></table></div></div>';
161
162
163
164
165
166
167
168
169
170
		} else {
			$html = '<p>'.$app->lng("no_data_database_size_txt").'</p>';
		}
		return $html;
	}

	function showMemUsage () {
		global $app;

		/* fetch the Data from the DB */
171
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'mem_usage' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
172
173
174
175
176

		if(isset($record['data'])) {
			$data = unserialize($record['data']);

			/*
177
178
            Format the data
            */
179
180
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
181
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
182
183
                <table class="table">
                <tbody>';
184

185
186
187
			foreach($data as $key => $value) {
				if ($key != '') {
					$html .= '<tr>
188
189
190
                        <td>' . $key . ':</td>
                        <td>' . $value . '</td>
                        </tr>';
191
192
				}
			}
193
			$html .= '</tbody></table>';
194
			$html .= '</div></div>';
195

196
197
198
		} else {
			$html = '<p>'.$app->lng("no_data_memusage_txt").'</p>';
		}
199

200
201
		return $html;
	}
202

203
204
	function showCpuInfo () {
		global $app;
205

206
		/* fetch the Data from the DB */
207
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'cpu_info' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
208

209
210
		if(isset($record['data'])) {
			$data = unserialize($record['data']);
211

212
			/*
213
214
            Format the data
            */
215
216
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
217
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
218
219
                <table class="table">
                <tbody>';
220
221
222
			foreach($data as $key => $value) {
				if ($key != '') {
					$html .= '<tr>
223
224
225
                        <td>' . $key . ':</td>
                        <td>' . $value . '</td>
                        </tr>';
226
227
				}
			}
228
			$html .= '</tbody></table>';
229
230
231
232
			$html .= '</div></div>';
		} else {
			$html = '<p>'.$app->lng("no_data_cpuinfo_txt").'</p>';
		}
233

234
235
		return $html;
	}
236

237
238
	function showServices () {
		global $app;
239

240
		/* fetch the Data from the DB */
241
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'services' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
242

243
244
		if(isset($record['data'])) {
			$data = unserialize($record['data']);
245

246
			/*
247
248
            Format the data
            */
249
250
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
251
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">
252
253
                <table class="table">
                <tbody>';
254

255
256
257
258
259
260
261
			if($data['webserver'] != -1) {
				if($data['webserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
262
263
264
                <td>'.$app->lng("monitor_services_web_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
265
			}
266
267


268
269
270
271
272
273
274
			if($data['ftpserver'] != -1) {
				if($data['ftpserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
275
276
277
                <td>'.$app->lng("monitor_services_ftp_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
278
279
280
281
282
283
284
285
286
			}

			if($data['smtpserver'] != -1) {
				if($data['smtpserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
287
288
289
                <td>'.$app->lng("monitor_services_smtp_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
290
291
292
293
294
295
296
297
298
			}

			if($data['pop3server'] != -1) {
				if($data['pop3server'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
299
300
301
                <td>'.$app->lng("monitor_services_pop_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
302
303
304
305
306
307
308
309
310
			}

			if($data['imapserver'] != -1) {
				if($data['imapserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
311
312
313
                <td>'.$app->lng("monitor_services_imap_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
314
315
316
317
318
319
320
321
322
			}

			if($data['bindserver'] != -1) {
				if($data['bindserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
323
324
325
                <td>'.$app->lng("monitor_services_mydns_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
326
327
328
329
330
331
332
333
334
			}

			if($data['mysqlserver'] != -1) {
				if($data['mysqlserver'] == 1) {
					$status = '<span class="online">'.$app->lng("monitor_services_online_txt").'</span>';
				} else {
					$status = '<span class="offline">'.$app->lng("monitor_services_offline_txt").'</span>';
				}
				$html .= '<tr>
335
336
337
                <td>'.$app->lng("monitor_services_mysql_txt").'</td>
                <td>'.$status.'</td>
                </tr>';
338
			}
339
340


341
			$html .= '</tbody></table></div></div>';
342
343
344
		} else {
			$html = '<p>'.$app->lng("no_data_services_txt").'</p>';
		}
345
346


347
348
		return $html;
	}
349

350
351
	function showSystemUpdate() {
		global $app;
352

353
		/* fetch the Data from the DB */
354
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'system_update' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
355

356
357
358
		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
359
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';
360
			/*
361
362
363
             * First, we have to detect, if there is any monitoring-data.
             * If not (because the destribution is not supported) show this.
            */
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
			if ($record['state'] == 'no_state') {
				$html .= '<p>'.$app->lng("monitor_updates_nosupport_txt").'</p>';
			}
			else {
				$data = unserialize($record['data']);
				$html .= nl2br(html_entity_decode($data['output']));
			}
			$html .= '</div></div>';
		} else {
			$html = '<p>'.$app->lng("no_data_updates_txt").'</p>';
		}

		return $html;
	}


	function showOpenVzBeancounter() {
		global $app;

		/* fetch the Data from the DB */
384
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'openvz_beancounter' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
385
386
387
388

		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
389
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';
390
			/*
391
392
393
             * First, we have to detect, if there is any monitoring-data.
             * If not (because the server is not a VE) show this.
            */
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
			$data = unserialize($record['data']);
			if ((!isset($data)) || ($data == '')) {
				$html .= '<p>'.$app->lng("monitor_beancounter_nosupport_txt").'</p>';
			}
			else {
				$html .= '<pre>' . nl2br($data) . '</pre>';
			}
			$html .= '</div></div>';
		} else {
			$html = '<p>'.$app->lng("no_data_updates_txt").'</p>';
		}

		return $html;
	}

	function showRaidState() {
		global $app;

		/* fetch the Data from the DB */
413
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'raid_state' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
414
415
416
417

		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
418
419
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';

420
			/*
421
422
423
             * First, we have to detect, if there is any monitoring-data.
             * If not (because the RAID-Controler is not supported yet) show this.
            */
424
425
426
427
428
			if ($record['state'] == 'no_state') {
				$html .= '<p>'.$app->lng("monitor_nosupportedraid1_txt").'</p>';
			}
			else {
				$data = unserialize($record['data']);
429
430
431
				// improve view @Author <info@typoworx.de>
				//-- $html .= nl2br($data['output']);
				$html .= '<xmp>' . $data['output'] . '</xmp>';
432
433
434
435
436
437
438
439
440
441
442
443
444
445
			}
			$html .= '</div></div>';

		} else {
			$html = '<p>'.$app->lng("no_data_raid_txt").'</p>';
		}

		return $html;
	}

	function showRKHunter() {
		global $app;

		/* fetch the Data from the DB */
446
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'rkhunter' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
447
448
449
450

		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
451
452
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';

453
			/*
454
455
456
             * First, we have to detect, if there is any monitoring-data.
             * If not (because rkhunter is not installed) show this.
            */
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
			$data = unserialize($record['data']);
			if ($data['output'] == '') {
				$html .= '<p>'.$app->lng("monitor_norkhunter_txt").'</p>';
			}
			else {
				$html .= nl2br($data['output']);
			}
			$html .= '</div></div>';

		} else {
			$html = '<p>'.$app->lng("no_data_rkhunter_txt").'</p>';
		}

		return $html;
	}

	function showFail2ban() {
		global $app;

		/* fetch the Data from the DB */
477
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'log_fail2ban' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
478
479
480
481

		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
482
483
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';

484
			/*
485
486
487
             * First, we have to detect, if there is any monitoring-data.
             * If not (because fail2ban is not installed) show this.
            */
488
489
490
			$data = unserialize($record['data']);
			if ($data == '') {
				$html .= '<p>'.
Marius Cramer's avatar
Marius Cramer committed
491
					'fail2ban is not installed on this server.<br />' .
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
					'See more (for debian) <a href="http://www.howtoforge.com/fail2ban_debian_etch" target="htf">here...</a>'.
					'</p>';
			}
			else {
				$html .= nl2br($data);
			}
			$html .= '</div></div>';

		} else {
			$html = '<p>There is no data available at the moment.</p>';
		}

		return $html;
	}

	function showMongoDB() {
		global $app;

		/* fetch the Data from the DB */
511
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'log_mongodb' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
512
513
514
515

		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
516
517
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';

518
			/*
519
520
521
             * First, we have to detect, if there is any monitoring-data.
             * If not (because mongodb is not installed) show this.
            */
522
523
524
			$data = unserialize($record['data']);
			if ($data == '') {
				$html .= '<p>'.
Marius Cramer's avatar
Marius Cramer committed
525
					'MongoDB is not installed on this server.<br />' .
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
					'</p>';
			}
			else {
				$html .= nl2br($data);
			}
			$html .= '</div></div>';

		} else {
			$html = '<p>There is no data available at the moment.</p>';
		}

		return $html;
	}

	function showIPTables() {
		global $app;
542
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'iptables_rules' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
543
544
545
		if(isset($record['data'])) {
			$html =
				'<div class="systemmonitor-state state-'.$record['state'].'">
546
                <div class="systemmonitor-content icons32 ico-'.$record['state'].'">';
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
			$data = unserialize($record['data']);
			if ($data == '') {
				$html .= '<p>Problem, there are no rules listed for the server</p>';
			}
			else {
				$html .= nl2br($data['output']);
			}
			$html .= '</div></div>';
		} else {
			$html = '<p>There is no data available at the moment.</p>';
		}
		return $html;
	}


	function showMailq() {
		global $app;

		/* fetch the Data from the DB */
566
		$record = $app->db->queryOneRecord("SELECT data, state FROM monitor_data WHERE type = 'mailq' and server_id = ? ORDER BY created DESC", $_SESSION['monitor']['server_id']);
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581

		if(isset($record['data'])) {
			$data = unserialize($record['data']);
			$html = nl2br($data['output']);
		} else {
			$html = '<p>'.$app->lng("no_data_mailq_txt").'</p>';
		}

		return $html;
	}

	function getDataTime($type) {
		global $app;

		/* fetch the Data from the DB */
582
		$record = $app->db->queryOneRecord("SELECT created FROM monitor_data WHERE type = ? and server_id = ? ORDER BY created DESC", $type, $_SESSION['monitor']['server_id']);
583
584
585
586
587
588
589
590
591
592
593
594
595

		/* TODO: datetimeformat should be set somewhat other way */
		$dateTimeFormat = $app->lng("monitor_settings_datetimeformat_txt");

		if(isset($record['created'])) {
			//        $res = date('Y-m-d H:i', $record['created']);
			$res = date($dateTimeFormat, $record['created']);
		} else {
			$res = '????-??-?? ??:??';
		}
		return $res;
	}

596
}
597

598
?>