Having problems authenticating with v2.5

Mike Noel ( noel@integrityonline.com )
Fri, 26 Jun 1998 08:29:03 -0700

I used to have RadiusNT v2.2 set up and working in ODBC mode with SQL
Server. But then I decided to upgrade to v2.5. I installed the v2.5
software without a problem. The problem seems to be with the database.

I didn't have any real users in the database with v2.2 so I thought the
best bet would be to simply start with the radius97.mdb access database,
upsize it to SQL Server, insert my specific data (servers and licenses
tables) then it would work. Right?

It hasn't worked so far. Through trial and error I've discovered that I
need to add saExpireDate and Extension to the SubAccounts table and OverDue
to the MasterAccounts table. (why weren't these already in Radius97.mdb?)
At this point I'm still not able to authenticate. Here is the output I get
from -x15 on the command line. Why is is not authenticating this user? Is
there an error? I have checked to make sure that the password and username
are in the SubAcounts table.

Thanks for any info.

-Mike Noel

radrecv: Request from host cdee120f code=1, id=250, length=75
User-Name = "test"
Challenge-Response = "\001\037\027\015+\366\013\322\323\026\365zO\
365V\217\211"
NAS-Identifier = 205.238.18.15
NAS-Port = 26
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Challenge-Response = "\001\037\027\015+\366\013\322\323\026\365zO\
365V\217\211"

SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Ex
tension+ma.OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), Dat
eAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType
, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts
sa Where (sa.Login='test' or sa.Shell='test' or sa.Email='test') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

SQL Statement: RadGetConfigs 1

Loading radius defaults for this type...

SQL Statement: RadGetATConfigs 'PPP'

Framed-Protocol = PPP (1)
User-Service = Framed-User (2)
Session-Timeout = 7200 (7200)
Framed-Netmask = 255.255.255.254 (0)
Framed-MTU = 255.255.255.254 (2400)
Framed-Compression = Van-Jacobsen-TCP-IP (2400)
Sending Ack of id 250 to cdee120f (pm7.pdx.integrityonline.com)
Framed-Protocol = PPP
User-Service = Framed-User
Session-Timeout = 7200
Framed-Netmask = 255.255.255.254
Framed-MTU = 2400
Framed-Compression = 2400

Resp Time: 110 Auth: 11/0 -> 11 Acct: 0/1/0 -> 1