Attunity endpoint: Cannot connect MYSQL server

[sat29]

Setup an endpoint of MYSQL server in Attunity, test connection fail with the following message:

Cannot connect to ODBC provider ODBC general error.RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message: [unixODBC][MySQL][ODBC 5.3(w) Driver]SSL connection error: unknown error number ODBC general error.

Internal Parameters has set:
provider : MySQL ODBC 5.3.8 Unicode Driver

 (Try set as either source or target type got the same error)

The Attunity Server and the MYSQL stand in the same segment

But also there has another existing MySQL server which could connected success

[john_wang]

Hello @Sweetie_A ,

Not sure what's the Replicate version and the ODBC client version you are running (we can see it's 5.3 however please let us know the exact build name), this information is helpful to understand the issue further.

Anyway, regarding the specific error below, it looks like certificate problem, the server/client certificate will need to be regenerated using a different common name than what was used for the CA certificate.

• SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message: [MySQL][ODBC 5.3(w) Driver]SSL connection error: error:00000001:lib(0):func(0):reason(1)

---

A good sample is ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1).

BTW, please take note all the paths in MySQL source endpoint should be a specific file rather than a path only, a sample in my labs:

If the problem persists, the better option is configurating an ODBC DSN and using the DSN access to debug the error. if all works in DSN then it should be fine in Replicate.

Hope this helps.

Regards,

John.