(RADIATOR) converting mysqldump to livingston format

[Andy De Petter]

Hi Philip,

Wouldn't it be a better idea, to check the maximum session time, and 
make a crontab on your server, that cleans (read: removes) all 
connections in your online table, that have been there for longer than 
your max session time?  That way, you don't have to clear your entire 
online interface on a regular base, which (correct me if I'm wrong), 
removes all entries from your online interface, and not only the ones 
that shouldn't be there anymore?

-Andy

Philip Clever wrote:

>Hello,
>
>Every couple of weeks we need to dump & clear the ACCOUTNING table, so that
>we can access the online interface (otherwise it grow to big and times out
>before returning any data).  We do a mysqldump command on it and it dumps to
>a comma delimited file.  We would like to view this through radacct.cgi
>specifying the logfile (.cgi?filename=).  However to get any info to return
>on the webpage the log file must be in "Livingston" format.  Does anyone
>know of a conversion utility to convert from Comma delimited to Livingston
>format?
>
>Thanks,
>
>Philip
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.372 / Virus Database: 207 - Release Date: 6/20/2002
>
>===
>Archive at http://www.open.com.au/archives/radiator/
>Announcements on radiator-announce at open.com.au
>To unsubscribe, email 'majordomo at open.com.au' with
>'unsubscribe radiator' in the body of the message.
>  
>


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.