(RADIATOR) Question about "Calls" table

[Hugh Irvine]

Hello Lin -

I will need to see a copy of your Radiator configuration file (no  
secrets) together with a trace 4 debug showing what is happening.

regards

Hugh


On Tuesday, November 5, 2002, at 10:21 AM, Huaikun Lin wrote:

> Hi
>
> I am using SQL server and radiator 3.1 radius.
>
> In SQL server,we have a table "calls" which records the accounting  
> data.
>
> Recently,I found the data in one of the field "CallDate" (data  
> type:datetime) is not exactly
> acurate. This data type should record data like "2002-11-05 12:05:23".  
> But the actual
> data is something like "2002-11-05 12:05:00" which the "second" field  
> is alway 0.
> (The year,month,day,hour,min are right.)
>
> When I check the radius debug, I can see the "Insert" statement  
> doesn't include
> the "second" field and make the data is not 100% acurate:
>
> insert into Calls  
> (UserName,AcctStatusType,NASPort,CallDate,AcctSessionId,AcctInputOctets 
> ,AcctSessionTime,
> AcctOutputOctets) values ('test',2,541262250,'Nov  5, 2002  
> 12:10','204301AA-3DC6C5C6',25 45013,14466,66242572)
>
> I think the insert statement in radius script causes the inacurate.
>
> If there is no "second" field in there,the SQL database makes it to be  
> "00".
>
> Is there anywhere to fix that?
>
> How to fix it.
>
> Lin
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
>

NB: I am travelling this week, so there may be delays in our  
correspondence.

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