ptopgen.in 14.8 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
my $TBROOT = "@prefix@";
47
use lib '@prefix@/lib';
48
require exitonwarn;
49
use libdb;
Leigh B. Stoller's avatar
Leigh B. Stoller committed
50

51 52
my $TRACK_INTERSWITCH_BANDWIDTH = "@TRACK_INTERSWITCH_BANDWIDTH@";

53 54 55
my %switches	  = ();
my %used_switches = ();
my %permissions   = ();
56

57 58 59
my $DEADPID = NODEDEAD_PID();
my $DEADEID = NODEDEAD_EID();

60
my $pid;
61
my $exempt_eid;
62
my $switchtouse;
63

64 65 66 67 68 69 70 71 72 73 74 75 76 77
#
# 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"};
}
78 79 80
if (defined($options{"m"})) {
    $mfactor = $options{"m"};
}
81 82 83
if (defined($options{"v"})) {
    $virtstuff = 1;
}
84 85 86
if (defined($options{"r"})) {
    $widearea = 1;
}
87 88 89
if (defined($options{"p"})) {
    $pid = $options{"p"};
}
90
if (defined($options{"e"})) {
91 92 93
    $exempt_eid = $options{"e"};
    usage()
	if (!defined($pid));
94 95
}

96
# Read class/type maps
97 98 99 100
my $result =
    DBQueryFatal("select class,type,delay_capacity,virtnode_capacity ".
		 "from node_types");
while (($class,$type,$delaycapacity,$vcap) = $result->fetchrow_array) {
101
    $classes{$type} = $class;
102
    $nodetypes{$type} = $delaycapacity;
103
    $virtcapacity{$type} = $vcap;
104 105 106 107 108 109 110 111 112 113 114

    # 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()) {
115 116 117 118
    if (! defined($type_features{$type})) {
	$type_features{$type} = ["$feature:$weight"];
    } else {
	push @{$type_features{$type}}, "$feature:$weight";
119 120 121
    }
}

122 123 124 125 126 127 128 129 130 131 132 133
#
# 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";
    }
}
134 135 136 137 138 139 140 141 142 143 144
#
# 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";
}
145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164
#
# 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;
    }
165 166 167 168 169
}

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

170
# Print switches
171
if (defined($switchtouse)) {
172
    print "node $switchtouse switch:1 *lan:*\n";
173 174 175 176 177 178 179
    $switches{$switchtouse} = 1;
}
else {
    $result =
	DBQueryFatal("select node_id from nodes where role = \"testswitch\"");

    while (($switch) = $result->fetchrow_array) {
180
	print "node $switch switch:1 *lan:*\n";
181 182
	$switches{$switch} = 1;
    }
183
}
184

185
# Find available nodes.
186
#
187 188
# This first query deals with just local nodes. Local nodes can host
# virtnodes, according to the delay_capacity in the types table. 
189
#
190

191
# the ordinary free condition for a local node.
192 193 194 195 196 197
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 ".
198
	"(b.pid='$pid' and b.eid='$exempt_eid'))"; 
199
}
Chad Barb's avatar
Chad Barb committed
200

201
$result =
202 203
    DBQueryFatal("select a.node_id,a.type,a.phys_nodeid,t.class,t.issubnode " .
		 "from nodes as a ".
204 205
		 "left join reserved as b on a.node_id=b.node_id ".
		 "left join reserved as m on a.phys_nodeid=m.node_id ".
206
		 "left join node_types as t on t.type=a.type ".
207
		 "where $free_condition and ".
208
		 "      (a.role='testnode' and t.isremotenode=0)");
Leigh B. Stoller's avatar
Leigh B. Stoller committed
209

210 211 212
#
# 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
213 214 215
# to use all nodes), or if there is no entry in the perms table for
# the type/class of node.
#
216
while (($node,$type,$physnode,$class,$issubnode) = $result->fetchrow_array) {
217 218 219
    $nodes{$node} = $type
	if (!defined($pid) ||
	    ($permissions{$type} && $permissions{$class}));
220 221 222
    if ($issubnode) {
	$subnode_of{$node} = $physnode;
    }
223
}
Leigh B. Stoller's avatar
Leigh B. Stoller committed
224 225

