Upgrade from 5.4 to 5.7 issue with Session

[Luc Winters]

Hello all

I was asked to upgrade our TekRadius from 5.4 to 5.7 After the upgrade my engineer noticed an issue causing us to roll back. The issue is described by the engineer below

From my engineer 

"On the existing service, if a session is live, but Tekradius doesn’t know about it, it will populate the ‘active sessions’ when it gets the first accounting packet. On the new version this doesn’t happen the ‘active sessions’ table only has active sessions when they have connected.

As we use active sessions table for the portal info, it would mean having to reconnect every customer to repopulate the active session table on the new version."

Question: is there a way around this issue?

Luc 

[Yasin KAPLAN]

Hi,

Can you try the latest built at https://www.kaplansoft.com/tekradius/release/TekRADIUS.D.zip ?

Best regards,

Yasin KAPLAN

[Luc Winters]

Hello Yasin

Sorry for the delay on this one, 

I have installed the linked version and I am getting an error 'Cannot display active sessions. Conversion from type 'DBnull' to type 'String' is not valid

Since it has been a while I downloaded the latest version from the website '5.7.7' and I get the same error. 

If I roll back to 5.4.4 then the active sessions come back

Luc

[Yasin KAPLAN]

Hi,

Is it possible for you to send output for the following SQL statement?

Select top 10 * from Sessions order by [TimeStamp]

Best regards,

Yasin KAPLAN

[Yasin KAPLAN]

Please run following queries prior to starting TekRADIUS service

Update Sessions set [OUserName] = [UserName] where [OUserName] is null;
Update Sessions set [LastActivity] = GETDATE() where [LastActivity] is null;
Update Sessions set [InterimUpdatePeriod] = 0 where [InterimUpdatePeriod] is null;
Update Sessions set [CallOrigin] = 'Outbound' where [CallOrigin] is null;

Best regards,

Yasin KAPLAN