Bug #105226 RuntimeError: Target host is configured as Windows STILL present as of 8.0.26
Submitted: 14 Oct 2021 10:43 Modified: 14 Oct 2021 16:12
Reporter: aaaaa aaaaa Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.26 OS:Windows
Assigned to: CPU Architecture:Any

[14 Oct 2021 10:43] aaaaa aaaaa
Description:
"RuntimeError: Target host is configured as Windows, but seems to be a different OS. Please review the connection settings." error when clicking on Server Status (and various other misc errors once you close the Configuration menu that appears afterwards, unfortunately I don't remember them and I can't afford to change the version again just for betatesting. Already lost a full morning because of that).

I'm stuck with version 8.0.22 due to that bug.

I've got it in both a brand new Windows installation whenere I directly installed both 8.0.26 and 8.0.23, and on one which I upgraded MySQL since 8.0.18 and it's now on 8.0.23 (which I'll have to downgrade to 8.0.22, if only for stability's sake).

And NO, repairing doesn't solve it. It's an installer/Workbench issue, because in 8.0.22 it doesn't appear at all.

How to repeat:
Install 8.0.23 or subsequent versions on a brand new formatted Windows install. Configure it with normal, basic settings. Click "Server Status". It should appear.

Suggested fix:
You know the version where it broke: 8.0.23. Other reports about the same bug have also said the same. Compare what's wrong between both versions and find the fix.
[14 Oct 2021 12:39] MySQL Verification Team
Hello,

Thank you for the bug report.
To investigate further this issue at our end, may I kindly request you to launch workbench under debug mode (-log-level=debug3) and provide unaltered workbench log file(more details about log are explained here - https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html)
Also, which language system is set to?

Regards,
Ashwini Patil
[14 Oct 2021 15:16] aaaaaa aaaaaa
Error log

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

[14 Oct 2021 15:17] aaaaaa aaaaaa
Error 1

Attachment: 1.png (image/png, text), 557.28 KiB.

[14 Oct 2021 15:17] aaaaaa aaaaaa
Error 2

Attachment: 2.png (image/png, text), 518.96 KiB.

[14 Oct 2021 15:19] aaaaaa aaaaaa
I lost my previous account login details, sorry. I've attached the log and pics of the bugs. Also, I'm on Windows 10 btw, fully updated as of today.
[14 Oct 2021 15:20] aaaaaa aaaaaa
System language: Spanish.
[14 Oct 2021 16:12] MySQL Verification Team
Thank you for the feedback. According wb.log attached:

OSVersion: Microsoft Windows NT 6.2.9200.0

Which is Windows 8.

https://www.mysql.com/support/supportedplatforms/workbench.html
[14 Oct 2021 17:53] aaaaaa aaaaaa
I REPEAT, I'm on Windows 10, with all of it's patches installed.

If it detects it as Windows NT, that's another problem to add to your list.
[30 Jul 2022 23:56] Lihui Yang
Hello,
My version is 8.0.29 and the problem remains.
Pls find att my logfile for reference.

Thanks and rgrds.
[30 Jul 2022 23:57] Lihui Yang
logfile

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

[31 Jul 2022 0:21] Lihui Yang
Hello,

By comparing the logfiles of mine and aaaaa's, I found something which might help.
Both logs show the OS version and related info are set to:
        OSVersion: Microsoft Windows NT 6.2.9200.0
	UserInteractive: True
	Version: 4.0.30319.42000
I said the items are 'set to' because it's impossible for us two to get exactly the same version of OS. The 2 version ids are probably default values which overwrite those configured on installation, which happens under certain conditions. For me it may be the OS update during this morning (Beijing Time), after which I started MySQL which worked normally yesterday.

Hope you check it and consider whether it matters.
If I guess right, you may locate the version overwrite mechanic and fix it, maybe adding a solidate OSVersion detecting step and take its results as the true version ids, alter the configures automatically or with user's option.

Thanks and regards.
[31 Jul 2022 1:38] Lihui Yang
Hey guys,

Glad to share that I've temporarily solved the problem.

I just started the installer and reconfigured the MySQL Server, without applying any special modifications. After the installer finished its job, I sucessfully loged in without receiving any error reports.

The process still confirms to my guess - you have to refresh the configurations related to the judgement of OSVersion. To solve the problem permanently, you may check and modify related mechanics to fully consider and deal with OS updates.

Thanks and best regards.