Advertisement:

Author Topic: Windows Server Update KB4493473 broke my forum  (Read 919 times)

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Windows Server Update KB4493473 broke my forum
« on: May 06, 2019, 09:04:09 AM »
Did the update this morning and re-booted and then got the "unable to connect to database..." message. 

NOT a SMF problem :-)

Problem was because MySQL would not start.    Even MySql Workbench couldn't connect.... it told me that Mysql server was not running.

I don't know a lot about servers, but searching the internet, I still could not find out how to make it start.

I could not figure it out, so I uninstalled the update, re-booted, and everything is fine now.

The problem update is:
Quote
2019-04 Cumulative Update for Windows Server 2016 for x64-based Systems (KB4493473)

I am now back at
Quote
2019-04 Cumulative Update for Windows Server 2016 for x64-based Systems (KB4493470)
which is was 'successfully installed' April 13. 

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Windows Server Update KB4493473 broke my forum
« Reply #1 on: May 06, 2019, 09:15:03 AM »
Check the MySQL log for more details about why it couldn't start up.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Re: Windows Server Update KB4493473 broke my forum
« Reply #2 on: May 06, 2019, 09:46:26 AM »
Quote
Check the MySQL log

Excellent suggestion.

I am hunting for it.  Do you know where I might find it?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Windows Server Update KB4493473 broke my forum
« Reply #3 on: May 06, 2019, 09:50:42 AM »
Where did you install it?
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Re: Windows Server Update KB4493473 broke my forum
« Reply #4 on: May 06, 2019, 10:18:32 AM »
Default location:  c:\Program Files\MySQL

You are asking about a   MySQL log, correct?

I just searched all of C:\  for *.log   I see many with today's date.   But none have a filename that seems to be what I am looking for.

I did find logs for Mysql Workbench.

Quote
C:\Users\myusername\AppData\Roaming\MySQL\Workbench\log

 These are very short and contain this several times each
Quote
Error 2003 connecting to server, assuming server is down and opening editor with no connection
07:41:23

This is found in ...  \MySQL\Workbench\log\sql_actions_Local_instance_MYSQL80.log
Quote
[1, 07:43:16] Could not connect, server may not be running.: Can't connect to MySQL server on 'localhost' (10061)

And I do realize this problem has nothing to do with SMF, so I super-extra appreciate the help.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Windows Server Update KB4493473 broke my forum
« Reply #5 on: May 06, 2019, 10:22:37 AM »
I was indeed asking about the MySQL log, and I'm really concerned that you don't seem to actually have one configured.

OK so next question, are the logs even configured? This involves looking in the MySQL configuration file, which might or might not be where you think it is - it might be in C:\Program Files\MySQL but it can end up in the Windows folders. It's *usually* called my.cnf but can also be called my.ini.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Re: Windows Server Update KB4493473 broke my forum
« Reply #6 on: May 06, 2019, 10:30:23 AM »
I will check after breakfast.

But this adventure reminds me that although I do not know squat about databases, I did find this funny many many years ago.....

School principal called a parent...   Did you really name your son Robert’); DROP TABLE ‘Students’; –?

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Re: Windows Server Update KB4493473 broke my forum
« Reply #7 on: May 06, 2019, 10:54:13 AM »
This is a screengrab from Mysql workbench.   I don't think we'll learn anything from this.

Today's stuff highlighted in blue.  We see a normal shutdown this morning for the server re-boot  at 11:15:35.

Then nothing for more than an hour until the microsoft update was uninstalled and system rebooted again.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,216
    • StoryBB/StoryBB on GitHub
Re: Windows Server Update KB4493473 broke my forum
« Reply #8 on: May 06, 2019, 11:03:39 AM »
Then I don't know what to suggest... for some reason there's still a lack of logs going on, since on a normal MySQL startup there should be more messages than that... but without logs it's impossible to say why it didn't start up correctly.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline AlanDewey

  • Semi-Newbie
  • *
  • Posts: 38
    • CCS Forum
Re: Windows Server Update KB4493473 broke my forum
« Reply #9 on: May 06, 2019, 11:10:25 AM »
I am going to forget about it for now.   microsoft will probably update their update to fix their fix in a week or so.

I have to go back to living by the rule to never install an update less than two weeks old.

Thanks for the help.