[RadiusNT Digest]

radiusnt-digest-request@iea-software.com
Fri, 31 Jul 1998 00:01:04 -0700

Message 1: Exact Disconnect Time.
from Gaby <gaby@inco.com.lb>

Message 2: Re: Framed Address based on Serverport
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 3: RadiusNT and the SAM
from "Greg" <greg@access.aic-fl.com>

Message 4: Re: Framed Address based on Serverport
from "Mohammed Ersan" <ersan@first.net.jo>

Message 5: Radius doesn't find a table
from Victor Alba <victor@webjogger.net>

Message 6: Re: Framed Address based on Serverport
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 7: Re: RadiusNT and the SAM
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 8: RadiusNT and the SAM
from "John Bichao Jr." <johnb@cascadenet.com>

Message 9: Online Total By User
from "logan.net support" <support@logan.net>

Message 10: Re: Radius doesn't find a table
from "Josh Hillman" <admin-maillist@talstar.com>

Message 11: Problems with similar domains w/Proxy
from "Tony Schwartz" <tony@transport.com>

Message 12: RE: RadiusNT and the SAM
from "Mike Roberts" <mike@datawest.net>

Message 13: Re: RadiusNT and the SAM
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 14: Troubles with RadiusNT 2.5
from Shawn Ring <shawn@integrityonline.com>

Message 15: radius 2.5 dr watson error
from Christian Schmit <cschmit@vo.lu>

Message 16: RadiusNT and SQL back-up question
from postman@cp-tel.net (Postman Account)

Message 17: Multilinking
from "Kevin Ingram" <kingram@cameron.net>

Message 18: IIS 4.0 FTP or Frontpage 98 Server Extension/RadiusNT/SQL Authentication.
from "Rudy Komsic" <rudyk@cyberglobe.net>

Message 19: Re: RadiusNT and SQL back-up question
from Glen Kowalski <admin@img.net>

Message 20: Re: RadiusNT and SQL back-up question
from "Peter D. Mayer" <dmayer@netwalk.com>

Message 21: Interesting Project for intertying NT User Manager with Emerald Database
from "Rudy Komsic" <rudyk@cyberglobe.net>

Message 22: Re: radius 2.5 dr watson error
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 23: Re: Online Total By User
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 24: Re: RadiusNT and the SAM
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 25: Re: Exact Disconnect Time.
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 26: Re: Troubles with RadiusNT 2.5
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 27: Re: Radius against NT
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 28: Re: Exact Disconnect Time.
from Gaby <gaby@inco.com.lb>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Exact Disconnect Time.
From: Gaby <gaby@inco.com.lb>
Date: Thu, 30 Jul 1998 10:12:23 +0200

Does anyone know if the PortMaster 2E supports the session-timeout
feature
that RadiusNT sends back to the NAS to disconnect users on exactly the
remaining time
they have?

Do I need to do anything more than turn on TimeBanking, properly populate the
server ports table, and make sure the callsonline view workx.

Thanx,
Gabe.

P.S. - Dave I never figured out why the manual service update for timebanking
wasn't working, so I just modified and pasted in the trigger to do the
trick, it seems to work great! It's just as efficient, no?

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Framed Address based on Serverport
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 30 Jul 1998 00:44:23 -0700

mauro wrote:
>
> Is there any way to set a Framed-Address based on the serverport that the
> user is connecting to?

Not currently. We are looking to add this in a future release.

-- 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: RadiusNT and the SAMFrom: "Greg" <greg@access.aic-fl.com>Date: Thu, 30 Jul 1998 04:49:31 -0500

Ok, guys I need a little help her. I have read ALL the docs, and ALL thearchives, but this is my problem:

I installed Radius 2.5 all went wellIt will authenticate fine if the user name and password are in the user fileexplictly but not against the NT SAM.

Radius is installed as a service, and I have a user in the User Manager withthe password of WINNT\DOMAIN. And I told it to log on as that user in theservice control manager of the Control Panel.

Questions:

1. Exactly what permissions, or groups do I need to give to the user thatRadius logs on as?

2. What Groups do I need to add my Users to?

Or am I really missing something here!

