ptopgen.in 15.1 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
#
# 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 =
320
321
	DBQueryFatal("select count(a.node_id),a.type,a.phys_nodeid,aa.type, ".
		     "  ns.status ".
322
323
324
325
326
327
328
329
330
331
332
333
		     "  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 ".
		     "        (b.node_id is null and ".
		     "         !(m.pid='$DEADPID' and m.eid='$DEADEID'))) ".
		     "group by a.phys_nodeid");
    
334
    while (($count,$type,$physnode,$ptype,$status) = $result->fetchrow_array) {
335
336
337
338
339
340
341
342
343
344
345
346
347
	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");
	}

348
349
350
351
352
353
354
355
356
	#
	# 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";
	}

357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
	#
	# 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";

373
374
375
	# Indicate that these nodes are beautiful and unique snowflakes
	push @flags, "unique";

376
	# Add features
377
378
379
380
381
	if (defined($type_features{$type})) {
	    push @features, @{$type_features{$type}};
	}
	if (defined($features{$physnode})) {
	    push @features, @{$features{$physnode}};
382
383
384
385
386
387
388
389
390
391
	}

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

	print "$text\n";
    }
}

392
# Read interfaces
393
$result = DBQueryFatal("SELECT node_id,card,port,iface,interface_type" .
394
		     " from interfaces");
395
while (($node,$card,$port,$iface,$type) = $result->fetchrow_array) {
396
    $interfacemap{"$node:$card:$port"} = $iface;
Chad Barb's avatar
   
Chad Barb committed
397
    if ((defined $type) && ($type ne "")) {
398
399
400
401
402
	$interfacetypes{"$node:$card:$port"} = $type;
    }
}

# Read interface types
403
404
$result = DBQueryFatal("SELECT type,max_speed from interface_types");
while (($type,$speed) = $result->fetchrow_array) {
405
406
407
    $interfacespeeds{$type} = $speed;
}

408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
# 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];
}

423
$result = DBQueryFatal("SELECT node_id1,card1,port1,node_id2,card2,port2" .
424
 		    " from wires where type=\"Node\" or type=\"Trunk\"");
425
while (($node1,$card1,$port1,$node2,$card2,$port2) = 
426
       $result->fetchrow_array) {
427
    if ((defined($nodes{$node1}) || defined($switches{$node1})) && 
428
	(defined($nodes{$node2}) || defined($switches{$node2}))) {
429
430
431
432
433
434
435
436
437
	$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;
	}
438
	if (defined($switches{$node2})) {
439
440
	    $used_switches{$node2} = 1;
	}
441
442
443
444
445
446
447
448
449
450
451
452
453
454
	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" .
455
		" $node2:$iface2 $bw 0 0 1\n";
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
500
501
502
503
504
505
506
507
508

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

509
510
foreach $interconnect (keys(%interconnects)) {
    ($src,$dst) = split(":",$interconnect);
511
    print "link link-$interconnect $src $dst $interconnects{$interconnect} 0 0 1\n";
512
}
513

514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
# 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"}};
535
536
537
    }
    else {
	return $default_switchport_speed;
538
539
    }
}
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557

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