I have been testing the connection to the mysql server for 3 days. Error 2026 .Today the provider said that it operates with opensql. In the new version Xojo 2021 does not work in version 2015R2.1 everything works wasn’t it a step back?
I Googled the error code and found this page. Note the connection error messages:
ERROR 2026 (HY000): SSL connection error: SSL certificate validation failure
ERROR 2026 (HY000): SSL connection error: Server doesn’t support SSL
ERROR 2026 (HY000): SSL connection error: ASN: bad other signature confirmation
To me, this suggests your provider is using outdated SSL as the older version of Xojo / MySQL does work.
how to set it up in xojo server’s provider
I’m starting to think you should either reveal your provider to someone who knows how to understand what services they’re offering, or switch to a provider that doesn’t give you so much runaround with modern SSL.