cymysql.err.InternalError: (1043, 'Bad handshake')

[kobe-tian]

django == 3.0.5
django-cymysql == 3.0.0
cymysql == 0.9.14
mysql == 5.7.23

Traceback (most recent call last):
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 197, in connect
self.connection = self.get_new_connection(conn_params)
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/mysql_cymysql/base.py", line 232, in get_new_connection
return Database.connect(**conn_params)
File "/home/linux/py3env/lib/python3.7/site-packages/cymysql/init.py", line 84, in Connect
return Connection(*args, **kwargs)
File "cymysql/connections.py", line 248, in cymysql.connections.Connection.init
File "cymysql/connections.py", line 414, in cymysql.connections.Connection._connect
File "cymysql/connections.py", line 500, in cymysql.connections.Connection._request_authentication
File "cymysql/connections.py", line 419, in cymysql.connections.Connection.read_packet
File "cymysql/packet.pyx", line 65, in cymysql.packet.MysqlPacket.init
File "cymysql/err.py", line 149, in cymysql.err.raise_mysql_exception
File "cymysql/err.py", line 144, in cymysql.err._check_mysql_exception
cymysql.err.InternalError: (1043, 'Bad handshake')

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/home/linux/py3env/lib/python3.7/threading.py", line 917, in _bootstrap_inner
self.run()
File "/home/linux/py3env/lib/python3.7/threading.py", line 865, in run
self._target(*self._args, **self._kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/autoreload.py", line 53, in wrapper
fn(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/commands/runserver.py", line 120, in inner_run
self.check_migrations()
File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/base.py", line 458, in check_migrations
executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/executor.py", line 18, in init
self.loader = MigrationLoader(self.connection)
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 49, in init
self.build_graph()
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 212, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 76, in applied_migrations
if self.has_table():
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 56, in has_table
return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 260, in cursor
return self._cursor()
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 236, in _cursor
self.ensure_connection()
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 197, in connect
self.connection = self.get_new_connection(conn_params)
File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, **kwargs)
File "/home/linux/py3env/lib/python3.7/site-packages/mysql_cymysql/base.py", line 232, in get_new_connection
return Database.connect(**conn_params)
File "/home/linux/py3env/lib/python3.7/site-packages/cymysql/init.py", line 84, in Connect
return Connection(*args, **kwargs)
File "cymysql/connections.py", line 248, in cymysql.connections.Connection.init
File "cymysql/connections.py", line 414, in cymysql.connections.Connection._connect
File "cymysql/connections.py", line 500, in cymysql.connections.Connection._request_authentication
File "cymysql/connections.py", line 419, in cymysql.connections.Connection.read_packet
File "cymysql/packet.pyx", line 65, in cymysql.packet.MysqlPacket.init
File "cymysql/err.py", line 149, in cymysql.err.raise_mysql_exception
File "cymysql/err.py", line 144, in cymysql.err._check_mysql_exception
django.db.utils.InternalError: (1043, 'Bad handshake')

[nakagami]

I don't know why, but

1. Write pure cymysql example code (not django and django-cymysql)
2. Test with mysql command

[kobe-tian]

I don't know why, but

1. Write pure cymysql example code (not django and django-cymysql)
2. Test with mysql command

have any example code, Test cymsql connect （use ssl）
i don't know how to test it

[kobe-tian]

here is my databases code
"options": { "ssl": { "ca": "", "cert": "", "key": "" } }

[nakagami]

seems

"options": { "ssh" : True }

[kobe-tian]

seems

"options": { "ssh" : True }

ops, it does't work, are you sure?
System check identified no issues (0 silenced). Exception in thread django-main-thread: Traceback (most recent call last): File "/home/linux/py3env/lib/python3.7/threading.py", line 917, in _bootstrap_inner self.run() File "/home/linux/py3env/lib/python3.7/threading.py", line 865, in run self._target(*self._args, **self._kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/autoreload.py", line 53, in wrapper fn(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/commands/runserver.py", line 120, in inner_run self.check_migrations() File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/base.py", line 458, in check_migrations executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 49, in __init__ self.build_graph() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 212, in build_graph self.applied_migrations = recorder.applied_migrations() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 76, in applied_migrations if self.has_table(): File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 56, in has_table return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 260, in cursor return self._cursor() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 236, in _cursor self.ensure_connection() File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection self.connect() File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 197, in connect self.connection = self.get_new_connection(conn_params) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/mysql_cymysql/base.py", line 232, in get_new_connection return Database.connect(**conn_params) File "/home/linux/py3env/lib/python3.7/site-packages/cymysql/__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "cymysql/connections.py", line 121, in cymysql.connections.Connection.__init__ TypeError: __init__() got an unexpected keyword argument 'ssh'

[nakagami]

Oh, Sorry

"options": {"ssl": Ture}

ssh -> ssl

[kobe-tian]

ssl

Traceback (most recent call last): File "/home/linux/py3env/lib/python3.7/threading.py", line 917, in _bootstrap_inner self.run() File "/home/linux/py3env/lib/python3.7/threading.py", line 865, in run self._target(*self._args, **self._kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/autoreload.py", line 53, in wrapper fn(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/commands/runserver.py", line 120, in inner_run self.check_migrations() File "/home/linux/py3env/lib/python3.7/site-packages/django/core/management/base.py", line 458, in check_migrations executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS]) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/executor.py", line 18, in __init__ self.loader = MigrationLoader(self.connection) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 49, in __init__ self.build_graph() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/loader.py", line 212, in build_graph self.applied_migrations = recorder.applied_migrations() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 76, in applied_migrations if self.has_table(): File "/home/linux/py3env/lib/python3.7/site-packages/django/db/migrations/recorder.py", line 56, in has_table return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 260, in cursor return self._cursor() File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 236, in _cursor self.ensure_connection() File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection self.connect() File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/django/db/backends/base/base.py", line 197, in connect self.connection = self.get_new_connection(conn_params) File "/home/linux/py3env/lib/python3.7/site-packages/django/utils/asyncio.py", line 26, in inner return func(*args, **kwargs) File "/home/linux/py3env/lib/python3.7/site-packages/mysql_cymysql/base.py", line 232, in get_new_connection return Database.connect(**conn_params) File "/home/linux/py3env/lib/python3.7/site-packages/cymysql/__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "cymysql/connections.py", line 160, in cymysql.connections.Connection.__init__ TypeError: argument of type 'bool' is not iterable

[nakagami]

Sorry, I'm not sure about the SSL connection thing.

The settings for ssl should be the same as PyMySQL in the original fork.
PyMySQL#430
Here's what you might find helpful.

[kobe-tian]

in fact, i just use cymysql. i got seem error
conn = cymysql.connect( host='xxx', user='xxxx', passwd='xxxxx' db='xxxxx', ssl={"ca": "ca path", "cert": "cert path", "key": "key path"} ) cur = conn.cursor()
but i do not useing ssl, i want work!