ptopgen.in 15.4 KB
Newer Older
Leigh B. Stoller's avatar
Leigh B. Stoller committed
1
#!/usr/bin/perl -w
Leigh B. Stoller's avatar
Leigh B. Stoller committed
2 3 4

#
# EMULAB-COPYRIGHT
5
# Copyright (c) 2000-2003 University of Utah and the Flux Group.
Leigh B. Stoller's avatar
Leigh B. Stoller committed
6 7 8
# All rights reserved.
#

9 10
use English;
use Getopt::Std;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
11

12 13
sub usage()
{
14 15 16 17 18
    print("Usage: ptopgen [-v] [-s switch] [-p pid [-e eid]] [-m factor]\n" .
	  "       -p include nodes the project has permission to use\n".
	  "       -e include given experiment's resources\n" .
	  "          in the ptopfile (as if they were free)\n" .
	  "       -v Include stuff for topologies with virtual nodes\n".
19
	  "       -r Include stuff for topologies with widearea nodes\n".
20
	  "       -m Override multiplex_factor\n");
21 22
    exit(-1);
}
23
my $optlist = "s:e:m:vp:r";
24
my $mfactor;
25
my $virtstuff = 0;
26
my $widearea  = 0;
27

28 29 30 31
#
# Turn off line buffering on output
#
$| = 1;
32 33 34 35 36 37 38 39 40 41 42 43

# Settings - Change these to your particular network.

#
# Also bogus. The interfaces table does not hold entries for the switch
# side of each link. It will have to at some point, when we have something
# other than 100Mbs ports (say, gbit ports).
#
# Speed in in Kbs!
#
my $default_switchport_speed    = 100000;

44 45 46 47 48 49
#
# Yet more bogosity - we hardcode this weight, which is given to wide-area
# (primarily plab) nodes to prefer spreading across sites
#
my $site_weight = 0.99;

50 51
######################################################################

52
my $TBROOT = "@prefix@";
53
use lib '@prefix@/lib';
54
require exitonwarn;
55
use libdb;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
56

57 58
my $TRACK_INTERSWITCH_BANDWIDTH = "@TRACK_INTERSWITCH_BANDWIDTH@";

59 60 61
my %switches	  = ();
my %used_switches = ();
my %permissions   = ();
62

63 64 65
my $DEADPID = NODEDEAD_PID();
my $DEADEID = NODEDEAD_EID();

66
my $pid;
67
my $exempt_eid;
68
my $switchtouse;
69

70 71 72 73 74 75 76 77 78 79 80 81 82 83
#
# Parse command arguments. Once we return from getopts, all that should be
# left are the required arguments.
#
%options = ();
if (! getopts($optlist, \%options)) {
    usage();
}
if (@ARGV) {
    usage();
}
if (defined($options{"s"})) {
    $switchtouse = $options{"s"};
}
84 85 86
if (defined($options{"m"})) {
    $mfactor = $options{"m"};
}
87 88 89
if (defined($options{"v"})) {
    $virtstuff = 1;
}
90 91 92
if (defined($options{"r"})) {
    $widearea = 1;
}
93 94 95
if (defined($options{"p"})) {
    $pid = $options{"p"};
}
96
if (defined($options{"e"})) {
97 98 99
    $exempt_eid = $options{"e"};
    usage()
	if (!defined($pid));
100 101
}

102
# Read class/type maps
103 104 105 106
my $result =
    DBQueryFatal("select class,type,delay_capacity,virtnode_capacity ".
		 "from node_types");
while (($class,$type,$delaycapacity,$vcap) = $result->fetchrow_array) {
107
    $classes{$type} = $class;
108
    $nodetypes{$type} = $delaycapacity;
109
    $virtcapacity{$type} = $vcap;
110 111 112 113 114 115 116 117 118 119 120

    # Default is permission to use all types,classes. 
    $permissions{$class} = 1;
    $permissions{$type}  = 1;
}

