python ssl mysql_Python3 MySQL SSL错误mysql.conn

我在这上面花了一整天的时间,想不出来。使用python和mysql.connector但当我尝试使用SSL时,我收到以下错误:Traceback (most recent call last):

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/network.py", line 384, in switch_to_ssl

self.sock.do_handshake()

File "/usr/lib/python3.4/ssl.py", line 804, in do_handshake

self._sslobj.do_handshake()

ssl.SSLError: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:600)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "./mysql_test.py", line 25, in

con = mysql.connector.connect(**config);

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/__init__.py", line 179, in connect

return MySQLConnection(*args, **kwargs)

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/connection.py", line 95, in __init__

self.connect(**kwargs)

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/abstracts.py", line 719, in connect

self._open_connection()

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/connection.py", line 210, in _open_connection

self._ssl)

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/connection.py", line 134, in _do_auth

self._socket.switch_to_ssl(**ssl_options)

File "/usr/local/lib/python3.4/dist-packages/mysql/connector/network.py", line 390, in switch_to_ssl

errno=2055, values=(self.get_address(), _strioerror(err)))

mysql.connector.errors.InterfaceError: 2055: Lost connection to MySQL server at '192.168.1.10:3306', system error: 1 [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:600)系统规范两台服务器:

德比安8.2

OpenSSL 1.0.1k 2015年1月8日

MySQL5.7.X版

Python3

pip3

在mysql.connector=连接器/Python 2.1.3

我知道ssl连接可以与php和climysql连接一起工作,但是我不知道如何让ssl正常工作。我还尝试在mysql.connector网络.py来源。我也尝试过使用或不使用_pure flag。非常感谢任何帮助。在

python源代码:

^{pr2}$

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值