monitor_core_module.inc.php

<?php
/*
Copyright (c) 2007-2010, 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 monitor_core_module {
	var $interval = 5; // do the monitoring every 5 minutes

	var $module_name = 'monitor_core_module';
	var $class_name = 'monitor_core_module';
	/* No actions at this time. maybe later... */
	var $actions_available = array();

	//* This function is called during ispconfig installation to determine
	//  if a symlink shall be created for this plugin.
	function onInstall() {
		global $conf;

		return true;

	}

	/*
        This function is called when the module is loaded
	*/
	function onLoad() {
		global $app;

		/*
         * Do the monitor every n minutes and write the result to the db
		*/
		$min = date('i');
		if (($min % $this->interval) == 0) {
			$this->doMonitor();
		}
	}

	/*
     This function is called when a change in one of the registered tables is detected.
     The function then raises the events for the plugins.
	*/
	function process($tablename, $action, $data) {
		// not needed
	} // end function

	//** Get distribution identifier
	//** IMPORTANT!
	//   This is the same code as in install/lib/install.lib.php
	//   So if you change it here, you also have to change it in there!
	//   Please do not forget to remove the swriteln(); - lines here at this file
	function get_distname() {

		$distname = '';
		$distver = '';
		$distid = '';
		$distbaseid = '';

		//** Debian or Ubuntu
		if(file_exists('/etc/debian_version')) {

			if(trim(file_get_contents('/etc/debian_version')) == '4.0') {
				$distname = 'Debian';
				$distver = '4.0';
				$distid = 'debian40';
				$distbaseid = 'debian';
			} elseif(strstr(trim(file_get_contents('/etc/debian_version')),'5.0')) {
				$distname = 'Debian';
				$distver = 'Lenny';
				$distid = 'debian40';
				$distbaseid = 'debian';
			} elseif(strstr(trim(file_get_contents('/etc/debian_version')),'6.0') || trim(file_get_contents('/etc/debian_version')) == 'squeeze/sid') {
				$distname = 'Debian';
				$distver = 'Squeeze/Sid';
				$distid = 'debian60';
				$distbaseid = 'debian';
			}  else {
				$distname = 'Debian';
				$distver = 'Unknown';
				$distid = 'debian40';
				$distbaseid = 'debian';
			}
		}

		//** OpenSuSE
		elseif(file_exists('/etc/SuSE-release')) {
			if(stristr(file_get_contents('/etc/SuSE-release'),'11.0')) {
				$distname = 'openSUSE';
				$distver = '11.0';
				$distid = 'opensuse110';
				$distbaseid = 'opensuse';
			} elseif(stristr(file_get_contents('/etc/SuSE-release'),'11.1')) {
				$distname = 'openSUSE';
				$distver = '11.1';
				$distid = 'opensuse110';
				$distbaseid = 'opensuse';
			} elseif(stristr(file_get_contents('/etc/SuSE-release'),'11.2')) {
				$distname = 'openSUSE';
				$distver = '11.1';
				$distid = 'opensuse110';
				$distbaseid = 'opensuse';
			}  else {
				$distname = 'openSUSE';
				$distver = 'Unknown';
				$distid = 'opensuse110';
				$distbaseid = 'opensuse';
			}
		}


		//** Redhat
		elseif(file_exists('/etc/redhat-release')) {

			$content = file_get_contents('/etc/redhat-release');

			if(stristr($content,'Fedora release 9 (Sulphur)')) {
				$distname = 'Fedora';
				$distver = '9';
				$distid = 'fedora9';
				$distbaseid = 'fedora';
			} elseif(stristr($content,'Fedora release 10 (Cambridge)')) {
				$distname = 'Fedora';
				$distver = '10';
				$distid = 'fedora9';
				$distbaseid = 'fedora';
			} elseif(stristr($content,'Fedora release 10')) {
				$distname = 'Fedora';
				$distver = '11';
				$distid = 'fedora9';
				$distbaseid = 'fedora';
			} elseif(stristr($content,'CentOS release 5.2 (Final)')) {
				$distname = 'CentOS';
				$distver = '5.2';
				$distid = 'centos52';
				$distbaseid = 'fedora';
			} elseif(stristr($content,'CentOS release 5.3 (Final)')) {
				$distname = 'CentOS';
				$distver = '5.3';
				$distid = 'centos53';
				$distbaseid = 'fedora';
			} else {
				$distname = 'Redhat';
				$distver = 'Unknown';
				$distid = 'fedora9';
				$distbaseid = 'fedora';
			}
		}

		//** Gentoo
		elseif(file_exists('/etc/gentoo-release')) {

			$content = file_get_contents('/etc/gentoo-release');

			preg_match_all('/([0-9]{1,2})/', $content, $version);
			$distname = 'Gentoo';
			$distver = $version[0][0].$version[0][1];
			$distid = 'gentoo';
			$distbaseid = 'gentoo';

		} else {
			die('Unrecognized GNU/Linux distribution');
		}

		return array('name' => $distname, 'version' => $distver, 'id' => $distid, 'baseid' => $distbaseid);
	}


	/*
    This method is called every n minutes, when the module ist loaded.
    The method then does a system-monitoring
	*/
	// TODO: what monitoring is done should be a config-var
	function doMonitor() {
		/* Calls the single Monitoring steps */
		$this->monitorHDQuota();
		$this->monitorServer();
		$this->monitorOSVer();
		$this->monitorIspCVer();
		$this->monitorDiskUsage();
		$this->monitorMemUsage();
		$this->monitorCpu();
		$this->monitorServices();
		$this->monitorOpenVzHost();
		$this->monitorOpenVzUserBeancounter();
		$this->monitorMailLog();
		$this->monitorMailWarnLog();
		$this->monitorMailErrLog();
		$this->monitorMessagesLog();
		$this->monitorISPCCronLog();
		$this->monitorFreshClamLog();
		$this->monitorClamAvLog();
		$this->monitorIspConfigLog();
		$this->monitorSystemUpdate();
		$this->monitorMailQueue();
		$this->monitorRaid();
		$this->monitorRkHunter();
		$this->monitorFail2ban();
		$this->monitorSysLog();
	}
	
	function monitorHDQuota() {
		global $app;
		global $conf;
		
		/* Initialize data array */
		$data = array();

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'harddisk_quota';

		/** The state of the harddisk_quota. */
		$state = 'ok';
		
		/** Fetch the data for all users*/
		$dfData = shell_exec('repquota -asu');

		// split into array
		$df = explode("\n", $dfData);

		/*
         * ignore the first 5 lines, process the rest
		*/
		for($i=5; $i <= sizeof($df); $i++) {
			if ($df[$i] != '') {
				/*
                 * Make a array of the data
				*/
				$s = preg_split ('/[\s]+/', $df[$i]);
				$username = $s[0];
				$data['user'][$username]['used'] = $s[2];
				$data['user'][$username]['soft'] = $s[3];
				$data['user'][$username]['hard'] = $s[4];
			}
		}
		
		/** Fetch the data for all users*/
		$dfData = shell_exec('repquota -asg');

		// split into array
		$df = explode("\n", $dfData);

		/*
         * ignore the first 5 lines, process the rest
		*/
		for($i=5; $i <= sizeof($df); $i++) {
			if ($df[$i] != '') {
				/*
                 * Make a array of the data
				*/
				$s = preg_split ('/[\s]+/', $df[$i]);
				$groupname = $s[0];
				$data['group'][$groupname]['used'] = $s[1];
				$data['group'][$groupname]['soft'] = $s[2];
				$data['group'][$groupname]['hard'] = $s[3];
			}
		}

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}
	
	function monitorServer() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'server_load';

		/*
        Fetch the data into a array
		*/
		$procUptime = shell_exec("cat /proc/uptime | cut -f1 -d' '");
		$data['up_days'] = floor($procUptime/86400);
		$data['up_hours'] = floor(($procUptime-$data['up_days']*86400)/3600);
		$data['up_minutes'] = floor(($procUptime-$data['up_days']*86400-$data['up_hours']*3600)/60);

		$data['uptime'] = shell_exec('uptime');

		$tmp = explode(',', $data['uptime'], 4);
		$tmpUser = explode(' ', trim($tmp[2]));
		$data['user_online'] = intval($tmpUser[0]);

		//* New Load Average code to fix "always zero" bug in non-english distros. NEEDS TESTING
		$loadTmp = shell_exec("cat /proc/loadavg | cut -f1-3 -d' '");
		$load = explode(' ', $loadTmp);
		$data['load_1'] = floatval(str_replace(',', '.', $load[0]));
		$data['load_5'] = floatval(str_replace(',', '.', $load[1]));
		$data['load_15'] = floatval(str_replace(',', '.', $load[2]));

		/** The state of the server-load. */
		$state = 'ok';
		if ($data['load_1'] > 20 ) $state = 'info';
		if ($data['load_1'] > 50 ) $state = 'warning';
		if ($data['load_1'] > 100 ) $state = 'critical';
		if ($data['load_1'] > 150 ) $state = 'error';

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}

	function monitorOsVer() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'os_info';

		/*
        Fetch the data into a array
		*/
		$dist = $this->get_distname();

		$data['name'] = $dist['name'];
		$data['version'] = $dist['version'];

		/* the OS has no state. It is, what it is */
		$state = 'no_state';

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorIspcVer() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'ispc_info';

		/*
        Fetch the data into a array
		*/
		$data['name'] = ISPC_APP_TITLE;
		$data['version'] = ISPC_APP_VERSION;

		/* the ISPC-Version has no state. It is, what it is */
		$state = 'no_state';

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}

	function monitorDiskUsage() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'disk_usage';

		/** The state of the disk-usage */
		$state = 'ok';

		/** Fetch the data of ALL devices into a array (needed for monitoring!)*/
		$dfData = shell_exec('df -hT');

		// split into array
		$df = explode("\n", $dfData);

		/*
         * ignore the first line, process the rest
		*/
		for($i=1; $i <= sizeof($df); $i++) {
			if ($df[$i] != '') {
				/*
                 * Make an array of the data
				*/
				$s = preg_split ('/[\s]+/', $df[$i]);
				$data[$i]['fs'] = $s[0];
				$data[$i]['type'] = $s[1];
				$data[$i]['size'] = $s[2];
				$data[$i]['used'] = $s[3];
				$data[$i]['available'] = $s[4];
				$data[$i]['percent'] = $s[5];
				$data[$i]['mounted'] = $s[6];
				/*
                 * calculate the state
				*/
				$usePercent = floatval($data[$i]['percent']);

				//* We don't want to check some filesystem which have no sensible filling levels
				switch($data[$i]['type']) {
					case 'iso9660':
					case 'cramfs':
					case 'udf':
					case 'tmpfs':
					case 'devtmpfs':
					case 'udev':
						break;
					default: 
						if ($usePercent > 75) $state = $this->_setState($state, 'info');
						if ($usePercent > 80) $state = $this->_setState($state, 'warning');
						if ($usePercent > 90) $state = $this->_setState($state, 'critical');
						if ($usePercent > 95) $state = $this->_setState($state, 'error');
						break;
				}
			}
		}


		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorMemUsage() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'mem_usage';

		/*
        Fetch the data into a array
		*/
		$miData = shell_exec('cat /proc/meminfo');

		$memInfo = explode("\n", $miData);

		foreach($memInfo as $line) {
			$part = preg_split('/:/', $line);
			$key = trim($part[0]);
			$tmp = explode(' ', trim($part[1]));
			$value = 0;
			if ($tmp[1] == 'kB') $value = $tmp[0] * 1024;
			$data[$key] = $value;
		}

		/*
         * actually this info has no state.
         * maybe someone knows better...???...
		*/
		$state = 'no_state';

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorCpu() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'cpu_info';

		/*
        Fetch the data into a array
		*/
		if(file_exists('/proc/cpuinfo')) {
			$cpuData = shell_exec('cat /proc/cpuinfo');
			$cpuInfo = explode("\n", $cpuData);
			$processor = 0;

			foreach($cpuInfo as $line) {

				$part = preg_split('/:/', $line);
				$key = trim($part[0]);
				$value = trim($part[1]);
				if($key == 'processor') $processor = intval($value);
				if($key != '') $data[$key.' '.$processor] = $value;
			}

			/* the cpu has no state. It is, what it is */
			$state = 'no_state';
		} else {
			/*
             * It is not Linux, so there is no data and no state
             *
             * no_state, NOT unknown, because "unknown" is shown as state
             * inside the GUI. no_state is hidden.
             *
             * We have to write NO DATA inside the DB, because the GUI
             * could not know, if there is any dat, or not...
			*/
			$state = 'no_state';
			$data['output']= '';
		}


		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorServices() {
		global $app;
		global $conf;

		/** the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** get the "active" Services of the server from the DB */
		$services = $app->dbmaster->queryOneRecord('SELECT * FROM server WHERE server_id = ' . $server_id);

		/* The type of the Monitor-data */
		$type = 'services';

		/** the State of the monitoring */
		/* ok, if ALL active services are running,
         * error, if not
         * There is no other state!
		*/
		$state = 'ok';

		/* Monitor Webserver */
		$data['webserver'] = -1; // unknown - not needed
		if ($services['web_server'] == 1) {
			if($this->_checkTcp('localhost', 80)) {
				$data['webserver'] = 1;
			} else {
				$data['webserver'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor FTP-Server */
		$data['ftpserver'] = -1; // unknown - not needed
		if ($services['file_server'] == 1) {
			if($this->_checkFtp('localhost', 21)) {
				$data['ftpserver'] = 1;
			} else {
				$data['ftpserver'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor SMTP-Server */
		$data['smtpserver'] = -1; // unknown - not needed
		if ($services['mail_server'] == 1) {
			if($this->_checkTcp('localhost', 25)) {
				$data['smtpserver'] = 1;
			} else {
				$data['smtpserver'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor POP3-Server */
		$data['pop3server'] = -1; // unknown - not needed
		if ($services['mail_server'] == 1) {
			if($this->_checkTcp('localhost', 110)) {
				$data['pop3server'] = 1;
			} else {
				$data['pop3server'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor IMAP-Server */
		$data['imapserver'] = -1; // unknown - not needed
		if ($services['mail_server'] == 1) {
			if($this->_checkTcp('localhost', 143)) {
				$data['imapserver'] = 1;
			} else {
				$data['imapserver'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor BIND-Server */
		$data['bindserver'] = -1; // unknown - not needed
		if ($services['dns_server'] == 1) {
			if($this->_checkTcp('localhost', 53)) {
				$data['bindserver'] = 1;
			} else {
				$data['bindserver'] = 0;
				$state = 'error'; // because service is down
			}
		}

		/* Monitor MySQL Server */
		$data['mysqlserver'] = -1; // unknown - not needed
		if ($services['db_server'] == 1) {
			if($this->_checkTcp('localhost', 3306)) {
				$data['mysqlserver'] = 1;
			} else {
				$data['mysqlserver'] = 0;
				$state = 'error'; // because service is down
			}
		}


		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorOpenVzHost() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'openvz_veinfo';

		/*
        Fetch the data into a array
		*/
		$app->load(openvz_tools);
		$openVzTools = new openvz_tools();
		$data = $openVzTools->getOpenVzVeInfo();

		/* the VE-Info has no state. It is, what it is */
		$state = 'no_state';

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}

	function monitorOpenVzUserBeancounter() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'openvz_beancounter';

		/*
        Fetch the data into a array
		*/
		$app->load(openvz_tools);
		$openVzTools = new openvz_tools();
		$data = $openVzTools->getOpenVzVeBeanCounter();

		/* calculate the state of the beancounter */
		if ($data == '') {
			$state = 'no_state';
		}
		else {
			$state = 'ok';

			/* transfer this output-string into a array */
			$test = explode("\n", $data);

			/* the first list of the output is not needed */
			array_shift($test);

			/* now process all items of the rest */
			foreach ($test as $item) {
				/*
			     * eliminate all doubled spaces and spaces at the beginning and end
				*/
				while (strpos($item, '  ') !== false) {
					$item = str_replace('  ', ' ', $item);
				}
				$item = trim($item);

				/*
			     * The failcounter is the LAST
				*/
				if ($item != '') {
					$tmp = explode(' ', $item);
					$failCounter = $tmp[sizeof($tmp)-1];
					if ($failCounter > 0 ) $state = 'info';
					if ($failCounter > 50 ) $state = 'warning';
					if ($failCounter > 200 ) $state = 'critical';
					if ($failCounter > 10000 ) $state = 'error';
				}
			}
		}

		/*
        Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}


	function monitorSystemUpdate() {
		/*
         *  This monitoring is expensive, so do it only once an hour
		*/
		$min = date('i');
		if ($min != 0) return;

		/*
         * OK - here we go...
		*/
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'system_update';

		/* This monitoring is only available on Debian or Ubuntu */
		if(file_exists('/etc/debian_version')) {

			/*
             * first update the "apt database"
			*/
			shell_exec('apt-get update');

			/*
             * Then test the upgrade.
             * if there is any output, then there is a needed update
			*/
			$aptData = shell_exec('apt-get -s -qq dist-upgrade');
			if ($aptData == '') {
				/* There is nothing to update! */
				$state = 'ok';
			}
			else {
				/*
				 * There is something to update! this is in most cases not critical, so we can
				 * do a system-update once a month or so...
				*/
				$state = 'info';
			}

			/*
             * Fetch the output
			*/
			$data['output'] = shell_exec('apt-get -s -q dist-upgrade');
		}
		elseif (file_exists('/etc/gentoo-release')) {

			/*
        	 * first update the portage tree
			*/

			// In keeping with gentoo's rsync policy, don't update to frequently (every four hours - taken from http://www.gentoo.org/doc/en/source_mirrors.xml)
			$do_update = true;
			if (file_exists('/usr/portage/metadata/timestamp.chk')) {
				$datetime = file_get_contents('/usr/portage/metadata/timestamp.chk');
				$datetime = trim($datetime);

				$dstamp = strtotime($datetime);
				if ($dstamp) {
					$checkat = $dstamp + 14400; // + 4hours
					if (mktime() < $checkat) {
						$do_update = false;
					}
				}
			}

			if ($do_update) {
				shell_exec('emerge --sync --quiet');
			}

			/*
             * Then test the upgrade.
             * if there is any output, then there is a needed update
			*/
			$emergeData = shell_exec('emerge -puDNt --color n --nospinner --quiet world');
			if ($emergeData == '') {
				/* There is nothing to update! */
				$state = 'ok';
			}
			else {
				/* There is something to update! */
				$state = 'warning';
			}

			/*
             * Fetch the output
			*/
			$data['output'] = shell_exec('emerge -pvuDNt --color n --nospinner world');
		}
		else {
			/*
             * It is not Debian/Ubuntu, so there is no data and no state
             *
             * no_state, NOT unknown, because "unknown" is shown as state
             * inside the GUI. no_state is hidden.
             *
             * We have to write NO DATA inside the DB, because the GUI
             * could not know, if there is any dat, or not...
			*/
			$state = 'no_state';
			$data['output']= '';
		}

		/*
         * Insert the data into the database
		*/
		$sql = 'INSERT INTO monitor_data (server_id, type, created, data, state) ' .
				'VALUES ('.
				$server_id . ', ' .
				"'" . $app->dbmaster->quote($type) . "', " .
				time() . ', ' .
				"'" . $app->dbmaster->quote(serialize($data)) . "', " .
				"'" . $state . "'" .
				')';
		$app->dbmaster->query($sql);

		/* The new data is written, now we can delete the old one */
		$this->_delOldRecords($type, 4);
	}

	function monitorMailQueue() {
		global $app;
		global $conf;

		/* the id of the server as int */
		$server_id = intval($conf['server_id']);

		/** The type of the data */
		$type = 'mailq';

		/* Get the data from the mailq */
		$data['output'] = shell_exec('mailq');

		/*
         *  The last line has more informations
		*/
		$tmp = explode("\n", $data['output']);
		$more = $tmp[sizeof($tmp) - 1];
		$this->_getIntArray($more);
		$data['bytes'] = $res[0];
		$data['requests'] = $res[1];

		/** The state of the mailq. */
		$state = 'ok';
		if ($data['requests'] > 2000 ) $state = 'info';
		if ($data['requests'] > 5000 ) $state = 'warning';
		if ($data['requests'] > 8000 ) $state = 'critical';
		if ($data['requests'] > 10000 ) $state = 'error';

		/*
         * Insert the data into the database