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_