imageid_defs.php 29.3 KB
Newer Older
1
2
<?php
#
3
# Copyright (c) 2006-2014 University of Utah and the Flux Group.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# 
# {{{EMULAB-LICENSE
# 
# This file is part of the Emulab network testbed software.
# 
# This file is free software: you can redistribute it and/or modify it
# under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or (at
# your option) any later version.
# 
# This file is distributed in the hope that it will be useful, but WITHOUT
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
# FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public
# License for more details.
# 
# You should have received a copy of the GNU Affero General Public License
# along with this file.  If not, see <http://www.gnu.org/licenses/>.
# 
# }}}
23
24
25
26
27
28
29
#
include_once("osinfo_defs.php");	# For SpitOSIDLink() below.

class Image
{
    var	$image;
    var $types;
30
31
    var $group;
    var $project;
32
33
34
35

    #
    # Constructor by lookup on unique ID
    #
36
    function Image($id, $version = NULL) {
37
38
39
	if (is_null($version)) {
	    list($id,$version) = preg_split('/:/', $id);
	}
40
41
	$safe_id = addslashes($id);

42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
	if (is_null($version)) {
	    $query_result =
		DBQueryWarn("select i.*,v.* from images as i ".
			    "left join image_versions as v on ".
			    "     v.imageid=i.imageid and v.version=i.version ".
			    "where i.imageid='$safe_id'");
	}
	else {
	    # This will get deleted images, but that is okay.
	    $safe_version = addslashes($version);
	    $query_result =
	        DBQueryWarn("select v.* from image_versions as v ".
			    "where v.imageid='$safe_id' and ".
			    "      v.version='$safe_version'");
	}
57
58
59
60
61
62
63
64
65
66
67
68
69

	if (!$query_result || !mysql_num_rows($query_result)) {
	    $this->image = NULL;
	    return;
	}
	$this->image = mysql_fetch_array($query_result);

	#
	# Load the type info.
	#
	$types = array();
	
	$query_result = 
70
	    DBQueryFatal("select distinct type from osidtoimageid ".
71
72
73
74
75
76
			 "where imageid='$safe_id'");
	
	while ($row = mysql_fetch_array($query_result)) {
	    $types[] = $row['type'];
	}
	$this->types = $types;
77
78
79
80

	# Load lazily;
	$this->group      = null;
	$this->project    = null;
81
82
83
84
85
86
87
88
    }

    # Hmm, how does one cause an error in a php constructor?
    function IsValid() {
	return !is_null($this->image);
    }

    # Lookup by imageid
89
    function Lookup($id, $version = NULL) {
90
	$foo = new Image($id,$version);
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113

	if (! $foo->IsValid())
	    return null;

	return $foo;
    }

    # Lookup by imagename in a project
    function LookupByName($project, $name) {
	$pid       = $project->pid();
	$safe_name = addslashes($name);
	
	$query_result =
	    DBQueryFatal("select imageid from images ".
			 "where pid='$pid' and imagename='$safe_name'");

	if (mysql_num_rows($query_result) == 0) {
	    return null;
	}
	$row = mysql_fetch_array($query_result);
	return Image::Lookup($row["imageid"]);
    }

114
115
116
117
118
119
120
121
122
123
124
125
126
127
    # Look for most recent unreleased version.
    function LookupUnreleased() {
	global $DOPROVENANCE;
	if (!$DOPROVENANCE) {
	    return $this;
	}
	$imageid   = $this->imageid();
	
	$query_result =
	    DBQueryFatal("select version from image_versions ".
			 "where imageid='$imageid' and released=0 and ".
			 "      deleted is null ".
			 "order by version desc limit 1");

Leigh B Stoller's avatar
Leigh B Stoller committed
128
129
	# If no unreleased version, just return $this. Might mean that
	# provenance is not turned on for the project cause of a feature.
130
	if (mysql_num_rows($query_result) == 0) {
Leigh B Stoller's avatar
Leigh B Stoller committed
131
	    return $this;
132
133
134
135
136
	}
	$row = mysql_fetch_array($query_result);
	return Image::Lookup($imageid, $row["version"]);
    }

137
138
139
140
141
142
143
144
145
146
147
148
149
150
    function LookupByUUID($uuid) {
	$safe_uuid = addslashes($uuid);

	$query_result =
	    DBQueryFatal("select imageid from images ".
			 "where uuid='$safe_uuid'");

	if (mysql_num_rows($query_result) == 0) {
	    return null;
	}
	$row = mysql_fetch_array($query_result);
	return Image::Lookup($row["imageid"]);
    }
    
151
152
153
154
155
156
157
158
    #
    # Refresh an instance by reloading from the DB.
    #
    function Refresh() {
	if (! $this->IsValid())
	    return -1;

	$imageid = $this->imageid();
159
160
	$version = $this->version();
	
161
	$query_result =
162
163
	    DBQueryWarn("select * from image_versions ".
			"where imageid='$imageid' and version='$version'");
164
165
166
167
168
    
	if (!$query_result || !mysql_num_rows($query_result)) {
	    $this->imageid = NULL;
	    return -1;
	}
169
	$this->image = mysql_fetch_array($query_result);
170
171
172
173
174
175
176

	#
	# Reload the type info.
	#
	$types = array();
	
	$query_result = 
177
	    DBQueryFatal("select distinct type from osidtoimageid ".
178
179
180
181
182
183
184
185
186
187
			 "where imageid='$imageid'");
	
	while ($row = mysql_fetch_array($query_result)) {
	    $types[] = $row['type'];
	}
	$this->types = $types;
	
	return 0;
    }

188
    #
189
190
    # Class function to create a new image descriptor.
    #
191
192
    function NewImageId($ez, $imagename, $args, $creator, $group,
			$target, &$errors) {
193
194
195
196
197
	global $suexec_output, $suexec_output_array;

        #
        # Generate a temporary file and write in the XML goo.
        #
Russ Fish's avatar
Russ Fish committed
198
	$xmlname = tempnam("/tmp", $ez ? "newimageid_ez" : "newimageid");
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
	if (! $xmlname) {
	    TBERROR("Could not create temporary filename", 0);
	    $errors[] = "Transient error(1); please try again later.";
	    return null;
	}
	if (! ($fp = fopen($xmlname, "w"))) {
	    TBERROR("Could not open temp file $xmlname", 0);
	    $errors[] = "Transient error(2); please try again later.";
	    return null;
	}

	# Add these. Maybe caller should do this?
	$args["imagename"] = $imagename;

	fwrite($fp, "<image>\n");
	foreach ($args as $name => $value) {
	    fwrite($fp, "<attribute name=\"$name\">");
	    fwrite($fp, "  <value>" . htmlspecialchars($value) . "</value>");
	    fwrite($fp, "</attribute>\n");
	}
	fwrite($fp, "</image>\n");
	fclose($fp);
	chmod($xmlname, 0666);
222
	$opt = ($target ? "-t " . escapeshellarg($target) : "");
223

224
	$script = "webnewimageid" . ($ez ? "_ez" : "");
225
226
227
	$retval = SUEXEC($creator->uid(),
			 $group->pid() . "," . $group->gid(),
			 "$script $opt $xmlname",
228
229
230
231
			 SUEXEC_ACTION_IGNORE);

	if ($retval) {
	    if ($retval < 0) {
232
		$errors[] = "Transient error(3, $retval); please try again later.";
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
		SUEXECERROR(SUEXEC_ACTION_CONTINUE);
	    }
	    else {
		# unlink($xmlname);
		if (count($suexec_output_array)) {
		    for ($i = 0; $i < count($suexec_output_array); $i++) {
			$line = $suexec_output_array[$i];
			if (preg_match("/^([-\w]+):\s*(.*)$/",
				       $line, $matches)) {
			    $errors[$matches[1]] = $matches[2];
			}
			else
			    $errors[] = $line;
		    }
		}
		else
249
		    $errors[] = "Transient error(4, $retval); please try again later.";
250
251
252
253
254
255
256
257
258
259
260
261
	    }
	    return null;
	}

        #
        # Parse the last line of output. Ick.
        #
	unset($matches);
	
	if (!preg_match("/^IMAGE\s+([^\/]+)\/(\d+)\s+/",
			$suexec_output_array[count($suexec_output_array)-1],
			$matches)) {
262
	    $errors[] = "Transient error(5); please try again later.";
263
264
265
266
267
268
	    SUEXECERROR(SUEXEC_ACTION_CONTINUE);
	    return null;
	}
	$image = $matches[2];
	$newimage = image::Lookup($image);
	if (! $newimage) {
269
	    $errors[] = "Transient error(6); please try again later.";
270
271
272
273
274
275
276
277
278
279
	    TBERROR("Could not lookup new image $image", 0);
	    return null;
	}

	# Unlink this here, so that the file is left behind in case of error.
	# We can then create the image by hand from the xmlfile, if desired.
	unlink($xmlname);
	return $newimage; 
    }

280
281
282
283
284
    #
    # Flip global bit. If making it global, turn off shared.
    # Also, if an EZ image, flip the bit on the os_info entry too.
    #
    function SetGlobal($mode) {
285
286
	$imageid  = $this->imageid();
	$version  = $this->version();
287
288
289
	$mode     = ($mode ? 1 : 0);
	$extra    = ($mode ? ",shared=0" : "");

290
291
	DBQueryFatal("update image_versions set global='$mode' $extra ".
		     "where imageid='$imageid' and version='$version'");
292
293

	if ($this->ezid()) {
294
295
	    DBQueryFatal("update os_info_versions set shared='$mode' ".
			 "where osid='$imageid' and vers='$version'");
296
297
298
299
	}
	return 0;
    }

300
301
    #
    # Class function to edit an image descriptor.
302
303
304
305
306
307
308
309
310
311
    #
    function EditImageid($image, $args, &$errors) {
	global $suexec_output, $suexec_output_array;

        #
        # Generate a temporary file and write in the XML goo.
        #
	$xmlname = tempnam("/tmp", "editimageid");
	if (! $xmlname) {
	    TBERROR("Could not create temporary filename", 0);
312
	    $errors[] = "Transient error(1); please try again later.";
313
314
315
316
	    return null;
	}
	if (! ($fp = fopen($xmlname, "w"))) {
	    TBERROR("Could not open temp file $xmlname", 0);
317
	    $errors[] = "Transient error(2); please try again later.";
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
	    return null;
	}

	# Add these. Maybe caller should do this?
	$args["imageid"] = $image->imageid();

	fwrite($fp, "<image>\n");
	foreach ($args as $name => $value) {
	    fwrite($fp, "<attribute name=\"$name\">");
	    fwrite($fp, "  <value>" . htmlspecialchars($value) . "</value>");
	    fwrite($fp, "</attribute>\n");
	}
	fwrite($fp, "</image>\n");
	fclose($fp);
	chmod($xmlname, 0666);

	$retval = SUEXEC("nobody", "nobody", "webeditimageid $xmlname",
			 SUEXEC_ACTION_IGNORE);

	if ($retval) {
	    if ($retval < 0) {
339
		$errors[] = "Transient error(3, $retval); please try again later.";
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
		SUEXECERROR(SUEXEC_ACTION_CONTINUE);
	    }
	    else {
		# unlink($xmlname);
		if (count($suexec_output_array)) {
		    for ($i = 0; $i < count($suexec_output_array); $i++) {
			$line = $suexec_output_array[$i];
			if (preg_match("/^([-\w]+):\s*(.*)$/",
				       $line, $matches)) {
			    $errors[$matches[1]] = $matches[2];
			}
			else
			    $errors[] = $line;
		    }
		}
		else
356
		    $errors[] = "Transient error(4, $retval); please try again later.";
357
358
359
360
361
362
363
364
	    }
	    return null;
	}

	# There are no return value(s) to parse at the end of the output.

	# Unlink this here, so that the file is left behind in case of error.
	# We can then create the image by hand from the xmlfile, if desired.
365
	#unlink($xmlname);
366
367
368
	return true;
    }

369
370
371
372
373
374
375
376
377
378
379
380
    #
    # Equality test.
    #
    function SameImage($image) {
	return $image->imageid() == $this->imageid();
    }

