RE: [Emerald] Generic Online Table

Ken Sorenson ( (no email) )
Wed, 21 Jun 2000 00:14:22 -0500

Thanks for the mod, but it still doesn't work. SQL debug shows the
following:

sql1: Update ServerPorts Set AcctStatusType=2 Where ServerID=0 AND Port=277
sql2: Select s.ServerID, Username, Server, Port, CallDate,
Mins=DateDiff(Minute, CallDate, GETDATE()), FramedAddress, ConnectInfo,
CallerID From Servers s, ServerPorts sp Where s.ServerID =
sp.ServerID AND Username <> 'no one' AND (AcctStatusType=1
OR AcctStatusType=3) UNION Select ServerID=0, Username, Server='Roam',
Port, CallDate, Mins=DateDiff(Minute, CallDate, GETDATE()), FramedAddress,
ConnectInfo, CallerID From RadRoamPorts Where (AcctStatusType=1 OR
AcctStatusType=3) Order by Server, Port

Do I have a misconfiguration in my roam servers?

Thanks!

Ken

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Tuesday, June 20, 2000 11:38 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] Generic Online Table

Ken Sorenson wrote:
>
> I am using .334 as well.. Nothing happens when I press the button.

One thing to check. The roamports.sql script isn't assigning
permissions to the RadRoamPorts table. Therefore, you might not
have permissions to remove records from that table. Turn on
debug mode and see if you are getting an SQL Error.

Running this should set the permissions correctly:

GRANT SELECT, DELETE, UPDATE ON RadRoamPorts TO Emerald, EmeraldAdmin,
EmeraldSecure
GRANT SELECT, INSERT, DELETE, UPDATE ON RadRoamPorts TO EmeraldApps

--

Dale E. Reed Jr.    Emerald and RadiusNT/X__________________________________________IEA Software, Inc.   www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart



For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart