Breaking Database Permission Changes in Automate 2021.1

After applying the Connectwise Automate 2021.1 patch, several partners reported different issues, unrelated to the database authentication changes. The symptoms varied from plugins not functioning to certain SQL queries not working, to issues with custom tables, all the way to major application issues. The cause of these issues can be traced back to permission changes. […]

Connectwise Automate MySQL user changes in patch 2021.1

Automate patch 2021.1 includes major changes to application user authentication and the interactions with MySQL. Below we describe what changed and what Automate administrators need to know. What changed? Previously each user in Automate had a matching user in MySQL with the same password. This allowed for integrations and administrators to authenticate to the database […]

MySQL 5.6 End of Life: What Connectwise Automate admins need to know

The MySQL 5.6 end of life date is February 5, 2021. Many Connectwise Automate partners are on MySQL 5.6, so here at Automation Theory, we wanted to clarify what that means for the day-to-day operations for Automate, and how to take action. End of Life: Just like Windows End of life in the Oracle world […]