Page History

...

1. There are some mandatory fields required to make the TULIP work. The list is given in the Required column of above table.
2. Process for making change in database
   1. Login to tulip database (username and password available in escrow -c iepm iepmacct Note: It works from pinger@pinger.slac.stanford.edu 

   2. Code Block

      24cottrell@pinger:~>mysql -u tulip -p tulip 24cottrell@pinger:~>mysql -h mysql-node01 -P 3307 -u scs_tulip_u -p scs_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>

      The password is in escrow edit -c iepm iepmacct
      or can be obtained by calling (assuming you have the right AFS privs):

      Code Block
      require "/afs/slac/g/scs/net/pinger/bin/admin.pl";\\ my $wrdw = &gtpwd('tulip');

      or by looking in /afs/slac/package/pinger/tulip/dbPwd/pws-tulip
   3. Change the database to tulip by cmd

   4. Code Block
      mysql> use scs_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,domain,pingURL,city,country,continent) values ('pinger.stanford.edu','171.66.6.39', 1 ,'37.4285','-122.178','PingER', 'http://pinger.stanford.edu/cgi-bin/traceroute.pl?','1','stanford.edu', 'http://pinger.stanford.edu/cgi-bin/traceroute.pl?function=ping','Menlo Park','United States','North America');

5. Or you can update an existing record, e.g.

6. Code Block
   mysql> update landmarks set latitude='31.4190 and longitude=-122.2017 where \' where hostname like '%www-wanmon.slac.stanford.edu%'; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0

7. Update Sites.xml so that it can now use the updated landmarks using following cmd cmd Note: you might have to execute kinit and enter pinger password to get permission.

8. Code Block
   /afs/slac/package/pinger/tulip/create_sites-xml.pl >\ ! /afs/slac/www/comp/net/wan-mon/tulip/sites.xml

...