Re: Table: ServerPorts
Stephan Malkmus ( stephan@i-con.de )
Thu, 26 Mar 1998 17:54:49 +0100
At 08:05 AM 3/26/98 -0800, you wrote:
>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.
>
I created them in the ServerPorts table before i put on the trigger.
The table looks like:
ServerID Port
1 10100
1 10101
etc..
maybe this is wrong?
Stephan Malkmus (stephan@i-con.de)
>--
>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
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>