Can't find overdue column name?

Mike Noel ( noel@integrityonline.com )
Thu, 07 May 1998 19:44:45 -0700

I'm trying to use a SQL Server database with RadiusNT (without emerald).
I'm using RadiusNT v2.2 so I took the radius7.mdb file and converted it to
an SQL Server database using the SQL Server upsizing plugin. I added my
portmaster to the server file and left the 1 test user in the database.

I am running radius -x15 from a prompt and each time I try to connect I get
the following error message on the screen. What's the deal?

***************************************************************************
radrecv: Request from host cdee121d code=1, id=12, length=75
User-Name = "test"
Challenge-Response = "\001\023\270\013\032T\337\360\371=\350AfC{\331\201"
NAS-IP-Address = 205.238.18.29
NAS-Port = 1
NAS-Port-Type = Async
User-Service = Framed-User
Framed-Protocol = PPP
rad_authenticate_ODBC()
Challenge-Response = "\001\023\270\013\032T\337\360\371=\350AfC{\331\201"

SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue),
maExpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
sa.AccountType, sa.Passw ord, sa.Login, sa.Shell From MasterAccounts
ma, SubAccounts sa Where (sa.Login= 'test' or sa.Shell='test') AND
ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0

Sending Reject of id 12 to cdee121d (pm1.intl.integrityonline.com)
LOG: ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'overdue'.

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'overdue'.

Resp Time: 130 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
*****************************************************************************

I'm kinda stumped for now. Any ideas? Do I have a trigger wrong or
something? Where's the "overdue" column coming from? BTW, if I try the
long select statement (above) in the SQL Query tool I get similar errors
about an invalid column name.

Thanks for any info.

_M_