Message 2: Upgrading to 2.5
from "Richard Pedersen" <rich@cybernet1.com>
Message 3: Re: Upgrading to 2.5
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 4: radius errors
from "Jason Chimney" <jason@cnx.net>
Message 5: Re: New install
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 6: SQL Concurrency Tables
from "Majordomo@essex1.com" <majordomo@essex1.com>
Message 7: Re: SQL Concurrency Tables
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 8: Re: radius errors
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 9: Re: radius errors
from rabaut <rabaut@hcc.cc.fl.us>
Message 10: Can RadiusNT do IP pooling ?
from radiusnt.iea-software@mailpost.terabit.net
Message 11: Re: radius errors
from Dale Reed <daler@iea-software.com>
Message 12: Re: RadiusNT 2.5.124 startup problem
from RRaines@via-net.net (Raines, Robert)
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Upgrading to 2.5
From: "Jason Chimney" <jason@cnx.net>
Date: Thu, 18 Jun 1998 09:07:58 -0700
Hi, I read on the web page that I can upgrade to 2.5 and preserve my
database. Is there anything we should be aware of before we attempt to
upgrade to 2.5?
Thanks,
Jason
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Upgrading to 2.5
From: "Richard Pedersen" <rich@cybernet1.com>
Date: Sat, 18 Oct 1997 11:23:10 -0600
After upgrading to 2.5 Radiusnt runs fine from the command line with
the -x15 switch
However when run as a service it does not work.
Any suggestions?
Using Access
In radius admin the configuration checked are
Mode odbc
debug odbc
the odbc dsn checks properly
under options the items checked are
concurrency
manual calls update
thank-you for any suggestions
Rich
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 3 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Upgrading to 2.5
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Thu, 18 Jun 1998 11:57:38 -0700
Jason Chimney wrote:
>
> Hi, I read on the web page that I can upgrade to 2.5 and preserve my
> database. Is there anything we should be aware of before we attempt to
> upgrade to 2.5?
As always, backup your installation before doing anything. It
should be a smooth upgrade, but if you are running against an
MS Access database, you should re-read the thread last week about
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 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: radius errorsFrom: "Jason Chimney" <jason@cnx.net>Date: Thu, 18 Jun 1998 12:21:06 -0700
Hello, our radius service stopped unexpectedly last night around 9pm. ADr.Watson window was generated; please take a look athttp://www.cnx.net/radiuserror.htm and let me know if this means anything,to anyone :)
Thanks
Jasonjason@cnx.net
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: New installFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 18 Jun 1998 12:19:30 -0700
rabaut wrote:> > Thanks... that took care of that problem...> now... it gives me the message> > "RadiusNT Standard initialized...."> > and not the message> > "waiting for requests"> > as the instructions state...> is that OK??
Thats because you have a logfile defined and RadiusNT is writingeverything to the logfile from that point on. Clear the logfilein the RadiusNT admin and restart RadiusNT.
-- 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: SQL Concurrency TablesFrom: "Majordomo@essex1.com" <majordomo@essex1.com>Date: Thu, 18 Jun 1998 15:39:38 -0500
Hi; I have recently converted our Access97 over to SQL and have everythingrunning fine except for turning on the non-concurrency. I have a program I wrote to keep Radius honest, it telnets into ourportmasters and verifies who's on with who Radius thinks is on and updatesthe ServerPorts table accordingly. I'm still not up to speed with SQL but Ihave noticed that there is a view (or table?) called 'CallsOnline' as wellas the 'ServerPorts' table. Which does RadiusNt (SQL mode) use for checkingconcurrency? I'm in the process of updating our monitor program to handleSQL and thought I'd double check before I got too far.
Thanks :) R. Laughlin Majordomo@essex1.com Essex Internet Sterling, IL 61081 (815) 625-8893
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SQL Concurrency TablesFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 18 Jun 1998 14:13:26 -0700
Majordomo@essex1.com wrote:> > I have recently converted our Access97 over to SQL and have everything> running fine except for turning on the non-concurrency.> I have a program I wrote to keep Radius honest, it telnets into our> portmasters and verifies who's on with who Radius thinks is on and updates> the ServerPorts table accordingly. I'm still not up to speed with SQL but I> have noticed that there is a view (or table?) called 'CallsOnline' as well> as the 'ServerPorts' table. Which does RadiusNt (SQL mode) use for checking> concurrency? I'm in the process of updating our monitor program to handle> SQL and thought I'd double check before I got too far.
The CallsOnline view includes information from the ServerPorts tableamong others. Your program should update the serverports 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 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: radius errorsFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Thu, 18 Jun 1998 14:44:46 -0700
Jason Chimney wrote:> > Hello, our radius service stopped unexpectedly last night around 9pm. A> Dr.Watson window was generated; please take a look at> http://www.cnx.net/radiuserror.htm and let me know if this means anything,> to anyone :)
If you are using an MS Access database, try compacting it. Whenan MS Access database becomes to big or corrupted, it can causethe application connecting to it via ODBC, to crash. If you lookat the function that crashed (SQLConvertString) its actual an MSAccess/Jet ODBC Driver function, not RadiusNT 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 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: radius errorsFrom: rabaut <rabaut@hcc.cc.fl.us>Date: Thu, 18 Jun 1998 22:26:45 -0400
hello
Does anybody have any experience with the configuration of the Bay NetworksRAC with RadiusNT??
Thanks
Mike
rabaut@hcc.cc.fl.usHillsborough Community CollegeP.O. Box 5096Tampa, Florida 33675-5096
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Can RadiusNT do IP pooling ?From: radiusnt.iea-software@mailpost.terabit.netDate: Thu, 18 Jun 1998 23:56:21 -0400
Can RadiusNT do IP pooling ?Like StillBelt Radius from Funk Software.I need to be able to assign IP addresses from different subnetsdepending on user name.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: radius errorsFrom: Dale Reed <daler@iea-software.com>Date: Thu, 18 Jun 1998 21:00:43 -0700
rabaut wrote:> > Does anybody have any experience with the configuration of the Bay Networks> RAC with RadiusNT??
Are you running into any specific problems, or just looking for genericsetup questions?
-- 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: RadiusNT 2.5.124 startup problemFrom: RRaines@via-net.net (Raines, Robert)Date: Fri, 19 Jun 1998 01:56:16 -0400
Dale,
I am having this same problem it seems that on a reboot the the radiusservices starts before all of the tables in the SQL server are ready. I haveset the ODBCTimeout from 15-600 without any change. It seems to me thatradius thinks the ODBC connection is ready before all the tables have loaded. Is there a way to till the radius service to pause for 30 seconds beforestarting? This is the only problem that we are having. We wouldn't havenotice this except that we had a extended power outage in the middle of thenight that pulled down our UPS. When the power went back on the radius systemdidn't go online. Should I move the SQL server and the radius service toseparate computers or is there another fix? I have included a logfile for eachstartup of the Radius service (auto and manual).
***Logfile with auto startup service***
Initializing Winsock...ODBC Datasource: 'Emerald'...Making ODBC Connection...ODBC Datasource: 'Emerald'...Making ODBC Connection...ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'RadAttributes'.
ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'RadValues'.
ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Servers'.
Accounting Column 0 (16): 'NASIdentifier'Accounting Column 1 (4): 'NASPort'Accounting Column 2 (10): 'AcctSessionID'Accounting Column 3 (1): 'AcctStatusType'Accounting Column 4 (16): 'CallDate'Accounting Column 5 (32): 'UserName'Accounting Column 6 (1): 'UserService'Accounting Column 7 (4): 'AcctDelayTime'Accounting Column 8 (4): 'AcctSessionTime'Accounting Column 9 (4): 'FramedProtocol'Accounting Column 10 (16): 'FramedAddress'Accounting Column 11 (4): 'AcctInputOctets'Accounting Column 12 (4): 'AcctOutputOctets'Accounting Column 13 (1): 'AcctTerminateCause'Accounting Column 14 (1): 'NASPortType'Accounting Column 15 (10): 'NASPortDNIS'Accounting Column 16 (11): 'CallerId' 17 Accounting Columns Loadedconfig_init(): dict_valfind(Lifetime-In-Days) not found.
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host d1746104 code=1, id=88, length=113Received unknown attribute 1Received unknown attribute 3Received unknown attribute 4Received unknown attribute 5Received unknown attribute 61Received unknown attribute 6Received unknown attribute 7Received unknown attribute 24Received unknown attribute 31Received unknown attribute 30Received unknown attribute 44rad_authenticate_ODBC()Authenticate: from 209.116.97.4 - No User Name
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data) VALUES (51, GetDate(), '', '209.116.97.4')
ODBC Error:S0002:208: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'RadLogs'.
Resp Time: 30 Auth: 0/0 -> 1 Acct: 0/0/0 -> 0
***Logfile with manual startup service***
Initializing Winsock...ODBC Datasource: 'Emerald'...Making ODBC Connection...ODBC Datasource: 'Emerald'...Making ODBC Connection...Accounting Column 0 (16): 'NASIdentifier'Accounting Column 1 (4): 'NASPort'Accounting Column 2 (10): 'AcctSessionID'Accounting Column 3 (1): 'AcctStatusType'Accounting Column 4 (16): 'CallDate'Accounting Column 5 (32): 'UserName'Accounting Column 6 (1): 'UserService'Accounting Column 7 (4): 'AcctDelayTime'Accounting Column 8 (4): 'AcctSessionTime'Accounting Column 9 (4): 'FramedProtocol'Accounting Column 10 (16): 'FramedAddress'Accounting Column 11 (4): 'AcctInputOctets'Accounting Column 12 (4): 'AcctOutputOctets'Accounting Column 13 (1): 'AcctTerminateCause'Accounting Column 14 (1): 'NASPortType'Accounting Column 15 (10): 'NASPortDNIS'Accounting Column 16 (11): 'CallerId' 17 Accounting Columns Loaded
Enterprise features enabled.
RadiusNT (Emerald Standard) Initialized...
radrecv: Request from host d1746104 code=1, id=41, length=113 User-Name = "?" Challenge-Response = "\001.\254\033\354\3244[APi\\327\244\033j\323" NAS-Identifier = ???.???.???.??? NAS-Port = 20104 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPP State = "" Caller-Id = "??????????" NAS-Port-DNIS = "???????" Acct-Session-Id = "266970863"rad_authenticate_ODBC()
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, sa.LoginLimit From MasterAccounts ma,SubAccounts sa Where (sa.Login='?' or sa.Shell='?' or sa.Email='?') ANDma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
Checking for duplicate logins.
SQL Statement: RadCheckOnline '?'
? found on-line 0 time(s).
SQL Statement: RadGetConfigs 232
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'PPP'
Sending Ack of id 41 to d1746104 (Ascend01) User-Service = Framed-User Framed-Protocol = PPP
Resp Time: 601 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0
Sincerely,
Bob
Robert RainesPresident, Via-Net, Inc.614 486-3481, Fax 614 486-3482
----------> From: Dale E. Reed Jr. <daler@iea-software.com>> To: radiusnt@iea-software.com> Subject: Re: RadiusNT 2.5.124 startup problem> Date: Wednesday, June 17, 1998 3:03 AM> > 2Day Internet wrote:> > > > >RadiusNT 2.5 should reconnect. What you can do is change the> > >ODBCTimeout> > >registry setting and make it larger so that RadiusNT will wait longer.> > >It is possible that is just not waiting long enough.> > > > Please advise the key path / value as I dont see such a key.> > Page 14 of the RadiusNT manual, in the Command line and Registry> Settings chapter, includes the key and information on the> ODBCTimeOut value.> > -- > 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