Thanks,
Paul
-----Original Message-----
From: Sheldon Edwards <slick@caribsurf.com>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Monday, April 20, 1998 7:11 AM
Subject: Re: Radius NT not seeing Column Name Data
>Check the RadLogs table and see if the column "Data" is there. If not
create
>this colum n as a character field probably length 90 and that would take
care
>of th einvalid column message.
>
>>From the information provided, it seems that the customer is trying to =
log
in
>with a username of "test". Check and see if this is a valid username.
>
>pvanhoesen wrote:
>
>> I have a demo of Emerald and Radius running with a Livingston PortMast=
er
>> just fine with the text file login. After some wild SQL rides, I now
have
>> the login to SQL successful. I am now getting an error that says it
doesn't
>> 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 feel=
ing
>> it's got something to do with a login, but I'm just guessing. I've go=
t
27
>> days left on my demo.
>>
>> Thanks,
>>
>> Paul Van Hoesen
>> 615-300-8059
>>
>> 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,
>> RadAttribut
>> 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),
>> 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=3D
>> 'test' or sa.Shell=3D'test') AND ma.CustomerID=3Dsa.CustomerID and
sa.Active<>0
>> and
>> ma.Active<>0
>>
>> 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, Da=
ta)
>> VALUE
>> 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
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>
>
>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>