Versions Compared

Old Version 12

changes.mady.by.user Unknown User (lone)

Saved on

compared with

New Version 13

changes.mady.by.user Les Cottrell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. There are some mandatory fields required to make the TULIP work.
    1. hostName, ipv4Addr, enabled (1 or 0), latitude, longitude, serviceInterfaceType(PingER/PlanetLab) ,tracerouteURL and tulipTier
    2. Additionally we can also give city,country,state,institution etc
  2. Process for making change in database
    1. Login to tulip database (username and password available in escrow -c iepm iepmacct
    2. Code Block
      
24cottrell@pinger:~>mysql -u root -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>
    3. Change the database to tulip by cmd
    4. Code Block
      mysql> use tulip;
Database changed
  3. Now insert new records using the following sql cmd; in this instance we are using ipv4Addr = 141.22.213.35;
  4. 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');
  5. 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