ConnectWise Automate MySQL 8.4: What MSPs need to know
ConnectWise Automate now supports MySQL 8.4. In this blog, we’ll look at what this means for MSPs and what the upgrade process is like. What’s New in MySQL 8.4? MySQL 8.4 is the latest long-term support (LTS) branch. It’s the successor to MySQL 8.0, which goes end-of-life in April 2026. Being an LTS branch, its […]
ConnectWise Ends MySQL 5.7 Support: What MSPs Need to Know
In January, ConnectWise announced they are ending support for MySQL 5.7 in Automate. In this blog, we’ll explore what that means and what actions MSPs need to take. Already End-of-Life You might be aware that MySQL 5.7 reached end-of-life in October 2023. It stopped receiving security updates, and for security and insurance/compliance reasons, your MySQL […]
EoL software and MSP insurance requirements
Here at Automation Theory, we advocate for keeping Automate’s MySQL database patched for typical security/performance/stability reasons. However, we’ve recently seen clients purchase our MySQL maintenance packages for cyber insurance reasons — a trend we hadn’t seen before. One client explained that his insurance carrier added a clause that claims wouldn’t be covered if the software […]
MySQL 5.7 End of Life: What Connectwise Automate admins need to know
The MySQL 5.7 end-of-life date is October 21, 2023. Many Connectwise Automate partners are on MySQL 5.7, so here at Automation Theory, we wanted to clarify what that means for the day-to-day operations of Automate and how to take action. End of Life: Just like Windows Software end-of-life with Oracle is the same as with […]
How to pwn an Automate server: Connectwise Automate LAN Security
ConnectWise Automate security is something at the forefront of discussion for every MSP. Previously we’ve discussed security from the WAN angle, and how reverse proxy technology can be implemented to reduce the attack surface. However, internal LAN communications can also be an attack vector, and here at Automation Theory, we wanted to give proper attention […]
Connectwise Automate MySQL 8 Support: What it means for Automate administrators
Connectwise Automate MySQL 8 support is scheduled to arrive in October 2021. This will also introduce formal support for Windows Server 2019 to Automate. Here at Automation Theory, we wanted to clarify what that means for the day-to-day operations for Automate, and how to take action. MySQL 8: What’s new? MySQL has a long and […]
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 […]
Top 5 myths about the Automate Database
As we begin discussing myths about the Connectwise Automate database, we’d like to go on record and say that most of the published information is wrong or misleading. Databases are extremely complex, and most of the existing tuning or maintenance advise is not holistic in nature — it treats symptoms and not the root causes. […]