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.