Re: Questions with Radius

Dusan Janjic ( (no email) )
Fri, 28 Aug 1998 15:35:49 -0400

Dale E. Reed Jr. wrote:

> Dusan Janjic wrote:
>
> > mode. Here are the error messages from the log file:
> >
> ...
> > I am not sure how to solve this??
>
> Run the rad25_up2.sql script against your Emerald database. It includes
> the missings fields noted.
>

Ok Dale,

This seemed to fix the problem but only partially. I have noticed more then
usual number of users that Radius reports as logged in. Here is the portion of
the messages from the log file:

Fri Aug 28 13:45:42 1998: 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 occurred in database 'Emerald', table 'RadLogMsgs', column
'RadLogMsgID'
Fri Aug 28 13:45:56 1998: User: rockplan already logged onto system 1 time(s).

Fri Aug 28 13:45:56 1998: 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 occurred in database 'Emerald', table 'RadLogMsgs', column
'RadLogMsgID'

It seems that either, Radius doesn't send the proper string to Emerald to
inform it of the termination of the session, or (unlikely ) unusual high
number of our users is trying to log in twice.

Can you help?