#
# Read the features table for each type.
# 
$result = DBQueryFatal("select type, feature, weight from node_type_features");
while (my ($type, $feature, $weight) = $result->fetchrow()) {
121 122 123 124
    if (! defined($type_features{$type})) {
	$type_features{$type} = ["$feature:$weight"];
    } else {
	push @{$type_features{$type}}, "$feature:$weight";
125 126 127
    }
}

128 129 130 131 132 133 134 135 136 137 138 139
#
# Read the features table for each individual node
#
$result = DBQueryFatal("select node_id, feature, weight from node_features");
while (my ($node_id, $feature, $weight) = $result->fetchrow()) {
    if (! defined($features{$node_id})) {
	$features{$node_id} = ["$feature:$weight"];
	next;
    } else {
	push @{$features{$node_id}}, "$feature:$weight";
    }
}
140 141 142 143 144 145 146 147 148 149 150
#
# Read in the node_auxtypes table for each node.
#
$result = DBQueryFatal("select node_id, type, count from node_auxtypes");
while (my ($node_id, $type, $count) = $result->fetchrow()) {
    if (! defined($auxtypes{$node_id})) {
	$auxtypes{$node_id} = ["$type:$count"];
	next;
    }
    push @{$auxtypes{$type}}, " $type:$count";
}
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170
#
# Read the permission table if given a pid. If there is an entry in
# the table for a type/class, then permission is granted only if there
# is a record with the pid. If not, remove the permission granted above.
# 
if (defined($pid)) {
    $result =
	DBQueryFatal("select type from nodetypeXpid_permissions");
    
    while (my ($type) = $result->fetchrow_array) {
	$permissions{$type} = 0;
    }
    
    $result =
	DBQueryFatal("select type from nodetypeXpid_permissions ".
		     "where pid='$pid'");
    
    while (my ($type) = $result->fetchrow_array) {
	$permissions{$type} = 1;
    }
171 172 173 174 175
}

# switches can't delay
$nodetypes{"switch"} = 0;

176
# Print switches
177
if (defined($switchtouse)) {
178
    print "node $switchtouse switch:1 *lan:*\n";
179 180 181 182 183 184 185
    $switches{$switchtouse} = 1;
}
else {
    $result =
	DBQueryFatal("select node_id from nodes where role = \"testswitch\"");

    while (($switch) = $result->fetchrow_array) {
186
	print "node $switch switch:1 *lan:*\n";
187 188
	$switches{$switch} = 1;
    }
189
}
190

191
# Find available nodes.
192
#
193 194
# This first query deals with just local nodes. Local nodes can host
# virtnodes, according to the delay_capacity in the types table. 
195
#
196

197
# the ordinary free condition for a local node.
198 199 200 201 202 203
my $free_condition = "(b.node_id is null)";

# if the user has specified an exempt pid/eid, 
# then view any node which is reserved to that experiment as available.
if (defined($exempt_eid)) {
    $free_condition = "($free_condition or ".
204
	"(b.pid='$pid' and b.eid='$exempt_eid'))"; 
205
}
Chad Barb's avatar
Chad Barb committed
206

207
$result =
208 209
    DBQueryFatal("select a.node_id,a.type,a.phys_nodeid,t.class,t.issubnode " .
		 "from nodes as a ".
210 211
		 "left join reserved as b on a.node_id=b.node_id ".
		 "left join reserved as m on a.phys_nodeid=m.node_id ".
212
		 "left join node_types as t on t.type=a.type ".
213
		 "where $free_condition and ".
214
		 "      (a.role='testnode' and t.isremotenode=0)");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
215

