Re: Emerald 2.5

Robert Boyle ( )
Fri, 05 Jun 1998 15:48:12 -0400

At 02:53 PM 6/5/98 +0100, you wrote:
>Hi Dale,
>At last we have got around to installing 2.5 taken from the ftp site today
>5th June.
>Accounting into Emerald is working fine, but trying to authenticate against
>Emerald sometimes brings up the following error
>Sending Reject of id 170 to c1a4b782 (PM3)
> SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
>S (10, GetDate(), 'cccuk', '12345678')
>ODBC Error:23000:547:
> [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
> COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The
>conflict oc
>curred in database 'Emerald25', table 'RadLogMsgs', column 'RadLogMsgID'
>User: cccuk Not found
>User: cccuk Not found
>Resp Time: 210 Auth: 2/6 -> 8 Acct: 22/0/0 -> 22

This LOOKS like it could be a duplicate entry coming from your NAS. If your
NAS does not receive an Ack, it will resend the accounting packet. Radius
will then try to insert it, but receive an error since the same data is
already in the table. Unless this is a bug... :)