Contents of /alx-src/branches/alx-web-070/mageupgrade.php
Parent Directory | Revision Log
Revision 2597 -
(show annotations)
(download)
Tue Jul 5 16:37:58 2011 UTC (13 years, 2 months ago) by niro
Original Path: alx-src/branches/alx-web-060/mageupgrade.php
File size: 5111 byte(s)
Tue Jul 5 16:37:58 2011 UTC (13 years, 2 months ago) by niro
Original Path: alx-src/branches/alx-web-060/mageupgrade.php
File size: 5111 byte(s)
-show a message if a system if fully upgraded and there are nor updates
1 | <? |
2 | |
3 | include('include/dbconn.php'); |
4 | include('include/basesql.php'); |
5 | include('include/common-functions.php'); |
6 | |
7 | echo '<table width=100% height=100% style="border:solid black 1px; background-color:#d5e5ff"><tr><td valign=middle align=center>'; |
8 | |
9 | ?> |
10 | |
11 | <style type="text/css"> |
12 | div.left { margin-left:20%; } |
13 | </style> |
14 | |
15 | <? |
16 | |
17 | function update_client_settings() |
18 | { |
19 | global $client; |
20 | |
21 | // set verbose off |
22 | ssh_editvar('VERBOSE', 'off', '/etc/mage.rc'); |
23 | |
24 | // update rsync server location |
25 | $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 | ssh_editvar('MAGE_RSYNC', $rsync, '/etc/alxconfig-ng/config.rc'); |
27 | ssh_editvar('RSYNC', $rsync, '/etc/mage.rc'); |
28 | |
29 | // 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 | ssh_editvar('MAGE_MIRRORS', $repository, '/etc/alxconfig-ng/config.rc'); |
32 | ssh_editvar('MIRRORS', $repository, '/etc/mage.rc'); |
33 | |
34 | // update samba update host |
35 | $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 | |
38 | // update samba update user |
39 | $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 | ssh_editvar('SMB_UPDATE_USER', $smbusername, '/etc/alxconfig-ng/config.rc'); |
41 | |
42 | // update samba update password |
43 | $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 | } |
46 | |
47 | // get alx version info |
48 | $alxinfo = sqlfirst('SELECT * FROM client_version WHERE serial='.$client); |
49 | $alxos = $alxinfo[os]; |
50 | $alxutils = $alxinfo[utils]; |
51 | |
52 | // always update the client settings first |
53 | update_client_settings(); |
54 | |
55 | if($op=="calc") |
56 | { |
57 | echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching list of packages to upgrade on client #'.$client.' ('.$ip.')...<br>'); |
58 | |
59 | if($alxos >= '0.6.0') { |
60 | $out = sshdo('NOCOLORS=true /sbin/mage uppretend | egrep "\[.*\]" | sed "s:\[.*\]\ \(.*\):\1:" | sed "s:/:,:" | sed "s:\(.*\)-:\1,:" | sed "s:\(.*\)-:\1,:"', $ip); |
61 | } |
62 | else { |
63 | $out = sshdo('NOCOLORS=true /sbin/mageupgrade --calc-bash | cut -d, -f1-2,4 | sed "s/\(.*\)-r\(.*\)/\1,r\2/"', $ip); |
64 | } |
65 | echo '<pre>'; |
66 | echo '<table border="0">'; |
67 | if (array_key_exists("0", $out)) |
68 | { |
69 | // tell that there are no updates if $out/$i is empty |
70 | if ( $out[1] == "") |
71 | { |
72 | echo "No updates available. The system is fully upgraded."; |
73 | } else { |
74 | foreach( $out as $i) |
75 | { |
76 | // element 0 is always 0 |
77 | if ($i=="0") continue; |
78 | |
79 | $row=explode("\n", $i); |
80 | foreach( $row as $x) |
81 | { |
82 | //ignore empty rows |
83 | //(the last one may empty) |
84 | if ($x=="") continue; |
85 | |
86 | $item=explode(",",trim($x)); |
87 | $pcat=$item[0]; |
88 | $pname=$item[1]; |
89 | $pver=$item[2]; |
90 | $pbuild=$item[3]; |
91 | |
92 | echo '<tr><td>'; |
93 | echo '<font color=green>'.$pcat.'/'.$pname.'</font>'; |
94 | echo '<td>'; |
95 | echo '<font color=blue> => [ '.$pver.'-'.$pbuild.' ] </font>'; |
96 | echo '</td>'; |
97 | echo '</td></tr>'; |
98 | } |
99 | } |
100 | } |
101 | } |
102 | else echo 'No updates for client '.$client.' available.'; |
103 | echo '</table>'; |
104 | echo '</pre>'; |
105 | } |
106 | elseif($op=="update") |
107 | { |
108 | echo '<img src="pics/online.gif" align=top> '.strtoupper('Fetching new mage database for client #'.$client.' ('.$ip.')...<br>'); |
109 | echo '<br>'; |
110 | echo '<pre><div align=left class=left>'; |
111 | |
112 | sshdo('NOCOLORS=true /sbin/mage update', $ip); |
113 | |
114 | echo '</div></pre>'; |
115 | echo '<script language="JavaScript">alert(\'Database-update successfully completed on client #'.$client.' .\')</script>'; |
116 | } |
117 | elseif($op=="upgrade") |
118 | { |
119 | echo '<img src="pics/online.gif" align=top> '.strtoupper('Running update-alx on client #'.$client.' ('.$ip.')...<br>'); |
120 | echo '<br>'; |
121 | echo '<pre><div align=left class=left>'; |
122 | |
123 | # check if /usr/sbin/update-alx exists, if not update mage-alx and alxconfig-alx first |
124 | $err = sshdo('[ -x /usr/sbin/update-alx ]', $ip); |
125 | if($err[0]!=0) |
126 | { |
127 | echo '"update-alx" missing on client "'.$client.'". Updating mage and alxconfig-ng first ...<br>'; |
128 | sshdo('NOCOLORS=true mage install mage', $ip); |
129 | sshdo('NOCOLORS=true mage install alxconfig-ng', $ip); |
130 | } |
131 | $err = sshdo('NOCOLORS=true /usr/sbin/update-alx', $ip); |
132 | if ($err[0]!=0) echo '<script language="JavaScript">alert(\'Upgrade *failed* on client #'.$client.' .\')</script>'; |
133 | else echo '<script language="JavaScript">alert(\'Upgrade successfully installed on client #'.$client.' .\')</script>'; |
134 | echo '</div></pre>'; |
135 | } |
136 | else echo 'unkown operation'; |
137 | echo '</td></tr></table>'; |
138 | |
139 | ?> |
Properties
Name | Value |
---|---|
svn:executable | * |