2021-10-23 23:19:40,732 - D:\git_workspace\sanoh\G01_0350\sql.py[line:24] - ERROR: mysql连接异常: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect database=self.database) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt "'cryptography' package is required for sha256_password or caching_sha2_password auth methods" RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Stack (most recent call last): File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 585, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2021-10-24 00:17:10,578 - D:\git_workspace\sanoh\G01_0350\sql.py[line:24] - ERROR: mysql连接异常: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect database=self.database) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt "'cryptography' package is required for sha256_password or caching_sha2_password auth methods" RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Stack (most recent call last): File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 585, in run self.product_name_set() File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set paramresult = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True) 2021-10-24 00:17:15,999 - D:\git_workspace\sanoh\G01_0350\sql.py[line:24] - ERROR: mysql连接异常: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Traceback (most recent call last): File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect database=self.database) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__ self.connect() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect self._request_authentication() File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication auth_packet = _auth.caching_sha2_password_auth(self, auth_packet) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key) File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt "'cryptography' package is required for sha256_password or caching_sha2_password auth methods" RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods Stack (most recent call last): File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap self._bootstrap_inner() File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner self.run() File "D:\git_workspace\sanoh\G01_0350\output_file.py", line 227, in run self.get_product_data() File "D:\git_workspace\sanoh\G01_0350\output_file.py", line 67, in get_product_data results = self.sqlclient.sql_inquire_all(sqlstr) File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all self.connect() File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)