Hello Madhav -
On Sat, 06 Nov 1999, Madhav Raj Maharjan wrote:
> Hi
>
> I would appreciate if you could help me to change TIME_STAMP into
> Formatted-Date when inserted into Database as DD MM YYYY 24HH:MM:SS;
>
> I could do for ACCOUNTING, RADLOG.
>
> For ACCOUNTING Table : Using AccColumnDef
> AcctColumnDef TIME_STAMP,Timestamp,formatted-date,to_date(''%e %m %Y
> %H:%M:%S', 'DD MM YYYY HH24:MI:SS')
>
> For RADLOG Table : Adding Few Lines on LogSQL.pm log() subroutine as below;
>
> For RADONLINE : ???
> How do I do it for RADONLINE Table
>
You would specify an "AddQuery" in your <SessionDatabase SQL> configuration.
<SessionDatabase SQL>
DBSource ...
DBUsername ...
DBAuth ...
AddQuery insert into RADONLINE .....
...
</SessionDatabase>
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