foreach $node (keys(%nodes)) {
226 227
    my $type = $nodes{$node};
    
228
    my @types = ("$type:1");
229 230 231
    my @features;
    my @flags;

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

237 238 239 240
    $delay_capacity = $nodetypes{$type};
    $virtnode_capacity = $virtcapacity{$type};
    
    if ($delay_capacity > 0) {
241
	push @types, "delay:$delay_capacity";
242
	    
243 244 245 246 247 248 249 250
	#################################################################
	### 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
	#################################################################
251
	push @types, "sim:100000";
252
    }
253

254 255 256 257 258 259 260
    #
    # Add any auxiliary types
    #
    if ($auxtypes{$node}) {
	push @types, @{$auxtypes{$node}};
    }

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

    # Add features
277 278 279 280 281
    if (defined($type_features{$type})) {
	push @features, @{$type_features{$type}};
    }
    if (defined($features{$node})) {
	push @features, @{$features{$node}};
282 283 284 285 286 287 288 289 290 291 292 293 294
    }

    #
    # 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
295
	}
296 297
	# Push the subnode's information into its flags
	push @flags, "subnode_of:$subnode_of{$node}";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
298
    }
299 300 301 302 303

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


304
    print "$text\n";
Leigh B. Stoller's avatar
Leigh B. Stoller committed
305 306
}

307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363
#
# 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 =
	DBQueryFatal("select count(a.node_id),a.type,a.phys_nodeid,aa.type ".
		     "  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 ".
		     "where  (a.role='virtnode' and t.isremotenode=1 and ".
		     "        ns.status='up' and ".
		     "        (b.node_id is null and ".
		     "         !(m.pid='$DEADPID' and m.eid='$DEADEID'))) ".
		     "group by a.phys_nodeid");
    
    while (($count,$type,$physnode,$ptype) = $result->fetchrow_array) {
	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");
	}

	#
	# 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";

364 365 366
	# Indicate that these nodes are beautiful and unique snowflakes
	push @flags, "unique";

367
	# Add features
368 369 370 371 372
	if (defined($type_features{$type})) {
	    push @features, @{$type_features{$type}};
	}
	if (defined($features{$physnode})) {
	    push @features, @{$features{$physnode}};
373 374 375 376 377 378 379 380 381 382
	}

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

	print "$text\n";
    }
}

383
# Read interfaces
384
$result = DBQueryFatal("SELECT node_id,card,port,iface,interface_type" .
385
		     " from interfaces");
386
while (($node,$card,$port,$iface,$type) = $result->fetchrow_array) {
387
    $interfacemap{"$node:$card:$port"} = $iface;
Chad Barb's avatar
 
Chad Barb committed
388
    if ((defined $type) && ($type ne "")) {
389 390 391 392 393
	$interfacetypes{"$node:$card:$port"} = $type;
    }
}

# Read interface types
394 395
$result = DBQueryFatal("SELECT type,max_speed from interface_types");
while (($type,$speed) = $result->fetchrow_array) {
396 397 398
    $interfacespeeds{$type} = $speed;
}

399 400 401 402 403 404 405 406 407 408 409 410 411 412 413
# 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];
}

414
$result = DBQueryFatal("SELECT node_id1,card1,port1,node_id2,card2,port2" .
415
 		    " from wires where type=\"Node\" or type=\"Trunk\"");
416
while (($node1,$card1,$port1,$node2,$card2,$port2) = 
417
       $result->fetchrow_array) {
418
    if ((defined($nodes{$node1}) || defined($switches{$node1})) && 
419
	(defined($nodes{$node2}) || defined($switches{$node2}))) {
420 421 422 423 424 425 426 427 428
	$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;
	}
429
	if (defined($switches{$node2})) {
430 431
	    $used_switches{$node2} = 1;
	}
432 433 434 435 436 437 438 439 440 441 442 443 444 445
	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" .
446
		" $node2:$iface2 $bw 0 0 1\n";
447 448
	}
    } 
449
}
450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 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

#
# 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;
		}
	    }
	}
    }
}

500 501
foreach $interconnect (keys(%interconnects)) {
    ($src,$dst) = split(":",$interconnect);
502
    print "link link-$interconnect $src $dst $interconnects{$interconnect} 0 0 1\n";
503
}
504

505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525
# 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"}};
526 527 528
    }
    else {
	return $default_switchport_speed;
529 530
    }
}
531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548

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 ();
    }
}