-
-
Notifications
You must be signed in to change notification settings - Fork 411
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
MySQL SSL connection error: unknown error number #3270
Comments
mysql log:
|
Seems like disabling SSL solved [mysqld]
ssl=off |
Disabling SSL might be a security issue in the near future. Its better to fix it from the origin instead of taking the easy way out |
Okay, i think latest libmysql update broke mysql SSL, thats why didn't work. |
I don't think SSL ever worked with our MySQL implementation, see #2772 |
No errors with older server version |
Quick guess that in older versions when you tried SSL but failed it just tried non-ssl connection. Now it might try to enforce SSL and not fall back to non-ssl on failure. |
I have an idea why this is happening. All this time, an old version of libmysql.dll (6.1.3.0) was shipped with the Windows server. After this change botder noticed it and updated the old files. You might ask, what could have changed between 6.1.3.0 and the current version (6.1.11.0)? My guess is that the issue is that SSL was not used before, but with the new version it is now enabled by default. Why is there a connection issue? The issue is that the MySQL connector supports only TLSv1 and TLSv1.1 protocols when compiled with yaSSL. Starting from MySQL 8.0.28, TLSv1 and TLSv1.1 are no longer supported. If this is indeed the case, there are 2 possible solutions:
int ssl_mode = SSL_MODE_DISABLED;
mysql_options(m_handle, MYSQL_OPT_SSL_MODE, &ssl_mode); If we choose the second option, it is probably better to add an option for dbConnect. |
We should go with the first one. Not having SSL is... A shame to say at least |
@Xenius97 What version of mysql server you are using now? I need a stable one for the server. |
8.2, latest WampServer (local) |
Some linux servers have related issue
|
When the MySQL server enforces SSL, this will still happen again no matter if you enable SSL via options or not |
Describe the bug
[2023-12-15 09:25:20] WARNING: [core]\ex_mysql\server\classes\mysql.lua:27: Bad usage @ 'dbConnect' [SSL connection error: unknown error number]
I think its caused by 6f1ccc8
Steps to reproduce
dbConnect()
Version
22331
Additional context
No response
Relevant log output
No response
Security Policy
The text was updated successfully, but these errors were encountered: