Subversion-Projekte lars-tiefland.openvz_admin

Revision

Revision 121 | Revision 123 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?php
9 lars 2 
	//$Id: load.php 122 2008-05-22 13:48:04Z lars $
109 lars 3 
	/**
4 
	 * 	@package	openvz_admin
5 
	 * 	@author		Lars Tiefland <ltiefland@gmail.com>
6 
	 **/
113 lars 7 
	require ("include/common.php");
8 
	$hns = HN::getHNs();
100 lars 9 
	unset($hns[-1]);
113 lars 10 
	#	$hns[3]="gate.dynalias.net";
11 
	foreach ($hns as $hn_id => $hn_name)
3 lars 12 
	{
122 lars 13 
		$configs = load_configs($hn_id, $hn_name);
14 
		foreach ($configs as $conf_id => $config)
114 lars 15 
		{
122 lars 16 
			$cfg = read_config($hn_id, $hn_name, $config);
17 
			update_db($cfg);
114 lars 18 
		}
19 
	}
122 lars 20 
 
21 
	function load_configs($hn_id, $hn_name)
114 lars 22 
	{
115 lars 23 
		unset($out);
113 lars 24 
		$cmd = "ssh root@$hn_name ls /etc/vz/conf/*.conf";
61 lars 25 
		exec($cmd, $out, $ret);
114 lars 26 
		return $out;
27 
	}
122 lars 28 
 
121 lars 29 
	function read_config($hn_id, $hn_name, $config)
114 lars 30 
	{
122 lars 31 
		$conf = basename($config);
32 
		$cmd = "scp root@$hn_name:/etc/vz/conf/$conf cfgs/$hn_id";
33 
		exec($cmd, $out, $ret);
34 
		$cont = file("cfgs/$hn_id/$conf");
35 
		$cont[] = "v_id=\"" . substr($conf, 0, strpos($conf, '.')) . "\"";
36 
		return $cont;
114 lars 37 
	}
122 lars 38 
 
39 
	function load_db($hn_id, $cfgs)
40 
	{
41 
		foreach ($cfgs as $config)
3 lars 42 
		{
122 lars 43 
			$sql = "SELECT * FROM distributions WHERE dist_name='" . $config["DISTRIBUTION"] .
44 
				"'";
45 
			$res = $db->query($sql);
46 
			if (!PEAR::isError($res))
3 lars 47 
			{
122 lars 48 
				if ($res->numRows())
3 lars 49 
				{
122 lars 50 
					$row = $res->fetchRow();
51 
					$dist_id = $row["dist_id"];
52 
				}
53 
				else
54 
				{
55 
					$sql = "INSERT INTO distributions (dist_name, dist_template) VALUES('" . $config["DISTRIBUTION"] .
56 
						"', '" . $config["OSTEMPLATE"] . "')";
57 
					$res = $db->query($sql);
58 
					$dist_id = $res->lastinsertID();
59 
				}
60 
				$sql = "SELECT * FROM vservers WHERE v_id=" . $config["v_id"] . " AND hn_id=$hn_id";
61 
				$res = $db->query($sql);
62 
				if (!PEAR::isError($res))
63 
				{
64 
					if (!$res->numRows())
3 lars 65 
					{
122 lars 66 
						$sql = "INSERT INTO vservers (v_id, v_name, v_dist, hn_id) VALUES (" . $config["v_id"] .
67 
							", '" . $config["HOSTNAME"] . "', $dist_id, $hn_id)";
68 
						$res = $db->query($sql);
69 
						if (PEAR::isError($res))
111 lars 70 
						{
122 lars 71 
							echo $res->getUserInfo();
111 lars 72 
						}
3 lars 73 
					}
74 
				}
122 lars 75 
				foreach ($conf as $field => $value)
100 lars 76 
				{
122 lars 77 
					$sql = "SELECT * FROM vserver_config WHERE vc_name='$field' AND v_id=" . $config["v_id"] .
78 
						" AND hn_id=$hn_id";
113 lars 79 
					$res = $db->query($sql);
80 
					if (!PEAR::isError($res))
100 lars 81 
					{
113 lars 82 
						if ($res->numRows())
112 lars 83 
						{
122 lars 84 
							$sql = "UPDATE vserver_config SET vc_value='$value' WHERE vc_name='$field' AND v_id=" .
85 
								$config["v_id"] . " AND hn_id=$hn_id";
112 lars 86 
						}
87 
						else
88 
						{
122 lars 89 
							$sql = "INSERT INTO vserver_config VALUES (" . $config["v_id"] . ", $hn_id, '$field', '$value')";
112 lars 90 
						}
113 lars 91 
						$res = $db->query($sql);
122 lars 92 
						if (PEAR::isError($res))
112 lars 93 
						{
122 lars 94 
							echo $res->getUserInfo();
112 lars 95 
						}
100 lars 96 
					}
97 
					else
98 
					{
99 
						echo $res->getUserInfo();
100 
					}
101 
				}
102 
			}
122 lars 103 
			else
104 
			{
105 
				echo $res->getUserInfo();
106 
			}
3 lars 107 
		}
122 lars 108 
	}
3 lars 109 
?>