RE: [Emerald] Calls not being cleared

PowerNet ( (no email) )
Thu, 30 Sep 1999 09:20:03 -0400

Here is the SQL command we use to clear the calls online table and it works=
Sure saves clicking clear for each user.

update serverports set username =3D NULL

Run this in your SQL query tool against the Emerald database.


*********** REPLY SEPARATOR ***********

On 9/30/99, at 1:35 PM, Malcolm Joosse wrote:

>The NAS is a MAX6000 and the problem is with the NAS not Emerald.
>There seems to be a hardware issue with the MAX 6000 randomly rebooting=
>thus it sends no Acc Stop to the Radius. I find out by my customers not
>being able to reconnect due to them still being showen as connected.
>I would like to be able to clear all the active connections in Emerald so
>the can log back you can imagen it takes a while to clear all our
>active connections.
>Lucient has agreed that their is a problem with the unit(s) and I will be
>getting a replacement next week.
>Is there a way to clear all the connections in one hit ?
>I have not seen any requests to Radius when the Max comes back online.
>-----Original Message-----
>[]On Behalf Of Dale E. Reed Jr.
>Sent: Thursday, 30 September 1999 2:53
>Subject: Re: [Emerald] Calls not being cleared
>Malcolm Joosse wrote:
>> Hello List,
>> We are having a problem with one of our NASes rebooting.
>> After the reboot Emerald shows the users as still being logged in, but
>> are not as they get disconnected after the reboot.
>> I think this is because the NAS does not give an accounting record for=
>> disconnection.
>> What I would like to know is, if I stop/start RadiusNT they still show=
>> being connected. The only way I have been able to remove them is using
>> clear connection button in Emerald.
>> Is there a better way ?
>What kind of terminal server? In -x15 debug mode does RadiusNT show
>that its sending any special packets to note that the NAS is starting
>Dale E. Reed Jr. Emerald and RadiusNT
>IEA Software, Inc.
>For more information about this list (including removal) go to:
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: