#    Copyright 2011 Merijntje Tak
#
#    This program is free software: you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by
#    the Free Software Foundation, version 3 of the License.
#
#    This program is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU General Public License for more details.
#
#    You should have received a copy of the GNU General Public License
#    along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
##############################################################################
#
#    tracestore.pl - Store traceroutes based on NetFlow data
#
#   This scripts processes a flowd database file, gets a list of all hosts 
#    contacted, does a traceroute to them and stores the result in a database.
#    This data can later be analyzed to, for example, map your ISP's AS 
#    paths.
#
#    Usage:
#     1. Start flowd and let it collect flows (see flowd man page)
#     1. Configure the variables in the script
#     2. Run the script
#
#    Dependencies:
#     - Perl module DBD::mysql
#     - Perl module Net::Traceroute
#     - flowd (tested with version 0.9.1, www.mindrot.org/projects/flowd/)
#
#    Database:
#    The script is designed to use a MySQL database backend. An example table
#     structure is provided in the mysql-tracestore.sql file. The file can be
#     loaded like this:
#     1. Login to MySQL
#       $ mysql -u root -p
#     2. Create a database
#       mysql> create database tracestore;
#     3. Create a new user
#       mysql> grant all on tracestore.* to 'username'@'localhost' identified by 'password';
#     4. Load the table structures
#       $ mysql -u username -p tracestore < mysql-tracestore.sql
#
#    Variables used in the script:
#     mysqlHost - Database server hostname
#     mysqlUser - Database username
#     mysqlPass - Database password
#     mysqlName - Database name
#
#     flowdFile - flowd database file to be used by the flowd-reader process
#
#     flowdSudo - Boolean to indicate whether sudo should be used to run the flowd-reader
#
#     flowdBin - Path to flowd-reader binary
#
#     sudoBin - Path to sudo binary
#
#     processTime - Number of seconds the script has to look back in the flowd database
#                    for flows to trace. If you put the script in cron, and let it run every
#                    5 minutes, set this variable to 300.
#
#
#     debugSwitch - turn on for debugging
#
#     debugSwitchThreads - turn on for thread debugging
#