--- alx-src/trunk/alx-web/mageupgrade.php	2008/06/04 21:54:04	424
+++ alx-src/trunk/alx-web/mageupgrade.php	2008/06/04 22:35:14	425
@@ -1,111 +1,111 @@
-<?
-	include('include/config.inc.php');
-	include('include/dbconn.php');
-	include('include/basesql.php');
-
-	echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
-?>
-	<style type="text/css">
-		div.left { margin-left:20%; }
-	</style>
-<?
-	function editvar($var, $value, $file)
-	{
-		global $ip;
-		global $sshcmd;
-
-		// sed cmd: ssh -l root 10.11.12.13 'sed -i -e "s|^(VAR=).*|\"VALUE\"| FILE'
-		$str = $sshcmd.' -l root '.$ip.' \'sed -i -e "s|^\\('.$var.'=\\).*|\\1\\"'.$value.'\\"|" '.$file.'\'';
-		system($str);
-	}
-
-	$pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$client.'');
-	while ($row = mysql_fetch_row ($pubkey))
-	{
-		# schreiben der .ssh/known_hosts file mit dem public rsa key des client,
-		# um die "yes" abfrage zu vermeiden
-		$hostfile = fopen ($home."/.ssh/known_hosts","w");
-		fwrite($hostfile,$ip." ".$row[0],strlen($row[0])+strlen($ip)+1);
-		fclose($hostfile);
-
-		# reboot des clients
-		passthru($pingcmd.' '.$ip.' &> /dev/null && exit 0 || exit 1',$retval);
-		if($retval==0)
-		{
-			if($op=="calc")
-			{
-				echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching list of packages to upgrade on client #'.$client.' ('.$ip.')...<br>');
-				exec($sshcmd.' -l root '.$ip.' /sbin/mageupgrade --calc-bash',$out,$err);
-				echo '<pre>';
-				echo '<table border="0">';
-				if (array_key_exists("0", $out))
-				{
-					foreach( $out as $i)
-					{
-						$item=explode(",",$i);
-						$pcat=$item[0];
-						$pname=$item[1];
-						$opver=$item[2];
-						$npver=$item[3];
-
-						echo '<tr><td>';
-						echo '<font color=green>'.$pcat.'/'.$pname.'</font>';
-						echo '<td>';
-						echo '<font color=blue> [ '.$opver.' -> '.$npver.' ] </font>';
-						echo '</td>';
-						echo '</td></tr>';
-					}
-				}
-				else echo 'No updates for client '.$client.' available.';			
-				echo '</table>';
-				echo '</pre>';
-			}
-			elseif($op=="update")
-			{
-				echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching new mage database for client #'.$client.' ('.$ip.')...<br>');
-				echo '<br>';
-				echo '<pre><div align=left class=left>';
-				// hotfix copy a fixed mage.rc
-				system('scp /var/www/localhost/htdocs/alx/he/mage.rc root@'.$ip.':/etc/mage.rc');
-				editvar("VERBOSE","off","/etc/mage.rc");
-				
-				// update rsync server location	
-				$rsync = sqlfirst('select client_locations.rsync from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'rsync');
-				echo $rsync;
-				editvar("RSYNC",$rsync,"/etc/mage.rc");
-
-				system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage update"');
-				echo '</div></pre>';
-				echo '<script language="JavaScript">alert(\'Database-update successfully completed on client #'.$client.' .\')</script>';
-			}
-			elseif($op=="upgrade")
-			{
-				echo '<img src="pics/online.gif" align=top> '.strtoupper('Running update-alx on client #'.$client.' ('.$ip.')...<br>');
-				echo '<br>';
-				echo '<pre><div align=left class=left>';
-				echo 'forcing verbose=off <br>';
-				editvar("VERBOSE","off","/etc/mage.rc");
-
-				// update repository server locations
-				$repo = sqlfirst('SELECT repository FROM client_locations WHERE location="HAT"', 'repository');
-				editvar("MIRRORS",$repo,"/etc/mage.rc");
-
-				# check if /usr/sbin/update-alx exists, if not update mage-alx and alxconfig-alx first
-				exec($sshcmd.' -l root '.$ip.' "[ -x /usr/sbin/update-alx ] && exit 0 || exit 1"',$outarr,$err);
-				if($err!=0)
-				{
-					echo '"/usr/sbin/update-alx" missing on client "'.$client.'". Updating mage-alx and alxconfig-ng-alx first ...<br>';
-					system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage install mage-alx"');
-					system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage install alxconfig-ng-alx"');
-				}
-				system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /usr/sbin/update-alx"');
-				echo '</div></pre>';
-				echo '<script language="JavaScript">alert(\'Upgrade successfully installed on client #'.$client.' .\')</script>';
-			}
-			else echo 'unkown operation';
-		}
-
-		else echo '<img src="pics/offline.gif" align=top> '.strtoupper('Client not online, try again later...<br>');
-	}
-	echo '</td></tr></table>';
-?>
+<?
+	include('include/config.inc.php');
+	include('include/dbconn.php');
+	include('include/basesql.php');
+
+	echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
+?>
+	<style type="text/css">
+		div.left { margin-left:20%; }
+	</style>
+<?
+	function editvar($var, $value, $file)
+	{
+		global $ip;
+		global $sshcmd;
+
+		// sed cmd: ssh -l root 10.11.12.13 'sed -i -e "s|^(VAR=).*|\"VALUE\"| FILE'
+		$str = $sshcmd.' -l root '.$ip.' \'sed -i -e "s|^\\('.$var.'=\\).*|\\1\\"'.$value.'\\"|" '.$file.'\'';
+		system($str);
+	}
+
+	$pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$client.'');
+	while ($row = mysql_fetch_row ($pubkey))
+	{
+		# schreiben der .ssh/known_hosts file mit dem public rsa key des client,
+		# um die "yes" abfrage zu vermeiden
+		$hostfile = fopen ($home."/.ssh/known_hosts","w");
+		fwrite($hostfile,$ip." ".$row[0],strlen($row[0])+strlen($ip)+1);
+		fclose($hostfile);
+
+		# reboot des clients
+		passthru($pingcmd.' '.$ip.' &> /dev/null && exit 0 || exit 1',$retval);
+		if($retval==0)
+		{
+			if($op=="calc")
+			{
+				echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching list of packages to upgrade on client #'.$client.' ('.$ip.')...<br>');
+				exec($sshcmd.' -l root '.$ip.' /sbin/mageupgrade --calc-bash',$out,$err);
+				echo '<pre>';
+				echo '<table border="0">';
+				if (array_key_exists("0", $out))
+				{
+					foreach( $out as $i)
+					{
+						$item=explode(",",$i);
+						$pcat=$item[0];
+						$pname=$item[1];
+						$opver=$item[2];
+						$npver=$item[3];
+
+						echo '<tr><td>';
+						echo '<font color=green>'.$pcat.'/'.$pname.'</font>';
+						echo '<td>';
+						echo '<font color=blue> [ '.$opver.' -> '.$npver.' ] </font>';
+						echo '</td>';
+						echo '</td></tr>';
+					}
+				}
+				else echo 'No updates for client '.$client.' available.';			
+				echo '</table>';
+				echo '</pre>';
+			}
+			elseif($op=="update")
+			{
+				echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching new mage database for client #'.$client.' ('.$ip.')...<br>');
+				echo '<br>';
+				echo '<pre><div align=left class=left>';
+				// hotfix copy a fixed mage.rc
+				system('scp /var/www/localhost/htdocs/alx/he/mage.rc root@'.$ip.':/etc/mage.rc');
+				editvar("VERBOSE","off","/etc/mage.rc");
+				
+				// update rsync server location	
+				$rsync = sqlfirst('select client_locations.rsync from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'rsync');
+				echo $rsync;
+				editvar("RSYNC",$rsync,"/etc/mage.rc");
+
+				system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage update"');
+				echo '</div></pre>';
+				echo '<script language="JavaScript">alert(\'Database-update successfully completed on client #'.$client.' .\')</script>';
+			}
+			elseif($op=="upgrade")
+			{
+				echo '<img src="pics/online.gif" align=top> '.strtoupper('Running update-alx on client #'.$client.' ('.$ip.')...<br>');
+				echo '<br>';
+				echo '<pre><div align=left class=left>';
+				echo 'forcing verbose=off <br>';
+				editvar("VERBOSE","off","/etc/mage.rc");
+
+				// update repository server locations
+				$repo = sqlfirst('SELECT repository FROM client_locations WHERE location="HAT"', 'repository');
+				editvar("MIRRORS",$repo,"/etc/mage.rc");
+
+				# check if /usr/sbin/update-alx exists, if not update mage-alx and alxconfig-alx first
+				exec($sshcmd.' -l root '.$ip.' "[ -x /usr/sbin/update-alx ] && exit 0 || exit 1"',$outarr,$err);
+				if($err!=0)
+				{
+					echo '"/usr/sbin/update-alx" missing on client "'.$client.'". Updating mage-alx and alxconfig-ng-alx first ...<br>';
+					system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage install mage-alx"');
+					system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /sbin/mage install alxconfig-ng-alx"');
+				}
+				system($sshcmd.' -l root '.$ip.' "NOCOLORS=true /usr/sbin/update-alx"');
+				echo '</div></pre>';
+				echo '<script language="JavaScript">alert(\'Upgrade successfully installed on client #'.$client.' .\')</script>';
+			}
+			else echo 'unkown operation';
+		}
+
+		else echo '<img src="pics/offline.gif" align=top> '.strtoupper('Client not online, try again later...<br>');
+	}
+	echo '</td></tr></table>';
+?>