(RADIATOR) timestamp ?

[Hugh Irvine]

Hello Chairarth -

You should set up the SQL database with a simple string field as the 
destination column (not a "datetime" field), because you just want to write 
the string as you describe below. Also, you should use the DateFormat 
statement together with the AcctColumnDef, something like this:

	......
	DateFormat %e %m %Y %T
	......
	AcctColumnDef DATESTRING, Timestamp, integer-date

Have a look at section 6.3 in the Radiator 2.18.1 reference manual.

regards

Hugh

On Wednesday 30 May 2001 18:00, chairarth wrote:

> > 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.

----------------------------------------
Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 8bit
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.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.