Greetings, We use the Diag fuctions to dump to a local syslog file on a machine nearby out as5300's, then use a bash script to parse it (I know, perl would be better) then upload it to a MySQL server then link the tables by Username. Works fairly well. Configuration:
Radius logs standard radius logs to detail files & to mysql directly Ciscos dump diag output to a suslog file on the radius server Bash script runs once every 10 minutes and uploads the syslog data to the Mysql Server, into a seperate table. So far, unless the mysql server goes down, we have a pretty accurate picture of what goes on. On Fri, 14 Nov 2003 09:56:53 +0000 James Green <[EMAIL PROTECTED]> wrote: > Mail_Man wrote: > > >Can someone point me in the right direction to where I can find > information > >on setting up Free Radius so that it collects all the call detail > records > >from a cisco as5300 gateway and stores it in a database? > > > >TIA > > > >-Seth > > > > > > Call detail? You mean calltracker? If so then good luck :D. > > We did it by: > > - configure the cisco to use calltracker and output it to the syslog. > - tell the cisco to forward the syslog onto a linux box > - configure the linux box to accept the incoming syslog requests and > pipe it through to a perl script > - write a perl script to accept the syslog lines, process them and store > them in the database using the ct_hndl field as the key. > > You cannot match the ct_hndl to the radius keys though, so you won't be > able to easily match the calltracker logs to the radius logs. We > contacted our cisco gold partner resellers and they contacted cisco > themselves, and no-one could figure out a reliable matching system. > Cisco advised to not bother with the radius logs, but use the > calltracker logs instead. > > Thanks, > > James Green > > -- �William Ragsdale - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
