Hi Ray,
This is what I've done. I based this on the mysql docs on the
"datetime" type:
In the goodies mysqlCreate.sql, I added this to the accounting table:
ACTUAL_TIME datetime,
and in my radius config, I added this to my AcctColumnDef's under <AuthBy
SQL>:
AcctColumnDef ACTUAL_TIME,Timestamp,formatted-date,\
'%Y/%m/%e %H:%M:%S'
Works great for me... Make sure you've got the Perl TimeDate module (on
FreeBSD you can find this as a port/package named p5-TimeDate-1.0x)...
Charles
| Charles Sprickman | Internet Channel
| INCH System Administration Team | (212)243-5200
| [EMAIL PROTECTED] | [EMAIL PROTECTED]
On Sat, 24 Jun 2000, Raymond Brighenti wrote:
> Hi,
>
> Sorry for what is probably a basic question, but currently Radiator is
> writing the Timestamp from the Radius record in Unix format, is there
> anyway to change this so that it writes the it in normal time?
>
> Thanks
>
> Ray
>
>
>
> ============================================
> "In cases of major discrepancy it's always reality
> that's got it wrong....reality is frequently inaccurate."
> ============================================
>
>
> ===
> Archive at http://www.starport.net/~radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
