Radius NT not seeing Column Name Data

pvanhoesen ( (no email) )
Sun, 19 Apr 1998 14:53:34 -0500

I have a demo of Emerald and Radius running with a Livingston PortMaster
just fine with the text file login. After some wild SQL rides, I now hav=
the login to SQL successful. I am now getting an error that says it doesn=
see login and an invalid column exists even though I can see the user PPP
login in the Emerald program. I am not an SQL genius so I have a feeling
it's got something to do with a login, but I'm just guessing. I've got 2=
days left on my demo.


Paul Van Hoesen

13) License:

Param: Debug Level: 15
Initializing Winsock...
ODBC Datasource: 'radius'...
Making ODBC Connection...

27 Days left of your 45 day trial.
Allocating Statement...

SQL Statement: Select Name, RadAttributeID, Type From RadAttributes

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

SQL Statement: Select Server, IPAddress, Secret From Servers

3 Clients Loaded
16 Accounting Columns Loaded

Radius NT is ready to receive requests!

Password =3D "\311a\334\346\026Q`\274L\201\311\230\365X\330D"
ODBC Datasource: 'radius'...
Making ODBC Connection...

SQL Statement: Select DateAdd(Day, (ma.extension + ma.overdue),
DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType,
ord, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where
'test' or sa.Shell=3D'test') AND ma.CustomerID=3Dsa.CustomerID and sa.Act=

ODBC: SQLFetch Error:100: (00000)

Sending Reject of id 63 to cf4117c7 (ts1.webwatch.net)
LOG: User: test Not found

User: test Not found

SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, UserName, Data)
S (10, GetDate(), 'test', 'qP=A7=ED(q? l=ACITO# =BC')

ODBC: SQLExecDirect Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data=

Resp Time: 281 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0