(Fwd) Re: ERROR

Serge Stein/i2Tech ( Serge_Stein@i2.com )
31 Dec 96 0:16:43 EDT

I was wondering if anyone else has gotten this error and can give me
an idea.

I am using emerald with radiusNT command line -x1 -o -A

This is the error I am getting

[Microsoft][ODBC SQL Server Driver] The column UserName in the table
Calls may not be null

When it gives this error, the user gets immediately disconnected. If
they call back, it lets them on. People seem to get annoyed at
having to log in twice.....I can't imagine why. You have been a
TREMENDOUS help. You are a God among
men, and a man among women. Thanks Again!!!

> This is accounting, I don't know what it would have to do with
> authentication. in -x15 debug mode, what does the packet received
> from the NAS look like? Does it have a username attribute?

Here is the packet from the NAS cut and pasted:

SQL Starement: INSERT INTO Calls (CallDate, NASIdentifier, NASPort,
AcctStatusType, AcctDelayTime, AcctSessionId, AscendDisconnectCause,
AscendDataRate) VALUES (GetDate(), '', 20116, 2, 0,
'220546840', 27, 14400)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column UserName
in table Calls may not be null.
Sending Accounting Ack of id 80 to d08731fd (max.mindsync.com)

Response Time: 150

I hope this can shed some light on the subject.

Jason Powell
RadiusNT Mailing list (radiusnt@iea.com)