Re: Table: ServerPorts

Dale E. Reed Jr. ( (no email) )
Thu, 26 Mar 1998 08:05:32 -0800

Stephan Malkmus wrote:
>
> >Stephan Malkmus wrote:
> >>
> >> sorry but i can't find it in the manuell
> >> how can i setup RadiusNT to maintain a callsonline
> >> table/view.
> >
> >You have to have a CallsOnline view to the Servers and ServerPorts tables.
> >It does vary depending on what kind of database you are using, though.
> >If its MS Access, you can look at the sample database included. For
> >SQL Server, you'd be best to look at the Emerlad scripts.
>
> I put on the the calls trigger (SQL Server 6.5 database) but only
> the timeleft field in table subaccounts is updated.

Do you have entries in your ServerPorts table for each port of your
NAS? You have to create those ahead of time, as RadiusNT will only
update them, it will NOT create them.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com