• Testers

    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
    
  • Testers

    @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

  • Senior Developer

    @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;

357
Online

8.1k
Users

15.0k
Topics

141.4k
Posts