[RadiusNT Digest]
radiusnt-digest-request@iea-software.com
Tue, 11 Aug 1998 00:01:14 -0700
Message 1: RE: Request for Enhancement
from hostmaster@interaxs.net
Message 2: RE: Request for Enhancement
from Brian Lube <brian@mpinet.net>
Message 3: SQL consolidation and user logins
from Mike Miller <michael@abraxis.com>
Message 4: Re: SQL consolidation and user logins
from Brian Lube <brian@mpinet.net>
Message 5: Re: SQL consolidation and user logins
from Mike Miller <michael@abraxis.com>
Message 6: Re: Request for Enhancement
from Edsonet <administrator@yellowhead.com>
Message 7: Re: Doc File
from Edsonet <administrator@yellowhead.com>
Message 8:
from "Andy Rosen" <arosen@surflinx.com>
Message 9: Cyclades PAthRAS and RadiusNT 2.5.
from "Informacoes - WideSys Informatica Ltda" <info@WIDESYS.COM.BR>
Message 10: Re: SQL consolidation and user logins
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 11: Re: Cyclades PAthRAS and RadiusNT 2.5.
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 12: Re: Attribute 26 - vendor specific ?
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 13: Re: 3com and RadiusNT
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 14: Re: ODBC errors
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 15: Re: Request for Enhancement
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 16: Re: SQL consolidation and user logins
from "Rudy Komsic" <rudyk@cyberglobe.net>
Message 17: Re: ODBC errors (solved)
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 18: Re: Request for Enhancement
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 19: Re: NTMail and RadiusNT
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 20: Re: NTMail and RadiusNT
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 21: Re: ODBC errors
from Ted Olson <tolson@ocsnet.net>
Message 22: URGENT BIG PROBLEM!
from "Allen Mallari" <allen@fiax.net>
Message 23: Re: ODBC errors
from Ted Olson <tolson@ocsnet.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Request for Enhancement
From: hostmaster@interaxs.net
Date: Mon, 10 Aug 1998 06:52:59 -0400
At 02:41 PM 8/9/98 -0500, you wrote:
>Actually the idea of allowing simultaneous access with one user account
>is not as bad as it sounds. I have not been able to find an ISP global
>or otherwise that allows for this functionality.
We allow simultaneous concurrent connections if the the customer needs and
pays for this feature.
>Here is the scenario:
>
>I am implementing PPTP for all of my dialup users however I don't want
>to buy all of my users 1500+ an individual account. I would rather start
>out with a fixed number of accounts to be able to login to the ISP with
>a single account. The ISP can charge me as though I have 100 accounts
>or whatever number I decide on. I also would like to have some
>"overdraft" coverage in there like +10 connections for when there are an
>abnormally high number of users traveling.
The only difficulty I see in the above is the "overdraft protection". I am
not certain how I would do this, but, I feel that it cound be accomplished
by some scheduled procedure which would monitor calls online for a
particular username at some given interval.
>
>If this could be monitored to tell me how many calls on the average the
>ISP is recieving on this account. Depending on what the outcome is, I
>can adjust my account login limit accordingly.
Total calls for the month, as well as other statistical info regarding the
account is always available to any of my customers directly from our
website. It is not difficult to do!
>
>I have talked with many an ISP and they all seem to tell me the same
>thing:
>My billing software does not allow for that.
We have created our own "billing software" through Access '97 as the front
end to MS SQL Server. We are able to create or modify a billing module to
customize the billing to the customers needs. We then run a macro which
executes all of the billing modules.
My request was more specific. I want to be able to automatically notify
users which DO NOT have multiple logon ability of the fact that they are
trying to do just that :)
Jim
>
>Andy
>aknight@lgc.com
>
>
>-----Original Message-----
>From: hostmaster@interaxs.net [mailto:hostmaster@interaxs.net]
>Sent: Sunday, August 09, 1998 7:01 AM
>To: radiusnt@iea-software.com
>Subject: Request for Enhancement
>
>
>Hi Dale,
>
>I have been following several threads in various lists regarding
>multiple
>concurrent logon control. RadiusNT does an excellent joj of controlling
>this!
>
>The one feature that is very often mentioned that seems to be an
>excellent
>idea, for several reasons, including selling more dialin accounts to
>commercial entities using one dialin for all employees, is the ability
>to
>send an email to the offending account explaining that the logon was
>rejected due to the fact that the username is already logged on.
>
>Might there be a way to get RadiusNT to have this option in a not too
>distant release?
>
>Jim Evans
>
>
>----------------------------
>We Distribute the Easy Internet and Easy HTML CD Roms
>hostmaster@interaxs.net
>InterNet Access Network
>18 McDaniel Street
>Dayton, OH 45405-4816
>Voice: 937-461-3660 Fax:937-228-2773
>
----------------------------
We Distribute the Easy Internet and Easy HTML CD Roms
hostmaster@interaxs.net
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Request for Enhancement
From: Brian Lube <brian@mpinet.net>
Date: Mon, 10 Aug 1998 09:05:20 -0400
Actually, as long as I could limit multipoint sessions I would be really
happy. With the invention of 'shotgun' modems (and DUN 1.2) we have had a
large number of customers double-up their modems trying to improve speed.
While this is a nice feature it can really hinder us in our modem-user
ratio...
Brian Lube
MPInet
At 06:52 AM 8/10/98 -0400, you wrote:
>At 02:41 PM 8/9/98 -0500, you wrote:
>>Actually the idea of allowing simultaneous access with one user account
>>is not as bad as it sounds. I have not been able to find an ISP global
>>or otherwise that allows for this functionality.
>
>We allow simultaneous concurrent connections if the the customer needs and
>pays for this feature.
>
>>Here is the scenario:
>>
>>I am implementing PPTP for all of my dialup users however I don't want
>>to buy all of my users 1500+ an individual account. I would rather start
>>out with a fixed number of accounts to be able to login to the ISP with
>>a single account. The ISP can charge me as though I have 100 accounts
>>or whatever number I decide on. I also would like to have some
>>"overdraft" coverage in there like +10 connections for when there are an
>>abnormally high number of users traveling.
>
>The only difficulty I see in the above is the "overdraft protection". I am
>not certain how I would do this, but, I feel that it cound be accomplished
>by some scheduled procedure which would monitor calls online for a
>particular username at some given interval.
>
>>
>>If this could be monitored to tell me how many calls on the average the
>>ISP is recieving on this account. Depending on what the outcome is, I
>>can adjust my account login limit accordingly.
>
>Total calls for the month, as well as other statistical info regarding the
>account is always available to any of my customers directly from our
>website. It is not difficult to do!
>
>>
>>I have talked with many an ISP and they all seem to tell me the same
>>thing:
>>My billing software does not allow for that.
>
>We have created our own "billing software" through Access '97 as the front
>end to MS SQL Server. We are able to create or modify a billing module to
>customize the billing to the customers needs. We then run a macro which
>executes all of the billing modules.
>
>My request was more specific. I want to be able to automatically notify
>users which DO NOT have multiple logon ability of the fact that they are
>trying to do just that :)
>
>Jim
>>
>>Andy
>>aknight@lgc.com
>>
>>
>>-----Original Message-----
>>From: hostmaster@interaxs.net [mailto:hostmaster@interaxs.net]
>>Sent: Sunday, August 09, 1998 7:01 AM
>>To: radiusnt@iea-software.com
>>Subject: Request for Enhancement
>>
>>
>>Hi Dale,
>>
>>I have been following several threads in various lists regarding
>>multiple
>>concurrent logon control. RadiusNT does an excellent joj of controlling
>>this!
>>
>>The one feature that is very often mentioned that seems to be an
>>excellent
>>idea, for several reasons, including selling more dialin accounts to
>>commercial entities using one dialin for all employees, is the ability
>>to
>>send an email to the offending account explaining that the logon was
>>rejected due to the fact that the username is already logged on.
>>
>>Might there be a way to get RadiusNT to have this option in a not too
>>distant release?
>>
>>Jim Evans
>>
>>
>>----------------------------
>>We Distribute the Easy Internet and Easy HTML CD Roms
>>hostmaster@interaxs.net
>>InterNet Access Network
>>18 McDaniel Street
>>Dayton, OH 45405-4816
>>Voice: 937-461-3660 Fax:937-228-2773
>>
>----------------------------
>We Distribute the Easy Internet and Easy HTML CD Roms
>hostmaster@interaxs.net
>InterNet Access Network
>18 McDaniel Street
>Dayton, OH 45405-4816
>Voice: 937-461-3660 Fax:937-228-2773
>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: SQL consolidation and user logins
From: Mike Miller <michael@abraxis.com>
Date: Mon, 10 Aug 1998 14:14:23 -0400
We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We
keep 2 months accounting for our records. Our database is generally has
around 300MB to 400MB of space used to handle this. Every morning at 4AM
SQL executive runs a script that deletes all calls records over 2 months
old. According to SQL executive, this process has been taking between 12
and 15 minutes to complete each night. Our problem is that during the
consolidation process, there are periods of time in which no users can log
onto the network. The Radius screen itself just freezes on an accounting
request until consolidation completes. Originally Radius was installed on
the same machine as SQL Server, but because of the login problems we moved
it onto a different machine from the SQL server... no luck, still freezes
during consolidation. The same copy of Radius is performing authentication
and accounting. I suspect that the Calls table is getting locked during
the mass delete query, but am not sure if this is causing our problem or
not. Has anyone dealt with this? Is there a workaround that will allow us
to perform consolidation without locking out logins? Would running two
copies of radius on two seperate machines (one for authentication and one
for accounting) help or am I heading the wrong direction with this?
--
==================================================== /\ Mike A. Miller == /--\ \/ Abraxis Networks ==/ \ B R A /\ I S == / == N E T W O R K S michael@abraxis.com====================================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL consolidation and user loginsFrom: Brian Lube <brian@mpinet.net>Date: Mon, 10 Aug 1998 14:46:23 -0400
It sounds like the query is hurting you. Are you using a datediff to clearit out (delete from calls where datediff(mm, calldate, getdate()) > 2)? Ifyou are this seems to be taking too long each night. I would suggest aweekly our monthly removal (I'm using weekly now, and it only takes about10 minutes each 7-10 days).
Brian LubeMPInet
At 02:14 PM 8/10/98 -0400, you wrote:>We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We>keep 2 months accounting for our records. Our database is generally has>around 300MB to 400MB of space used to handle this. Every morning at 4AM>SQL executive runs a script that deletes all calls records over 2 months>old. According to SQL executive, this process has been taking between 12>and 15 minutes to complete each night. Our problem is that during the>consolidation process, there are periods of time in which no users can log>onto the network. The Radius screen itself just freezes on an accounting>request until consolidation completes. Originally Radius was installed on>the same machine as SQL Server, but because of the login problems we moved>it onto a different machine from the SQL server... no luck, still freezes>during consolidation. The same copy of Radius is performing authentication>and accounting. I suspect that the Calls table is getting locked during>the mass delete query, but am not sure if this is causing our problem or>not. Has anyone dealt with this? Is there a workaround that will allow us>to perform consolidation without locking out logins? Would running two>copies of radius on two seperate machines (one for authentication and one>for accounting) help or am I heading the wrong direction with this? >>-->>>>===================================================>= /\ Mike A. Miller =>= /--\ \/ Abraxis Networks =>=/ \ B R A /\ I S =>= / =>= N E T W O R K S michael@abraxis.com=>===================================================>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL consolidation and user loginsFrom: Mike Miller <michael@abraxis.com>Date: Mon, 10 Aug 1998 15:19:40 -0400
The exact query (very simple):
DELETE Calls WHERE CallDate < DATEADD(day, -60, getdate())
Weekly and monthly consolidation takes much longer (as in *hours* tocomplete)... I know because our initial consolidation long ago *really*hurt us!
Is there a better query I should use?
--At 02:46 PM 8/10/98 -0400, you wrote:>It sounds like the query is hurting you. Are you using a datediff to clear>it out (delete from calls where datediff(mm, calldate, getdate()) > 2)? If>you are this seems to be taking too long each night. I would suggest a>weekly our monthly removal (I'm using weekly now, and it only takes about>10 minutes each 7-10 days). >>Brian Lube>MPInet>>At 02:14 PM 8/10/98 -0400, you wrote:>>We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We>>keep 2 months accounting for our records. Our database is generally has>>around 300MB to 400MB of space used to handle this. Every morning at 4AM>>SQL executive runs a script that deletes all calls records over 2 months>>old. According to SQL executive, this process has been taking between 12>>and 15 minutes to complete each night. Our problem is that during the>>consolidation process, there are periods of time in which no users can log>>onto the network. The Radius screen itself just freezes on an accounting>>request until consolidation completes. Originally Radius was installed on>>the same machine as SQL Server, but because of the login problems we moved>>it onto a different machine from the SQL server... no luck, still freezes>>during consolidation. The same copy of Radius is performing authentication>>and accounting. I suspect that the Calls table is getting locked during>>the mass delete query, but am not sure if this is causing our problem or>>not. Has anyone dealt with this? Is there a workaround that will allow us>>to perform consolidation without locking out logins? Would running two>>copies of radius on two seperate machines (one for authentication and one>>for accounting) help or am I heading the wrong direction with this? >>>>-->>>>>>>>===================================================>>= /\ Mike A. Miller =>>= /--\ \/ Abraxis Networks =>>=/ \ B R A /\ I S =>>= / =>>= N E T W O R K S michael@abraxis.com=>>===================================================>> > ==================================================== /\ Mike A. Miller == /--\ \/ Abraxis Networks ==/ \ B R A /\ I S == / == N E T W O R K S michael@abraxis.com====================================================
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Request for EnhancementFrom: Edsonet <administrator@yellowhead.com>Date: Mon, 10 Aug 1998 13:25:33 -0600
I fail to see what good sending an email to a customer who can't login is.Our NAS returns the reason for not being able to log in immediately, aslong as the customer uses the post dial-up login screen. The PAPauthorization screen uses the same generic message for practically everyerror that it encounters. Thats where the improvement is needed.
J.A. CouttsSystems EngineerEdsonet/TravPro********************** SEPARATER ********************At Sun, 09 Aug 1998 08:00:51 -0400, you wrote:>Hi Dale,>>I have been following several threads in various lists regarding multiple>concurrent logon control. RadiusNT does an excellent joj of controlling this!>>The one feature that is very often mentioned that seems to be an excellent>idea, for several reasons, including selling more dialin accounts to>commercial entities using one dialin for all employees, is the ability to>send an email to the offending account explaining that the logon was>rejected due to the fact that the username is already logged on.>>Might there be a way to get RadiusNT to have this option in a not too>distant release?>>Jim Evans>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Doc FileFrom: Edsonet <administrator@yellowhead.com>Date: Mon, 10 Aug 1998 13:47:06 -0600
At Fri, 07 Aug 1998 13:44:33 -0600, you wrote:>What Version of MS Word is required to read the RadiusNT25.doc file. We are>using MS Word Version 7.0, and none of the formatting comes through when we>attempt to view it. The HTML files on the Web site are only for RadiusNT>V2.2, which explains some of the difficulty we had setting 2.5 up.>>J.A. Coutts>Systems Engineer>Edsonet/TravPro******************* REPLY ******************I answered my own question. After much diligent searching throughMicrosoft's support site, I found that the formatting for Word97/98 isdifferent from previous versions (no explanation offered as to why). Thereis an update patch available from Microsoft called WRD97CNV.EXE, which willdetect a Word97 file and convert it so that it can be read by Version 6.xor 7.x. Since Word97/98 will read the older files, might I suggest that theDOC files on the Web site be converted so that everyone can read them.
MS Word is not considered a critical application at our site, such that wewould always have the latest version.
J.A. CouttsSystems EngineerEdsonet/TravPro
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: From: "Andy Rosen" <arosen@surflinx.com>Date: Mon, 10 Aug 1998 16:21:45 -0400
unsubscribe
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Cyclades PAthRAS and RadiusNT 2.5.From: "Informacoes - WideSys Informatica Ltda" <info@WIDESYS.COM.BR>Date: Mon, 10 Aug 1998 17:24:20 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0030_01BDC483.B660A9B0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
Hi, I would like to know setup the tables in the radius97.mdb. I have =Cyclades PathRAS and in text mode, it is ok. But in ODBC mode, it is not =ok. Thanks.
Fernando,fernandokb@widesys.com.br
------=_NextPart_000_0030_01BDC483.B660A9B0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
Hi,
I would like to =know setup=20the tables in the radius97.mdb. I have Cyclades PathRAS and in text =mode, it is=20ok. But in ODBC mode, it is not ok.
=Thanks.
Fernando,
fernandokb@widesys.com.br
------=_NextPart_000_0030_01BDC483.B660A9B0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL consolidation and user loginsFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 13:46:31 -0700Mike Miller wrote:> > We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We> keep 2 months accounting for our records. Our database is generally has> around 300MB to 400MB of space used to handle this. Every morning at 4AM> SQL executive runs a script that deletes all calls records over 2 months> old. According to SQL executive, this process has been taking between 12> and 15 minutes to complete each night. Our problem is that during the> consolidation process, there are periods of time in which no users can log> onto the network. The Radius screen itself just freezes on an accounting> request until consolidation completes. Originally Radius was installed on> the same machine as SQL Server, but because of the login problems we moved> it onto a different machine from the SQL server... no luck, still freezes> during consolidation. The same copy of Radius is performing authentication> and accounting. I suspect that the Calls table is getting locked during> the mass delete query, but am not sure if this is causing our problem or> not. Has anyone dealt with this? Is there a workaround that will allow us> to perform consolidation without locking out logins? Would running two> copies of radius on two seperate machines (one for authentication and one> for accounting) help or am I heading the wrong direction with this?RadiusNT 2.2 uses one connection for both accounting and authentication.Therefore, when you delete records from the calls table, it hangs theotherconnections until the lock it done (including RadiusNT).RadiusNT 2.5 has a different connection for accounting andauthentication.Therefore, when you start deleting a bunch of records, auth continuesandaccounting hangs until you are done (not much you can do about that).Moral of the story: Upgrade to RadiusNT 2.5. :)-- 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: Cyclades PAthRAS and RadiusNT 2.5.From: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 14:15:07 -0700> Informacoes - WideSys Informatica Ltda wrote:> > Hi,> I would like to know setup the tables in the radius97.mdb. I have> Cyclades PathRAS and in text mode, it is ok. But in ODBC mode, it is> not ok.Can you include more information like what you see when runningRadiusNT? Have you configured the servers 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: Attribute 26 - vendor specific ?From: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 08:35:07 -0700Glenn, Bill wrote:> > If I may, I'd like to ask a question to any Radius knowledgable list> members. First, does RadiusNT 2.5.105 support vendor specific accounting> attributes? Second, if so what do I need to add to the dictionary file to> enable this attribute. I can,see the attribute is present in the accounting> debug log but it has a null value and I know a value is present in the> request packet.Vendor Specific Attributes are only supported in ODBC mode. A coupleof people have reported problems with VSA in 2.5.12x and they are testing a correction for it.You must add the Vendor ID in the RadVendors table (like 9 forCisco, etc) and then you can add attributes into the RadAttriutestable with a RadAttributeID of 26, a RadVendorID matching the entryyou added, and a RadVendorType of the VSA you want to have. Thedata portion will allways be the data speicfic to the VSA.-- 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: Re: 3com and RadiusNTFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 08:39:50 -0700CPD- Jr wrote:> > Hello all,> > I'm sorry if you already discuss this issue, but I searched for a> solution and could not find it.> We have a 3Com total control with 1 Hyper ARC, Authentication is working> but Accounting is not.> RadiusNT complains Field 'Calls.CallerID' can't be a zero-length> string.> On table calls I have callerid column empty, and accounting works just> fine when I try> c:\radlogin test test START ... STOPCheck your Calls Table and see what the requirements for the CallerIDfield is. You may have a size restriction on it that is causing thefailure. You can do this by highlighting the calls tale and selectingdesign from within MS Access itself.-- 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: ODBC errorsFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 09:30:02 -0700Ted Olson wrote:> > Seemed to go very smoothly - for a couple hours at least. Since then, we've> had 3-4 distinct problems where connections are fine for a while and then> start being denied with the error below. The bandaid fix is to stop and> restart RadiusNT, then all is OK again (until the next time).It seems to be a response time problem. If you look at the responsetimes, they are from 10 seconds upwards to 30 seconds. Thats notgoing to cut it. :( > Any idea what might be causing this? It wasn't happening on the old> machine, and it's the exact same database as before, no changes to table> structures or indexes. Is there a way to determine which table/index is> being referred to? (It just happened again...) Here's a longshot, but is> the dual CPU config an issue at all?Its referring to the accounting (calls tale, primary key). The issueis that the records DOES get saved the first time, but takes so longthatthe NAS re-sends it laster (getting this error). This starts anavalanche affect that you are seeing. One thing you might try is running in single thread mode. I'mstill not sure about how well MS Access will handle auth andaccounting simulataneously, which you are seeing a lot of (theintertwined debug from the auth and acct is a sign of that).-- 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: Request for EnhancementFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 14:28:02 -0700Brian Lube wrote:> > Actually, as long as I could limit multipoint sessions I would be really> happy. With the invention of 'shotgun' modems (and DUN 1.2) we have had a> large number of customers double-up their modems trying to improve speed.> While this is a nice feature it can really hinder us in our modem-user> ratio...Almost all NASes support the Port-Limit attribute, which limits thenumber of sessions that can be bonded together in one MLPPP session.THis is not concurrency control (since it doesn't prevent the userfrom making two calls that are not tied together, like sharing anaccount with a friend). -- 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: SQL consolidation and user loginsFrom: "Rudy Komsic" Date: Mon, 10 Aug 1998 17:30:28 -0400Actually Dale, we have upgraded to 2.5 and still it is behaving as 2.2. Whenwe do a consolidation, Radius says that the server has timed out and theclient still can not get online. The Server is running a PII 300 with 128MBRam. Is there a way of making a temp Online table within the database wherethe accounting would be stored while the consolidation is being processed?Then after consolidation, it would move the new records into the mastertimelog database? Anyway of making more than one request process (likerunning 2 ISQL scripts at the same time) function?-----Original Message-----From: Dale E. Reed Jr. To: radiusnt@iea-software.com Date: August 10, 1998 4:48 PMSubject: Re: SQL consolidation and user logins>Mike Miller wrote:>>>> We are using RadiusNT 2.2 with ODBC and a MS-SQL 6.5 sp4 SQL database. We>> keep 2 months accounting for our records. Our database is generally has>> around 300MB to 400MB of space used to handle this. Every morning at 4AM>> SQL executive runs a script that deletes all calls records over 2 months>> old. According to SQL executive, this process has been taking between 12>> and 15 minutes to complete each night. Our problem is that during the>> consolidation process, there are periods of time in which no users can log>> onto the network. The Radius screen itself just freezes on an accounting>> request until consolidation completes. Originally Radius was installed on>> the same machine as SQL Server, but because of the login problems we moved>> it onto a different machine from the SQL server... no luck, still freezes>> during consolidation. The same copy of Radius is performing authentication>> and accounting. I suspect that the Calls table is getting locked during>> the mass delete query, but am not sure if this is causing our problem or>> not. Has anyone dealt with this? Is there a workaround that will allow us>> to perform consolidation without locking out logins? Would running two>> copies of radius on two seperate machines (one for authentication and one>> for accounting) help or am I heading the wrong direction with this?>>RadiusNT 2.2 uses one connection for both accounting and authentication.>Therefore, when you delete records from the calls table, it hangs the>other>connections until the lock it done (including RadiusNT).>>RadiusNT 2.5 has a different connection for accounting and>authentication.>Therefore, when you start deleting a bunch of records, auth continues>and>accounting hangs until you are done (not much you can do about that).>>Moral of the story: Upgrade to RadiusNT 2.5. :)>>-->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 errors (solved)From: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 14:38:57 -0700Ted Olson wrote:> > We're still seeing a few of the following AUTH errors however, seem to be> related to either no username or invalid character problems in the> password. I wonder if these errors are considered normal? Any possible> relationship to the "trim" option, which we have checked?> > ODBC Error:00000:0:> ODBC Error:00000:6:If the first number is 00000 then there isn't an error. If this occurs right after the authentication query, it means no rows werereturned (and RadiusNT checks the error value to see if thats corrector something is wrong with the DB).-- 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: Request for EnhancementFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 14:46:30 -0700hostmaster@interaxs.net wrote:> > I have been following several threads in various lists regarding multiple> concurrent logon control. RadiusNT does an excellent joj of controlling this!> > The one feature that is very often mentioned that seems to be an excellent> idea, for several reasons, including selling more dialin accounts to> commercial entities using one dialin for all employees, is the ability to> send an email to the offending account explaining that the logon was> rejected due to the fact that the username is already logged on.> > Might there be a way to get RadiusNT to have this option in a not too> distant release?RadiusNT itself sends the message via the RADIUS protocol to the RADIUS client. Many terminal servers will display this message inplain text if the user did not use PAP/CHAP to authenticate. However,the LCP/PAP/CHAP protocols do NOT have facilities for displayingmessages. Therefore, although not a limitation of RadiusNT, its notpossible to display a message to a majority of the users who haveconcurrency problems.-- 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 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: NTMail and RadiusNTFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 15:12:03 -0700Viktors Judins wrote:> > >hmmm.... well That will not help fix it.... be more elaborate in what the> >problem is.> > NTMail 3.02 works Ok if user is in NTMail users database.> When I try to send message to user than not in NTMail database, but is in> SQL Server (connect via ODBC), we have no response. Do You have any idea> where I can monitor, what happens?> I have no 100% sure that Radius 2.5 work properly but it is loaded two users> from Radius database (table SubAccount) on startup time.When you start the SMTP service, does NTMail log a success ofinitializing the DLL or a failure? Do you have an ESID in the registry? Have you defined a logfile in the registry for theDLL and if so, what does it contain?-- 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: Re: NTMail and RadiusNTFrom: "Dale E. Reed Jr." Date: Mon, 10 Aug 1998 15:13:25 -0700Viktors Judins wrote:> > Hello!> I have a problem with NTMail users autorization. I install RadiusNT 2.5,> NTMail 3.02m and DewauthNTMail.Whats dewauthntmail?-- 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 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC errorsFrom: Ted Olson Date: Mon, 10 Aug 1998 16:18:30 -0700At 09:30 AM 8/10/98 -0700, you wrote:>It seems to be a response time problem. If you look at the response>times, they are from 10 seconds upwards to 30 seconds. Thats not>going to cut it. :(And some even longer. What response time is considered normal, or acceptable?Regarding -s mode, I don't see where that can be specified in eitherradadmin or the registry. Where/how is that option set?(BTW, migration to SQL/S is in our plans, just one step at a time...)Thanks much,-Ted OlsonOCS Software..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: URGENT BIG PROBLEM!From: "Allen Mallari" Date: Mon, 10 Aug 1998 16:35:57 -0700Hi Dale, I'm still having problem running my radiusnt 2.5it's giving me an error: (null):couldn't open server to find server.I even followed the instructions on the manualand no luck... please help.. my other serverkeeps on going down for some reason... and ican't afford to have no secondary authentication server.I'm using Winnt4.0, IIS4, USRobotics NAS, andhave other radiusnt running ver 2.2 and it works fineI want the other server to be 2.5. PLEASEEEEE...give me a step by step procedure to troubleshootthis problem... THANKS A LOT,ALLEN MALLARI702-310-3600..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 23 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ODBC errorsFrom: Ted Olson Date: Mon, 10 Aug 1998 18:07:32 -0700Dale, following up on my previous post - the really high resp times(5-digit!) you saw were in the first file attachment I sent you. Don't knowwhat might have caused that? Anyway, what we're seeing now in acct.log isnumbers comsistently in the 70-90 range (those are ms, right?),occasionally a little over 100. Also, they remain pretty much the samewhether an error is recorded or not, i.e. not higher even when a keyviolation error (ODBC 23000) occurs. Just FYI, still running Access97w/2.5, multi-thread.Thanks,-TedAt 09:30 AM 8/10/98 -0700, you wrote:>It seems to be a response time problem. If you look at the response>times, they are from 10 seconds upwards to 30 seconds. Thats not>going to cut it. :(And some even longer. What response time is considered normal, or acceptable?Regarding -s mode, I don't see where that can be specified in eitherradadmin or the registry. Where/how is that option set?(BTW, migration to SQL/S is in our plans, just one step at a time...)Thanks much,-Ted OlsonOCS Software