Re: Password Encryption

Dale E. Reed Jr. ( (no email) )
Wed, 30 Apr 1997 23:18:28 -0700

Mark A. Knight wrote:
>
> BINGO!
>
> I have another one for you. Probably just as easy and just as dumb. Why do I get the following message and what attribute in what table do I need to set to correct it?
>
> SQL Statement: INSERT INTO Calls (CallDate,UserName,NASPort,AcctStatusType,
> AcctDelayTime,AcctSessionID,FramedProtocol,FramedAddress) VALUES (GetDate(),'joe',20
> 101,1,0,'229551867',1,'207.240.11.153')
>
> ODBC: SQLExecDirect Error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASIdentifier in table
> Calls may not be null.
> Sending Accounting Ack of id 116 to cff00b03 (expmax1)

Ok. I worked a problem like this today. If you are using a USR
product, certain versions of their
equipment send either BOTH NAS-IP-Address(4)/NAS-Identifier(32) or just
NAS-Identifier (32).

The dictionary that comes with Emerald/RadiusNT has one old legacy thing
concerning
this. Both of these are called NAS-Identifier, OR they will be reversed.
Grab a dump
of the accounting packet from radrecv to response time. If
NAS-Identifier is NOT
in the packet, you need to rename the dictiionary to match.

This problem has been fixed in RadiusNT 2.1, also.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com