Message 2: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: RE: User Restrictions
from "Michael Edholm" <me@wineasy.se>
Message 4: Re: User Restrictions
from "David Leigh" <davidl@logi.net.au>
Message 5: Re: CLARIFICATION RRAS AND CHAP
from "Terry Bomersbach" <terryb@the-cia.net>
Message 6: ODBC vs Text
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 7: Starting...
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 8: RE: Text backup from database - more
from "Kurt Lange" <klange@usinternet.com>
Message 9: RE: Framed-Route
from "Ken Sorenson" <ksoren@tsi-online.com>
Message 10: RE: Framed-Route
from "Ken Sorenson" <ksoren@tsi-online.com>
Message 11: Re: Framed-Route
from "Terry Bomersbach" <terryb@the-cia.net>
Message 12: Re: Framed-Route
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: Text backup from database - more
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 14: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: Re: Starting...
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 16: Re: User Restrictions
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 17: Re: ODBC vs Text
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 18: Re: Starting...
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 19: Re: Starting...
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 20:
from "Lorri Manning" <lorri@cowtown.net>
Message 21: Re: Starting... and reinstalling...
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 22: Re: Starting... and reinstalling...
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 23: Re: Starting... and reinstalling...
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 24: FIX: VerifyMailUser and Multiple Virtual Domains
from "Rudy Komsic" <rudyk@cyberglobe.net>
Message 25: Strange Log
from "Humberto Guzman" <hguzman@sysop.com.mx>
Message 26: Re: FIX: VerifyMailUser and Multiple Virtual Domains
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 27: Database was: Starting...
from "Humberto Guzman" <hguzman@sysop.com.mx>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: User Restrictions
From: Tim Ballingall <tim@mazda.com.au>
Date: Thu, 20 Aug 1998 16:54:36 +1000
Thanks Dale,
I was wondering though if it is possible to assign fixed IP addresses to
users.
Thanks again
Tim
-----Original Message-----
From: Dale E. Reed Jr. [mailto:daler@iea-software.com]
Sent: Thursday, August 20, 1998 8:42 AM
To: radiusnt@iea-software.com
Subject: Re: User Restrictions
Tim Ballingall wrote:
>
> I was wondering if Radius has any facility to restrict user access to
> particular hosts.
>
> I have a Cisco 2511 & I can put IP filters that block access from a
> particular address to any other address.
>
> Would it be feasible to assign a specific IP address to one user &
then
> apply my IP filters to this address & thus the user as well ?
You should be able to specify the filter for the user and the
Cisco will apply it for that user (regarless of their IP) for
the duration of the call.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.comThis message has successfully passed virus checking.Mazda Australia takes every precaution to ensure email messages are virus free. For complete protection, you should virus test this message.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: User RestrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 02:01:29 -0700
Tim Ballingall wrote:> > I was wondering though if it is possible to assign fixed IP addresses to> users.
Sure. Its just one more attribute for the user. :)
-- 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: User RestrictionsFrom: "Michael Edholm" <me@wineasy.se>Date: Thu, 20 Aug 1998 11:19:21 +0200
Hi Dale
If you run your Radius server in ODBC mode you are saying that I should makeanother field in the subaccounts table for the fixed ip adress? If that isthe case which fields do I need to add in the table?
/Michael Edholm
WinEasy Staff
> -----Original Message-----> From: radiusnt-request@iea-software.com> [mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.> Sent: den 20 augusti 1998 11:01> To: radiusnt@iea-software.com> Subject: Re: User Restrictions>>> Tim Ballingall wrote:> >> > I was wondering though if it is possible to assign fixed IP addresses to> > users.>> Sure. Its just one more attribute for the user. :)>> --> 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: User RestrictionsFrom: "David Leigh" <davidl@logi.net.au>Date: Thu, 20 Aug 1998 20:00:40 +0800
Hi Dale
I've downloaded and read the 45 page guide for RadiusNT usage with ODBC.However, the explanation of the various methods of configuring still left mepuzzled. Is there a longer, step by step walkthrough available anywhere. Iam thinking of an idiot's guide. Not just any idiot mind you - I'm talkingan utterly-exhausted "I've been awake 3 days can't think at all and have tohave a demo Radius going by Monday" sort of idiot. Any help would beappreciated. Even idiots feel gratitude :)
Cheers
David Leigh
-----Original Message-----From: Michael Edholm <me@wineasy.se>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Thursday, August 20, 1998 5:18 PMSubject: RE: User Restrictions
>Hi Dale>>If you run your Radius server in ODBC mode you are saying that I shouldmake>another field in the subaccounts table for the fixed ip adress? If that is>the case which fields do I need to add in the table?>>/Michael Edholm>>WinEasy Staff>>>> -----Original Message----->> From: radiusnt-request@iea-software.com>> [mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.>> Sent: den 20 augusti 1998 11:01>> To: radiusnt@iea-software.com>> Subject: Re: User Restrictions>>>>>> Tim Ballingall wrote:>> >>> > I was wondering though if it is possible to assign fixed IP addressesto>> > users.>>>> Sure. Its just one more attribute for the user. :)>>>> -->> 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 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: CLARIFICATION RRAS AND CHAPFrom: "Terry Bomersbach" <terryb@the-cia.net>Date: Thu, 20 Aug 1998 07:59:12 -0500
>RadiusNT records the password as "CHAP", since it doesn't have a clear>text password to record for the user (its one-way encrypted). Have>you verified whether PAP works (and if its not, did you check your>secrets and see what -x15 showed for it?). I would get PAP working>first.
PAP works, but if I restart the NT server I have to remove the registryentries again for CHAP and SPAP. They are haunting me.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: ODBC vs TextFrom: "Humberto Guzman" <hguzman@sysop.com.mx>Date: Thu, 20 Aug 1998 08:51:04 +0000
Hello,
I just installed Radius NT yesterday, I read through the dosumentation anddid not find the following:
Which MODE is better (or should I try to setup) Text or ODBC???
I already have SQL running, and it is a fresh install of Radius NT (notmigraing from another radius flavor)
Thanks!Humberto G
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Starting...From: "Humberto Guzman" <hguzman@sysop.com.mx>Date: Thu, 20 Aug 1998 09:34:02 +0000
....just installed radius NT, when starting tthe service I get a log filefilled with errors... Please help :)
Log file:
Thu Aug 20 09:22:04 1998: Invalid Database or Computer Date.Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'RadAttributes'.Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'RadValues'.Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Servers'.Thu Aug 20 09:22:04 1998: RadiusNT: Parse error -95 for user testThu Aug 20 09:22:04 1998: RadiusNT Enterprise Initialized...
Any ideas what this may mean? Anyway seems radius NT DID start...
cyaHumberto Guzman________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet
Tel. 338-9424
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Text backup from database - moreFrom: "Kurt Lange" <klange@usinternet.com>Date: Thu, 20 Aug 1998 11:02:05 -0500
Dale, sorry there was some confusion in my previous message. The attributename is correct "Framed-Route", that was just a misspelling in my email.It's the quotes around the actual data that are the problem.
It seems to me there is an issue in the conversion from ODBC to Text. Ifthe data "1.1.1.0/24 2.2.2.2 1" saved in SQL is in quotes it will not loadin the routing table when auth'ing against ODBC. To get the data to havequotes around it using radusers.exe you have to put it in quotes in SQL butyou can't have quotes around it if you want it to work when auth'ing againstODBC. Is it possible for radusers.exe to add quotes around multi parameterdata, i.e. 1.1.1.0/24 2.2.2.2 1 gets saved to the text file as "1.1.1.0/242.2.2.2 1"?
Framed-Route = "1.1.1.0/24 2.2.2.2 1"Loads text file in RadiusNT but doesn't work on NAS (USR TC HUB/NetServer)auth'ing against ODBC.
Framed-Route = 1.1.1.0/24 2.2.2.2 1Works on NAS auth'ing from ODBC but RadiusNT gives the following error ontext file load:
radius: attribute name 2.2.2.2 not foundradius: Parse error -95 for user USERNAME
It can be hard to explain things in email, hope that's clear??? Thanks foryour help...
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale E. Reed Jr.Sent: Wednesday, August 19, 1998 10:59 PMTo: radiusnt@iea-software.comSubject: Re: Text backup from database - more
Kurt Lange wrote:>> I was playing with radusers.exe and ran in to a problem with attributesthat> have more then one parameter. It appears that attributes with a space in> them i.e. Framed Route, won't load from the text file. When I put theroute> in with quotes around it it will load from the file and appears to auth OK> but the route doesn't work in the NAS (it does work when NOT in quotes).
Framed-Route should be "Framed-Route". Attriubute names can not havespaces in them. This is reall the Emerald compatability issue thatI was referring to with the newer version of radusers.
> Framed Route "1.1.1.0/24 2.2.2.2 1"> Loads text file in RadiusNT but doesn't work on NAS (USR TCHUB/NetServer).>> Framed Route 1.1.1.0/24 2.2.2.2 1> Works on NAS but RadiusNT gives the following error on load:>> radius: attribute name 2.2.2.2 not found> radius: Parse error -95 for user USERNAME> 1778 users loaded!
It should be:
Framed-Route = "1.1.1.0/24 2.2.2.2 1"
For string attributes, you must include the begin/end quotes in thedata field of the RadConfigs/RadATConfigs tables.
--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: RE: Framed-RouteFrom: "Ken Sorenson" <ksoren@tsi-online.com>Date: Thu, 20 Aug 1998 11:39:32 -0500
Thanks for the response. One more ignorant question... I am not familiarwith the conversion.. what process do I use to resolve 255.255.255.224 to/27? Ect...
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Thursday, August 20, 1998 1:35 AMTo: radiusnt@iea-software.comSubject: Re: Framed-Route
Ken Sorenson wrote:>> Hello Dale.. I am wondering if my problem is related to this. I am tryingto> place specific route in my Emerald subacounts with little success. I am> using 3com/TC Hyperarcs.. When I Place the routes statically in theHyperarc> they work.. When I use Framed-Route in RadiusNT, It seems to disregard the> whole statement. I see it loading in -x15, however nothing changes in my> route table.>> Ex:> Framed-Route 201.92.75.11 255.255.255.255 208.167.95.3 2> Or> Framed-Route 201.92.75.64 255.255.255.224 208.167.95.3 2>> I have utilized the Framed-Address, and Framed-Netmask...
The format for Framed-Route is:
x.x.x.x/yy z.z.z.z
Where x.x.x.x is the source address and yy is the subnet. z.z.z.zis the gateway for it.
> I figure I am missing something obvious.>> Also, I am getting two unknown attributes, 50 and 51. From the 3com docsit> appears that 50=Account-Multi-Session-Id, 51=Account-Link-Count. Howshould> do I add these?
Either using the Emerald Admin, Config Radius, or directory to theRadAttriutes table.
--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 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Framed-RouteFrom: "Ken Sorenson" <ksoren@tsi-online.com>Date: Thu, 20 Aug 1998 12:37:55 -0500
Heh.. Nevermind.. I think I need more sleep....
Thanks.KS
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com] On Behalf Of Ken SorensonSent: Thursday, August 20, 1998 11:40 AMTo: radiusnt@iea-software.comSubject: RE: Framed-Route
Thanks for the response. One more ignorant question... I am not familiarwith the conversion.. what process do I use to resolve 255.255.255.224 to/27? Ect...
-----Original Message-----From: radiusnt-request@iea-software.com[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Thursday, August 20, 1998 1:35 AMTo: radiusnt@iea-software.comSubject: Re: Framed-Route
Ken Sorenson wrote:>> Hello Dale.. I am wondering if my problem is related to this. I am tryingto> place specific route in my Emerald subacounts with little success. I am> using 3com/TC Hyperarcs.. When I Place the routes statically in theHyperarc> they work.. When I use Framed-Route in RadiusNT, It seems to disregard the> whole statement. I see it loading in -x15, however nothing changes in my> route table.>> Ex:> Framed-Route 201.92.75.11 255.255.255.255 208.167.95.3 2> Or> Framed-Route 201.92.75.64 255.255.255.224 208.167.95.3 2>> I have utilized the Framed-Address, and Framed-Netmask...
The format for Framed-Route is:
x.x.x.x/yy z.z.z.z
Where x.x.x.x is the source address and yy is the subnet. z.z.z.zis the gateway for it.
> I figure I am missing something obvious.>> Also, I am getting two unknown attributes, 50 and 51. From the 3com docsit> appears that 50=Account-Multi-Session-Id, 51=Account-Link-Count. Howshould> do I add these?
Either using the Emerald Admin, Config Radius, or directory to theRadAttriutes table.
--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 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Framed-RouteFrom: "Terry Bomersbach" <terryb@the-cia.net>Date: Thu, 20 Aug 1998 12:24:36 -0500
255.255.255.255 = 32255.255.255.252 = 30255.255.255.248 = 29255.255.255.240 = 28255.255.255.224 = 27255.255.255.192 = 26255.255.255.? = 25255.255.255.0 = 24
Sorry, can't help on the 128 address conversion as I don't use it enough.It's also in the Ascend manuals.
-----Original Message-----From: Ken Sorenson <ksoren@tsi-online.com>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Thursday, August 20, 1998 11:26 AMSubject: RE: Framed-Route
>Thanks for the response. One more ignorant question... I am not familiar>with the conversion.. what process do I use to resolve 255.255.255.224 to>/27? Ect...>>-----Original Message----->From: radiusnt-request@iea-software.com>[mailto:radiusnt-request@iea-software.com] On Behalf Of Dale E. Reed Jr.>Sent: Thursday, August 20, 1998 1:35 AM>To: radiusnt@iea-software.com>Subject: Re: Framed-Route>>Ken Sorenson wrote:>>>> Hello Dale.. I am wondering if my problem is related to this. I am trying>to>> place specific route in my Emerald subacounts with little success. I am>> using 3com/TC Hyperarcs.. When I Place the routes statically in the>Hyperarc>> they work.. When I use Framed-Route in RadiusNT, It seems to disregardthe>> whole statement. I see it loading in -x15, however nothing changes in my>> route table.>>>> Ex:>> Framed-Route 201.92.75.11 255.255.255.255 208.167.95.3 2>> Or>> Framed-Route 201.92.75.64 255.255.255.224 208.167.95.3 2>>>> I have utilized the Framed-Address, and Framed-Netmask...>>The format for Framed-Route is:>>x.x.x.x/yy z.z.z.z>>Where x.x.x.x is the source address and yy is the subnet. z.z.z.z>is the gateway for it.>>> I figure I am missing something obvious.>>>> Also, I am getting two unknown attributes, 50 and 51. From the 3com docs>it>> appears that 50=Account-Multi-Session-Id, 51=Account-Link-Count. How>should>> do I add these?>>Either using the Emerald Admin, Config Radius, or directory to the>RadAttriutes table.>>-->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 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Framed-RouteFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:11:34 -0700
Ken Sorenson wrote:> > Thanks for the response. One more ignorant question... I am not familiar> with the conversion.. what process do I use to resolve 255.255.255.224 to> /27? Ect...
Its a bit count. Each octetc is 8 bits. Therefore 255.255.255.0 is8+8+8+0 = 24. 224 is 128 + 64 + 32 (the three highest bits of the lastoctet) which would be 8+8+8+3 or /27.
> The format for Framed-Route is:> > x.x.x.x/yy z.z.z.z> > Where x.x.x.x is the source address and yy is the subnet. z.z.z.z> is the gateway for it.> > > I figure I am missing something obvious.> >> > Also, I am getting two unknown attributes, 50 and 51. From the 3com docs> it> > appears that 50=Account-Multi-Session-Id, 51=Account-Link-Count. How> should> > do I add these?> > Either using the Emerald Admin, Config Radius, or directory to the> RadAttriutes table.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Text backup from database - moreFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:18:56 -0700
Kurt Lange wrote:> > Dale, sorry there was some confusion in my previous message. The attribute> name is correct "Framed-Route", that was just a misspelling in my email.> It's the quotes around the actual data that are the problem.> > It seems to me there is an issue in the conversion from ODBC to Text. If> the data "1.1.1.0/24 2.2.2.2 1" saved in SQL is in quotes it will not load> in the routing table when auth'ing against ODBC. To get the data to have> quotes around it using radusers.exe you have to put it in quotes in SQL but> you can't have quotes around it if you want it to work when auth'ing against> ODBC. Is it possible for radusers.exe to add quotes around multi parameter> data, i.e. 1.1.1.0/24 2.2.2.2 1 gets saved to the text file as "1.1.1.0/24> 2.2.2.2 1"?
Yes. I realized this laster last night. The new radusers does infactcorrectly handle the quotes so that it is correct all around. I'll tryto get the new one available soon. It uses a completely different setof stored procedures, has better problem recovery, and can store to afile directly (not stdio).
--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: Re: User RestrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:29:06 -0700
David Leigh wrote:> > I've downloaded and read the 45 page guide for RadiusNT usage with ODBC.> However, the explanation of the various methods of configuring still left me> puzzled. Is there a longer, step by step walkthrough available anywhere. I> am thinking of an idiot's guide. Not just any idiot mind you - I'm talking> an utterly-exhausted "I've been awake 3 days can't think at all and have to> have a demo Radius going by Monday" sort of idiot. Any help would be> appreciated. Even idiots feel gratitude :)
There is no additional documentation for RadiusNT besides the currentmanual. What specific function or operation are you having problemswith?
Because of the technical nature of RadiusNT, we do recommend abase level of technical knowledge for using it in a stand alone environment. We have a full ISP suite that includes RadiusNT and isGUI driven for those people who want an easier to use packagewithout having to understand the details underneath it.
--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 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Starting...From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:33:55 -0700
Humberto Guzman wrote:> > ...just installed radius NT, when starting tthe service I get a log file> filled with errors... Please help :)> > Log file:> > Thu Aug 20 09:22:04 1998: Invalid Database or Computer Date.> Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name> 'RadAttributes'.> Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name> 'RadValues'.> Thu Aug 20 09:22:04 1998: ODBC Error:S0002:208:> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Servers'.> Thu Aug 20 09:22:04 1998: RadiusNT: Parse error -95 for user test> Thu Aug 20 09:22:04 1998:> RadiusNT Enterprise Initialized...> > Any ideas what this may mean? Anyway seems radius NT DID start...
Most likely you didn't set the database in the ODBC DSN. RadiusNTcan not find any of the tables it is looking for. This could alsobe that you didn't create the tables before hand. The SQL Scriptsfor SQL Server are on the FTP site in the /radiusnt/mssql directory.
--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 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: User RestrictionsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:36:14 -0700
Michael Edholm wrote:> > If you run your Radius server in ODBC mode you are saying that I should make> another field in the subaccounts table for the fixed ip adress? If that is> the case which fields do I need to add in the table?
No. You would add entries in the RadConfigs table matching the user'sAccountID with the RADIUS attributes you want specifically for that user (like Framed-Address).
--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 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC vs TextFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 11:39:41 -0700
Humberto Guzman wrote:> > I just installed Radius NT yesterday, I read through the dosumentation and> did not find the following:> > Which MODE is better (or should I try to setup) Text or ODBC???
This depends on what you want. If you don't want/need any of the ODBC features, you can use text. I typically recommend setting uptext mode first, then going to ODBC.
--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 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Starting...From: "Humberto Guzman" <hguzman@sysop.com.mx>Date: Thu, 20 Aug 1998 13:51:44 +0000
Thanks Dale...
I reinstalled, reading step by step of the manual :)
I created the ODBC DSN manually...
Now I am gettting the following log:
Thu Aug 20 13:49:31 1998: RadiusNT Enterprise Initialized...Thu Aug 20 13:49:38 1998: ODBC Error:23000:233: [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in tableCalls may not be null.
any ideas? ...thanks!Humberto G
>Most likely you didn't set the database in the ODBC DSN. RadiusNT>can not find any of the tables it is looking for. This could also>be that you didn't create the tables before hand. The SQL Scripts>for SQL Server are on the FTP site in the /radiusnt/mssql directory.>>-->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> ________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet
Tel. 338-9424
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Starting...From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 13:30:08 -0700
Humberto Guzman wrote:> > I reinstalled, reading step by step of the manual :)> > I created the ODBC DSN manually...> > Now I am gettting the following log:> > Thu Aug 20 13:49:31 1998:> RadiusNT Enterprise Initialized...> Thu Aug 20 13:49:38 1998: ODBC Error:23000:233:> [Microsoft][ODBC SQL Server Driver][SQL Server]The column NASPort in table> Calls may not be null.
In Enterprise Manager, expand down to the calls table and select edit.In the default value for the NASPort column enter (-1) and save thetable. That should fix this error.
-- 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 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Lorri Manning" <lorri@cowtown.net>Date: Thu, 20 Aug 1998 16:39:07 -0500
unsubscribe
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Starting... and reinstalling...From: "Humberto Guzman" <hguzman@sysop.com.mx>Date: Thu, 20 Aug 1998 16:49:59 +0000
Well... solved that reinstalling, now I am getting a much simpler error,which may then lead to the same one. Now I get in my log file:
Thu Aug 20 16:48:24 1998: Invalid Database or Computer Date.Thu Aug 20 16:48:24 1998: RadiusNT Enterprise Initialized...
Thanks!Humberto Guzman
>In Enterprise Manager, expand down to the calls table and select edit.>In the default value for the NASPort column enter (-1) and save the>table. That should fix this error.>>-- >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> ________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet
Tel. 338-9424
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Starting... and reinstalling...From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 20 Aug 1998 15:22:51 -0700
Humberto Guzman wrote:> > Well... solved that reinstalling, now I am getting a much simpler error,> which may then lead to the same one. Now I get in my log file:> > Thu Aug 20 16:48:24 1998: Invalid Database or Computer Date.> Thu Aug 20 16:48:24 1998:> RadiusNT Enterprise Initialized...
This just means that RadiusNT couldn't find a license key and is inEval mode. You can request an eval key from sales to make the errorgo away.
-- 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: Starting... and reinstalling...From: "Humberto Guzman" <hguzman@sysop.com.mx>Date: Thu, 20 Aug 1998 17:31:45 +0000
Thanks!I asked for it right now...Now I get the following in logs:Thu Aug 20 17:28:34 1998: ODBC Error:S0022:207: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'.
strange?
Thanks a Bunch!Guzman
At 03:22 PM 8/20/98 -0700, you wrote:>Humberto Guzman wrote:>> >> Well... solved that reinstalling, now I am getting a much simpler error,>> which may then lead to the same one. Now I get in my log file:>> >> Thu Aug 20 16:48:24 1998: Invalid Database or Computer Date.>> Thu Aug 20 16:48:24 1998:>> RadiusNT Enterprise Initialized...>>This just means that RadiusNT couldn't find a license key and is in>Eval mode. You can request an eval key from sales to make the error>go away.>>-- >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> ________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet
Tel. 338-9424
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 24 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: FIX: VerifyMailUser and Multiple Virtual DomainsFrom: "Rudy Komsic" <rudyk@cyberglobe.net>Date: Thu, 20 Aug 1998 18:45:07 -0400
After spending some time battling with SQL's stored Procedure VerifyMailUserto get it to list only 1 user for the proper domain, I had modified thefollowing lines:
AND ( Login = @usernameOR shell = @usernameOR Email = @username + "@" + @domain)
To look like this:
AND ( Email = @username + "@" + @domainOR shell + "@" + d.maildomain = @username + "@" + @domainOR Login + "@" + d.maildomain = @username + "@" + @domain)
In Emerald, when I set someone a new subaccount for the isp domain, I use thefollowing:Username: supportPassword: xxxxEMail: <Blank>
Now when I have a client who has a virtual domain name on our server (eg:test.com), I use the following to setup his Email information to avoidusername and email login duplication:
Username: support-test.comPassword: yyyyEMail: support@test.com
Now when the user tries loggin in via the virtually hosted domain (eg: pop3:mail.test.com) when it asks for username, he would type in support and hisyyyy password and VerifyMailUser will properly select the right username forthe account. The support-test.com username is there as reference to knowwhich support account from the domain name it belongs to.
Wel here is the FULL VerifyUserName procedure if anyone would like to use it.
PLEASE NOTE: If you did not specify Domains and Billing Groups for Domains inthe Emerald Administration, You MUST Add the EMail: Address for each domainclient. Without it, he will not be able to login.
Hope this helps a lot of you Mail domain hosters.
----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
VerifyMailUser Procedure below.-----if exists (select * from sysobjects where id = object_id('dbo.VerifyMailUser')and sysstat & 0xf = 4) drop procedure dbo.VerifyMailUserGO
CREATE PROCEDURE VerifyMailUser @username varchar(32), @domain varchar(32),@esid integer AS
Select Login, Shell, EMail, d.MailDomain, Password, HomeDir