-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Victor Alba
Sent: Tuesday, July 07, 1998 4:17 PM
To: support@iea-software.com
Cc: emerald@iea-software.com
Subject: No Accounting
I'm not sure if this is a radius or Emerlad question that's why I've posted
to both lists..... Radius itself seems to be working ok but I can't get
Emerald to do the accounting. This is what I'm getting when I do the
accounting test using 'Radlogin' :
-------------------------------------------------------------
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host d09d8703 code=4, id=240, length=59
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "dfadda"
Acct-Session-Id = "3574822240"
Acct-Status-Type = Start
SQL Statement: INSERT INTO Calls
(CallDate,NASIdentifier,NASPort,UserName,AcctS
essionId,AcctStatusType) VALUES
(GetDate(),'127.0.0.1',0,'Pdfadda','3574822240',
1)
ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'AcctSession
Id'.
Resp Time: 78 Auth: 0/0 -> 0 Acct: 0/1/0 -> 1
-----------------------------------------------------------------
That's as far as it goes, then when I open emerald and click on the On-line
tab all I get is "SQL failed".
What's happening here...?
-Victor