Bug #97389 Cannot open mysqlrouter.log on Windows

• Submitted: 28 Oct 2019 3:19
• Modified: 26 Feb 2020 21:27
• Reporter: Yoseph Phillips
• Status: Closed
• Category: MySQL Router
• Severity: S3 (Non-critical)
• Version: 8.0.18
• OS: Windows
• CPU Architecture: Any

[28 Oct 2019 3:19] Yoseph Phillips

Description:
Cannot open mysqlrouter.log on Windows.

All attempts to open mysqlrouter.log result in permission denied issues, and even an administrator cannot change the security permissions to gain access.

As a workaround we have completely deleted this file and recreated it manually granting all permissions to everyone.

How to repeat:
Install mysqlrouter using bootstrap, directory, conf-bind-address.
Then run mysqlrouter with install-service and config to create the windows service.
Then start the windows service which creates this file.
Then attempt to open the file.

[28 Oct 2019 3:21] Yoseph Phillips

Added version 8.0.18.

[28 Oct 2019 6:23] MySQL Verification Team

Hello Yoseph Phillips,

Thank you for the report and feedback.

regards,
Umesh

[26 Feb 2020 21:27] Philip Olson

Posted by developer:
 
Fixed as of the MySQL Router 8.0.19 release, and here's the proposed changelog entry from the documentation team:

On Windows, when the Windows service created the Router log file (which
happens when running router as a service after bootstrap), the log file
became unreadable (inaccessible) by anyone else; including the local
administrator. The workaround was to manually delete and recreate the log
file after installation.

Thank you for the bug report.