SSL connection error: error:00000001:lib(0):func(0):reason(1)

Databases
1

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.

But …

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.

2

Apears to be a Cipher issue. This is all the error reporting it gives.

3

Self signed cert?

4

Yes.

5

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?

6

Thanks Julian,

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.