Can some one help with this...
I still can't get users to authenticate with RadiusNT.
Using RadiusNT .60 - NT4/sp2 - SQL6.5 - ODBC2.5 - Cicso 2511
Running as '-x15 -b'
I have gone over the SQL rights, user rights, the database
I don't know how may times! I have brought up Access to
modify the database, no problem there, Emerald edits ok.
I have tried to do an SQL Trace on the calls that
RadiusNT is making to the SQL server and nothing appears
in the debug window. I suspect this is because RadiusNT
doesn't have any DDE or RPC calls in it that Trace can
hook.
RadiusNT does the authenticating ok for the users in
the flat text file, and does the accounting/logging to the
SQL server for the users in the flat file, but won't
authenticate any users in the SQL database.
I have been at this awhile and would appreciate any
and all comments on this. Below is a text capture of
my last frustration before I go home.
-------------- begin --------------------------
radrecv: Request from host cdc7ce02 code=1, id=80, length=70
NAS-Identifier = 205.199.206.2
NAS-Port = 1
User-Name = "test"
Challenge-Response =
"\001\024\331X0-_\177\210\343\222x\002\030\317\331'" User-Service
= Framed-User Framed-Protocol = PPP
rad_authenticate_ODBC()
Challenge-Response =
"\001\024\331X0-_\177\210\343\222x\002\030\317\331'"
Decrypted Password: +P_-,4
Allocating Statement...
SQL Statement: Select DateAdd(Day, ma.extension, maExpireDate),
DateAdd(Day, sa
..extension, saExpireDate), sa.AccountID, sa.AccountType, sa.Password,
sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where
(sa.Login='test1' or sa.Sh ell='test1') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0
Freeing SQL Statement...
LOG: User: test Not found
User: test Not found
Sending Reject of id 80 to cdc7ce02 (rtr-dav1.csx.net)
Response Time: 474
--------------------- end ------------------------
###################################################
Dave Helton System Admin CSX.NET
Circumspect Corporation dave@csx.net
902 East River Drive Davenport, IA 52803
Business: 319-323-6313 Fax: 319-323-3415
CSX.net Home Page http://www.csx.net
###################################################