> Chuck Chopp wrote:
> >
> > I noticed that early in the log file there is an ODBC error that happens
> > due to a syntax error in an SQL statement. I think that this SQL error
> > is the actual source of the problem since it appears to affect the
> > loading of attribute information from the database into the radius
> > program.
>
> Version of RadiusNT past 2.5.200, have full VSA support. I would guess
> that your DB doesn't have the VSA columns (VendorID and VendorType) in
> the RadConfigs or RadATConfigs tables. You should also have those in
> the
> RadAttributes and RadValues tables. If you don't have those columns,
> the
> defaults will not load.
I checked out the table structure for each of those tables. The RadVendorID
and RadVendorType fields were present in 3 of the 4 tables. The RadValues
table was missing these fields. I opened up the database in Access 97 and
added those fields. I then saved the modified tables and started up the
radius server with "radius -x15". I then retried the authentication test with
"radlogin test test". I got the same authentication rejection that I was
getting previously. The debug output from radius still indicates the
following:
test: PPP has no RADIUS default attributes.
test: PPP has no RADIUS default attributes.
For some reason it just won't read the default attributes for the "PPP"
account type. All of these settings are at their "out of the box" default
values. I would expect that the sample database that gets shipped with the
product would be valid, but at this point I cannot tell if the database is
wrong or if there is a bug in the software.
Chuck
--Chuck ChoppChuckChopp@rtfmcsi.com http://www.rtfmcsi.com ICQ # 22321532RTFM Consulting Services Inc. 864 801 2795 voice & voicemail103 Autumn Hill Road 864 801 2774 faxGreer, SC 29651 800 400 4935 pager 8004004935@alphapage.airtouch.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart