Hi All,
Came in today to find that the Mac hosting our JAMF Pro had done an automatic update and was sitting on the latest MacOS 10.14.3. JSS version is v10.9.0
MySQL had been left waaaaay behind on 5.6.39 which I understand is no longer supported (According to all documentation) ..... so I carefully followed the notes to upgrade it to 5.7.25.
All went absolutely fine, upgrade completed, server had a restart, JAMF was up and running and iPads were checking in - Great!
In preparation for the upgrade up to 10.10.1 (which was my main aim for today) I carefully read through the instructions and release notes regarding the database upgrade and noticed that MySQL 8.0 is now supported and recommended for use.
As the 5.6 >> 5.7 upgrade had just gone smoothly, I thought to myself "Why not go up to 8.0.15?" before I do the intended 10.10.1 upgrade? Seemed like a good idea at the time .......
Followed article to do preliminary checks for 5.7 > 8.0 upgrade.
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
No errors found, check passed
Running the MySQL 8.0.15 installer , chose "Legacy Authentication" option when prompted as per JAMF article:-
https://www.jamf.com/jamf-nation/articles/630/configuring-mysql-8-0-for-jamf-pro
Annnnnnnnnnnd.............. Now I can't get into JAMF! Attempting to login gives me a database connection error and I don't know what to do next!
Also, I like that the new MySQL Preference Pane is a bit more functional now, but the "Stop / Start" buttons don't always work properly (I had this issue back on 5.6 aswell)
Any suggestions??
General Specs Again:-
mySQL: 8.0.15
macOS: 10.14.3
JSS: 10.9.0 (with eventual upgrade to 10.10.1 planned once these issues are resolved)
Java: 8 Update 201