...
Code Block |
---|
+----------------------+--------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default | Extra Required| +----------------------+--------------+------+-----+---------------------+-------+ | nodeID | int(11) | | | 0 | | 0 | | name | varchar(80) | | | | | 0 | | hostName | varchar(80) | YES | | NULL | | 1 | | ipv4Addr | varchar(15) | YES | | NULL | 1 | | domain | varchar(80) | YES | | NULL | | 1 | | description | varchar(200) | YES | | NULL | | 0 | | pingerNickname | varchar(50) | YES | | NULL | | 0 | | pingerMonitor | tinyint(1) | YES | | NULL | | 0 | | pingerBeacon | tinyint(1) | YES | | NULL | | 0 | | notCheckedAtSlac | tinyint(1) | YES | | NULL | | 0 | | enabled | tinyint(1) | YES | | 1 | | 1 | | institution | varchar(100) | YES | | NULL | | 1 | | city | varchar(100) | YES | | NULL | | 1 | | state | varchar(100) | YES | | NULL | | 0 | | country | varchar(100) | YES | | NULL | | 1 | | continent | varchar(100) | YES | | NULL | | 1 | | latitude | float | YES | | NULL | | 1 | | longitude | float | YES | | NULL | | 1 | | serviceInterfaceType | varchar(30) | YES | | NULL | | 1 | | planetLabScript | varchar(120) | YES | | NULL | | 0 | | pingURL | varchar(120) | YES | | NULL | | 1 | | tracerouteURL | varchar(120) | YES | | NULL | | 1 | | pingPacketSize | int(11) | YES | | NULL | | 0 | | tulipScalingFactor | smallint(6) | YES | | NULL | | 0 | | tulipTier | smallint(6) | YES | | NULL | | 1 | | lastUpdateDate | timestamp | YES | | 0000-00-00 00:00:00| | 0 | | comments | text | YES | | NULL | | 0 | +----------------------+--------------+------+-----+---------------------+-------+ |
- There are some mandatory fields 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. The list is given in the Required column of above table.
- Process for making change in database
- Login to tulip database (username and password available in escrow -c iepm iepmacct
Code Block 24cottrell@pinger:~>mysql -u tulip -p tulip Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 664 to server version: 4.1.22-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
- Change the database to tulip by cmd
Code Block mysql> use tulip; Database changed
- Now insert new records using the following sql cmd; in this instance we are using ipv4Addr = 141.22.213.35;
Code Block insert into landmarks (hostName,ipv4Addr,enabled,latitude,longitude,serviceInterfaceType,tracerouteURL,tulipTier,domain) values ('mars.planetlab.haw-hamburg.de','141.22.213.35','1','53.55','10','PlanetLab','141.22.213.35','1','haw-hamburg.de');
- Or you can update an existing record, e.g.
Code Block mysql> update landmarks set latitude=31.4190 and longitude=-122.2017 where hostname like '%www-wanmon.slac.stanford.edu%'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0
- 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