Greg

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Framed Address based on ServerportFrom: "Mohammed Ersan" <ersan@first.net.jo>Date: Thu, 30 Jul 1998 13:11:26 +0300

dale,

please we are not looking for future release bu only for emerald 2.5 when its going to get released

At 12:44 AM 07/30/98 -0700, you wrote:

>mauro wrote:

>>

>> Is there any way to set a Framed-Address based on the serverport that the

>> user is connecting to?

>

>Not currently. We are looking to add this in a future release.

>

>--

>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

>

<center>Mohammed Ersan

ersan@first.net.jo

firstnet

</center>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius doesn't find a tableFrom: Victor Alba <victor@webjogger.net>Date: Thu, 30 Jul 1998 11:27:05 -0400

RadiusNT is not authenticating at this moment, here is part of the outputof Radius -x15:

====================================================================== Decrypted Password: Cucho Database Password: CuchoChecking for duplicate logins.

SQL Statement: RadCheckOnline 'Cucho'

Cucho found on-line 0 time(s).

SQL Statement: RadGetConfigs 342

ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'RadVendorID'.

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'PPP60+25+25'

ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'RadVendorID'.

Sending Reject of id 3 to d09d870a (PowerRack)Cucho: PPP60+25+25 has no RADIUS default attributes.

Cucho: PPP60+25+25 has no RADIUS default attributes.

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)VALUES (19, GetDate(), 'Cucho', 'Cucho')

ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'.

Resp Time: 500 Auth: 0/0 -> 27 Acct: 1/0/0 -> 1==============================================================================

What can we do get Radius to authenticate...??

-Victor

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Framed Address based on ServerportFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 08:44:19 -0700

Mohammed Ersan wrote:> > please we are not looking for future release bu only for emerald> 2.5 when its going to get released

I was just talking about RadiusNT, not Emerald. > At 12:44 AM 07/30/98 -0700, you wrote:> >mauro wrote:> >>> >> Is there any way to set a Framed-Address based on the serverport that the> >> user is connecting to?> >> >Not currently. We are looking to add this in a future release.

-- 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 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT and the SAMFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 08:47:43 -0700

Greg wrote:> > Ok, guys I need a little help her. I have read ALL the docs, and ALL the> archives, but this is my problem:> > I installed Radius 2.5 all went well> It will authenticate fine if the user name and password are in the user file> explictly but not against the NT SAM.> > Radius is installed as a service, and I have a user in the User Manager with> the password of WINNT\DOMAIN. And I told it to log on as that user in the> service control manager of the Control Panel.

It sounds like you probably have this incorrenct. The password ofthe user RadiusNT is running on is irrelevant (it must be correct,however). The WINNT\DOMAIN format is the USER'S password in thedatabase or text file that is trying to be authenticated. Theiractua NT password will be whatever is normally is. > Questions:> > 1. Exactly what permissions, or groups do I need to give to the user that> Radius logs on as?

Administrator Equivalent. > 2. What Groups do I need to add my Users to?

With 2.5, the users shouldn't need any special permissions.

-- 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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT and the SAMFrom: "John Bichao Jr." <johnb@cascadenet.com>Date: Thu, 30 Jul 1998 12:14:48 -0400

Dale,

I'm almost in the same situation. I've been helping a friend out when I can.He's running 2.2 if I remember correctly. I have it set to runfor him as a text users file. Works fine but he really wants to use the NTSAM. I have never been able to get it to work for him. All I dois move the users actual password to an identical account(same user id- case and everything)which is already created in the NT user manager.Then replace the password in the users file with the WINNT\DOMAINscheme(using the pfe32 program of coarse)and poof it doesn't work anymore. Imust be missing something. Please help.

-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.Sent: Thursday, July 30, 1998 11:48 AMTo: radiusnt@iea-software.comSubject: Re: RadiusNT and the SAM

Greg wrote:>> Ok, guys I need a little help her. I have read ALL the docs, and ALL the> archives, but this is my problem:>> I installed Radius 2.5 all went well> It will authenticate fine if the user name and password are in the userfile> explictly but not against the NT SAM.>> Radius is installed as a service, and I have a user in the User Managerwith> the password of WINNT\DOMAIN. And I told it to log on as that user in the> service control manager of the Control Panel.

