I run an webapp that connects to a MySQL DB. Until now via an SSH-tunnel.
For portability reasons I need to use the SSL connections from within the app.
Works fine from my Mac.
The Linux App server (client from the MySQL-db view) connects fine using a mysql-ssl command line connect with all the client-ca etc. files.
But on the same app-server the xojo app gives: SSL connection error: error:00000001:lib(0):func(0):reason(1)
Spend a day looking for the root cause. … No success until now.
Apears to be a Cipher issue. This is all the error reporting it gives.
Is it a wildcard cert? (if yes, try a non-wildcard)
Has the cert expired?
Try using absolute paths to your ssl related files.
Is the cipher you’re specifying in your code available on the server?
Since i work with mixed environments, it looks to be the last. And getting all systems in line.
In fact I got it working now for Linux client-systems with DHE-RSA-AES256-SHA.
Now I have the challange to get it working on Windows10/ODBC.