realtime logging empty

[bspdegh]

Real time logging does not show anything starting from midnight for a few minutes or hours. Affected versions are 9.6 and 9.5 (and maybe earlier releases)

[ra-at-diladele-com]

It is a known issue being researched - it seems some UTC calculations are not correct in Activity table due to UTC <-> localtime calculations.

From support:

Hm – this is really a bug – the log system seems to correctly think server is in CDT and thus writes logs to
 locally 06 june file; but the Admin UI takes data from locally 07 june file (which has not yet happen to 
you – but already happen to me here in EU).

Ok now it is 07 June at servers CDT timezone and I am immediately able to see the records in the Admin 
UI of me browsing  through the server. So there is a 5 hours window at the end of the day (CDT-UTC) 
when realtime cannot render current logs.. 

Creating issue...

[ra-at-diladele-com]

Updated the latest virtual appliance for 9.7 (develpment branch) with fixes for this issue - please could you try running it and see if the issue is fixed? - https://packages.diladele.com/websafety-va/9.7/websafety.zip

[ra-at-diladele-com]

Our tests seem to show it is fine.

[bspdegh]

Confirmed working. Could you please improve the upgrade process. Some things are missing after restoring the backup, like network config, hostname, additional safe ports config and ssl inspection is disabled.

[bspdegh]

also the default policies (strict, etc.) could be removed if they are not included in the backup