@Attilio P Sorry, but I was busy. The problem you have with SSLMode and SSLEnabled commands is that the 2.0 framework has not been released for all platforms. So SSLMode is deprecated for the Desktop version but not for the web version (The Webframework 2.0 will be released with the new 2020r1 release this year). Surely the problem is in the xojo code but with the information you gave me I don't know how to help you.
My mariadb configuration is on centos7 and I left all the default values except some customization. For example:
ssl-ca = /etc/my.cnf.d/ssl/ca-cert.pem
ssl-cert = /etc/my.cnf.d/ssl/server-cert.pem
ssl-key = /etc/my.cnf.d/ssl/server-key.pem
tls_version = TLSv1.0,TLSv1.1,TLSv1.2,TLSv1.3
but when you say it works on linux do you mean the xojo version of linux or another client?
Hello, no worries, same here, I did tested other apps on other linux machines, in my case Debian 10 , I will try to build a quick web app to see if connecting from one web app on another machine will work, but in my case I do need to use it on MacOS so while that could validate or invalidate the working on linux in the end I will need it to work on Mac.
I guess I'll have to do another test and if this one fails as well in the worst case I'll have to find another framework or platform that is more flexible and does not have so many bugs and restrictions, hard decision but a needed one in the end, We cannot tell to the customers stay with us 6 more months until Xojo fixes their bugs and loosing customers is bad for us as well.