!!! Warning !!! DO THIS BEFORE YOU UPGRADE TO 14.0.3
DonFerguson
Posts: 202 Silver 5
I just upgraded from 14.0.2 to 14.0.3 and none of my webserver hosts would stay up.
Fortunately, I was able to find the issue in the log found in the path C:\ProgramData\Red Gate\Logs\Redgate Monitor\
Here is the significant portion of the issue in the log.
Fortunately, I was able to find the issue in the log found in the path C:\ProgramData\Red Gate\Logs\Redgate Monitor\
Here is the significant portion of the issue in the log.
2024-05-14 21:50:40,091 [ 8] ERROR Microsoft.Extensions.Hosting.Internal.Host - Hosting failed to start
System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\ProgramData\Red Gate\SQL Monitor\MyCertFile.pfx'
The reason for this failure is because Redgate renamed the SQL Monitor folder as documented in the release notes.
https://documentation.red-gate.com/monitor14/redgate-monitor-14-0-release-notes-240977444.html
The fix: Edit and update C:\ProgramData\Red Gate\Redgate Monitor\Webserver.Kestrel.config, Replace references of SQL Monitor with Redgate Monitor to reflect the correct path.
Do this before you upgrade.
Hopefully this post will help others avoid the surprise failure I had to troubleshoot.
The reason for this failure is because Redgate renamed the SQL Monitor folder as documented in the release notes.
https://documentation.red-gate.com/monitor14/redgate-monitor-14-0-release-notes-240977444.html
Changes
- Rename the redundant folder of "SQL Monitor" from the ProgramData folder left after upgrade from v. 13 to avoid future confusion.
The fix: Edit and update C:\ProgramData\Red Gate\Redgate Monitor\Webserver.Kestrel.config, Replace references of SQL Monitor with Redgate Monitor to reflect the correct path.
Do this before you upgrade.
Hopefully this post will help others avoid the surprise failure I had to troubleshoot.
Tagged:
Answers
Thank you for pointing that out! I will work to get the v14 migration guide updated (as it will impact any users updating from v13 to 14.0.3 using https with the Kestrel webservice and storing the cert in that folder, and also see about a note added to the release notes as well.
Kind regards,
Alex
Have you visited our Help Center?
I have added a note to the bottom of the "Configuration files and query search data location" section of the Migration guide to version 14 documentation indicating the rename of the previous SQL Monitor folder from version 14.0.3 onwards and its particular impact on configuration files that were manually updated with that path (e.g. when enabling https).
Kind regards,
Alex
Have you visited our Help Center?