Message 2: MS SQL Server 6.5 Questions
from postman@cp-tel.net (Postman Account)
Message 3: RRAS = Error 1053
from Celso Carvalho do Amaral <webmaster@douranet.com.br>
Message 4: RRAS = Error 1053
from Celso Carvalho do Amaral <webmaster@douranet.com.br>
Message 5: Re: RRAS = Error 1053
from "Lorri Thomas" <lorri@cowtown.net>
Message 6: Re: RRAS = Error 1053
from "Lorri Thomas" <lorri@cowtown.net>
Message 7: Year 2000 compliance
from PSS <pss@sunbeach.net>
Message 8: Re: Year 2000 compliance
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 9: MS Access97 to MS SQL
from postman@cp-tel.net (Postman Account)
Message 10: Re: MS Access97 to MS SQL
from Mike Noel <noel@integrityonline.com>
Message 11: Radlogs and ASCEND Max 4004
from "Pat Augustine" <pata@ilnk.com>
Message 12: Re: Radlogs and ASCEND Max 4004
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Fw: multilink
from "Andrew Hall" <aah@impaq.net.au>
Message 14: Re: RadiusNT 2.5.124 startup problem
from "2Day Internet" <peter@2day.net.nz>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RadiusNT 2.5.124 startup problem
From: "2Day Internet" <peter@2day.net.nz>
Date: Mon, 15 Jun 1998 19:04:41 +1200
Until recently I have been running RadiusNT in debug mode. I have just
taken to starting it as a service when the machine starts.
It does not seem to want to authenticate when started in this way however.
If I stop the service and then restart it after boot time, it starts
authenticating.
Is it possible it is attempting to communicate with MS SQL dB before SQL
server has completed startup?
Is there some way of having RadiusNT retry the odbc connect if it does not
successfully connect the first time?
regards
Peter Mott
Chief Enthusiast
2Day Internet Limited.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: MS SQL Server 6.5 Questions
From: postman@cp-tel.net (Postman Account)
Date: Mon, 15 Jun 1998 11:09:29 -0500
I'm attempting to setup MS SQL Server to use
with RadiusNT.
I've started the SQL service... went to the ODBC32
manager in Control Panel... added Radius as
a SQL database... as the RadiusNT instructions
outlined.
Whenever I run "radius -x15", it only loads 1 client
(when there are actually about 14 clients).
If I set it up as an Access 97 database in the ODBC
manager, it loads all 14 clients with "radius -x15"...
and RadiusNT works.
What am I overlooking?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RRAS = Error 1053
From: Celso Carvalho do Amaral <webmaster@douranet.com.br>
Date: Mon, 15 Jun 1998 14:27:18 -0400
Hi
I have a PM3. It works very well in Radius 2.5 but the RRAS of the Internet
option pack does not update the calls table. The error message is 1053.
Index or primary key can't contain a Null value. I have already changed the
name of Attribute #4 from NAS-IP-Address to NAS-Identifier in the
RadAttributes table but this does not work either. When I use Microsoft's
Radius both the PM3 and the RRAS work. What could be some other options
that I could try to resolve this problem? Thanks for your time.
Celso Carvalho do Amaral
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 4 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RRAS = Error 1053
From: Celso Carvalho do Amaral <webmaster@douranet.com.br>
Date: Mon, 15 Jun 1998 14:27:18 -0400
Hi
I have a PM3. It works very well in Radius 2.5 but the RRAS of the Internet
option pack does not update the calls table. The error message is 1053.
Index or primary key can't contain a Null value. I have already changed the
name of Attribute #4 from NAS-IP-Address to NAS-Identifier in the
RadAttributes table but this does not work either. When I use Microsoft's
Radius both the PM3 and the RRAS work. What could be some other options
that I could try to resolve this problem? Thanks for your time.
Celso Carvalho do Amaral
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 5 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: RRAS = Error 1053
From: "Lorri Thomas" <lorri@cowtown.net>
Date: Mon, 15 Jun 1998 13:42:17 -0500
We're running the same setup. Go into your Calls table, in design view and
put in a default value of 9999. This should stop the error. Also in your
Servers table, make sure there is an entry for "localhost" with an IP
address of 127.0.0.1 and a password of secret.
Lorri Thomas - Operations Manager
Cowtown Net, Inc., 3044 Wichita Court,
Fort Worth, TX 76140
http://www.cowtown.net
"No matter how hard you try, you can't baptize cats."
-----Original Message-----
From: Celso Carvalho do Amaral <webmaster@douranet.com.br>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Monday, June 15, 1998 2:33 PM
Subject: RRAS = Error 1053
|Hi
|
|I have a PM3. It works very well in Radius 2.5 but the RRAS of the Internet
|option pack does not update the calls table. The error message is 1053.
|Index or primary key can't contain a Null value. I have already changed the
|name of Attribute #4 from NAS-IP-Address to NAS-Identifier in the
|RadAttributes table but this does not work either. When I use Microsoft's
|Radius both the PM3 and the RRAS work. What could be some other options
|that I could try to resolve this problem? Thanks for your time.
|
|Celso Carvalho do Amaral
|
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 6 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: RRAS = Error 1053
From: "Lorri Thomas" <lorri@cowtown.net>
Date: Mon, 15 Jun 1998 13:45:43 -0500
Oops! Forgot to tell you what field in the Calls table = NasPort default
value = 9999
-----Original Message-----
From: Lorri Thomas <lorri@cowtown.net>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Monday, June 15, 1998 2:44 PM
Subject: Re: RRAS = Error 1053
|We're running the same setup. Go into your Calls table, in design view and
|put in a default value of 9999. This should stop the error. Also in your
|Servers table, make sure there is an entry for "localhost" with an IP
|address of 127.0.0.1 and a password of secret.
|
|Lorri Thomas - Operations Manager
|Cowtown Net, Inc., 3044 Wichita Court,
|Fort Worth, TX 76140
|http://www.cowtown.net
|
|"No matter how hard you try, you can't baptize cats."
|
|-----Original Message-----
|From: Celso Carvalho do Amaral <webmaster@douranet.com.br>
|To: radiusnt@iea-software.com <radiusnt@iea-software.com>
|radiusnt@iea-software.com <radiusnt@iea-software.com>
|Date: Monday, June 15, 1998 2:33 PM
|Subject: RRAS = Error 1053
|
|
||Hi
||
||I have a PM3. It works very well in Radius 2.5 but the RRAS of the
Internet
||option pack does not update the calls table. The error message is 1053.
||Index or primary key can't contain a Null value. I have already changed
the
||name of Attribute #4 from NAS-IP-Address to NAS-Identifier in the
||RadAttributes table but this does not work either. When I use Microsoft's
||Radius both the PM3 and the RRAS work. What could be some other options
||that I could try to resolve this problem? Thanks for your time.
||
||Celso Carvalho do Amaral
||
|
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 7 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Year 2000 compliance
From: PSS <pss@sunbeach.net>
Date: Mon, 15 Jun 1998 17:19:56 -0400
We offer annual accounts and we put records into our data base with an
expiry date in the year 2000, should this prove to be a problem ?
Thanks
Damian Dunphy
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 8 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Year 2000 compliance
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Mon, 15 Jun 1998 14:52:57 -0700
PSS wrote:
>
> We offer annual accounts and we put records into our data base with an
> expiry date in the year 2000, should this prove to be a problem ?
No.
-- 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: MS Access97 to MS SQLFrom: postman@cp-tel.net (Postman Account)Date: Mon, 15 Jun 1998 17:02:18 -0500
I know this is probably a very basic question, but..
Can someone please explain how to go about converting ourRadiusNT Access97 database to a SQL database? Will westill be able to use our Access97 forms?
Or, give me some pointers on this one... is their a website that documents this process? ...or a utility that does this?
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: MS Access97 to MS SQLFrom: Mike Noel <noel@integrityonline.com>Date: Mon, 15 Jun 1998 15:18:07 -0700
You need the Access upsizing tool. You may already have it. Check in theTools->Add-Ins menu. Look for something called "Upsize to SQL". If youdon't have it, let me know and I can send it to you.
_M_
At 05:02 PM 6/15/98 -0500, you wrote:>>I know this is probably a very basic question, but..>>Can someone please explain how to go about converting our>RadiusNT Access97 database to a SQL database? Will we>still be able to use our Access97 forms?>>Or, give me some pointers on this one... is their a website >that documents this process? ...or a utility that does this?>>>>>>>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radlogs and ASCEND Max 4004From: "Pat Augustine" <pata@ilnk.com>Date: Mon, 15 Jun 1998 20:06:28 -0400
Dale, We've recently installed RadiusNT 2.5 on our backup Radius server, stillrunning 2.2 on the primary. Users are signing on (mostly) ok. Checking Radlogs (and populating RadLogMsg per your previous message), Iget the occasional user error. However, the table is also getting 1 entryper minute from each of our Maxes that basically says the Max itself triedto login and failed (user not found). The Radlog entry looks like this:
10 Jun 15 1998 7:57PM pools-Max2.ilnk.comascend (null) (null)(null)
Max2.ilnk.com is the name of the 4004. I see them go by in -x15 mode, aswell, but I don't know what's causing it. We've upgraded the Max to 6.1.0+recently and have been advised by Ascend that it has an IP Pool leak thatthey hope to fix soon, but I don't know if that's related or not. Does this make any sense to you at all? Any known issues with Ascend 6.1.0+(the first release with v.90)?
In addition, I seem to get little bubbles of unsuccessful logins. Duringthe day, suddenly for about 15 minutes it seems everybody is getting a LANSECURITY ERROR and being rejected and then 15 minutes later, everybody getsin just fine with no changes anywhere. Most of the rejects don't show up inthe Radius Logs (either the logfile on disk or the Radlogs table in Emerald)at all, so the Max may just be rejecting them outright, but I don't know whyit would do that (I've got excess IP Pools allocated so that the Maxshouldn't be out of IP addresses and did a Show Pool to verify that I had atleast SOME available IP addresses).
Thanks for any help.
Pat Augustinepata@ilnk.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radlogs and ASCEND Max 4004From: "Dale E. Reed Jr." <daler@iea-software.com>Date: Mon, 15 Jun 1998 18:20:22 -0700
Pat Augustine wrote:> > We've recently installed RadiusNT 2.5 on our backup Radius server, still> running 2.2 on the primary. Users are signing on (mostly) ok.> Checking Radlogs (and populating RadLogMsg per your previous message), I> get the occasional user error. However, the table is also getting 1 entry> per minute from each of our Maxes that basically says the Max itself tried> to login and failed (user not found). The Radlog entry looks like this:> > 10 Jun 15 1998 7:57PM pools-Max2.ilnk.com> ascend (null) (null)> (null)> > Max2.ilnk.com is the name of the 4004. I see them go by in -x15 mode, as> well, but I don't know what's causing it. We've upgraded the Max to 6.1.0+> recently and have been advised by Ascend that it has an IP Pool leak that> they hope to fix soon, but I don't know if that's related or not.> Does this make any sense to you at all? Any known issues with Ascend 6.1.0+> (the first release with v.90)?
This is a standard behavior from a Max (usually when you reboot or reseta config). Check the MAX documentation on how to turn this off. Itwas recently posted here on the list as well (check the archives).
> In addition, I seem to get little bubbles of unsuccessful logins. During> the day, suddenly for about 15 minutes it seems everybody is getting a LAN> SECURITY ERROR and being rejected and then 15 minutes later, everybody gets> in just fine with no changes anywhere. Most of the rejects don't show up in> the Radius Logs (either the logfile on disk or the Radlogs table in Emerald)> at all, so the Max may just be rejecting them outright, but I don't know why> it would do that (I've got excess IP Pools allocated so that the Max> shouldn't be out of IP addresses and did a Show Pool to verify that I had at> least SOME available IP addresses).
You would have to run RadiusNT in -x15 to really see whats going on during thattime. I would guess you are having a SQL Server issue where RadiusNT getshung or held up by another task (like someone doing an intense query on yoursql server, or deleting records from the calls table). The dual threadoperation of RadiusNT 2.5 should help the later, but you may need to profileyour SQL Server (performance monitor) and try and track down who/what is happening.
-- 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 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Fw: multilinkFrom: "Andrew Hall" <aah@impaq.net.au>Date: Tue, 16 Jun 1998 16:08:46 +1000
USR NAS support it.. I tried with two channels as suggested, and it worksfine, each channel seems to be treated individually. My problem now is howdo I automate it under radius NT? Basically I would like to offer rubberbandwidth and allow the addition of a third link to two permanents for a setamount of time. The two permanents should stay up all the time..
So.. I guess I need some kind of conditional script that will allow zerosession time out for the first two channels and a 3 hour timeout for thethird..
Thanks..
Andrew.
>>-----Original Message----->>From: Dale E. Reed Jr. <daler@iea-software.com>>>To: radiusnt@iea-software.com <radiusnt@iea-software.com>>>Date: Saturday, 13 June 1998 9:44>>Subject: Re: multilink>>>>>>>> Andrew Hall wrote:>>>>>>>> Question..>>>>>>>> Does anyone know of anyway to define different radius reply attributes>>for>>>> different connections in a multilink bundle. In other words I want tobe>>able>>>> to set a session timeout only on one link only of a multilink PPP>bundle.>>>>>>>> Can this be done, will Radiusnt support it?>>>>>>I'm not sure if a NAS supports this. It would be interested to try,>>>though. What you could do to see if it would work if connect the>>>first channel, change the Session-Timeout to a low number (like say>>>three minutes) and then connect the second channel. If the second>>>channels drops in three minutes, then it is supported. I would>>>guess that MOST nases see the ports as a single session, though.>>>>>>-->>>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: RadiusNT 2.5.124 startup problemFrom: "2Day Internet" <peter@2day.net.nz>Date: Tue, 16 Jun 1998 18:39:30 +1200
Anybody have any ideas about following ...?
-----Original Message-----From: 2Day Internet <peter@2day.net.nz>To: radiusnt@iea-software.com <radiusnt@iea-software.com>Date: Monday, 15 June 1998 19:05Subject: RadiusNT 2.5.124 startup problem
>Until recently I have been running RadiusNT in debug mode. I have just>taken to starting it as a service when the machine starts.>>It does not seem to want to authenticate when started in this way however.>If I stop the service and then restart it after boot time, it starts>authenticating.>>Is it possible it is attempting to communicate with MS SQL dB before SQL>server has completed startup?>>Is there some way of having RadiusNT retry the odbc connect if it does not>successfully connect the first time?