Subversion-Projekte lars-tiefland.openvz_admin

Revision

Revision 9 | Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?php
2 
	require("include/common.php");
3 
	$cmd="ssh root@mainframe ls /etc/vz/conf/???.conf";
4 
	unset($out);
5 
	exec($cmd, $out, $ret);
6 
	$files=$out;
7 
	foreach($files as $conf)
8 
	{
9 
		$conf=basename($conf);
10 
		unset($out);
11 
		//$cmd="scp root@mainframe:/etc/vz/conf/???.conf cfgs";
12 
		//exec($cmd, $out, $ret);
13 
		$cont_f=file("cfgs/$conf");
14 
		$cont_f[]="v_id=\"".substr($conf,0,3)."\"";
15 
		$cont[]=$cont_f;
16 
	}
17 
	foreach($cont as $conf)
18 
	{
19 
		foreach($conf as $value)
20 
		{
21 
			$value=rtrim($value);
22 
			if($value[0]==" " || $value[0]=="#" || $value=="")
23 
			{
24 
				continue;
25 
			}
26 
			$cfg_v=explode("=",$value);
27 
			$cfg_val[$cfg_v[0]]=trim($cfg_v[1],'"');
28 
		}
29 
		$cfgs[]=$cfg_val;
30 
	}
31 
	$i=0;
32 
	echo "Lade Konfigurationen in die DB<br>";
33 
	foreach($cfgs as $conf)
34 
	{
35 
		$sql="SELECT * FROM distributions WHERE dist_name='".$conf["DISTRIBUTION"]."'";
36 
		$res=$db->query($sql);
37 
		if(!PEAR::isError($res))
38 
		{
39 
			if($res->numRows())
40 
			{
41 
				$row=$res->fetchRow();
42 
				$dist_id=$row["dist_id"];
43 
			}
44 
			else
45 
			{
46 
				$sql="INSERT INTO distributions (dist_name, dist_template) VALUES('".$conf["DISTRIBUTION"]."', '".$conf["OSTEMPLATE"]."')";
47 
				$res=$db->query($sql);
48 
				$dist_id=$res->lastinsertID();
49 
			}
50 
			$sql="SELECT * FROM vservers WHERE v_id=".$conf["v_id"];
51 
			$res=$db->query($sql);
52 
			if(!PEAR::isError($res))
53 
			{
54 
				if(!$res->numRows())
55 
				{
56 
					echo "Neueintrag für Server ".$conf["v_id"]."<br>";
57 
					$sql="INSERT INTO vservers (v_id, v_name, v_dist) VALUES (".$conf["v_id"].", '".$conf["HOSTNAME"]."', $dist_id)";
58 
					$res=$db->query($sql);
59 
					if(PEAR::isError($res))
60 
					{
61 
						echo $res->getUserInfo();
62 
					}
63 
				}
64 
			}
65 
		}
66 
		else
67 
		{
68 
			echo $res->getUserInfo();
69 
		}
70 
		foreach($conf as $field => $value)
71 
		{
72 
			$sql="SELECT * FROM vserver_config WHERE vc_name='$field' AND v_id=".$conf["v_id"];
73 
			$res=$db->query($sql);
74 
			if(!PEAR::isError($res))
75 
			{
76 
				if($res->numRows())
77 
				{
78 
					$sql="UPDATE vserver_config SET vc_value='$value' WHERE vc_name='$field' AND v_id=".$conf["v_id"];
79 
				}
80 
				else
81 
				{
82 
					$sql="INSERT INTO vserver_config VALUES (".$conf["v_id"].", '$field', '$value')";
83 
				}
84 
				$res=$db->query($sql);
85 
				if(PEAR::isError($res))
86 
				{
87 
					echo $res->getUserInfo();
88 
				}
89 
			}
90 
			else
91 
			{
92 
				echo $res->getUserInfo();
93 
			}
94 
 
95 
		}
96 
		$i++;
97 
	}
98 
?>