Not authenticating with ODBC

Dmitry Prokhorov ( (no email) )
Mon, 7 Apr 1997 02:07:04 +0400

Can anybody help me make RadiusNT worked correctly?
I am running NT 4.0 with the latest service pack and RadiusNT .60 in ODBC
Mode using MS Access 7 example.
In a Text mode everything works correctly. In ODBC mode users are not
authenticated.
Sorry, my English is not well. Thank you.

a) C:\radius>radius.exe -x15

0) Mode: 0
1) EncryptPasswords: 0
2) IgnoreCase: 0
3) ReqAcctAuth: 0
4) Options: 16
5) Debug: 4
6) ODBCDatasource: Radius
7) DataDirectory: c:\radius
8) AcctDirectory: c:\radius\acct
9) UsersFile: users
10) Username:
11) Password:
12) AuthPort: 1645
13) AcctPort: 1646

Param: Debug Level: 15
Param: ODBC Only Enabled
Initializing Winsock...
ODBC Datasource: 'Radius'...
Allocating ODBC Henv...
Allocating ODBC Connect...
Making ODBC Connection...
MS Access Mode Enabled
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

SQL Statement: Select ra.Name, rv.Name, rv.Value From RadValues rv,
RadAttribut
es ra Where rv.RadAttributeID = ra.RadAttributeId

odbc_read_client_info()
Allocating Statement...

SQL Statement: Select Server, IPAddress, Secret From Servers

Client:localhost:127.0.0.1:localhost
Allocating Statement...
Accounting Column 0: 'NASIdentifier'
Accounting Column ............................
Accounting Column 19: 'ClientPortDNIS'

Radius NT is ready to receive requests!

b) C:\radius>radlogin.exe test test

Checking Radius user test:
0: Time: 485 Auth: Bad

0 Good 1 Bad 485 Avg

>Radius answer:

radrecv: Request from host 7f000001 code=1, id=1, length=0
NAS-Identifier = 127.0.0.1
NAS-Port = 0
User-Name = "test"
Password = "v\255\245\252\177Ux\343\034\3529\201w&\343Q"
rad_authenticate_ODBC()
Password = "v\255\245\252\177Ux\343\034\3529\201w&\343Q"
Decrypted Password: |άΙ_
Allocating Statement...

SQL Statement: Select DateAdd('d', ma.extension, maExpireDate),
DateAdd('d', ma
..extension, maExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login,
sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='test' or
sa.She
ll='test') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and
ma.Active<>0

Database Password: test
Freeing SQL Statement...
LOG: User: test Not found

User: test Not found
Sending Reject of id 1 to 7f000001 (localhost)

Response Time: 545

---------------------------------
Users:
test Password = "test"
User-Service = Framed-User
<blank line>
---------------------------------