...
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 The text file should be manually check 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
- one 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 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 !!
--to be continued