...
We can also update landmarks manually using the following process. To update/add new nodes first we need to skim through the table schema to get to know mandatory and optional fields. Schema for reffernce is as under
| 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 are some mandatory fields, which are required to make the TULIP work.Before adding you must check that you have everything in point (2a)
- hostName,ipv4Addr,enabled (1 or 0) ,latitude,longitude,serviceInterfaceType(PingER/PlanetLab),tracerouteURL and tulipTier
- Additionaly 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 follwing cmd
Code Block create_sites-xml.pl > /afs/slac/www/comp/net/wan-mon/tulip/sites.xml