It sounds like you probably have this incorrenct. The password ofthe user RadiusNT is running on is irrelevant (it must be correct,however). The WINNT\DOMAIN format is the USER'S password in thedatabase or text file that is trying to be authenticated. Theiractua NT password will be whatever is normally is.

> Questions:>> 1. Exactly what permissions, or groups do I need to give to the userthat> Radius logs on as?

Administrator Equivalent.

> 2. What Groups do I need to add my Users to?

With 2.5, the users shouldn't need any special permissions.

--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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Online Total By UserFrom: "logan.net support" <support@logan.net>Date: Thu, 30 Jul 1998 12:41:20 -0400

In the enhanced database, when does online total by user get reset? Doesall the time automatically go back to zero at the beginning of every month,or when the calls table is emptied? I am just wondering when I will have toprint it our for this month?

Thanks,Luke---------------logan.net tech supportsupport@logan.net937-593-7177 x 125

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius doesn't find a tableFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Thu, 30 Jul 1998 13:16:11 -0400

Victor, did you run the rad25_up2.sql script (if you're using RadiusNT2.5.x)? It's at: ftp.iea-software.com/radiusnt/rad25_up2.sql

Josh Hillmanhillman@talstar.com

----------> From: Victor Alba <victor@webjogger.net>> To: radiusnt@iea-software.com> Cc: support@iea-software.com> Subject: Radius doesn't find a table> Date: Thursday, July 30, 1998 11:27 AM> > RadiusNT is not authenticating at this moment, here is part of the output> of Radius -x15:> > ======================================================================> Decrypted Password: Cucho> Database Password: Cucho> Checking for duplicate logins.> > SQL Statement: RadCheckOnline 'Cucho'> > Cucho found on-line 0 time(s).> > SQL Statement: RadGetConfigs 342> > ODBC Error:S0022:207:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name> 'RadVendorID> '.> > Loading radius defaults for this type...> > SQL Statement: RadGetATConfigs 'PPP60+25+25'> > ODBC Error:S0022:207:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name> 'RadVendorID> '.> > Sending Reject of id 3 to d09d870a (PowerRack)> Cucho: PPP60+25+25 has no RADIUS default attributes.> > Cucho: PPP60+25+25 has no RADIUS default attributes.> > SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data)> VALUE> S (19, GetDate(), 'Cucho', 'Cucho')> > ODBC Error:S0022:207:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name'Data'.> > > Resp Time: 500 Auth: 0/0 -> 27 Acct: 1/0/0 -> 1>==============================================================================> > > > What can we do get Radius to authenticate...??> > > -Victor>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Problems with similar domains w/ProxyFrom: "Tony Schwartz" <tony@transport.com>Date: Thu, 30 Jul 1998 10:29:54 -0700

Hello all:

I am using Enterprise Evaluation with great success. Proxying seems to workvery fine.

A question has arisen that I cant get around:

If I am proxying off of a suffix of @aaaaaI cant hit a seperate suffix of @aaaaa.bbb

The first thought that comes to mind is to change the @aaaaa.bbb tosomething else unfortunately that is not an option. Any ideas??

Tony

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: RadiusNT and the SAMFrom: "Mike Roberts" <mike@datawest.net>Date: Thu, 30 Jul 1998 12:05:38 -0600

He (and I) want(s) to authenticate out of the NT SAM, by either group, or bywhether "grant dial-in access" is given.

Does RadiusNT do this?

*Mike Roberts*DataWest Internet, LLC*Colorado Springs - http://www.datawest.net*(719) 635-9999 - ICQ 387413

-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.Sent: Thursday, July 30, 1998 9:48 AMTo: radiusnt@iea-software.comSubject: Re: RadiusNT and the SAM

> Ok, guys I need a little help her. I have read ALL the docs, and ALL the> archives, but this is my problem:>> I installed Radius 2.5 all went well> It will authenticate fine if the user name and password are in the userfile> explictly but not against the NT SAM.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT and the SAMFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 11:33:17 -0700

Mike Roberts wrote:> > He (and I) want(s) to authenticate out of the NT SAM, by either group, or by> whether "grant dial-in access" is given.> > Does RadiusNT do this?

Not currently. I have been looking into the "grant dial-in access"and most likely group support 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 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Troubles with RadiusNT 2.5From: Shawn Ring <shawn@integrityonline.com>Date: Thu, 30 Jul 1998 00:29:54 -0700

We are currently running Radius NT 2.5 on a NT server in ODBC mode. Wehave been running it successfully now for about 2 months. Just last nightwe noticed Radius.exe using 70 - 95% of our processor! IT hasn't been thisway until now. Authentication is working normally and we have rebooted thesystem twice to make sure it received a clean startup. At this time we arenot sure of why it is taking that much of the processor. Any avenues wouldbe very appreciated at this time.

Thank you ahead of time for your help!!!!

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: radius 2.5 dr watson errorFrom: Christian Schmit <cschmit@vo.lu>Date: Thu, 30 Jul 1998 21:39:54 +0200

Hi,

We successfully run radius 2.5 with MS SQL serverin ODBC mode only for some months. Some weeks agowe changed the mode to both odbc and text an now radiuscrashes every 2-3 days.

Is this a known problem?

Thanks,Christian

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RadiusNT and SQL back-up questionFrom: postman@cp-tel.net (Postman Account)Date: Thu, 30 Jul 1998 14:54:36 -0500

Recently, we upsized our RadiusNT database to MS SQL.

I just tried to back-up our SQL server... and I noticed that the Radius database files were all skipped because they were in use. :(

Any suggestions as to how to properly back-up the whole server... including the Radius database files?

Please reply... thanks in advance.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: MultilinkingFrom: "Kevin Ingram" <kingram@cameron.net>Date: Thu, 30 Jul 1998 16:17:00 -0500

Does anyone here have any experience multilinking two connections togetherusing MS-RRAS? I can establish one connection or the other but not both atonce.

Thanks,Kevin Ingram

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: IIS 4.0 FTP or Frontpage 98 Server Extension/RadiusNT/SQL Authentication.From: "Rudy Komsic" <rudyk@cyberglobe.net>Date: Thu, 30 Jul 1998 17:27:59 -0400

Hello,

I was told by Microsoft that IIS 4.0 FTP and Frontpage is capable ofauthenticating via an ODBC Database. If anyone was able to get this working,could you please help me with getting this set up. I checked Microsoft'sSupport section and I can not obtain any info about this.

----Rudy KomsicPresident, Network Administrator - Cyberglobe Communications Inc.4996 Place de la Savane, Suite 200, Montreal, Quebec, H4P 1Z6Tel: (514)342-3883 Fax: (514)342-5139 E-Mail: rudyk@cyberglobe.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT and SQL back-up questionFrom: Glen Kowalski <admin@img.net>Date: Thu, 30 Jul 1998 14:38:45 -0700

At 02:54 PM 7/30/98 -0500, Postman Account wrote:>>Recently, we upsized our RadiusNT database to MS SQL. >>I just tried to back-up our SQL server... and I noticed >that the Radius database files were all skipped because >they were in use. :( >>Any suggestions as to how to properly back-up the >whole server... including the Radius database files? >>Please reply... thanks in advance.>>>>>>>The only software that we have found that is able to properly backup openfiles is Stac Replica.

Glen.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT and SQL back-up questionFrom: "Peter D. Mayer" <dmayer@netwalk.com>Date: Thu, 30 Jul 1998 18:42:13 -0400

The best way we've found to do this is to do an SQL Backup of your databaseeach night just before the machine backup runs.1)In Enterprise Manager, go to Tools>Database Backup/Restore.2)Under Database Device click New.3)Pick a name, and make sure "Disk Backup Device" is selected.4)Select the database you want backed up, and click Entire Database,Initialize Device, and No Expiration date.5)Then click on your newly created Backup Device and click schedule. Leavethe volume label blank.6)Select recurring, and select Daily, every 1 days, occurs once at 12:00AM(or just before your backup starts).

Then even though it doesn't backup your main database, it will still backupthe backup device. Then if you need to restore, just restore the backupdevice from tape and use the restore utility.

Just a suggestion,Peter D. MayerNetWalk Tech Supportdmayer@netwalk.com

-----Original Message-----From: Postman Account <postman@cp-tel.net>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Thursday, July 30, 1998 3:56 PMSubject: RadiusNT and SQL back-up question

>Recently, we upsized our RadiusNT database to MS SQL.>>I just tried to back-up our SQL server... and I noticed>that the Radius database files were all skipped because>they were in use.

>>Any suggestions as to how to properly back-up the>whole server... including the Radius database files?>>Please reply... thanks in advance.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Interesting Project for intertying NT User Manager with Emerald DatabaseFrom: "Rudy Komsic" <rudyk@cyberglobe.net>Date: Thu, 30 Jul 1998 19:45:38 -0400

After thinking long hours ( just a about 10 minutes in RL) I was wondering ifSQL could be triggered to execute an external batch process. If so, Emerald'sinterface for 2.5 can be customized to include the following fields to createweb pages with IIS software:

Fields needed in Emerald Database:

IISServer=Boolean Toggle to see if External process to create user account via ResourceKit's Create User command

Domain=varchar Domain the user is created on (usually the server's local user table, notthe whole company domain)

IISServerName=varchar Server where to create the user account.

IISClientDirectory=varchar The Directory that the client's website will be hosted on (usually in UNCstructure since we would use the Samba method (the one hackers use to gainaccess to a netbios connected drive) to connect to the domain to create thedirectory or use the net login command.

IISFPHosting=Boolean This would be to verify if the client will be hosting via Frontpage. Ifso, it will just create a new directory web site via the web administrationtools.

IISIPMap=varchar The IP Address the client's website will be using for binding to the site.

IISServerWebName=varchar The name the site will be called (usually full domain name www.xyz.com)

IISServerFTPName=varchar The name the site will be called via FTP

Any other variables that would be needed can be displayed at a later date.

Procedure of having Emerald setup the client's FTP or Frontpage site.

If the IISServer has a value of true, then on the SQL Server the run externalprocess would start the batch file with the variables needed to first createthe Client's account. We could use the Resource Kit's create user program tomake the account with the appropriate values and have them assigned to thecorrect groups. Along with the username and password would come theExpiration date as well. This way Emerald would control the dates and activeaccount information for the client. The client's Home directory will be basedwithin the User Manager via a global directory name based on the copied useraccount defined for this (usually Z:\INetPub\users.xyz.com\~%USERNAME%). IFthe client has a full domain name, then a different home directory would beused (Z:\INetPub\%VALUE%-%USERNAME%, Value is the value passed fromIISServerWebName and username is to make easy tracking for accoutningpurposes).

The Next step would be to use the power of SQL to make a HTML Request to thedestination server and access a modified version of the ASP web basedadministration page where it would create the virtual site and bind it to anavailable IP that was assigned via IISIPMap. If the server is gonna be afrontpage server, the IISFPHosting will determine if the Frontpage Hostingfeatures would be activated. Any additional features could be defined at alater date that would be needed for this.

If the site is not gonna be Frontpage hosted, then a second ASP request wouldbe made to make the www.xyz.com be associated to ftp.xyz.com. The client'sFTP Site would not have anonymous login and could access it via username andpassword. If the client's site is a virtual directory, the same would followbut he would see a list of all directories in the virtual site. He will onlyhave access to his directory structure only as read and write.

Now if the client needs a CGI-BIN directory, this can also be created via theweb-based management.

If anyone out there is interested in programming this, I would like to hearfrom you so that we could work together on this and finally have Emerald workdirectly with NT and IIS instead of using just one FTP server solution.

Dale, any insite on this type of configuration that could be added to Emeraldto make this function or give negative feedback on this would be appreciated.

Now the task of finding someone who would be interested in developing this(prefer a Canadian Programmer since we are based in Canada)

----Rudy KomsicPresident, Network Administrator - Cyberglobe Communications Inc.4996 Place de la Savane, Suite 200, Montreal, Quebec, H4P 1Z6Tel: (514)342-3883 Fax: (514)342-5139 E-Mail: rudyk@cyberglobe.net

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: radius 2.5 dr watson errorFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 18:23:27 -0700

Christian Schmit wrote:> > We successfully run radius 2.5 with MS SQL server> in ODBC mode only for some months. Some weeks ago> we changed the mode to both odbc and text an now radius> crashes every 2-3 days.

Please give more details of the config. What options do you haveenabled. Are you using the reload option?

-- 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 23 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Online Total By UserFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 18:34:29 -0700

logan.net support wrote:> > In the enhanced database, when does online total by user get reset? Does> all the time automatically go back to zero at the beginning of every month,> or when the calls table is emptied? I am just wondering when I will have to> print it our for this month?

The enhanced database was contributed by a customer. I don't think itdoes any database managament (like Emerald does). Its probably justa summary of the calls table, for whatever period of data is in there.

-- 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 24 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: RadiusNT and the SAMFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 18:35:56 -0700

John Bichao Jr. wrote:> > I'm almost in the same situation. I've been helping a friend out when I can.> He's running 2.2 if I remember correctly. I have it set to run> for him as a text users file. Works fine but he really wants to use the NT> SAM. I have never been able to get it to work for him. All I do> is move the users actual password to an identical account(same user id> - case and everything)which is already created in the NT user manager.> Then replace the password in the users file with the WINNT\DOMAIN> scheme(using the pfe32 program of coarse)and poof it doesn't work anymore. I> must be missing something. Please help.

I would recommend using 2.5. It resolves the old permissionrequirementsandalso is more descriptive of a permission problem, if one stillexists.

-- 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 25 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Exact Disconnect Time.From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 19:06:35 -0700

Gaby wrote:> > Does anyone know if the PortMaster 2E supports the session-timeout> feature> that RadiusNT sends back to the NAS to disconnect users on exactly the> remaining time> they have?

Yes, it does. > Do I need to do anything more than turn on TimeBanking, properly populate the> server ports table, and make sure the callsonline view workx.

Nope. CallsOnline doesn't have anything to do with TimeBanking though(except maybe concurrency control). > P.S. - Dave I never figured out why the manual service update for timebanking> wasn't working, so I just modified and pasted in the trigger to do the> trick, it seems to work great! It's just as efficient, no?

A trigger is always more efficient than RadiusNT manually doing things.

-- 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 26 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Troubles with RadiusNT 2.5From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 19:11:29 -0700

Shawn Ring wrote:> > We are currently running Radius NT 2.5 on a NT server in ODBC mode. We> have been running it successfully now for about 2 months. Just last night> we noticed Radius.exe using 70 - 95% of our processor! IT hasn't been this> way until now. Authentication is working normally and we have rebooted the> system twice to make sure it received a clean startup. At this time we are> not sure of why it is taking that much of the processor. Any avenues would> be very appreciated at this time.

You could run it in debug mode and see if you can catch when its using that much CPU. The debug should let you know whats going on.

-- 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 27 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius against NTFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 30 Jul 1998 19:13:50 -0700

Greg wrote:> > Can someone please email me the proper entry in the user file to have> Emerald Radius authenticate all users against the NT Sam file (WinNT40SP3).> > We need to get it up and running so we can try it before we fully turn down> the Livingston Radius. Currently we have one default entry that send all> authentication to the NT SAM.

Can you include that Entry? Is RadiusNT running in both mode?Does the uesr RadiusNT is running as have permissions to login auser (ie. administrator rights).

-- 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 28 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Exact Disconnect Time.From: Gaby <gaby@inco.com.lb>Date: Fri, 31 Jul 1998 09:19:08 +0200

Sorry 'bout this guys. It turns out I was multiplying my TimeLeft Field by3600 instead of60 and the session time out always turned out to be 60 times that of what Iwanted it to be.Twas a problem with my script generator.

Thanx.Again.

At 10:12 AM 7/30/98 +0200, you wrote:> Does anyone know if the PortMaster 2E supports the session-timeout>feature>that RadiusNT sends back to the NAS to disconnect users on exactly the>remaining time>they have?>>Do I need to do anything more than turn on TimeBanking, properly populate the >server ports table, and make sure the callsonline view workx.>>Thanx,>Gabe.>>P.S. - Dave I never figured out why the manual service update for timebanking> wasn't working, so I just modified and pasted in the trigger to do the> trick, it seems to work great! It's just as efficient, no?>>>