Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Display children header

Database Connections to MySQL unavailable after idle timeout

...

  • The default wait_timeout for MySQL is relatively short and the JOC Cockpit does not have a mechanism for keeping the connection open over longer periods of time such as overnight. 
  • See the following article for instructions about how to change the MySQL DBMS timeout variable:
  • If the DBMS wait_timeout is too short users will get an "Unauthorized to access JOC Cockpit" message together with a JOC-407 error message after submitting their credentials. However, restarting the JOC Cockpit web service / daemon will create a new database connection and allow authorized users to log in again.

 

Display children header