Скачать или смотреть MariaDB update causes client connection problem : mariadb.OperationalError: TLS/SSL error: SSL is r

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah  

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!MariaDB update causes client connection problem : mariadb.OperationalError: TLS/SSL error: SSL is required, but the server does not support it

After updating Python mariadb to 1.1.10 (mariadbconnector-c version 3.4.1).
mariadb
I can't connect to the database through Python anymore. Worked for several years and now this error.
I don't need SSL or TLS for now. Server side does not use this (mysql on NAS synology using mariadb 10.11.6).
mysql
synology
Clients are using macos running sonoma 14.6.1. Debugging python code halts at the line
super().__init__(*args, **kwargs) in the init def of class Connection (connections.py) from mariadb package.
super().__init__(*args, **kwargs)
connections.py
mariadb
It seems to force SSL while it is not set as a argument
connection = mariadb.connect(host=e_host,user=get_user_NAS(),password=get_pw_NAS(),database=database_name).
connection = mariadb.connect(host=e_host,user=get_user_NAS(),password=get_pw_NAS(),database=database_name)
This code worked for years, so there was a change made that causes this.
How to disable this in the client?
Tried ssl_verify_cert set to false but no change. Tried previous version of mariadb package, but can't install previous mariadb connector-c with brew, only the 3.4.1. So, I am stuck now.. Any idea how to set this off?
ssl_verify_cert
mariadb
mariadb connector-c
When using client through terminal it connects, don't even have to pass --ssl=0 as param to make a connection. Only when using Python's mariadb.
I can't seem to connect anymore.
OpenSSL 3.3.2 is installed.


Tags: python,macos,ssl,mariadb,nasSource of the question:
https://stackoverflow.com/questions/7...

Question and source license information:
https://meta.stackexchange.com/help/l...
https://stackoverflow.com/