Re: Error 2627

Waldemar Born ( (no email) )
Fri, 27 Feb 1998 13:50:05 +0100

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
>