...
| Code Block |
|---|
--
-- Populate the TeraPaths database for the TeraPaths UMich-side secure testbed
-- MySQL server on tera01.ultralight.org (192.84.86.25)
-- Database structure version 1.2.0
-- 01/23/07
--
USE terapaths;
--
-- database settings
--
INSERT INTO terapathsDatabaseInfo (
version,
creationTimeStamp,
serverIpAddress,
serverName,
siteName
) VALUES (
"1.2.0",
NOW(),
"192.124.59.130",
"terapaths.slac.stanford.edu",
"SLAC"
);
--
-- drivers for communication between instance and router
INSERT INTO routerDrivers (
name,
driverInfo
) VALUES (
"DUMMY_DRIVER",
"hardware,DUMMY,type,DUMMY,os,DUMMY,comm_protocol,DUMMY"
);
INSERT INTO routerDrivers (
name,
driverInfo
) VALUES (
"CISCO_WS-C6509_IOS_TELNET",
"hardware,CISCO,type,WS-6509,os,IOS,comm_protocol,TELNET"
);
INSERT INTO routerDrivers (
name,
driverInfo
) VALUES (
"CISCO_WS-C6509_IOS_SSH",
"hardware,CISCO,type,WS-6509,os,IOS,comm_protocol,SSH"
);
SELECT @driver := LAST_INSERT_ID();
--
-- terapath instance, and endpoint to communicate to
--
INSERT INTO routerManagers (
ipAddress,
name,
wsdlURL,
interface,
managerDir
) VALUES (
"192.124.59.130",
"terapaths01.slac.stanford.edu",
"httpshttp://192.124.59.130:48580/terapathsNetworkDeviceControllers/tpsNDC",
"GigabitEthernet3/33",
"/home/terapaths/routerConfig"
);
SELECT @edgeManager := LAST_INSERT_ID();
SELECT @borderManager := @edgeManager;
--
-- routers
--
INSERT INTO routers (
ipAddress,
name,
routerInfo,
driverParameters,
driverId,
managingNodeId,
position
) VALUES (
"192.124.59.129",
"tera",
"hardware,CISCO,type,WS-6509,os,IOS12.2(18)SXD1",
"system_prompt,tera,terapaths,XXXXXXX,entry_pass,XXXXXXX,enable_pass,XXXXXXX,policy_name_root,QoS_nile",
@driver,
@edgeManager,
"edge"
);
SELECT @edge := LAST_INSERT_ID();
SELECT @border := @edge;
INSERT INTO virtualRouters (
name
) VALUES (
"tera (physical-edge)"
);
SELECT @vedge := LAST_INSERT_ID();
INSERT INTO virtualRouters (
name
) VALUES (
"nile (physical-border)"
);
SELECT @vborder := LAST_INSERT_ID();
INSERT INTO virtualRouterMembers (
virtualRouterId,
routerId
) VALUES
(<at:var at:name="vedge," />edge),
(<at:var at:name="vborder," />border);
INSERT INTO routes (
edge,
border
) VALUES (
@vedge,
@vborder
);
SELECT @route := LAST_INSERT_ID();
--
-- worker nodes
---
INSERT INTO hosts (
ipAddress,
name,
route,
interface
) VALUES
("192.124.59.200", "node00.slac.stanford.edu", @route, "GigabitEthernet3/4"),
("192.124.59.201", "node01.slac.stanford.edu", @route, "GigabitEthernet3/5"),
("192.124.59.202", "node02.slac.stanford.edu", @route, "GigabitEthernet3/6"),
("192.124.59.203", "node03.slac.stanford.edu", @route, "GigabitEthernet3/7"),
("192.124.59.204", "node04.slac.stanford.edu", @route, "GigabitEthernet3/8"),
("192.124.59.205", "node05.slac.stanford.edu", @route, "GigabitEthernet3/9"),
("192.124.59.206", "node06.slac.stanford.edu", @route, "GigabitEthernet3/10"),
("192.124.59.207", "node07.slac.stanford.edu", @route, "GigabitEthernet3/11"),
("192.124.59.208", "node08.slac.stanford.edu", @route, "GigabitEthernet3/12");
INSERT INTO remoteLANServiceURL (
ipAddress,
mask,
maskedIpAddress,
prefix,
wsdlURL,
preference
) VALUES
("198.124.220.0", "255.255.255.0", ipAddr2dec("198.124.220.0")&ipAddr2dec("255.255.255.0"), 24, "httpshttp://198.124.220.9:48588/terapathsRemoteTPsListeners/tpsRTPsL"
, 0);
INSERT INTO WANServiceURL (
ipAddress,
mask,
maskedIpAddress,
prefix,
wsdlURL,
preference
) VALUES
("198.124.220.0", "255.255.255.0", ipAddr2dec("198.124.220.0")&ipAddr2dec("255.255.255.0"), 24, "OSCARS,https://oscars.es.net/axis2/services/OSCARS", 0);
INSERT INTO diffServClasses (
name,
dscp,
aggregateBandwidth,
configured,
active
) VALUES
("BE",0,0,0,0),
("CS01",1,0,0,0),
("CS02",2,0,0,0),
("CS03",3,0,0,0),
("CS04",4,0,0,0),
("CS05",5,0,0,0),
("CS06",6,0,0,0),
("CS07",7,0,0,0),
("CS1",8,0,0,0),
("CS11",9,0,0,0),
("AF11",10,0,0,0),
("CS13",11,0,0,0),
("AF12",12,0,0,0),
("CS15",13,0,0,0),
("AF13",14,0,0,0),
("CS17",15,0,0,0),
("CS2",16,0,0,0),
("CS21",17,0,0,0),
("AF21",18,0,0,0),
("CS23",19,0,0,0),
("AF22",20,0,0,0),
("CS25",21,0,0,0),
("AF23",22,0,0,0),
("CS27",23,0,0,0),
("CS3",24,0,0,0),
("CS31",25,0,0,0),
("AF31",26,0,0,0),
("CS33",27,0,0,0),
("AF32",28,0,0,0),
("CS35",29,0,0,0),
("AF33",30,0,0,0),
("CS37",31,0,0,0),
("CS4",32,0,0,0),
("CS41",33,0,0,0),
("AF41",34,0,0,0),
("CS43",35,0,0,0),
("AF42",36,0,0,0),
("CS45",37,0,0,0),
("AF43",38,0,0,0),
("CS47",39,0,0,0),
("CS5",40,0,0,0),
("CS51",41,0,0,0),
("CS52",42,0,0,0),
("CS53",43,0,0,0),
("CS54",44,0,0,0),
("CS55",45,0,0,0),
("EF",46,0,0,0),
("CS57",47,0,0,0),
("CS6",48,0,0,0),
("CS61",49,0,0,0),
("CS62",50,0,0,0),
("CS63",51,0,0,0),
("CS64",52,0,0,0),
("CS65",53,0,0,0),
("CS66",54,0,0,0),
("CS67",55,0,0,0),
("CS7",56,0,0,0),
("CS71",57,0,0,0),
("CS72",58,0,0,0),
("CS73",59,0,0,0),
("CS74",60,0,0,0),
("CS75",61,0,0,0),
("CS76",62,0,0,0),
("CS77",63,0,0,0);
--Simple partitioning of bandwidth for testbed's 1 Gbit connection
UPDATE diffServClasses SET aggregateBandwidth= 15000000, configured=1 WHERE name="CS1";
UPDATE diffServClasses SET aggregateBandwidth= 20000000, configured=1 WHERE name="AF11";
UPDATE diffServClasses SET aggregateBandwidth= 40000000, configured=1 WHERE name="CS2";
UPDATE diffServClasses SET aggregateBandwidth= 50000000, configured=1 WHERE name="AF21";
UPDATE diffServClasses SET aggregateBandwidth= 75000000, configured=1 WHERE name="AF31";
UPDATE diffServClasses SET aggregateBandwidth=100000000, configured=1 WHERE name="AF41";
UPDATE diffServClasses SET aggregateBandwidth=150000000, configured=1 WHERE name="CS47";
UPDATE diffServClasses SET aggregateBandwidth=200000000, configured=1 WHERE name="EF";
UPDATE diffServClasses SET aggregateBandwidth=250000000, configured=1 WHERE name="CS7";
INSERT INTO bandwidthClasses (
name,
diffServClassId,
bandwidth,
type,
configured,
active
) VALUES
("CS1_1",(SELECT id FROM diffServClasses WHERE name="CS1"), 5000000,"shared",1,0),
("CS1_2",(SELECT id FROM diffServClasses WHERE name="CS1"), 5000000,"shared",1,0),
("CS1_3" ,(SELECT id FROM diffServClasses WHERE name="CS1"), 5000000,"shared",1,0),
("AF11_1",(SELECT id FROM diffServClasses WHERE name="AF11"),10000000,"shared",1,0),
("AF11_2",(SELECT id FROM diffServClasses WHERE name="AF11"),10000000,"shared",1,0),
("CS2_1",(SELECT id FROM diffServClasses WHERE name="CS2"), 20000000,"shared",1,0),
("CS2_2",(SELECT id FROM diffServClasses WHERE name="CS2"), 20000000,"shared",1,0),
("AF21",(SELECT id FROM diffServClasses WHERE name="AF21"), 50000000,"static",1,0),
("AF31",(SELECT id FROM diffServClasses WHERE name="AF31"), 75000000,"static",1,0),
("AF41",(SELECT id FROM diffServClasses WHERE name="AF41"), 100000000,"static",1,0),
("CS47",(SELECT id FROM diffServClasses WHERE name="CS47"), 150000000,"static",1,0),
("EF",(SELECT id FROM diffServClasses WHERE name="EF"), 200000000,"static",1,0),
("CS7",(SELECT id FROM diffServClasses WHERE name="CS7"), 250000000,"static",1,0);
--Default user
INSERT INTO users (
userName,
passWord,
type
) VALUES
('terapaths',PASSWORD('*******'),'standard');
|
...
| Code Block |
|---|
[yee@terapaths dist]$ cat terapaths.properties ################################################### # Change this file to match your host information # ################################################### # driver.for.host.localhostterapaths = com.mysql.jdbc.Driver db.for.host.localhostterapaths = jdbc:mysql://localhost/terapaths?user=terapaths&password=******** pws.for.host.localhostterapaths = https://localhost:40860/terapathsPublicWebServices/tpsPWS iws.for.host.localhostterapaths = https://localhost:40860/terapathsInternalWebServices/tpsIWS OSCARS.for.host.localhostterapaths = https://localhost:40860/terapathsESnetOSCARSProxy/ESnetOSCARSProxy ################################################ # Add other hosts here by specifying same five # # values as above for each host # ################################################ |
...
| Code Block |
|---|
[yee@terapaths dist]$ cat terapathsWebInterfaceDefaults ################################## # Defaults for the web interface # # This file must be in the # # /home/terapaths directory # # ORDER IS IMPORTANT!!! # ################################## # default web interace value # 1. source IP address 192.124.59.200 # 2. destination IP address # 198.124.220.134 192.124.59.200204 # 3. source low port # 10000 # 4. source high port # 10000 # 5. destination low port # 10000 # 6. destination high port # 10000 # 7. protocol tcp # 8. reservation direction bidirectional # 9. time span for schedule day |
...