Thanks for this reply.
I've studied all the code best I can with my non-Perl eyes. And I've
experimented with "AcctLogFileFormat" a bit. I've got a SQL Server -
compliant timestamp with:
AcctLogFileFormat %Y-%m-%d %H:%M:%S
I also have the newline problem solved, since it looks like it
automatically includes the entire record on a single "line".
The only thing I still would like to be able to do is insert TAB characters
to delimit the attributes. I've tried things like "\t" (and "\n"), but they
are just inserted literally into the output. Is there any more control
available that could help me?
Thanks again!
Dave
On Monday, January 24, 2000 5:11 PM, Hugh Irvine [SMTP:[EMAIL PROTECTED]]
wrote:
>
> Hello Dave -
>
> On Tue, 25 Jan 2000, Dave Kitabjian wrote:
> > Where can I learn more about "AcctLogFileFormat" than what is printed
in
> > the manual for 2.14?
> >
> > Here's what we're doing. For reliability reasons, rather than send
> > Accounting data via SQL, we are going to allow Radiator to write to the
> > detail file, which should never fail. Then, periodically, a VB app
running
> > on a Windows server will wake up, request all new accounting records
from a
> > server running on the Radiator host, upload them into the database, and
go
> > back to sleep.
> >
> > So the short story is that I have to parse my detail file. Obviously, I
can
> > make my job a lot easier if I have a lot of control over how the
records
> > are laid out in the detail file. With AcctLogFileFormat, it appears
that I
> > can choose fields and perhaps their order, but that's it. I'd like to
also
> > be able to:
> >
> > 1) Reformat the Timestamp so that it's SQL Server readable
> >
> > 2) Reserve Newline characters to separate entire accounting records
only;
> > preferably preserving the Tab character to delimit individual fields of
the
> > record.
> >
>
> I think my first inclination would be to build a second SQL server and
define
> it as a backup in the Radiator configuration file. However, if you want
to know
> what AcctLogFileFormat does, have a look at the subroutine called
> "format_special" in the file "radiusd" in the main Radiator directory.
> AcctLogFileFormat itself is defined in the file "Radius/Handler.pm", but
it
> just calls "format_special".
>
> hth
>
> Hugh
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
