Subversion-Projekte lars-tiefland.openvz_admin

Revision

Revision 136 | Revision 151 | 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 138 2008-07-15 11:26:24Z lars $
109 lars 3
	/**
4
	 * 	@package	openvz_admin
5
	 * 	@author		Lars Tiefland <ltiefland@gmail.com>
6
	 **/
113 lars 7
	require ("include/common.php");
138 lars 8
	$hns = HN::getHNs();
9
	unset($hns[-1]);
113 lars 10
	foreach ($hns as $hn_id => $hn_name)
3 lars 11
	{
122 lars 12
		$configs = load_configs($hn_id, $hn_name);
13
		foreach ($configs as $conf_id => $config)
114 lars 14
		{
122 lars 15
			$cfg = read_config($hn_id, $hn_name, $config);
126 lars 16
			update_db($hn_id, $cfg);
114 lars 17
		}
18
	}
122 lars 19
 
20
	function load_configs($hn_id, $hn_name)
114 lars 21
	{
115 lars 22
		unset($out);
113 lars 23
		$cmd = "ssh root@$hn_name ls /etc/vz/conf/*.conf";
61 lars 24
		exec($cmd, $out, $ret);
114 lars 25
		return $out;
26
	}
122 lars 27
 
121 lars 28
	function read_config($hn_id, $hn_name, $config)
114 lars 29
	{
129 lars 30
		$config = basename($config);
31
		$cmd = "scp root@$hn_name:/etc/vz/conf/$config cfgs/$hn_id";
122 lars 32
		exec($cmd, $out, $ret);
130 lars 33
		$conf = file("cfgs/$hn_id/$config");
129 lars 34
		$conf[] = "v_id=\"" . substr($config, 0, strpos($config, '.')) . "\"";
127 lars 35
		foreach ($conf as $value)
36
		{
37
			if ($value)
38
			{
39
				$value = rtrim($value);
40
				if ($value[0] == " " || $value[0] == "#")
41
				{
42
					continue;
43
				}
44
				$cfg_v = explode("=", $value);
45
				$cfg_val[$cfg_v[0]] = trim($cfg_v[1], '"');
46
			}
47
			else
48
			{
49
				continue;
50
			}
51
		}
131 lars 52
		$cfgs[] = $cfg_val;
127 lars 53
		return $cfgs;
114 lars 54
	}
122 lars 55
 
123 lars 56
	function update_db($hn_id, $cfgs)
122 lars 57
	{
124 lars 58
		global $db;
125 lars 59
 
122 lars 60
		foreach ($cfgs as $config)
3 lars 61
		{
125 lars 62
			if (isset($config["DISTRIBUTION"]))
3 lars 63
			{
125 lars 64
				$sql = "SELECT * FROM distributions WHERE dist_name='" . $config["DISTRIBUTION"] .
65
					"'";
66
				$res = $db->query($sql);
67
				if (!PEAR::isError($res))
3 lars 68
				{
125 lars 69
					if ($res->numRows())
70
					{
71
						$row = $res->fetchRow();
72
						$dist_id = $row["dist_id"];
136 lars 73
						$sql_v="SELECT v_dist, dist_name FROM distributions, vservers WHERE dist_id=v_dist AND v_id=".$config["v_id"];
74
						$res_v=$db->query($sql_v);
75
						if(PEAR::isError($res_v))
76
						{
77
							die($res_v->getUserInfo());
78
						}
79
						$row_v=$res_v->fetchRow();
80
						$dist_name = $row_v["dist_name"];
81
						if ($dist_name != $config["DISTRIBUTION"])
82
						{
83
							$sql="UPDATE vservers SET v_dist=$dist_id WHERE v_id=".$config["v_id"];
84
							$res=$db->query($sql);
85
							if(PEAR::isError($res))
86
							{
87
								die($res->getUserInfo());
88
							}
89
						}
125 lars 90
					}
91
					else
92
					{
93
						$sql = "INSERT INTO distributions (dist_name, dist_template) VALUES('" . $config["DISTRIBUTION"] .
94
							"', '" . $config["OSTEMPLATE"] . "')";
95
						$res = $db->query($sql);
126 lars 96
						$dist_id = $db->lastinsertID();
125 lars 97
					}
122 lars 98
				}
99
				else
100
				{
125 lars 101
					die($res->getUserInfo());
122 lars 102
				}
125 lars 103
			}
104
			$sql = "SELECT * FROM vservers WHERE v_id=" . $config["v_id"] . " AND hn_id=$hn_id";
105
			$res = $db->query($sql);
106
			if (!PEAR::isError($res))
107
			{
108
				if (!$res->numRows())
122 lars 109
				{
125 lars 110
					$sql = "INSERT INTO vservers (v_id, v_name, v_dist, hn_id) VALUES (" . $config["v_id"] .
111
						", '" . $config["HOSTNAME"] . "', $dist_id, $hn_id)";
112
					$res = $db->query($sql);
113
					if (PEAR::isError($res))
3 lars 114
					{
125 lars 115
						echo $res->getUserInfo();
3 lars 116
					}
117
				}
125 lars 118
			}
119
			else
120
			{
121
				die($res->getUserInfo());
122
			}
123
			foreach ($config as $field => $value)
124
			{
125
				$sql = "SELECT * FROM vserver_config WHERE vc_name='$field' AND v_id=" . $config["v_id"] .
126
					" AND hn_id=$hn_id";
127
				$res = $db->query($sql);
128
				if (!PEAR::isError($res))
100 lars 129
				{
125 lars 130
					if ($res->numRows())
100 lars 131
					{
125 lars 132
						$sql = "UPDATE vserver_config SET vc_value='$value' WHERE vc_name='$field' AND v_id=" .
133
							$config["v_id"] . " AND hn_id=$hn_id";
100 lars 134
					}
135
					else
136
					{
125 lars 137
						$sql = "INSERT INTO vserver_config VALUES (" . $config["v_id"] . ", $hn_id, '$field', '$value')";
138
					}
139
					$res = $db->query($sql);
140
					if (PEAR::isError($res))
141
					{
100 lars 142
						echo $res->getUserInfo();
143
					}
144
				}
125 lars 145
				else
146
				{
147
					echo $res->getUserInfo();
148
				}
100 lars 149
			}
3 lars 150
		}
122 lars 151
	}
136 lars 152
?>