G01_0350/log/error.log.2021-12-09

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)