...
- There are some mandatory fields required to make the TULIP work. 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 Note: It works from pinger@pinger.slac.stanford.edu
The password is in escrow edit -c iepm iepmacctCode Block 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>
or can be obtained by calling (assuming you have the right AFS privs):
or by looking in /afs/slac/package/pinger/tulip/dbPwd/pws-tulipCode Block require "/afs/slac/g/scs/net/pinger/bin/admin.pl";\\ my $wrdw = >pwd('tulip');
- Change the database to tulip by cmd
Code Block mysql> use scs_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,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');
- 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 cmd Note: you might have to execute kinit and enter pinger password to get permission.
Code Block /afs/slac/package/pinger/tulip/create_sites-xml.pl >\ ! /afs/slac/www/comp/net/wan-mon/tulip/sites.xml
...