We are using PingER and PlanetLab landmarks for geolocation in TULIP. PlanetLab landmarks are manually updated with the help of perl script "insert_planetlab.pl" which is under the tulip directory /afs/slac.stanford.edu/package/pinger/tulip. This script loops over monthly active hosts in PlanetLab and inserts new one based on thier their availability. PingER nodes are updated with the help of automated script "create_sites-xml"(updated by trscrontab job running at 2:40am in pinger@pinger.slac.stanford.edu) which is located under TULIP directory.
...
| Code Block |
|---|
+----------------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------+------+-----+---------------------+-------+ | nodeID | int(11) | | | 0 | | | name | varchar(80) | | | | | | hostName | varchar(80) | YES | | NULL | | | ipv4Addr | varchar(15) | YES | | NULL | | | domain | varchar(80) | YES | | NULL | | | description | varchar(200) | YES | | NULL | | | pingerNickname | varchar(50) | YES | | NULL | | | pingerMonitor | tinyint(1) | YES | | NULL | | | pingerBeacon | tinyint(1) | YES | | NULL | | | notCheckedAtSlac | tinyint(1) | YES | | NULL | | | enabled | tinyint(1) | YES | | 1 | | | institution | varchar(100) | YES | | NULL | | | city | varchar(100) | YES | | NULL | | | state | varchar(100) | YES | | NULL | | | country | varchar(100) | YES | | NULL | | | continent | varchar(100) | YES | | NULL | | | latitude | float | YES | | NULL | | | longitude | float | YES | | NULL | | | serviceInterfaceType | varchar(30) | YES | | NULL | | | planetLabScript | varchar(120) | YES | | NULL | | | pingURL | varchar(120) | YES | | NULL | | | tracerouteURL | varchar(120) | YES | | NULL | | | pingPacketSize | int(11) | YES | | NULL | | | tulipScalingFactor | smallint(6) | YES | | NULL | | | tulipTier | smallint(6) | YES | | NULL | | | lastUpdateDate | timestamp | YES | | 0000-00-00 00:00:00 | | | comments | text | YES | | NULL | | +----------------------+--------------+------+-----+---------------------+-------+ |
- As it is evident there There are some mandatory fields mentioned in underline point are required to make the TULIP work.
- hostName, ipv4Addr, enabled (1 or 0), latitude, longitude, serviceInterfaceType(PingER/PlanetLab) ,tracerouteURL and tulipTier
- Additionally we can also give city,country,state,institution etc
- Process for making change in database
- Login to tulip database (username and password available in escrow -c iepm iepmacct
- Change the database to tulip by cmd
Code Block mysql> use tulip;
- Now insert new records using the following sql cmd; in this instance we are using ipv4Addr = 141.22.213.35; generally ipv4Addr is the primary key but we can also use hostName as an identifier to disable landmarks
Code Block insert into landmarks (hostName,ipv4Addr,enabled,latitude,longitude,serviceInterfaceType,tracerouteURL,tulipTier) values ('mars.planetlab.haw-hamburg.de','141.22.213.35','1','53.55','10','PlanetLab','141.22.213.35','1');- Update Sites.xml so that it can now use the updated landmarks using following cmd
Code Block create_sites-xml.pl > /afs/slac/www/comp/net/wan-mon/tulip/sites.xml