Re: [Emerald] Generic Online Table
Dale E. Reed Jr. ( (no email) )
Wed, 21 Jun 2000 12:31:01 -0700
Ken Sorenson wrote:
>
> 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?
No, it looks like there is still an issue with it. I'll check into it.
--
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