    # accessors
    function field($name) {
	return (is_null($this->image) ? -1 : $this->image[$name]);
    }
    function imagename()	{ return $this->field("imagename"); }
381
    function version()		{ return $this->field("version"); }
382
383
    function pid()		{ return $this->field("pid"); }
    function gid()		{ return $this->field("gid"); }
384
385
    function pid_idx()		{ return $this->field("pid_idx"); }
    function gid_idx()		{ return $this->field("gid_idx"); }
386
    function imageid()		{ return $this->field("imageid"); }
387
388
    function parent_imageid()	{ return $this->field("parent_imageid"); }
    function parent_version()	{ return $this->field("parent_version"); }
389
    function uuid()		{ return $this->field("uuid"); }
390
391
    function creator()		{ return $this->field("creator"); }
    function creator_idx()	{ return $this->field("creator_idx"); }
392
    function creator_urn()	{ return $this->field("creator_urn"); }
393
    function created()		{ return $this->field("created"); }
394
    function deleted()		{ return $this->field("deleted"); }
395
396
397
398
399
400
401
    function description()	{ return $this->field("description"); }
    function loadpart()		{ return $this->field("loadpart"); }
    function loadlength()	{ return $this->field("loadlength"); }
    function part1_osid()	{ return $this->field("part1_osid"); }
    function part2_osid()	{ return $this->field("part2_osid"); }
    function part3_osid()	{ return $this->field("part3_osid"); }
    function part4_osid()	{ return $this->field("part4_osid"); }
402
403
404
405
    function part1_vers()	{ return $this->field("part1_vers"); }
    function part2_vers()	{ return $this->field("part2_vers"); }
    function part3_vers()	{ return $this->field("part3_vers"); }
    function part4_vers()	{ return $this->field("part4_vers"); }
406
    function default_osid()	{ return $this->field("default_osid"); }
407
    function default_vers()	{ return $this->field("default_vers"); }
408
409
410
411
412
413
    function path()		{ return $this->field("path"); }
    function magic()		{ return $this->field("magic"); }
    function ezid()		{ return $this->field("ezid"); }
    function shared()		{ return $this->field("shared"); }
    function isglobal()		{ return $this->field("global"); }
    function updated()		{ return $this->field("updated"); }
414
415
    function updater()		{ return $this->field("updater"); }
    function updater_urn()	{ return $this->field("updater_urn"); }
416
    function mbr_version()	{ return $this->field("mbr_version"); }
417
    function hash()		{ return $this->field("hash"); }
418
419
    function metadata_url()	{ return $this->field("metadata_url"); }
    function imagefile_url()	{ return $this->field("imagefile_url"); }
420
    function logfileid()	{ return $this->field("logfileid"); }
421
    function noexport()		{ return $this->field("noexport"); }
422
423
424
    function ready()		{ return $this->field("ready"); }
    function isdelta()		{ return $this->field("isdelta"); }
    function released()		{ return $this->field("released"); }
425
426
427
428
429
430
431
432
433
434
435
436
437
438

