[judyblitzcraig]

I tried following the installation instructions as outlined in the documentation, but the link to download the program in the Mac section is expired/doesn't work. Is there a current version of openCATS for mac users that I can download?

[kevinharper]

I have a client on v0.9.4 and would like to update it to the latest to plug some security holes and change to https. When preparing to do so, I found that MySQL is no longer supported and it's now MariaDB. My hosting provider does not offer MariaDB.

Are the two compatible enough to continue using MySQL or no?

[RussH]

Hi Kevin,

MySQL isn't deeply incompatible, it's just the out of the box defaults have changed - so it behaves differently from expected.. even down to how it sorts. MariaDB still behaves. If you were very persistent you can probably get MySQL to behave.. but simpler for the project to standardise just on MariaDB

If you have to stick on MySQL you can probably get to v0.9.6 but I'd recommend reviewing subsequent XSS changes and backporting them - htmlspecialchars on public-facing form fields as a minimum. Also check security on uploads/attachment folders; https://documentation.opencats.org/tech ... -.htaccess

All-in-all, I'd go to 0.9.7.2 with MariaDB and php 7.2.

Russ.