RE: Big problems w/RadiusNT 2.5

ken french ( frenchkc@gru.net )
Mon, 11 May 1998 16:10:29 -0400

Should be like the following, or
this is what I am using;

INSERT RadLogMsgs VALUES(0, "Generic Message", 0)
INSERT RadLogMsgs VALUES(1, "Generic Error", 5)

INSERT RadLogMsgs VALUES(10, "User Not Found", 3)
INSERT RadLogMsgs VALUES(11, "Bad Password", 3)
INSERT RadLogMsgs VALUES(12, "User Expired", 2)
INSERT RadLogMsgs VALUES(13, "User OverDue", 2)
INSERT RadLogMsgs VALUES(14, "Over Login Limit", 1)
INSERT RadLogMsgs VALUES(15, "No Time Left", 1)
INSERT RadLogMsgs VALUES(16, "Port Not Allowed", 2)
INSERT RadLogMsgs VALUES(19, "No Attributes", 3)

INSERT RadLogMsgs VALUES(50, "Bad Request", 4)
INSERT RadLogMsgs VALUES(51, "No Username", 4)
INSERT RadLogMsgs VALUES(52, "No Password", 4)
INSERT RadLogMsgs VALUES(53, "Bad Digest", 6)

INSERT RadLogMsgs VALUES(60, "Parse Error", 5)
INSERT RadLogMsgs VALUES(100, "Chap Not Allowed", 5)

-----Original Message-----
From: Greg Waugh [SMTP:gregmail@pol.com]
Sent: Monday, May 11, 1998 3:38 PM
To: RadiusNT@iea-software.com
Subject: Re: Big problems w/RadiusNT 2.5

No, RadLogMsgs is empty. I assume there should be something in there? I
ran the conversion script....

-----Original Message-----
From: ken french <frenchkc@gru.net>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Sunday, May 10, 1998 11:49 PM
Subject: Re: Big problems w/RadiusNT 2.5

Do you have the RadLogMsgs table populated?
If populated, go you have a row with RadLogMsgID = 19?

-----Original Message-----
From: Greg Waugh <gregmail@pol.com>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Sunday, May 10, 1998 8:43 PM
Subject: Big problems w/RadiusNT 2.5

<SNIP>

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)
VALUES (19, GetDate(), 'bhoffman', 'g+-n6f=|?+}k+|[??')

ODBC Error:23000:547:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with
COLUMN FOREIGN KEY constraint 'FK__RadLogs__RadLogM__1E1A7EA3'. The
conflict oc
curred in database 'Emerald', table 'RadLogMsgs', column 'RadLogMsgID'