Home Explore Help
Register Sign In
sanoh
/
G01_0350
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 92685d12e3
Branches Tags
G01_0350
/
log
/
error.log.2021-12-09

error.log.2021-12-09 6.1 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 
  1. 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
    2. 

  2. Traceback (most recent call last):
    3. 

  3.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect
    4. 

  4.     database=self.database)
    5. 

  5.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
    6. 

  6.     self.connect()
    7. 

  7.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
    8. 

  8.     self._request_authentication()
    9. 

  9.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
    10. 

  10.     auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
    11. 

  11.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth
    12. 

  12.     data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key)
    13. 

  13.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt
    14. 

  14.     "'cryptography' package is required for sha256_password or caching_sha2_password auth methods"
    15. 

  15. RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
    16. 

  16. Stack (most recent call last):
    17. 

  17.   File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    18. 

  18.     self._bootstrap_inner()
    19. 

  19.   File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    20. 

  20.     self.run()
    21. 

  21.   File "D:\git_workspace\sanoh\G01_0350\pro.py", line 585, in run
    22. 

  22.     self.product_name_set()
    23. 

  23.   File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set
    24. 

  24.     paramresult = self.sqlclient.sql_inquire_all(sqlstr)
    25. 

  25.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all
    26. 

  26.     self.connect()
    27. 

  27.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect
    28. 

  28.     self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)
    29. 

  29. 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
    30. 

  30. Traceback (most recent call last):
    31. 

  31.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect
    32. 

  32.     database=self.database)
    33. 

  33.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
    34. 

  34.     self.connect()
    35. 

  35.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
    36. 

  36.     self._request_authentication()
    37. 

  37.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
    38. 

  38.     auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
    39. 

  39.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth
    40. 

  40.     data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key)
    41. 

  41.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt
    42. 

  42.     "'cryptography' package is required for sha256_password or caching_sha2_password auth methods"
    43. 

  43. RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
    44. 

  44. Stack (most recent call last):
    45. 

  45.   File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    46. 

  46.     self._bootstrap_inner()
    47. 

  47.   File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    48. 

  48.     self.run()
    49. 

  49.   File "D:\git_workspace\sanoh\G01_0350\pro.py", line 585, in run
    50. 

  50.     self.product_name_set()
    51. 

  51.   File "D:\git_workspace\sanoh\G01_0350\pro.py", line 503, in product_name_set
    52. 

  52.     paramresult = self.sqlclient.sql_inquire_all(sqlstr)
    53. 

  53.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all
    54. 

  54.     self.connect()
    55. 

  55.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect
    56. 

  56.     self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)
    57. 

  57. 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
    58. 

  58. Traceback (most recent call last):
    59. 

  59.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 21, in connect
    60. 

  60.     database=self.database)
    61. 

  61.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 353, in __init__
    62. 

  62.     self.connect()
    63. 

  63.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 633, in connect
    64. 

  64.     self._request_authentication()
    65. 

  65.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\connections.py", line 932, in _request_authentication
    66. 

  66.     auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
    67. 

  67.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 265, in caching_sha2_password_auth
    68. 

  68.     data = sha2_rsa_encrypt(conn.password, conn.salt, conn.server_public_key)
    69. 

  69.   File "D:\git_workspace\sanoh\G01_0350\venv_win32\lib\site-packages\pymysql\_auth.py", line 144, in sha2_rsa_encrypt
    70. 

  70.     "'cryptography' package is required for sha256_password or caching_sha2_password auth methods"
    71. 

  71. RuntimeError: 'cryptography' package is required for sha256_password or caching_sha2_password auth methods
    72. 

  72. Stack (most recent call last):
    73. 

  73.   File "D:\Python\Python36-32\lib\threading.py", line 884, in _bootstrap
    74. 

  74.     self._bootstrap_inner()
    75. 

  75.   File "D:\Python\Python36-32\lib\threading.py", line 916, in _bootstrap_inner
    76. 

  76.     self.run()
    77. 

  77.   File "D:\git_workspace\sanoh\G01_0350\output_file.py", line 227, in run
    78. 

  78.     self.get_product_data()
    79. 

  79.   File "D:\git_workspace\sanoh\G01_0350\output_file.py", line 67, in get_product_data
    80. 

  80.     results = self.sqlclient.sql_inquire_all(sqlstr)
    81. 

  81.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 68, in sql_inquire_all
    82. 

  82.     self.connect()
    83. 

  83.   File "D:\git_workspace\sanoh\G01_0350\sql.py", line 24, in connect
    84. 

  84.     self.log_file.logger.error('mysql连接异常: {0}'.format(e), exc_info=True, stack_info=True)
    85.