...
| 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",
"http://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@vedge,@edge),
(<at:var at:name="vborder," />border@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, "http://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');
|
...
Application | Description |
|---|---|
terapathsWebInterface | Web frontend to terapaths |
terapathsInternalWebServices | |
terapathsPublicWebServices | |
terapathsESnetOSCARSProxy | Interaction with OSCARS |
terapathsRemoteTPsListeners | Interaction with other terapaths instances |
terapathsNetworkDeviceControllers | Router interactions |
Web Interface
Located at
http://192.124.59.130:40860/terapathsWebInterface
You can log in using accounts that have been setup in the MySQL table 'users'; if you can't log on, that's because you don't have an account in the database.
...
Getting the DOE Certificate
Use firefox.
- Request a new certificate
- add the certificate to your browser by going to
http://pki1.doegrids.org/ca
...
- : Go to 'Retrieval' -> 'Import CA Certificate Chain' -> 'Import the CA certificate chain into your browser' -> 'Submit'
- when you get an email back from the DOE, click on the link to retrieve your certificate; scroll to the bottom and click on 'import your certificate'
- in firefox preferences' 'advanced' -> 'encryption' -> 'view certificates'
Select your certificate and click on 'backup'
...