Message 2: Re: ver2.5
from "Dale E. Reed Jr." <daler@iea-software.com>
Message 3: Re: ver2.5
from Ted Olson <tolson@ocsnet.net>
Message 4: CallsOnline - table vs query?
from Ted Olson <tolson@ocsnet.net>
Message 5: Re: Radius start error (solved)
from Ted Olson <tolson@ocsnet.net>
Message 6: Access to SQL
from Glen Harvy <glen@aquarius.com.au>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Crashed when reloaded
From: "Wilyono Jusuf" <netadmin@globalinfo.net>
Date: Mon, 27 Jul 1998 00:12:35 +0700
Hi,
Each time I tried to reload users database, the RadiusNT service
always crashed. And I had to restart the machine, since restarting
the service didn't help. Dr. Watson errors were displayed during
the reboot process.
Below is what authentication log showed:
----- start -----
Initializing Winsock...
RadiusNT Enterprise Initialized...
radrecv: Request from host 7f000001 code=1, id=176, length=60
NAS-IP-Address = 127.0.0.1
NAS-Port = 0
User-Name = "*reload*"
Password = "\342s\012D\351\230.\262~\244L\322[|\227\340"
Checking user record PW_PASSWORD type
authPapPwd
chkPwd->strvalue is ReloaD
decrypted pwd is ReloaD
----- end -----
Willy
___________________
GlobalNet - Jakarta
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: ver2.5
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Sun, 26 Jul 1998 11:00:41 -0700
Ted Olson wrote:
>
> Well, we're up with 2.5.124 ... now adding tables and fields to match the
> new changes. At the moment we're trying to figure out the relationship (or
> lack thereof) that is causing a stream of MsgID=19 in RadLogs, accompanyied
> by the logfile entries below. Can't really see the relationship so far that
> is missing and causing these errors (users trying to dial in keep getting a
> 'wrong password' message). Any help?
If you look in the RadLogMsgs table, you'll see thet 19 is "No
Attributes".
That means the user doesn't have any specific attributes and there are
not
default attributes for the user's account type in the RadATConfigs
table.
> Sat Jul 25 17:27:45 1998: ODBC Error:07001:-3010:
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 3.
> Sat Jul 25 17:27:46 1998: ODBC Error:07001:-3010:
> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 3.
> Sat Jul 25 17:27:46 1998: username: PPP has no RADIUS default attributes.
These are misleading errors. Usually this means that fields are either
missing or not named to what the query is expecting.
-- 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: ver2.5From: Ted Olson <tolson@ocsnet.net>Date: Sun, 26 Jul 1998 11:49:33 -0700
At 11:00 AM 7/26/98 -0700, you wrote:>Ted Olson wrote:>> >> Well, we're up with 2.5.124 ... now adding tables and fields to match the>> new changes. At the moment we're trying to figure out the relationship (or>> lack thereof) that is causing a stream of MsgID=19 in RadLogs, accompanied>> by the logfile entries below. Can't really see the relationship so far that>> is missing and causing these errors (users trying to dial in keep getting a>> 'wrong password' message). Any help?>>If you look in the RadLogMsgs table, you'll see thet 19 is "No>Attributes".>That means the user doesn't have any specific attributes and there are>not>default attributes for the user's account type in the RadATConfigs>table.>
Actually Dale, just FYI, those attributes *were* already set up(AccountType in sa and matching record/field in RadATConfigs). That's whatstumped me, and I fired off the note above 'just in case' while continuingto create the tables that are new in 2.5 and populating the new fieldadditions to our preexisting tables from v1.16.49b. After that was doneeverything worked fine, with no need to add any attributes (they werealready there, including defaults). Seems that it must have been adifferent relationship that was dependant on one of the new changes thatwas triggering the errors.
(Sorry if my note was yelling fire prematurely, but being down on a busyweekend with phones ringing off the hook is no picnic, as I'm sure youknow. Just wanted to get the question out there as a backup plan in casewhat we were doing still didn't solve the problem.)
Thanks,-Ted
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: CallsOnline - table vs query?From: Ted Olson <tolson@ocsnet.net>Date: Sun, 26 Jul 1998 11:51:47 -0700
Just a low-key question: What are the reasons or opinions, one way or theother, for setting up a CallsOnline table versus just running a query?We've been using the query method for quite some time now, just curiousabout the rationale or possible uses/advantages for the table...
Thanks,-Ted OlsonOCS Software
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Radius start error (solved)From: Ted Olson <tolson@ocsnet.net>Date: Sun, 26 Jul 1998 12:46:43 -0700
For possible benefit to someone else, here's a recap of the problem weexperienced yesterday and how it was solved.
CONFIGRadiusNT 1.16.49b, running as a service on NT4.0/SP3, dedicated auth/acctserver
PROBLEMUsers couldn't authenticate, found RadiusNT service had stopped. Itwouldn't restart, returned a general system error ("1067: the processterminated unexpectedly"). Command line would also not start the app,running radius -x15 reported "ODBC: SQLConnect Error: [Microsoft][ODBCMicrosoft Access 97 Driver] General error, failed to get the expressionservice."
CLUESThis system had been running without a glitch for several months, problemseemed to occur out of the blue. But there *was* one recent change,coincidentally on the afternoon just before the trouble started. We weresetting up an AT scheduled process to run a batch file to compact ourauth/acct db ... it was to stop RadiusNT, then compact the db, then restartRadiusNT, simple enough. But it was pausing (and so failing) at the compactstep because of Microsoft's very annoying little "Mr. Paperclip," which wecouldn't find anywhere to disable from running at startup. One of our techsthought this was part of the wizards option at installation, so hereinstalled Access97.
TROUBLESHOOTINGSince the problem started the following morning, we associated these eventstogether and spent quite a lot of time investigating possible ODBCproblems, reinstalling drivers, removing and installing Access97 again,removed and reinstalled the RadiusNT service, tried running it as a commandline app, double checking registry values, etc etc. Searched through all ofRadiusNT's online archives (very handy Dale) as well as a general Netsearch for ODBC problems - tried a couple of suggestions we found, but allwith no change. Also, when attempting to repair the db via the ODBC DSNmanager, the same error message appeared as noted earlier ("failed to getthe expression service"). However, the db would successfully repair andcompact via Access itself.
SOLUTIONDale sent an e-mail recommending installing version 2.5, since v1.x is nolonger supported and he knew that ODBC issues were handled a bitdifferently now. My preference had been to try to fix the original problemand get back to square one first, since I don't like to make several systemchanges all at the same time - that's living dangerously! But we had runout of airspeed, altitude, and ideas so decided what the hell, nothing tolose.
It worked! Immediately after removing 1.16 and installing and configuring2.5 (plus the update), the RadiusNT service would start again. We thenstarted receiving connection attempts that were failing, with a confusingerror message about "no attributes," even though RadAttributes were alreadythere in our previous db. Anyhow, there were a few new tables to create andseveral new fields to add to preexisting tables - although there did notseem to be any obvious relationship to the attributes error, that problemnevertheless cleared right up as soon as we finished with the db updates -normal connections resumed immediately (came flooding in is actually morelike it).
RECAPThe good news is that all is running great again! I still have a questionmark about what actually happened to cause the problem in the first place,but that may never be known. Would a reinstall of 1.16 have solved it?Maybe, but by the time we reached that point it didn't make sense not tomove up to 2.5 (if that had not worked we would have backtracked).
Thanks to Dale for the online support and suggestions, even on a weekend(when else do things go wrong?), and for the new version. Hope these notesmight assist someone else...
Regards,
Ted OlsonOCS Software
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Access to SQLFrom: Glen Harvy <glen@aquarius.com.au>Date: Mon, 27 Jul 1998 09:46:48 +1000
Hi,
I'm moving my database from MS Access to MS SQL and now get the followingerror:
iHTML error in C:\WebSite\htdocs\client2.htmlError Number : 350Error Description: Native SQL Error CodeProbable cause: Previous Page: C:\WebSite\htdocs\client2.html
A Database Error Occurred:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name'SubAccounts'.Last SQL Statement:
Is there a different syntax required between access and SQL?
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