Subversion-Projekte lars-tiefland.openvz_admin

Revision

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