psonar_auto.pl
This script automates the whole process of finding new PerfSonar landmarks. It works as follows:
- Fetch the list of all PerfSONAR sites from http://132.160.6.186/toolkit/gui/perfAdmin/directory.cgi
- Find the sites that have working traceroute server.
- Then find the sites that also have location information at http://ipaddress/toolkit, e.g. http://132.160.6.186/toolkit/
- Compare the final list of working nodes to the ones in TULIP database to list the new sites.
The script is located at : /afs/slac.stanford.edu/package/pinger/tulip/psonar_auto.pl
Multiple text files are generated in the /tmp directory
- perfsonar_list.txt -> complete list of PerfSONAR sites
- perfsonar_list_working.txt -> sites with working traceroute server
- perfsonar_list_working_wl.txt -> sites with working traceroute server and location information
The following file is the most important and is generated in /afs/slac.stanford.edu/package/pinger/tulip/ .
- perfsonar_list_new.txt -> working Perfsonar sites that are not in TULIP DB. The format is: ipaddr | city | state | country | lat | long
Since it requires access to TULIP DB, it must be run from pinger@pinger.
History
- 92 landmarks added on 4-3-14 (Asad)
- 94 landmarks added on 1-8-14 (Asad)
- 56 landmarks added on 1-9-14 (Asad)
- 7 landmarks added on 1-10-14 (Asad)
trscrontab
This script runs at the start of each month from trscrontab.
perfdb.pl
This script is written to facilitate the process of adding newly found perfSONAR landmarks to TULIP MySQL database. Before running perfdb.pl one must load perfsonar_list_new.txt (generated by psonar_auto.pl) in MS Excel. When loading the text file choose both 'tab' and 'comma' as delimiting characters. Now most of rows would have this format:
IP Addr | City | State | Country | Latitude | Longitude
However the format required by perfdb.pl is:
IP Addr | City | Country | Region | Latitude | Longitude
Where the region could be Europe, North America, Latin America, S.E. Asia, South Asia, East Asia, Russia, Africa, Taiwan, Australia e.t.c. New regions could be defined provided we have sufficient landmarks.
The excel file should be manually checked to ensure that all the landmarks entries are correct. It is not uncommon for the coordinates to be incorrect. In most of the cases the error would be due to a typo and can be fixed easily. Check for the following:
- Latitude and Longitude swapped
- Missing - negative sign
- single digit typo
It is best to delete landmark entries which have their coordinates as whole integers since this location might be inaccurate to over 100 kilometers.
The final excel file should be saved in tab separated format .txt (tsv). The path of this file should be provided in perfdb.pl (line 63) and finally the script can be executed.
script location: /nfs/slac/g/net/pinger/tulip/
Disclaimer: This script can cause serious damage if improperly used. You have been warned !!
--Subject to change