(RADIATOR) timestamp ?

[chairarth]

Hi Hugh

According to your suggestion , I 've add column name "DATE" to the RADUSAGE table
and add this line below in configuration file

AcctColumnDef DATE,Timestamp,integer-date

After restart radiator and try to make a connection , I find that there are
datetime value at DATE column at SQL Server. It's ok.But we want date format like
" DD MM YYYY HH24:MM:SS" . So I edit AcctCoumnDef DATE as below.

AcctColumnDef DATE,Timestamp,integer-date,to_date(’%e %m %Y %H:%M:%S’)

Well, it's not work . In Radiator log file show error message

Wed May 30 14:24:23 2001: ERR: do failed for 'insert into RADUSAGE (USERNAME,
TIME_STAMP, ACCTSTATUSTYPE, ACCTSESSIONID, FRAMEDIPADDRESS, NASIDENTIFIER, DATE)
values  ('test', 991207463, 1, '51012c24', '10.10.64.63', '10.10.0.2',
'to_date(30 05 2001 14:24:23)')': [Microsoft][ODBC SQL Server Driver][SQL
Server]Syntax error converting datetime from character string. (SQL-22008)(DBD:
st_execute/SQLExecute err=-1)

What should I do?

Thanks
Chairath
 

Hugh Irvine wrote:

> Hello Chairath -
>
> Have a look at the "radacct.cgi" script in the main Radiator directory to see
> how it is done. Otherwise, you could add a column to the RADUSAGE table into
> which you could directly write the formatted date string when posting
> accounting records.
>
> hth
>
> Hugh
>
> On Wednesday 30 May 2001 12:06, chairarth wrote:
>
> > > Hi ,
> >
> > By now we implement Radiator with Radmin .  Due to we don't wanna let
> > dailup users access to Radmin to check their own usage time. And we have
> > web server (implement on ASP Language) to serve our customers already .
> > Therefore , we plan to let our users check usage time on this server .
> > But  when we check at RADUSAGE Table , we found that  the value of
> > "TIME_STAMP" is int ( e.g. 990781489) .
> >
> > So how can we write ASP Scripte to show value of TIME_STAMP like RAmin
> > List Usage show ( e.g. 25/05/2001 16:04) .
> >
> > Thanks
> > Chairath
>
> ----------------------------------------
> Content-Type: text/html; charset="us-ascii"; name="Attachment: 1"
> Content-Transfer-Encoding: 7bit
> Content-Description:
> ----------------------------------------
>
> --
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20010530/45ff0147/attachment.html>