Re: Radius & ODBC & SQL

Philip Thomas ( phil@saturnnet.com )
Mon, 31 Mar 1997 15:48:47 -0800

Dale E. Reed Jr. wrote:
>
> On Mon, 31 Mar 1997, Philip Thomas wrote:
>
> > You guys will love this error I am getting. I just recently upgrade to
> > SQL version 6.5, we are running emerald version 2.1 and radius version
> > 1.1. I found after the upgrade no one was able to log on and after
> > running radius debug (radius -x11) I came up with this error:
> >
> > radrecv: Request from host d0cb4b05 code=4, id=54, length=115
> > Acct-Session-Id = "1A000015"
> > User-Name = "p50"
> > NAS-Identifier = 208.203.75.5
> > NAS-Port = 1
> > NAS-Port-Type = ISDN
> > Acct-Status-Type = Start
> > Acct-Authentic = Local
> > NAS-Port-DNIS = "7028260470"
> > Caller-Id = "\200\2037028249664"
> > User-Service = Framed-User
> > Framed-Protocol = PPP
> > Framed-Address = 208.203.78.30
> > Acct-Delay-Time = 3330
> > ODBC: SQLExecDirect Error:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
> > constraint 'pk_Calls': Attempt to insert duplicate key in object
> > 'Calls'.
> > Response Time: 15
> >
> > This is not limited to just ISDN but all incoming call.
>
> This is just accounting. What about the authentication
> attempts RadiusNT receives? Don't worry about the
> above unless its happening alot. Post the Auth attempt
> from -x15 and we can see whats wrong.
>
> Dale
>
> ----------------------------------------------------------
> RadiusNT Mailing List listserver@emerald.iea.com

Here it is, hope this helps:

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctSessionTime,AcctInputOctets,AcctOutputOctets,NASPortDNIS,AcctTerminateCause,UserService,FramedProtocol,FramedAddress,AcctDelayTime)
VALUES (GetDate(),'1A00001D','phil','208.203.75.
5',1,0,2,2790,176196,631292,'8260470',1,2,1,'208.203.75.212',2880)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.

Response Time: 1094
radrecv: Request from host d0cb4b05 code=4, id=70, length=113
Acct-Session-Id = "1A00001D"
User-Name = "phil"
NAS-Identifier = 208.203.75.5
NAS-Port = 1
NAS-Port-Type = Async
Acct-Status-Type = Start
Acct-Authentic = Local
NAS-Port-DNIS = "8260470"
Caller-Id = "\200\2037029728923"
User-Service = Framed-User
Framed-Protocol = PPP
Framed-Address = 208.203.75.212
Acct-Delay-Time = 5670
Allocating Statement...

SQL Statement: INSERT INTO Calls
(CallDate,AcctSessionId,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,NASPortDNIS,UserService,FramedProtocol,FramedAddress,AcctDelayTime)
VALUES
(GetDate(),'1A00001D','phil','208.203.75.5',1,0,1,'8260470',2,1,'208.203.75.212',5670)

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_Calls': Attempt to insert duplicate key in object
'Calls'.

Response Time: 875