RE: Clearing Calls from the online table

Greg Keys ( (no email) )
Wed, 10 Jun 1998 12:18:28 -0400

I ran into this problem with Emerald 2.1.whatever........ It was something
to do with the call table.....
AAARRRGGGHHH ... went to pull up the sql enterprise manager and my server
blue screened........

Anyway, now that the server is back up..... the call table has an item in
it called connectinfo that somehow was not in my copy of the database......
Set your radius to -x15 and watch for SQL errors...... I do not remember
what the details were but I do remember that a change to the database fixed
this problem....
It may also have been related to the following problem. I was working on a
different problem when the inability to clear calls was fixed, which is why
I do not clearly remember the details of it. I Just remember thinking, "I
bet that fixed this too!" and when I checked, it had...........

The connectinfo also must exist in the serverports table

> Greg Keys wrote:
> I am sitting here watching Radius authenticating against our brand new
> install (what a job :} ) and everything is working fine,
> except.......,
> When we get an invalid login attempt (bad user name) I see in Radius
> mode) the following error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'
> Any idea's?

You need to add a data column to your RadLogs table. Execute this in
isql_w against your Emerald database:

ADD Data varchar (50) NULL DEFAULT NULL

--Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |

---------------------------------------------------------- Emerald Mailing List> -----Original Message-----> From:> []On Behalf Of Chris A.> Christopher> Sent: Wednesday, June 10, 1998 9:07 AM> To:> Subject: Re: Clearing Calls from the online table>>>> At 03:24 PM 6/9/98 -0700, you wrote:> >Chris A. Christopher wrote:> >>> >> I am unable to clear calls from the online table. I have> restarted the SQL> >> services and rebooted the machine to no avail. What am I doing wrong? I> >> keep getting an SQL error everytime I try and clear a call.> >> >Its most likely a permissions problem. Can you clear the call if you> >login as sa?>> No, even if I am logged in as SA> >>> >> >> -------------------------------------------------------------------> Chris A. Christopher> CEO Voice (304)292.7700> Labyrinth Solutions Inc. Fax (304)292.6549> 235 High Street, Suite 416> Morgantown, WV 26507-0434> ====================================================================>>