216 217 218
#
# Scan the results, checking permissions and adding to the list
# You get to use a node type if no pid was specified (that is, you get
219 220 221
# to use all nodes), or if there is no entry in the perms table for
# the type/class of node.
#
222
while (($node,$type,$physnode,$class,$issubnode) = $result->fetchrow_array) {
223 224 225
    $nodes{$node} = $type
	if (!defined($pid) ||
	    ($permissions{$type} && $permissions{$class}));
226 227 228
    if ($issubnode) {
	$subnode_of{$node} = $physnode;
    }
229
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
230 231

foreach $node (keys(%nodes)) {
232 233
    my $type = $nodes{$node};
    
234
    my @types = ("$type:1");
235 236 237
    my @features;
    my @flags;

238 239 240 241 242
    # Might be equal, which assign would sum as two, not one!
    if ($type ne $classes{$type}) {
	push(@types, "$classes{$type}:1");
    }

243 244 245 246
    $delay_capacity = $nodetypes{$type};
    $virtnode_capacity = $virtcapacity{$type};
    
    if ($delay_capacity > 0) {
247
	push @types, "delay:$delay_capacity";
248
	    
249 250 251 252 253 254 255 256
	#################################################################
	### NSE Node hack. Instead of adding sim nodes into the
	### database schema, I'm just adding it here for now
	### untill we can figure out how to add sim nodes into the
	### nodes table.  One assumption is that if we the node
	### type can support delay nodes, then it is a local node
	### and therefore we can support sim nodes
	#################################################################
257
	push @types, "sim:100000";
258
    }
259

260 261 262 263 264 265 266
    #
    # Add any auxiliary types
    #
    if ($auxtypes{$node}) {
	push @types, @{$auxtypes{$node}};
    }

267 268 269 270
    if ($virtstuff && $virtnode_capacity > 0) {
	#
	# Ditto for jailed nodes
	#
271
	if (defined($mfactor) && $mfactor <= $virtnode_capacity) {
272
	    push @types, "pcvm:$mfactor";
273 274
	}
	else {
275
	    push @types, "pcvm:$virtnode_capacity";
276
	}
277
	push @types, "*lan:*";
278
	# Add trivial bw spec.
279 280 281 282
	push @flags, "trivial_bw:400000";
    }

    # Add features
283 284 285 286 287
    if (defined($type_features{$type})) {
	push @features, @{$type_features{$type}};
    }
    if (defined($features{$node})) {
	push @features, @{$features{$node}};
288 289 290 291 292 293 294 295 296 297 298 299 300
    }

    #
    # Handle subnodes
    #
    if ($subnode_of{$node}) {
	# We don't want to include subnodes unless their parent node is going
	# to be in the ptop file too
	if (!$nodes{$subnode_of{$node}}) {
	    # In fact, nuke it from %nodes so that we don't include its links,
	    # either
	    delete $nodes{$node};
	    next;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
301
	}
302 303
	# Push the subnode's information into its flags
	push @flags, "subnode_of:$subnode_of{$node}";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
304
    }
305 306 307 308 309

    my $text = "node $node " . join(" ",@types) . " - " . join(" ",@features) .
	" - " . join(" ",@flags);


310
    print "$text\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
311 312
}

313 314 315 316 317 318 319 320 321 322 323 324 325
#
# Widearea Nodes. Includes plab nodes. Note that widearea nodes are never
# allocated directly (they are in a holding experiment), but assign deals
# with it by allocating multiple vnodes on a pnode.
#
# The underlying physnode has to be "up", as determined by the
# autostatus stuff; this will prevent us from allocating a dead
# virtual node to an experiment.  This is especially hacky. We need
# another mechanism for this. We only add virtnodes when assign says
# we need them. This reduces the problem size for assign.
#
if ($widearea) {
    $result =
326
	DBQueryFatal("select count(a.node_id),a.type,a.phys_nodeid,aa.type, ".
327
		     "  ns.status, wn.site ".
328 329 330 331 332 333 334
		     "  from nodes as a ".
 		     "left join reserved as b on a.node_id=b.node_id ".
		     "left join nodes as aa on aa.node_id=a.phys_nodeid ".
		     "left join reserved as m on a.phys_nodeid=m.node_id ".
		     "left join node_status as ns on ".
		     "     a.phys_nodeid=ns.node_id ".
		     "left join node_types as t on t.type=a.type ".
335 336
		     "left join widearea_nodeinfo as wn on ".
		     "     wn.node_id=a.phys_nodeid ".
337 338 339 340 341
		     "where  (a.role='virtnode' and t.isremotenode=1 and ".
		     "        (b.node_id is null and ".
		     "         !(m.pid='$DEADPID' and m.eid='$DEADEID'))) ".
		     "group by a.phys_nodeid");
    
342 343
    while (($count,$type,$physnode,$ptype,$status,$site)
	    = $result->fetchrow_array) {
344 345 346 347 348 349 350 351 352 353 354 355 356
	my @types;
	my @features;
	my @flags;

	$virtnode_capacity = min($count, $virtcapacity{$ptype});

	@types = ("$type:$virtnode_capacity");	

	# Might be equal, which assign would sum as two, not one!
	if ($type ne $classes{$type}) {
	    push(@types, "$classes{$type}:$virtnode_capacity");
	}

357 358 359 360 361 362 363 364 365
	#
	# Mark any nodes that are not up with a feature, so that they won't
	# normally get assigned. We want to include them, though, because we
	# allow people to do fix-node to down nodes
	#
	if ($status && ($status ne 'up')) {
	    push @features, "down:1";
	}

366 367 368 369 370 371 372
	#
	# Mark which site this node belongs to
	#
	if ($site) {
	    push @features, "*&$site:$site_weight";
	}

373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388
	#
	# Add any auxiliary types.
	#
	# XXX These come from the physnode, not the vnode. 
	#
	if ($auxtypes{$physnode}) {
	    foreach my $auxtype (@{$auxtypes{$physnode}}) {
		my ($type,$num) = split(":", $auxtype);

		push(@types, "$type:$virtnode_capacity");
	    }
	}

	# Add trivial bw spec.
	push @flags, "trivial_bw:400000";

389 390 391
	# Indicate that these nodes are beautiful and unique snowflakes
	push @flags, "unique";

392
	# Add features
393 394 395 396 397
	if (defined($type_features{$type})) {
	    push @features, @{$type_features{$type}};
	}
	if (defined($features{$physnode})) {
	    push @features, @{$features{$physnode}};
398 399 400 401 402 403 404 405 406 407
	}

	my $text = "node $physnode " .
	           join(" ",@types) . " - " . join(" ",@features) .
		   " - " . join(" ",@flags);

	print "$text\n";
    }
}

408
# Read interfaces
409
$result = DBQueryFatal("SELECT node_id,card,port,iface,interface_type" .
410
		     " from interfaces");
411
while (($node,$card,$port,$iface,$type) = $result->fetchrow_array) {
412
    $interfacemap{"$node:$card:$port"} = $iface;
Chad Barb's avatar
 
Chad Barb committed
413
    if ((defined $type) && ($type ne "")) {
414 415 416 417 418
	$interfacetypes{"$node:$card:$port"} = $type;
    }
}

# Read interface types
419 420
$result = DBQueryFatal("SELECT type,max_speed from interface_types");
while (($type,$speed) = $result->fetchrow_array) {
421 422 423
    $interfacespeeds{$type} = $speed;
}

424 425 426 427 428 429 430 431 432 433 434 435 436 437 438
# Read interface switches
$result = DBQueryFatal("SELECT node_id1, iface, node_id2 FROM wires AS w " .
	"LEFT JOIN interfaces as i ON w.node_id1=i.node_id AND w.card1=i.card");
while (($node,$iface,$switch) = $result->fetchrow_array) {
    if ($node && $iface) {
	$interfaceswitches{"$node:$iface"} = $switch;
    }
}

# Read interface cards and ports
$result = DBQueryFatal("SELECT node_id, iface, card, port FROM interfaces");
while (($node,$iface,$card,$port) = $result->fetchrow_array) {
    $interfacecardports{"$node:$iface"} = [$card,$port];
}

439
$result = DBQueryFatal("SELECT node_id1,card1,port1,node_id2,card2,port2" .
440
 		    " from wires where type=\"Node\" or type=\"Trunk\"");
441
while (($node1,$card1,$port1,$node2,$card2,$port2) = 
442
       $result->fetchrow_array) {
443
    if ((defined($nodes{$node1}) || defined($switches{$node1})) && 
444
	(defined($nodes{$node2}) || defined($switches{$node2}))) {
445 446 447 448 449 450 451 452 453
	$iface1 = get_iface($node1,$card1,$port1);
	$iface2 = get_iface($node2,$card2,$port2);
	$iface1bw = get_ifacebw($node1,$card1,$port1);
	$iface2bw = get_ifacebw($node2,$card2,$port2);
	if ($iface1bw < $iface2bw) {
	    $bw = $iface1bw;
	} else {
	    $bw = $iface2bw;
	}
454
	if (defined($switches{$node2})) {
455 456
	    $used_switches{$node2} = 1;
	}
457 458 459 460 461 462 463 464 465 466 467 468 469 470
	if (defined($switches{$node1})) {
	    $used_switches{$node1} = 1;
	}
	if (defined($switches{$node1}) && defined($switches{$node2})) {
	    # interswitch link
	    if (defined($interconnects{"$node1:$node2"})) {
		$interconnects{"$node1:$node2"} += $bw;
	    } else {
		$interconnects{"$node1:$node2"} = $bw;
	    }
	} else {
	    # !!! - Here we use our knowledge that in the wires table links
	    # to the switch always come as node2.
	    print "link link-$node1:$iface1-$node2:$iface2 $node1:$node1/$iface1" .
471
		" $node2:$iface2 $bw 0 0 1\n";
472 473
	}
    } 
474
}
475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 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

#
# If we're supposed to track interswitch bandwidth, subtract out the amount
# that's already in use
#
if ($TRACK_INTERSWITCH_BANDWIDTH) {
    #
    # Get a list of all VLANs
    #
    my $result = DBQueryFatal("SELECT virtual, members FROM vlans");
    while (my ($virtual, $members) = $result->fetchrow()) {
	#
	# Split apart the space-separated list of members
	#
	my @members = split /\s+/, $members;
	my %switches = ();
	foreach my $member (@members) {
	    my ($node,$iface) = split /:/, $member;
	    my $switch = get_ifaceswitch($node,$iface);
	    my ($card, $port) = get_ifacecardport($node,$iface);
	    my $bw = get_ifacebw($node,$card,$port);
	    $switches{$switch} += $bw;
	}

	#
	# Check to see if more than one switch was found among the member
	# list, and if so, go through all the pairs
	#
	my @switches = keys %switches;
	if (@switches > 1) {
	    for (my $i = 0; $i < (@switches -1); $i++) {
		my $switch1 = $switches[$i];
		my $switch2 = $switches[$i+1];
		my $bw = $switches{$switch1};
		if ($switches{$switch2} < $bw) {
			$bw = $switches{$switch2};
		}
		#
		# The trunk link could be listed in either order
		#
		if ($interconnects{"$switch1:$switch2"}) {
		    $interconnects{"$switch1:$switch2"} -= $bw;
		} elsif ($interconnects{"$switch2:$switch1"}) {
		    $interconnects{"$switch2:$switch1"} -= $bw;
		}
	    }
	}
    }
}

525 526
foreach $interconnect (keys(%interconnects)) {
    ($src,$dst) = split(":",$interconnect);
527
    print "link link-$interconnect $src $dst $interconnects{$interconnect} 0 0 1\n";
528
}
529

530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550
# Print out links
sub get_iface {
    ($node,$card,$port) = @_;
    if (defined($interfacemap{"$node:$card:$port"})) {
	return $interfacemap{"$node:$card:$port"};
    } else {
	# shark hack
	if ($node =~ /^sh/) {
	    return "eth0";
	} else {
	    return "(null)";
	}
	# end shark hack 
    }
};

# Find the bandwidth for an interface
sub get_ifacebw {
    ($node,$card,$port) = @_;
    if (defined($interfacetypes{"$node:$card:$port"})) {
	return $interfacespeeds{$interfacetypes{"$node:$card:$port"}};
551 552 553
    }
    else {
	return $default_switchport_speed;
554 555
    }
}
556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573

sub get_ifaceswitch {
    ($node,$iface) = @_;
    if (defined($interfaceswitches{"$node:$iface"})) {
	return $interfaceswitches{"$node:$iface"};
    } else {
	return undef;
    }
}

sub get_ifacecardport {
    ($node,$iface) = @_;
    if (defined($interfacecardports{"$node:$iface"})) {
	return @{$interfacecardports{"$node:$iface"}};
    } else {
	return ();
    }
}