------=_NextPart_000_0048_01BDC6E3.9FD23030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dale: I'm having problems authenticating with a new installation =
running RadiusNT in OBDC mode. Login is rejected with "user has no =
default attributes. New account setup with default attributes for the =
service look OK in the tables. I suspect the Radius DSN is not reading =
the database correctly.
I notice that initialization shows radius as and invalid database. =
Where to I look to correct this? Cut and past attached:
Initializing Winsock...
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled
ODBC Datasource: 'Emerald'...
Making ODBC Connection...
MS SQL Server Mode Enabled
radius: Invalid Database or Computer Date.
Thu Aug 13 17:48:22 1998: Invalid Database or Computer Date.
Invalid Database or Computer Date.
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'
16 Accounting Columns Loaded
Thu Aug 13 17:48:22 1998:=20
RadiusNT Enterprise Initialized...
RadiusNT Enterprise Initialized...
radrecv: Request from host 7f000001 code=3D1, id=3D15, length=3D61
NAS-Identifier =3D 127.0.0.1
NAS-Port =3D 0
User-Name =3D "flatrate2"
Password =3D "\270{5"\312\0113\245\360\003XR\033I\327\205"
rad_authenticate_ODBC()
Password =3D "\270{5"\312\0113\245\360\003XR\033I\327\205"
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.TimeLeft, =
sa.LoginLimit From MasterAccounts ma, SubAccounts sa Where =
(sa.Login=3D'flatrate2' or sa.Shell=3D'flatrate2') AND =
ma.CustomerID=3Dsa.CustomerID and sa.Active<>0 and ma.Active<>0
Decrypted Password: flatrate2
Database Password: flatrate2
Checking for duplicate logins.
SQL Statement: RadCheckOnline 'flatrate2'
ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadCheckOnline' not found.
Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadCheckOnline' not found.
SQL Statement: RadGetConfigs 3
ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadGetConfigs' not found.
Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadGetConfigs' not found.
Loading radius defaults for this type...
SQL Statement: RadGetATConfigs 'Flat Rate'
ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadGetATConfigs' not found.
Thu Aug 13 17:49:04 1998: ODBC Error:37000:2812:
[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure =
'RadGetATConfigs' not found.
Sending Reject of id 15 to 7f000001 (Localhost)
flatrate2: Flat Rate has no RADIUS default attributes.
Thu Aug 13 17:49:04 1998: flatrate2: Flat Rate has no RADIUS default =
attributes.
flatrate2: Flat Rate has no RADIUS default attributes.
SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, =
Data) VALUES (19, GetDate(), 'flatrate2', 'flatrate2')
ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name =
'Data'.
Thu Aug 13 17:49:04 1998: ODBC Error:S0022:207:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name =
'Data'.
Resp Time: 271 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
Thanks
Rick Morgan
rick@gtn.net=20
------=_NextPart_000_0048_01BDC6E3.9FD23030
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">