Message 2: Re: Time of Day restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: Re: Calls Online
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 4: Re: Time of Day restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Need RadiusNT SQL help
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sat, 23 May 1998 00:13:46 -0700
Mike Gent wrote:
>
> What I would like is an sql script that adds everything into a database
> that is required for radiusnt 2.5, or a base script for 2.2 that I can
> then run the rad25_up.sql script on.
See the following URL. Its the chop of the Emerald database as
per the RadiusNT 2.5 docs. I did correct some issues with the DNIS
stuff that the 2.5 docs on the ftp site has incorrect.
ftp://ftp.iea-software.com/radiusnt/beta/MSSQL/radiusnt.sql
There are also scripts for sybase and Oracle in that beta directory
as well.
-- 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time of Day restrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 23 May 1998 00:16:56 -0700
McCallum, Michael wrote:> > Thanks for the information on the documentation. I found the reference> and have a question.> > I need to grant access for an accounttype from midnight to 0800 and 2000> to midnight. According to the table layout it looks like I could only> grant access either from midnight to 0800 OR 2000 to midnight but not> both for a single account type. Any suggestions?
What you are trying to do is the same as granting from 8pm to 8am.Just enter 1200 (20 * 60) for the start and 480 (8 * 60) for the stop.
> Also, if server access is enabled do I have to populate entries for all> possible servers so a valid record is found?
Yes. If you enable server access by default access to the port isdenied unless specifically granted.
-- 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls OnlineFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 23 May 1998 00:23:14 -0700
Bruno Tremblay wrote:> > Radius V. 2.5.110> > I change "usersname" to "username" and I still getting the same error.
How did you change that? Do you mean you changed username to usersnamein the CallsOnline query?
> I don't want any times restrictions on ServerAccess do I set Start time to 0> and Stop time to 1440
Set them both to 0.
-- 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
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Time of Day restrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Sat, 23 May 1998 00:26:55 -0700
Zak Wolfinger wrote:> > Is there an easy way to do this on a per user basis? I
No. Server Port Access is per Account Type.
> guess I could setup an AccountType for the user and populate> the ServerAccess table for the new account type, but with a> couple hundred ports, it seems to be a long process. Unless> I'm doing it wrong?
You can add an entry in the ServerAccess with a NULL port. RadiusNT 2.5handles that correctly. Its actually preferred, since it will keep thenumber of records down.
-- 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