Bug #111267 Server Status failed
Submitted: 4 Jun 2023 9:34 Modified: 5 Jun 2023 5:59
Reporter: Miklós Csuvár Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.33 OS:Windows (10 Home Englosh)
Assigned to: CPU Architecture:x86 (AMD Ryzen 7 5700G with Radeon Graphics 3.80 GHz)
Tags: Administration, chcp, management access, server status, WbAdmin.openAdminSection

[4 Jun 2023 9:34] Miklós Csuvár
Description:
This is a re-report of bug #111130 with significant new data (wb.log, attached in next comment as I could not identify any file attach opportunity during report writing.).

The problem is the same. After the root logged into MySQL and want to check server status (UI -> Server -> Server status) there are two error messages.
The error messages are always the same:
Error 1:
"Could not acquire management access for administation
RuntimeError: Unable to execute command chcp.
Please make sure that the C:\Windows\System32 directory is in your PATH environment variable."

Error 2:
"Error during ""
error calling Python module function WbAdmin.openAdminSection"

Details:
PATH
"C:\Windows\System32" is in the System environment variables and in PATH of User1 (administrator) as well.

The system
Edition	Windows 10 Home
Version	22H2
Installed on	‎2022. ‎05. ‎30.
OS build	19045.2965
Experience	Windows Feature Experience Pack 1000.19041.1000.0

How to repeat:
Starting MySQL Workbench 8.0 CE. Root logs in, then UI -> Server -> Server status.

Suggested fix:
Suggested fixies were tried and failed.
#111130 was classified as Duplicate. Therefore I went to bug #103339, that referred to #102300.

#102300 suggested several fix methods. On the base of them I performed 2 tests. Both of them resulted in the problem reported above.

Test1
chcp:
   65001
System language:
   English
      Beta - Use Unicode UTF-8: Yes
C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\os_utils.py
@@ -353,7 +353,9 @@:
   process = subprocess.Popen(command, stdin = subprocess.PIPE, encoding="utf-8", stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)
C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\os_utils.py
@@ -315,7 +315,9 @@:
   f = open(path, 'r', encoding='utf-8')
C:/Program Files/MySQL/MySQL Workbench 8.0/modules/wb_admin_config_file_be.py
@@ -1147,7 +1147,7 @@:
   outf = open(self.temp_file_name, "w", encoding='utf-8')
C:/Program Files/MySQL/MySQL Workbench 8.0/modules/wb_admin_config_file_be.py
@@ -1170,7 +1170,7 @@:
   outf = open(self.temp_file_name, "r", encoding='utf-8')

Test2
chcp:
   437
System language:
   English
      Beta - Use Unicode UTF-8: No
C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\os_utils.py
@@ -353,7 +353,9 @@:
   process = subprocess.Popen(command, stdin = subprocess.PIPE, text=True, stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)
C:\Program Files\MySQL\MySQL Workbench 8.0\workbench\os_utils.py
@@ -315,7 +315,9 @@:
   f = open(path, 'r')
C:/Program Files/MySQL/MySQL Workbench 8.0/modules/wb_admin_config_file_be.py
@@ -1147,7 +1147,7 @@:
   outf = open(self.temp_file_name, "w")
C:/Program Files/MySQL/MySQL Workbench 8.0/modules/wb_admin_config_file_be.py
@@ -1170,7 +1170,7 @@:
   outf = open(self.temp_file_name, "r")
[4 Jun 2023 9:37] Miklós Csuvár
chcp is not founf and other errors

Attachment: wb.log (application/octet-stream, text), 10.53 KiB.

[5 Jun 2023 5:59] MySQL Verification Team
Hello Miklós,

Thank you for the report and feedback.
An existing bug report Bug #102300 already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

regards,
Umesh