Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/mageupgrade.php

    Diff of /alx-src/branches/alx-web-070/mageupgrade.php

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    alx-src/branches/alx-web-050/mageupgrade.php revision 1608 by niro, Thu Dec 2 22:13:04 2010 UTC alx-src/branches/alx-web-060/mageupgrade.php revision 2596 by niro, Tue Jul 5 16:24:21 2011 UTC
    # Line 1  Line 1 
    1  <?  <?
    2   include('include/dbconn.php');  
    3   include('include/basesql.php');  include('include/dbconn.php');
    4    include('include/basesql.php');
    5   echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';  include('include/common-functions.php');
    6  ?>  
    7   <style type="text/css">  echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>';
    8   div.left { margin-left:20%; }  
    9   </style>  ?>
    10  <?  
    11   function editvar($var, $value, $file)  <style type="text/css">
    12   {   div.left { margin-left:20%; }
    13   global $ip;  </style>
    14   global $sshcmd;  
    15    <?
    16   // sed cmd: ssh -l root 10.11.12.13 'sed -i -e "s|^\(VAR=\).*|\1\"VALUE\"| FILE'  
    17   $str = $sshcmd.' '.$ip.' \'sed -i -e "s|^\\('.$var.'=\\).*|\\1\\"'.$value.'\\"|" '.$file.'\'';  function update_client_settings()
    18   //echo $str.'<br>';  {
    19   system($str);   global $client;
    20   }  
    21     // set verbose off
    22   $pubkey = mysql_query('select public_key from ssh_auth_clients where serial='.$client.'');   ssh_editvar('VERBOSE', 'off', '/etc/mage.rc');
    23   while ($row = mysql_fetch_row ($pubkey))  
    24   {   // update rsync server location
    25   # schreiben der .ssh/known_hosts file mit dem public rsa key des client,   $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');
    26   # um die "yes" abfrage zu vermeiden   ssh_editvar('MAGE_RSYNC', $rsync, '/etc/alxconfig-ng/config.rc');
    27   $hostfile = fopen ($home."/.ssh/known_hosts","w");   ssh_editvar('RSYNC', $rsync, '/etc/mage.rc');
    28   fwrite($hostfile,$ip." ".$row[0],strlen($row[0])+strlen($ip)+1);  
    29   fclose($hostfile);   // update repository server location
    30     $repository = sqlfirst('select client_locations.repository from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'repository');
    31   # reboot des clients   ssh_editvar('MAGE_MIRRORS', $repository, '/etc/alxconfig-ng/config.rc');
    32   passthru($pingcmd.' '.$ip.' &> /dev/null && exit 0 || exit 1',$retval);   ssh_editvar('MIRRORS', $repository, '/etc/mage.rc');
    33   if($retval==0)  
    34   {   // update samba update host
    35   if($op=="calc")   $updateserver = sqlfirst('select client_locations.updateserver from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'updateserver');
    36   {   ssh_editvar('SMB_UPDATE_HOST', $updateserver, '/etc/alxconfig-ng/config.rc');
    37   echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching list of packages to upgrade on client #'.$client.' ('.$ip.')...<br>');  
    38   exec($sshcmd.' '.$ip.' /sbin/mageupgrade --calc-bash',$out,$err);   // update samba update user
    39   echo '<pre>';   $smbusername = sqlfirst('select client_locations.username from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'username');
    40   echo '<table border="0">';   ssh_editvar('SMB_UPDATE_USER', $smbusername, '/etc/alxconfig-ng/config.rc');
    41   if (array_key_exists("0", $out))  
    42   {   // update samba update password
    43   foreach( $out as $i)   $smbpassword = sqlfirst('select client_locations.password from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'password');
    44   {   ssh_editvar('SMB_UPDATE_PASS', $smbpassword, '/etc/alxconfig-ng/config.rc');
    45   $item=explode(",",$i);  }
    46   $pcat=$item[0];  
    47   $pname=$item[1];  // get alx version info
    48   $opver=$item[2];  $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$client);
    49   $npver=$item[3];  $alxos = $alxinfo[os];
    50    $alxutils = $alxinfo[utils];
    51   echo '<tr><td>';  
    52   echo '<font color=green>'.$pcat.'/'.$pname.'</font>';  // always update the client settings first
    53   echo '<td>';  update_client_settings();
    54   echo '<font color=blue> [ '.$opver.' -> '.$npver.' ] </font>';  
    55   echo '</td>';  if($op=="calc")
    56   echo '</td></tr>';  {
    57   }   echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching list of packages to upgrade on client #'.$client.' ('.$ip.')...<br>');
    58   }  
    59   else echo 'No updates for client '.$client.' available.';   if($alxos >= '0.6.0') {
    60   echo '</table>';   $out = sshdo('NOCOLORS=true /sbin/mage uppretend | egrep "\[.*\]" | sed "s:\[.*\]\ \(.*\):\1:" | sed "s:/:,:" | sed "s:\(.*\)-:\1,:" | sed "s:\(.*\)-:\1,:"', $ip);
    61   echo '</pre>';   }
    62   }   else {
    63   elseif($op=="update")   $out = sshdo('NOCOLORS=true /sbin/mageupgrade --calc-bash | cut -d, -f1-2,4 | sed "s/\(.*\)-r\(.*\)/\1,r\2/"', $ip);
    64   {   }
    65   echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching new mage database for client #'.$client.' ('.$ip.')...<br>');   echo '<pre>';
    66   echo '<br>';   echo '<table border="0">';
    67   echo '<pre><div align=left class=left>';   if (array_key_exists("0", $out))
    68   // hotfix copy a fixed mage.rc   {
    69   system('scp /var/www/localhost/htdocs/alx/he/mage.rc root@'.$ip.':/etc/mage.rc');   foreach( $out as $i)
    70   // hotfix2 and a config.rc   {
    71   system('scp /var/www/localhost/htdocs/alx/he/config.rc root@'.$ip.':/etc/alxconfig-ng/config.rc');   // element 0 is always 0
    72   editvar("VERBOSE","off","/etc/mage.rc");   if ($i=="0") continue;
    73    
    74   // update rsync server location   $row=explode("\n", $i);
    75   $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');   foreach( $row as $x)
    76   echo $rsync;   {
    77   editvar("MAGE_RSYNC",$rsync,"/etc/alxconfig-ng/config.rc");   //ignore empty rows
    78   editvar("RSYNC",$rsync,"/etc/mage.rc");   //(the last one may empty)
    79     if ($x=="") continue;
    80   system($sshcmd.' '.$ip.' "NOCOLORS=true /sbin/mage update"');  
    81   echo '</div></pre>';   $item=explode(",",trim($x));
    82   echo '<script language="JavaScript">alert(\'Database-update successfully completed on client #'.$client.' .\')</script>';   $pcat=$item[0];
    83   }   $pname=$item[1];
    84   elseif($op=="upgrade")   $pver=$item[2];
    85   {   $pbuild=$item[3];
    86   echo '<img src="pics/online.gif" align=top> '.strtoupper('Running update-alx on client #'.$client.' ('.$ip.')...<br>');  
    87   echo '<br>';   echo '<tr><td>';
    88   echo '<pre><div align=left class=left>';   echo '<font color=green>'.$pcat.'/'.$pname.'</font>';
    89   #echo 'forcing verbose=off <br>';   echo '<td>';
    90   // hotfix copy a fixed mage.rc   echo '<font color=blue> => [ '.$pver.'-'.$pbuild.' ] </font>';
    91   system('scp /var/www/localhost/htdocs/alx/he/mage.rc root@'.$ip.':/etc/mage.rc');   echo '</td>';
    92   // hotfix2 and a config.rc   echo '</td></tr>';
    93   system('scp /var/www/localhost/htdocs/alx/he/config.rc root@'.$ip.':/etc/alxconfig-ng/config.rc');   }
    94   editvar("VERBOSE","off","/etc/mage.rc");   }
    95     }
    96   // update rsync server location   else echo 'No updates for client '.$client.' available.';
    97   $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 '</table>';
    98   editvar("MAGE_RSYNC",$rsync,"/etc/alxconfig-ng/config.rc");   echo '</pre>';
    99   editvar("RSYNC",$rsync,"/etc/mage.rc");  }
    100    elseif($op=="update")
    101   // update repository server location  {
    102   $repository = sqlfirst('select client_locations.repository from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'repository');   echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching new mage database for client #'.$client.' ('.$ip.')...<br>');
    103   editvar("MAGE_MIRRORS",$repository,"/etc/alxconfig-ng/config.rc");   echo '<br>';
    104   editvar("MIRRORS",$repository,"/etc/mage.rc");   echo '<pre><div align=left class=left>';
    105    
    106   // update samba update host   sshdo('NOCOLORS=true /sbin/mage update', $ip);
    107   $updateserver = sqlfirst('select client_locations.updateserver from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'updateserver');  
    108   editvar("SMB_UPDATE_HOST",$updateserver,"/etc/alxconfig-ng/config.rc");   echo '</div></pre>';
    109     echo '<script language="JavaScript">alert(\'Database-update successfully completed on client #'.$client.' .\')</script>';
    110   // update samba update user  }
    111   $smbusername = sqlfirst('select client_locations.username from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'username');  elseif($op=="upgrade")
    112   editvar("SMB_UPDATE_USER",$smbusername,"/etc/alxconfig-ng/config.rc");  {
    113     echo '<img src="pics/online.gif" align=top> '.strtoupper('Running update-alx on client #'.$client.' ('.$ip.')...<br>');
    114   // update samba update password   echo '<br>';
    115   $smbpassword = sqlfirst('select client_locations.password from client_serials inner join client_locations on client_locations.location=client_serials.location and client_serials.serial='.$client, 'password');   echo '<pre><div align=left class=left>';
    116   editvar("SMB_UPDATE_PASS",$smbpassword,"/etc/alxconfig-ng/config.rc");  
    117     # check if /usr/sbin/update-alx exists, if not update mage-alx and alxconfig-alx first
    118     $err = sshdo('[ -x /usr/sbin/update-alx ]', $ip);
    119   # check if /usr/sbin/update-alx exists, if not update mage-alx and alxconfig-alx first   if($err[0]!=0)
    120   exec($sshcmd.' '.$ip.' "[ -x /usr/sbin/update-alx ] && exit 0 || exit 1"',$outarr,$err);   {
    121   if($err!=0)   echo '"update-alx" missing on client "'.$client.'". Updating mage and alxconfig-ng first ...<br>';
    122   {   sshdo('NOCOLORS=true mage install mage', $ip);
    123   echo '"/usr/sbin/update-alx" missing on client "'.$client.'". Updating mage-alx and alxconfig-ng-alx first ...<br>';   sshdo('NOCOLORS=true mage install alxconfig-ng', $ip);
    124   system($sshcmd.' '.$ip.' "NOCOLORS=true /sbin/mage install mage-alx"');   }
    125   system($sshcmd.' '.$ip.' "NOCOLORS=true /sbin/mage install alxconfig-ng-alx"');   $err = sshdo('NOCOLORS=true /usr/sbin/update-alx', $ip);
    126   }   if ($err[0]!=0) echo '<script language="JavaScript">alert(\'Upgrade *failed* on client #'.$client.' .\')</script>';
    127   //system($sshcmd.' '.$ip.' "NOCOLORS=true /usr/sbin/update-alx"');   else echo '<script language="JavaScript">alert(\'Upgrade successfully installed on client #'.$client.' .\')</script>';
    128   exec($sshcmd.' '.$ip.' "NOCOLORS=true /usr/sbin/update-alx && exit 0 || exit 1"',$outarr,$err);   echo '</div></pre>';
    129   echo '</div></pre>';  }
    130   if ($err!=0) echo '<script language="JavaScript">alert(\'Upgrade *failed* on client #'.$client.' .\')</script>';  else echo 'unkown operation';
    131   else echo '<script language="JavaScript">alert(\'Upgrade successfully installed on client #'.$client.' .\')</script>';  echo '</td></tr></table>';
    132   }  
    133   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>';  
     ?>  
    Legend:
    Removed from v.1608  
    changed lines
      Added in v.2596