Message 2: Re: The Incredible Expanding Database
from postman@cp-tel.net (Postman Account)
Message 3: Re: The Incredible Expanding Database
from hostmaster@interaxs.net
Message 4: Re: The Incredible Expanding Database
from "Majordomo@essex1.com" <majordomo@essex1.com>
Message 5: Re: The Incredible Expanding Database
from Dale Reed <daler@iea-software.com>
Message 6: Radius7.mdb cleanup & compress?
from "Zak Wolfinger" <zak@cyberlink.com>
Message 7: Did this authenticate?
from Mike Noel <noel@integrityonline.com>
Message 8: Re: Did this authenticate?
from Dale Reed <daler@iea-software.com>
Message 9: Re: Did this authenticate?
from Mike Noel <noel@integrityonline.com>
Message 10: IP ADDRESS
from "Allen Mallari" <allen@fiax.net>
Message 11: Re: IP ADDRESS
from Dale Reed <daler@iea-software.com>
Message 12: Re: IP ADDRESS
from "Allen Mallari" <allen@fiax.net>
Message 13: Re: IP ADDRESS
from Dale Reed <daler@iea-software.com>
Message 14: Re: Did this authenticate?
from Dale Reed <daler@iea-software.com>
Message 15: Lantronix LRS32 and RadiusNT
from Glen Harvy <root@aquarius.com.au>
Message 16: Re: IP ADDRESS
from "Allen Mallari" <allen@fiax.net>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: RE: Can't connect to ODBC database
From: "Paul Smith" <pjsmith@microtech.co.gg>
Date: Mon, 29 Jun 1998 09:06:54 +0100
Thanks for that. Sorry about the HTML.
I already had the "Emerald" option set.
I cleared the logfile fields and from the prompt it now gets to the
"RadiusNT Enterprise Initialized" but still fails when you try to check the
ODBC connection.
I can however now see that authentication info is reaching radiusNT, and it
is trying to insert it into the calls sql table.
Regards, Paul
-----Original Message-----
From: radiusnt-request@iea-software.com
[mailto:radiusnt-request@iea-software.com]On Behalf Of Dale Reed
Sent: 29 June 1998 03:22
To: radiusnt@iea-software.com
Subject: Re: Can't connect to ODBC database
In the future please only send TEST messgaes. HTML messages and
attachment are not allowed on the list.
> Paul Smith wrote:
>
> I've entered the authentication information and the DSN, but when I
> click the check button it says "check connection failed". I can't see
> what I'm doing wrong, although I'm sure it's probably something
> simple.
Make sure ou have clicked on the Options button of the ODBC
configuration
and specified "Emerald" for the database.
> I've started RadiusNT with the -x15 option, and the it's supposed to
> go to the "wating for requests stage" but it only gets as far as "1
> Client's loaded"
Clear the logfile entry in the RadiusNT admin to see everything on
the screen.
--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
QUIT
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: postman@cp-tel.net (Postman Account)Date: Mon, 29 Jun 1998 10:04:14 -0500
Dale,
Is it possible to setup a seperate Access97 databaseto handle just the calls information?
If so, would this increase the stability/efficiencyof RadiusNT?
Or, would it make any difference at all?
I guess I'm afraid of our RadiusNT machine becomingunstable.... due to one large Access97 database.
....too bad there isn't a more efficient way to save accounting information... and still be able to generate report information.
Additionally, it is very frustrating to find out that you must buy MS SQL server (at ~$1,400.00) for RadiusNT to function properly. :(
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: hostmaster@interaxs.netDate: Mon, 29 Jun 1998 11:17:39 -0400
I believe that you can use the MS SQL Workstation version which issomewhere between $250 and $400.
Jim
At 10:04 AM 6/29/98 -0500, you wrote:>>Additionally, it is very frustrating to find out >that you must buy MS SQL server (at ~$1,400.00) >for RadiusNT to function properly. :(> ----------------------------hostmaster@interaxs.netInterNet Access Network18 McDaniel StreetDayton, OH 45405-4816Voice: 937-461-3660 Fax:937-228-2773
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: "Majordomo@essex1.com" <majordomo@essex1.com>Date: Mon, 29 Jun 1998 10:31:39 -0500
Howdy; It is definitely the nature of Access97. We had to compact/compress atleast twice a week. The more activity Access has the more it expands. Wealso had loads of problems with ODBC locking up every 30 hours or so.Changed over to SQL, much better :). We only have to dump the logs now andthen. RadiusNT Rules!
At 12:16 PM 6/26/98 -0500, you wrote:>>Unfortunately, I think this is the nature of RadiusNT v2.5 >when using Access97.... it explodes in size... constantly... >not sure if this is a bug.>>Our RadiusNT v2.5 database grows very rapidly and has to >be compacted at least once a day... it doubles... and >triples in size... every 24 hours... debugging is off.>>Although, we never had this problem under RadiusNT v1.6. >>Usually, it'll be recommended for you to buy MS SQL >server... and run it with RadiusNT.
>At 09:05 AM 6/26/98 -0700, you wrote:>>Hi, we are using RadiusNT to authenticate against an MSAccess database. I>>have noticed that after about 24hours of running this database has grown>>from about 7MB to over 100MB in size. I have needed to stop the RadiusNT>>service (not good) and compact/repair the database to return it to a more>>manageable size.>>>>Anybody have an idea what I am doing wrong?>>>>Thanks,>>>>Jason>>>>> R. Laughlin Majordomo@essex1.com Essex Internet Sterling, IL 61081 (815) 625-8893
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: The Incredible Expanding DatabaseFrom: Dale Reed <daler@iea-software.com>Date: Mon, 29 Jun 1998 08:37:53 -0700
Postman Account wrote:> > Additionally, it is very frustrating to find out> that you must buy MS SQL server (at ~$1,400.00)> for RadiusNT to function properly. :(
Frustrating? Thats like saying you are upset because you boughta 486 to run NT Server and its not giving you the performance youwanted from a $100 machine. You can buy SBS at $1395 that includeslicenses for SQL Server, NT Server, etc. You can also use Sybaseand Oracle (which don't have problems either). Its not a functionalityissue with RadiusNT, its a disfunctional database system that wasn'treally designed to do what you want it to do.
-- 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Radius7.mdb cleanup & compress?From: "Zak Wolfinger" <zak@cyberlink.com>Date: Mon, 29 Jun 1998 11:53:31 -0500
Is there a way to clean / compress the Access97 radius database whileradius is still running?
Zak Wolfinger email: zak@cyberlink.comCyberLink, Inc. voice: (219) 235-1400213 S Main Street fax: (219) 235-1599South Bend, IN 46601 www: http://www.wolfinger.net/zak
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Did this authenticate?From: Mike Noel <noel@integrityonline.com>Date: Mon, 29 Jun 1998 11:50:11 -0700
I'm still tracking down the RadNT/SQL Server problem. When I run radius-x15 from the command line and try dialing up with a test user I get thefollowing output...
It looks to me like it is authenticating the user and sending back anaccept message to our portmaster. But on the dialup machine I get the"can't connect" message. Each time I dialup the portmaster tries 10 or 11times, all the trials look just like this.
I can't figure out if the problem is with my Radius configuration, myportmaster, or my dialup computer.
Any ideas?
_M_noel@integrityonline.com
radrecv: Request from host cdee120f code=1, id=194, length=75 User-Name = "test" Challenge-Response = "\001\020\312V\271\302\225\341RYC'b\360\3433\364" NAS-Identifier = 205.238.18.15 NAS-Port = 26 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPPrad_authenticate_ODBC() Challenge-Response = "\001\020\312V\271\302\225\341RYC'b\360\3433\364"
SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccountssa Where (sa.Login='test' or sa.Shell='test') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
SQL Statement: RadGetConfigs 1
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'PPP'
User-Service = 2 (2) Framed-Protocol = 1 (1)Sending Ack of id 194 to cdee120f (pm7.pdx.integrityonline.com) User-Service = Framed-User Framed-Protocol = PPP
Resp Time: 90 Auth: 11/0 -> 11 Acct: 0/0/0 -> 0
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Did this authenticate?From: Dale Reed <daler@iea-software.com>Date: Mon, 29 Jun 1998 12:35:50 -0700
Mike Noel wrote:> > I'm still tracking down the RadNT/SQL Server problem. When I run radius> -x15 from the command line and try dialing up with a test user I get the> following output...> > It looks to me like it is authenticating the user and sending back an> accept message to our portmaster. But on the dialup machine I get the> "can't connect" message. Each time I dialup the portmaster tries 10 or 11> times, all the trials look just like this.
> Sending Ack of id 194 to cdee120f (pm7.pdx.integrityonline.com)> User-Service = Framed-User> Framed-Protocol = PPP> > Resp Time: 90 Auth: 11/0 -> 11 Acct: 0/0/0 -> 0
Yes, they are all responding. What you may want to do is set RadiusNTto run on a specific IP Address in the Admin and see if it correctsthe problem.
-- 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: Did this authenticate?From: Mike Noel <noel@integrityonline.com>Date: Mon, 29 Jun 1998 12:52:41 -0700
>Yes, they are all responding. What you may want to do is set RadiusNT>to run on a specific IP Address in the Admin and see if it corrects>the problem.
Ok. I changed the IP Address setting from All to the IP that RadiusNT isrunning on. I still got the same output. I do not have the port set butI'm surprised it would even communicate with the portmaster if the defaultdidn't work. However, I can put that in the field. What is the default port?
Any other ideas?
_M_
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: IP ADDRESSFrom: "Allen Mallari" <allen@fiax.net>Date: Mon, 29 Jun 1998 13:32:20 -0700
How do you assign an IP address to a specific user wheneverthey login?
Thanks,Allen
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: IP ADDRESSFrom: Dale Reed <daler@iea-software.com>Date: Mon, 29 Jun 1998 16:44:56 -0700
Allen Mallari wrote:> > How do you assign an IP address to a specific user whenever> they login?
What mode are you running RadiusNT in?
-- 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: IP ADDRESSFrom: "Allen Mallari" <allen@fiax.net>Date: Mon, 29 Jun 1998 18:10:11 -0700
Text Mode
*********** REPLY SEPARATOR ***********
On 6/29/98, at 4:44 PM, Dale Reed wrote:
>Allen Mallari wrote:>> >> How do you assign an IP address to a specific user whenever>> they login?>>What mode are you running RadiusNT in?>>-- >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: IP ADDRESSFrom: Dale Reed <daler@iea-software.com>Date: Mon, 29 Jun 1998 20:45:01 -0700
Allen Mallari wrote:> > >> How do you assign an IP address to a specific user whenever> >> they login?> >> >What mode are you running RadiusNT in?>> Text Mode
Just add a Framed-Address entry for the user in your users files.
-- 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: Did this authenticate?From: Dale Reed <daler@iea-software.com>Date: Mon, 29 Jun 1998 21:31:01 -0700
Mike Noel wrote:> > >Yes, they are all responding. What you may want to do is set RadiusNT> >to run on a specific IP Address in the Admin and see if it corrects> >the problem.> > Ok. I changed the IP Address setting from All to the IP that RadiusNT is> running on. I still got the same output. I do not have the port set but> I'm surprised it would even communicate with the portmaster if the default> didn't work. However, I can put that in the field. What is the default port?
You might want to try some debug on the PM side and also test RadiusnTwith Radlogin (see the testing section of the RadiusNT 2.5 docs).
The default port for auth is 1645 and Acct is 1646.
-- 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: Lantronix LRS32 and RadiusNTFrom: Glen Harvy <root@aquarius.com.au>Date: Tue, 30 Jun 1998 15:38:51 +1000
Hi,
I've been offered one of the above beasts and will need to runRadiusNT/Emerald with it.
Has anyone got any experience with Lantronix products in general and theabove in particular?
Glen.--------------------------------------------------------------------AQUARIUS Communications for all your Internet<>Fidonet needs <>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailervoice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930http://www.aquarius.com.au <> mailto:sales@aquarius.com.au
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: IP ADDRESSFrom: "Allen Mallari" <allen@fiax.net>Date: Mon, 29 Jun 1998 23:46:39 -0700
can you give me a detailed sample for clients file???
because i can see. it's only WINNT\domain in the client file.
Thanks,Allen
*********** REPLY SEPARATOR ***********
On 6/29/98, at 8:45 PM, Dale Reed wrote:
>Allen Mallari wrote:>> >> >> How do you assign an IP address to a specific user whenever>> >> they login?>> >>> >What mode are you running RadiusNT in?>>>> Text Mode>>Just add a Framed-Address entry for the user in your users files.>>-- >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