Hello, several questions regarding upgrading MySQL.

Some background info:
osTicket Version v1.15.4 (6bd7884) — Up to date
Web Server Software Microsoft-IIS/8.5
MySQL Version 5.5.62
PHP Version 7.3.31

My vulnerability scanning tools says there is a Denial of Service issue with MySQL 5.5.62 and recommends upgrade to version 5.7.30. Any issues upgrading to this version? Is MySQL 5.7.30 (or newer) compatible with osTicket 1.15.4?

I tried to use MySQL Installer. The catalogue updated via the web, and showed all updates available, but selecting upgrade throws an error about no updates available. Any ideas?


I haven't used the Windows version of MYSQL in a long time since switching to Linux, but I seem to remember that the the installer program doesn't support upgrades from major version to version.....in your case 5.5 to 5.7 and only does minor versions. I.E. 5.5.XX. I used to download the archive version and just overwrite the files to do upgrades. As always, make backups.

5 days later

I was able to get the newest version of 5.7 installed. Do anyone have documentation or instructions on how to migrate the data? How do I tell osTicket to begin using the new database?

I haven't tried to do this, but you should be able to use mysql cli or a 3rd party tool (like MySQL Workbench) and export the datebase.
Shut down mysql 5.5 service.
install and Start the 5.7 service.
Then you can do the same thing (connect to the server) and restore the exported database(s).

Write a Reply...