(RADIATOR) converting mysqldump to livingston format

[Hugh Irvine]

Hello Philip -

Why don't you just add an AcctLogFileName to write the flat files at the same 
time as the SQL?

	AcctLogFileName %L/detail-%Y-%m

The above will write a new file for every month with a name like this:

	detail-2002-07

You can alter the naming to suit.

BTW - you can use the same special characters to automatically write to a 
different SQL table as well (the tables must be created first).

regards

Hugh

On Tue, 2 Jul 2002 10:03, 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.