Re: Error 2627

Dale E. Reed Jr. ( (no email) )
Fri, 27 Feb 1998 10:55:55 -0800

It would seem odd that the first Accounting request (with
Acct-Delay-Time=0) would be a duplicate. Is this an
Emerald database? The first thing I would look at would be
the primary key on the calls table. It could be setup
incorrectly.

Waldemar Born wrote:
>
> Hi Dale,
>
> here is the complete sequence:
>
> Resp Time: 110 Auth: 26/0 -> 26 Acct: 0/0/0 -> 0
> radrecv: Request from host c0a80064 code=1, id=102, length=70
> NAS-Identifier = "brickXL"
> Service-Type = Framed-User
> Framed-Protocol = PPP
> User-Name = "GuntherK"
> CHAP-Password = "\001\314\216\262\026A\014n\274\331V\344\377\360\245W\2
> 50"
> rad_authenticate_ODBC()
> CHAP-Password = "\001\314\216\262\026A\014n\274\331V\344\377\360\245W\2
> 50"
>
> SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue), maExpireDa
> te), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType
> , sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa W
> here (sa.Login='GuntherK' or sa.Shell='GuntherK') AND ma.CustomerID=sa.Cust
> omerID and sa.Active<>0 and ma.Active<>0
>
> SQL Statement: Select ra.RadAttributeID, Name, Data, Value, Type From RadC
> onfigs rc, RadAttributes ra Where ra.RadAttributeID=rc.RadAttributeID AND r
> c.AccountID=1
>
> User-Name = GuntherK (1)
> User-Password = guntherk (1)
> Service-Type = Framed-User (2)
> Framed-Protocol = PPP (1)
> Framed-Address = 192.168.12.241 (1)
> Framed-Netmask = 255.255.255.255 (1)
> Framed-Compression = Van-Jacobsen-TCP-IP (1)
> Idle-Timeout = 300 (300)
> Sending Ack of id 102 to c0a80064 (xl.lip.net)
> User-Name = "GuntherK"
> User-Password = "guntherk"
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Framed-Address = 192.168.12.241
> Framed-Netmask = 255.255.255.255
> Framed-Compression = Van-Jacobsen-TCP-IP
> Idle-Timeout = 300
>
> Resp Time: 1188 Auth: 27/0 -> 27 Acct: 0/0/0 -> 0
> radrecv: Request from host c0a80064 code=4, id=103, length=95
> NAS-Identifier = "brickXL"
> Service-Type = Framed-User
> Framed-Protocol = PPP
> User-Name = "GuntherK"
> NAS-Port = 0
> Acct-Status-Type = Start
> Acct-Delay-Time = 0
> Acct-Link-Count = ""
> Acct-Session-Id = "43000016"
> Acct-Multi-Session-Id = "43000016"
>
> SQL Statement: INSERT INTO Calls (CallDate,NASIdentifier,FramedProtocol,Us
> erName,NASPort,AcctStatusType,AcctDelayTime,AcctLinkCount,AcctSessionId,Acc
> tMultiSessionId) VALUES (GetDate(),'brickXL',1,'GuntherK',0,1,0,'','4300001
> 6','43000016')
>
> ODBC: SQLExecDirect Error 2627:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY co
> nstraint 'PK_Calls_1__13': Attempt to insert duplicate key in object 'Calls
> '.
> Sending Accounting Ack of id 103 to c0a80064 (xl.lip.net)
>
> Resp Time: 688 Auth: 27/0 -> 27 Acct: 0/0/1 -> 1
>
> -----Original Message-----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@emerald.iea.com <emerald@emerald.iea.com>
> Date: Friday, February 27, 1998 8:06 AM
> Subject: Re: Error 2627
>
> >> Waldemar Born wrote:
> >>
> >> Hi all,
> >>
> >> i receive error 2627 in x15 mode. I had to make some changes to get the
> Brick
> >> XL working, and now i get SQL error 2627...
> >
> >Please include the -x15 debug from radrecv() to the resp line for this
> >request.
> >
> >--
> >Dale E. Reed Jr. (daler@iea-software.com)
> >_________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.iea-software.com
> >
> > ----------------------------------------------------------
> > Emerald Mailing List listserver@emerald.iea.com
> >
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com

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