Fog Reports

[Greg Plamondon]

any time I try and use the user tracking to find what PC a user is logged into I get:

Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

The apache error.log:

[Wed Apr 07 09:39:23.233725 2021] [proxy_fcgi:error] [pid 23644] (70007)The timeout specified has expired: [client 192.168.10.170:49336] AH01075: Error dispatching request to :, referer: http://10fogserver.xxxxxxx.com/fog/management/index.php?node=report

[Sebastian Roth]

@Greg-Plamondon Possibly many records in the DB causing the timeout on load?

SQL query to check the number of entries: SELECT COUNT(*) FROM userTracking;

[Greg Plamondon]

@sebastian-roth yes I believe that was the case. I don’t remember the record count as I already purged data older than 30 days. I set up a SQL event that runs daily.

DELETE from userTracking WHERE utDate < now() - interval 30 DAY;

I can now run the reports