This is what I ran to fix that problem. I don't know why the update scripts
that come with Emerald (and/or are available on the FTP site?) haven't been
fixed and re-uploaded yet.
Before running these, make sure that you have the following tables (they
should contain all of your old data):
radatconfigs_old
radconfigs_old
delete from radatconfigs
go
insert into radatconfigs
(accounttype, radattributeid, radvendorid, radvendortype, data, value,
radcheck)
select accounttype, radattributeid, radvendorid, radvendortype, data,
value, radcheck
from radatconfigs_old
go
delete from radconfigs
go
insert into radconfigs
(AccountID, RadAttributeID, RadVendorID, RadVendorType, Data, Value,
RadCheck)
select AccountID, RadAttributeID, RadVendorID, RadVendorType, Data, Value,
RadCheck
from radconfigs_old
go
Josh
>> -----Original Message-----
>> From: emerald-request@iea-software.com
>> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
>> Sent: Wednesday, April 14, 1999 11:32 PM
>> To: emerald@iea-software.com
>> Subject: Re: [Emerald] Radius will not load RadAttributes? (Help!)
>>
>>
>> > Gabriel Sponsler wrote:
>> >
>> > Since I upgraded Emerald to version 2.5 on a different server I
>> > have not been able to get RadiusNT to function. ODBC is pointing to
>> > the Emerald database and Radius is connecting as SA (dbo of all tables
>> > and databases). It appears identical to my functioning Emerald setup
>> > on my original server, I just can't get my arms around what is going
>> > on.
>> >
>> > This is the tail end of the message that comes up when I load
>> > Radius in debug mode:
>> >
>> > 21 Accounting Columns Loaded
>> > config_init(): dict_valfind(Lifetime-In-Days) not found.
>> > Enterprise features enabled.
>> > RadiusNT 2.5.160 (Emerald Standard) Initialized...
>> >
>> > This is the debug script I get when attempting a RadLogin:
>> >
>> > radrecv: Request from host a5e3e460 code=1, id=73, length=57
>> > Received unknown attribute 4, vendor 0
>> > Received unknown attribute 5, vendor 0
>> > Received unknown attribute 1, vendor 0
>> > Received unknown attribute 2, vendor 0
>> > rad_authenticate_ODBC()
>> > Sending Reject of id 73 to a5e3e460 (165.227.228.96)
>> > Authenticate: from 165.227.228.96 - No User Name
>> > SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username,
>> > Data, Caller
>> > ID) VALUES (51, GetDate(), '', '165.227.228.96', NULL) SQL Statement:
>> > INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data, Calle ID)
>> > VALUES (51, GetDate(), '', 'Proliant3', NULL)
>> >
>> > Resp Time: 261 Auth: 0/1 -> 1 Acct: 0/0/0 -> 0
>> >
>> > All I can think at this point is I had some type of error in
>> > upgrading the databases in between servers, but at this point I am
>> > really grasping for straws. If anyone has ANY ideas I would be
>> > appreciative.
>>
>> This happens when RadiusNT failed to load the RadAttributes table.
>> Do you receive any errors when RadiusNT starts up (ahead of the debug
>> that you quoted above)?
>>
>>
>> --
>>
>> Dale E. Reed Jr. Emerald and RadiusNT
>> __________________________________________
>> IEA Software, Inc. www.iea-software.com
>>
>
>