    # Return the DB data.
    function DBData()		{ return $this->image; }
    # and the types array
    function Types()		{ reset($this->types); return $this->types; }

    #
    # Access Check, determines if $user can access $this record.
    # 
    function AccessCheck($user, $access_type) {
	global $TB_IMAGEID_READINFO;
	global $TB_IMAGEID_MODIFYINFO;
	global $TB_IMAGEID_DESTROY;
	global $TB_IMAGEID_ACCESS;
439
	global $TB_IMAGEID_EXPORT;
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
	global $TB_IMAGEID_MIN;
	global $TB_IMAGEID_MAX;
	global $TBDB_TRUST_USER;
	global $TBDB_TRUST_GROUPROOT;
	global $TBDB_TRUST_LOCALROOT;
	$mintrust = $TB_IMAGEID_READINFO;

	if ($access_type < $TB_IMAGEID_MIN || $access_type > $TB_IMAGEID_MAX) {
	    TBERROR("Invalid access type $access_type!", 1);
	}

        #
        # Admins do whatever they want!
        # 
	if (ISADMIN()) {
	    return 1;
	}

	$shared = $this->shared();
	$global = $this->isglobal();
460
	$imageid= $this->imageid();
461
462
463
	$pid    = $this->pid();
	$gid    = $this->gid();
	$uid    = $user->uid();
464
465
466
	$uid_idx= $user->uid_idx();
	$pid_idx= $user->uid_idx();
	$gid_idx= $user->uid_idx();
467
468

        #
469
        # Global ImageIDs can be read by anyone but written with permission.
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
        # 
	if ($global) {
	    if ($access_type == $TB_IMAGEID_READINFO) {
		return 1;
	    }
	}

        #
        # Otherwise must have proper trust in the project.
        # 
	if ($access_type == $TB_IMAGEID_READINFO) {
	    $mintrust = $TBDB_TRUST_USER;
            #
            # Shared imageids are readable by anyone in the project.
            #
	    if ($shared)
		$gid = $pid;
	}
	else {
	    $mintrust = $TBDB_TRUST_LOCALROOT;
	}

492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
	if (TBMinTrust(TBGrpTrust($uid, $pid, $gid), $mintrust) ||
	    TBMinTrust(TBGrpTrust($uid, $pid, $pid), $TBDB_TRUST_GROUPROOT)) {
	    return 1;
	}
        # No point in looking further; never allowed.
	if ($access_type == $TB_IMAGEID_EXPORT) {
	    return 0;
	}
	
	#
	# Look in the image permissions. First look for a user permission,
	# then look for a group permission.
	#
	$query_result = 
	    DBQueryFatal("select allow_write from image_permissions ".
			 "where imageid='$imageid' and ".
			 "      permission_type='user' and ".
			 "      permission_idx='$uid_idx'");
	
	if (mysql_num_rows($query_result)) {
	    $row  = mysql_fetch_array($query_result);

            # Only allowed to read.
	    if ($access_type == $TB_IMAGEID_READINFO ||
		$access_type == $TB_IMAGEID_ACCESS)
		return 1;
	}
	$trust_none = TBDB_TRUSTSTRING_NONE;
	$query_result = 
	    DBQueryFatal("select allow_write from group_membership as g ".
			 "left join image_permissions as p on ".
			 "     p.permission_type='group' and ".
			 "     p.permission_idx=g.gid_idx ".
			 "where g.uid_idx='$uid_idx' and ".
			 "      p.imageid='$imageid' and ".
			 "      trust!='$trust_none'");

	if (mysql_num_rows($query_result)) {
            # Only allowed to read.
	    if ($access_type == $TB_IMAGEID_READINFO ||
		$access_type == $TB_IMAGEID_ACCESS)
		return 1;
	}
	return 0;
536
537
    }

538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
    #
    # Load the project object for an experiment.
    #
    function Project() {
	$pid_idx = $this->pid_idx();

	if ($this->project)
	    return $this->project;

	$this->project = Project::Lookup($pid_idx);
	if (! $this->project) {
	    TBERROR("Could not lookup project $pid_idx!", 1);
	}
	return $this->project;
    }
    #
    # Load the group object for an experiment.
    #
    function Group() {
	$gid_idx = $this->gid_idx();

	if ($this->group)
	    return $this->group;

	$this->group = Group::Lookup($gid_idx);
	if (! $this->group) {
	    TBERROR("Could not lookup group $gid_idx!", 1);
	}
	return $this->group;
    }

569
    function Show($showperms = 0) {
570
	global $TBBASE, $DOPROVENANCE;
571
	
572
573
	$imageid	= $this->imageid();
	$imagename	= $this->imagename();
574
	$version	= $this->version();
575
576
577
578
579
580
581
582
583
	$pid		= $this->pid();
	$gid		= $this->gid();
	$description	= $this->description();
	$loadpart	= $this->loadpart();
	$loadlength	= $this->loadlength();
	$part1_osid	= $this->part1_osid();
	$part2_osid	= $this->part2_osid();
	$part3_osid	= $this->part3_osid();
	$part4_osid	= $this->part4_osid();
584
585
586
587
	$part1_vers	= $this->part1_vers();
	$part2_vers	= $this->part2_vers();
	$part3_vers	= $this->part3_vers();
	$part4_vers	= $this->part4_vers();
588
	$default_osid	= $this->default_osid();
589
	$default_vers	= $this->default_vers();
590
591
592
593
	$path		= $this->path();
	$shared		= $this->shared();
	$globalid	= $this->isglobal();
	$creator	= $this->creator();
594
	$creator_urn	= $this->creator_urn();
595
	$created	= $this->created();
596
	$updated	= $this->updated();
597
598
	$updater	= $this->updater();
	$updater_urn	= $this->updater_urn();
599
	$uuid           = $this->uuid();
600
	$mbr_version    = $this->mbr_version();
601
	$hash           = $this->hash();
602
	
603
604
605
606
607
608
609
610
611
612
	#
	# An imported image has a metadata_url, and at the moment I
	# do want to worry about exporting an imported image.
	#
	$imagefile_url  = $this->imagefile_url();
	$metadata_url   = $this->metadata_url();
	if (! $metadata_url) {
	    $metadata_url = "$TBBASE/image_metadata.php?uuid=$uuid";
	}

613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
	if (!$description)
	    $description = "&nbsp;";
	if (!$path)
	    $path = "&nbsp;";
	if (!$created)
	    $created = "N/A";
    
        #
        # Generate the table.
        #
	echo "<table align=center border=2 cellpadding=2 cellspacing=2>\n";

	echo "<tr>
                <td>Image Name: </td>
                <td class=\"left\">$imagename</td>
              </tr>\n";

630
631
632
633
634
635
636
	echo "<tr>
                <td>Description: </td>
                <td class=left>\n";
	echo "$description";
	echo "   </td>
 	      </tr>\n";

637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
	echo "<tr>
                <td>Project: </td>
                <td class=\"left\">
                  <a href='showproject.php3?pid=$pid'>$pid</a></td>
              </tr>\n";

	echo "<tr>
                  <td>Group: </td>
                  <td class=\"left\">
                    <a href='showgroup.php3?pid=$pid&gid=$gid'>$gid</a></td>
              </tr>\n";
    
	echo "<tr>
                <td>Created: </td>
                <td class=left>$created</td>
 	      </tr>\n";

654
655
656
657
658
659
660
661
662
663
664
665
	echo "<tr>
                <td>Creator: </td>
                <td class=left>$creator</td>
     	      </tr>\n";

	if ($creator_urn) {
	    echo "<tr>
                    <td>Creator URN: </td>
                    <td class=left>$creator_urn</td>
         	  </tr>\n";
	}
	    
666
667
668
669
670
	if ($updated) {
	    echo "<tr>
                    <td>Updated: </td>
                    <td class=left>$updated</td>
     	          </tr>\n";
671
672
673
674
675
676
677
678
679
680
	    echo "<tr>
                    <td>Updated By: </td>
                    <td class=left>$updater</td>
     	          </tr>\n";
	    if ($updater_urn) {
		echo "<tr>
                        <td>Updater URN: </td>
                        <td class=left>$updater_urn</td>
         	          </tr>\n";
	    }
681
	}
682
683
684
685
686
687
688
689
	$deleted = $this->deleted();
	if (isset($deleted)) {
	    
	    echo "<tr>
                    <td><font color=red>Deleted: </font></td>
                    <td class=left><font color=red>$deleted</font></td>
     	          </tr>\n";
	}
690

691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
	#
	# Find the last time this image was used. 
	#
	$usage_result =
	    DBQueryFatal("select FROM_UNIXTIME(stamp) as lastused ".
			 "  from image_history ".
			 "where action='os_setup' and imageid='$imageid' ".
			 "order by stamp desc limit 1");
	if (mysql_num_rows($usage_result)) {
	    $urow = mysql_fetch_array($usage_result);
	    $lastused = $urow['lastused'];

	    echo "<tr>
                    <td>Last Used: </td>
                    <td class=\"left\">$lastused</td>
                  </tr>\n";
	}
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722

	echo "<tr>
                <td>Load Partition: </td>
                <td class=\"left\">$loadpart</td>
              </tr>\n";

	echo "<tr>
                <td>Load Length: </td>
                <td class=\"left\">$loadlength</td>
              </tr>\n";

	if ($part1_osid) {
	    echo "<tr>
                     <td>Partition 1 OS: </td>
                     <td class=\"left\">";
723
	    SpitOSIDLink($part1_osid, $part1_vers);
724
725
726
727
728
729
730
731
	    echo "   </td>
                  </tr>\n";
	}

	if ($part2_osid) {
	    echo "<tr>
                     <td>Partition 2 OS: </td>
                     <td class=\"left\">";
732
	    SpitOSIDLink($part2_osid, $part2_vers);
733
734
735
736
737
738
739
740
	    echo "   </td>
                  </tr>\n";
	}

	if ($part3_osid) {
	    echo "<tr>
                     <td>Partition 3 OS: </td>
                     <td class=\"left\">";
741
	    SpitOSIDLink($part3_osid, $part3_vers);
742
743
744
745
746
747
748
749
	    echo "   </td>
                  </tr>\n";
	}

	if ($part4_osid) {
	    echo "<tr>
                     <td>Partition 4 OS: </td>
                     <td class=\"left\">";
750
	    SpitOSIDLink($part4_osid, $part4_vers);
751
752
753
754
755
756
757
758
	    echo "   </td>
                  </tr>\n";
	}

	if ($default_osid) {
	    echo "<tr>
                     <td>Boot OS: </td>
                     <td class=\"left\">";
759
	    SpitOSIDLink($default_osid, $default_vers);
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
	    echo "   </td>
                  </tr>\n";
	}

	echo "<tr>
                <td>Filename: </td>
                <td class=left>\n";
	echo "$path";
	echo "  </td>
              </tr>\n";

	echo "<tr>
                  <td>Types: </td>
                  <td class=left>\n";
	echo "&nbsp;";
	foreach ($this->Types() as $type) {
	    echo "$type &nbsp; ";
	}
	echo "  </td>
              </tr>\n";

	echo "<tr>
                <td>Shared?: </td>
                <td class=left>\n";
	if ($shared)
	    echo "Yes";
	else
	    echo "No";
    
	echo "  </td>
              </tr>\n";

	echo "<tr>
                <td>Global?: </td>
                <td class=left>\n";

796
797
	$globalflip = ($globalid ? 0 : 1);
	$globalval  = ($globalid ? "Yes" : "No");
798
799
	echo "$globalval (<a href='toggle.php?imageid=$imageid".
	    "&type=imageglobal&value=$globalflip'>Toggle</a>)";
800
801
802
803
	echo "  </td>
              </tr>\n";

	echo "<tr>
804
805
                <td>Internal ID (Vers): </td>
                <td class=left>$imageid ($version)</td>
806
807
              </tr>\n";

808
809
810
811
812
813
814
815
816
817
	if ($this->parent_imageid()) {
	    $p_imageid   = $this->parent_imageid();
	    $p_version   = $this->parent_version();
	    $p_image     = Image::Lookup($p_imageid, $p_version);
	    $p_imagename = $p_image->imagename();
	    $p_url       = CreateURL("showimageid", $p_image,
				      "version", $p_version);
	    
	    echo "<tr>
                    <td>Derived from: </td>
Leigh B Stoller's avatar
Leigh B Stoller committed
818
819
                    <td class=left><a href='$p_url'>
                      ${p_imagename}:${p_version}</a></td>
820
821
822
823
                  </tr>\n";

	    if ($this->parent_imageid() != $this->imageid() &&
		$this->version() > 0) {
824
		$p_version   = $this->version() - 1;
825
		$p_url       = CreateURL("showimageid", $this,
826
					 "version", $p_version);
827
828
		echo "<tr>
                        <td>Previous Vers: </td>
829
                        <td class=left>
Leigh B Stoller's avatar
Leigh B Stoller committed
830
                            <a href='$p_url'>${imagename}:${p_version}</a></td>
831
832
                      </tr>\n";
	    }
833
834
835
836
837
838
839
840
841
842
	}
	# Look for an unreleased version of this image.
	$unreleased = $this->LookupUnreleased();
	if ($unreleased && $unreleased->version() != $this->version()) {
	    $u_version = $unreleased->version();
	    $u_url     = CreateURL("showimageid", $this, "version", $u_version);

	    echo "<tr>
                    <td>Unreleased Vers: </td>
                    <td class=left>
Leigh B Stoller's avatar
Leigh B Stoller committed
843
                         <a href='$u_url'>${imagename}:${u_version}</a></td>
844
845
846
847
848
                  </tr>\n";
	}
	if ($DOPROVENANCE) {
	    $released = $this->released();
	    $ready    = $this->ready();
Leigh B Stoller's avatar
Leigh B Stoller committed
849
	    $isdelta  = $this->isdelta();
850
851
852
853
854
855
	    
	    echo "<tr>
                    <td>Rdy/Rel/Delta: </td>
                    <td class=left>$ready/$released/$isdelta</td>
                  </tr>\n";
	}
856

857
858
859
860
861
	echo "<tr>
                <td>MBR Version: </td>
                <td class=left>$mbr_version</td>
              </tr>\n";

862
863
864
865
866
867
868
	# Until I change the schema.
	if ($mbr_version == 99) {
	    echo "<tr>
                    <td>XEN Package: </td>
                    <td class=left>Yes</td>
                  </tr>\n";
	}
869
870
	if ($this->ezid()) {
	    $doesxen = 0;
871
	    $osinfo = $this->OSinfo();
872
873
874
875
876
877
878
879
880
881
882
883
884
	    if ($osinfo && $osinfo->def_parentosid()) {
		$parentosinfo = OSinfo::Lookup($osinfo->def_parentosid());
		if ($parentosinfo &&
		    $parentosinfo->FeatureSupported("xen-host")) {
		    $doesxen = 1;
		}
	    }
	    $xenval  = ($doesxen ? "Yes" : "No");
	    $xenflip = ($doesxen ? 0 : 1);

	    echo "<tr>
                  <td>XEN Capable?:</td>
   	          <td class=left>
885
886
                     $xenval (<a href='toggle.php?imageid=$imageid".
		          "&type=imagedoesxen&value=$xenflip'>Toggle</a>
887
888
889
890
891
892
893
                      if you know this image can run
               as a XEN guest. More info
               <a target=_blank
                  href='https://wiki.emulab.net/wiki/Emulab/wiki/xen'>here</a>)
              </td>
             </tr>\n";
	}
894

895
896
897
898
899
900
901
	if ($hash) {
	    echo "<tr>
                    <td>SHA1 Hash: </td>
                    <td class=left>$hash</td>
                  </tr>\n";
	}

902
903
904
905
906
	echo "<tr>
                <td>UUID: </td>
                <td class=left>$uuid</td>
              </tr>\n";

907
908
909
910
911
912
913
914
915
916
917
918
	echo "<tr>
                <td>Metadata URL: </td>
                <td class=left><a href='$metadata_url'>https:// ...</a></td>
              </tr>\n";

	if ($imagefile_url) {
	    echo "<tr>
                   <td>Image File URL: </td>
                   <td class=left><a href='$imagefile_url'>https:// ...</a></td>
                  </tr>\n";
	}

919
920
921
922
923
	#
	# Show who all can access this image outside the project.
	#
	if ($showperms) {
	    $query_result =
924
		DBQueryFatal("select distinct * from image_permissions ".
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
			     "where imageid='$imageid' ".
			     "order by permission_type,permission_id");
	    if (mysql_num_rows($query_result)) {
		echo "<tr>
                      <td align=center colspan=2>
                      External permissions
                      </td>
                  </tr>\n";

		while ($row = mysql_fetch_array($query_result)) {
		    $perm_type = $row['permission_type'];
		    $perm_idx  = $row['permission_idx'];
		    $writable  = $row['allow_write'];

		    if ($writable) {
			$writable = "(read/write)";
		    }
		    else {
			$writable = "(read only)";
		    }

		    if ($perm_type == "user") {
			$user = User::Lookup($perm_idx);
			if (isset($user)) {
			    $uid = $user->uid();
			    echo "<tr>
                                    <td>User: </td>
                                    <td class=left>$uid $writable</td>
                                  </tr>\n";
			}
		    }
		    elseif ($perm_type == "group") {
			$group = Group::Lookup($perm_idx);
			if (isset($group)) {
			    $pid = $group->pid();
			    $gid = $group->gid();
			    echo "<tr>
                                    <td>Group: </td>
                                    <td class=left>$pid/$gid $writable</td>
                                  </tr>\n";
			}
		    }
		}
	    }
	}

971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
	echo "</table>\n";
    }

    #
    # See if an image is inuse.
    #
    function InUse() {
	$imageid = $this->imageid();

	$query_result1 =
	    DBQueryFatal("select * from current_reloads ".
			 "where image_id='$imageid'");
	$query_result2 =
	    DBQueryFatal("select * from scheduled_reloads ".
			 "where image_id='$imageid'");
	$query_result3 =
	    DBQueryFatal("select * from node_type_attributes ".
			 "where attrkey='default_imageid' and ".
			 "      attrvalue='$imageid' limit 1");

	if (mysql_num_rows($query_result1) ||
	    mysql_num_rows($query_result2) ||
	    mysql_num_rows($query_result3)) {
	    return 1;
	}
	return 0;
    }
998
999
1000

    function GetLogfile() {
	$this->Refresh();
For faster browsing, not all history is shown. View entire blame