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:
HiNB: I am travelling this week, so there may be delays in our correspondence.
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
--
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
