Enrollment Fails Using the Casper Suite or Recon Suite v8.63 or earlier with MySQL 5.6

[donmontalvo]

New KB provides a "fix" for the issue of our inability to enroll Macs:

Enrollment Fails Using the Casper Suite or Recon Suite v8.63 or earlier with MySQL 5.6
https://jamfnation.jamfsoftware.com/article.html?id=318

However, it does not tell us if it is safe to roll back JSS if we are already running 5.6?

Can we shut down JSS, uninstall MySQL 5.6...then install MySQL 5.5 and start MySQL again?

Is this safe? Is it recommended?

PS, no option to post this question on the KB page...so posting here.

TIA
Don

[DavidSu · Accepted solution]

Hi Don,

Depending on the OS, a roll back of MySQL can be a little trickier than that. An alternative workaround for the error is to comment the sql_mode parameter out of the my.cnf/my.ini, and restart MySQL (this will disable strict mode). We'll get the KB updated to reflect this.

Thanks,
Dave

[donmontalvo]

@david.suehring Thanks for the incredibly fast response and workaround. :)

We'll test this to see if it fixes the problem in our environment.

Don

[donmontalvo]

Sorry for the late response...your solution was spot on.

Don