search

datajoint / mym

MySQL API for MATLAB with support for BLOB objects
Other
7 stars 17 forks source link

MySQL Compatibility with Version >8.0.18 #55

Open guzman-raphael opened 4 years ago

guzman-raphael commented 4 years ago

Apparently the MySQL 8.0.19 release broke the connection for mym. I've skimmed the notes here but didn't see anything obvious (the compression algorithm definition between server/client looked interesting tho). Thinking for now we should communicate that we support up to 8.0.18 until we could assign some time to address. The error that is encountered is of the sort:

SSL connection error: unknown error number
liminghu commented 3 years ago

@guzman-raphael Did you solve the issue? I installed the latest mym, I have the similar issue: db = mym('open', server, username, password) Error using mym SSL connection error: unknown error number

I checked mysql version: 8.0.22

A-Baji commented 2 years ago

This issue is related to the TLS encryption logic. The current work around would just be to manually turn it off: db = mym('open', server, username, password, 'false')

stjaeckel commented 1 year ago

I have the same issuse. Turning it off results in the following error: Error using mym Authentication plugin 'caching_sha2_password' cannot be loaded: /home/stephan/MATLAB Add-Ons/Toolboxes/mym/distribution/mexa64/caching_sha2_password.so: cannot open shared object file: No such file or directory

System: ubuntu 22.04 Mysql Version: mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))