Hi Guys Here is a release (version 1.0) of a program I wrote and have found very useful. Maybe someone else will too.
http://www.peternixon.net/code/h323detail2db.pl.txt Its purpose is to parse h323 VoIP call records as emmitted by ciscos and insert them into a database if they dont already exist. It is setup to work with my slightly custom Database format and a Postgresql DB server although it uses DBI and will therefore work with any DB server supported by Perl DBI. It will work fine on standard RADIUS Accounting records (Non h323) by simply changing the 2 sql queries to suit your database layout. I use this program to verify that the data in my database is actually correct and contains all records (If a DB server goes offline my radius servers still log the detail files) It requires the CPAN modules DBI and Getopt::Long to function. Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
