can't connect to mysql host after windows update

For users or potential users.
Post Reply
drtbar
Posts: 72
Joined: Wed Dec 26, 2007 6:43 pm
Location: Muskegon, MI

can't connect to mysql host after windows update

Post by drtbar » Wed May 16, 2018 5:37 am

Come in this morning and half of my clients cannot connect to the sql server on the server box. After a restart all but one was able to connect. The server updated last night and it seems 10% of the time when windows updates, it breaks something on my network.

The box that I still cannot get to connect can connect to the server via windows explorer with the path \\server, but opendental cannot connect for some reason. I've tried running as administrator and restarted 3 times.

Any suggestions?

drtbar
Posts: 72
Joined: Wed Dec 26, 2007 6:43 pm
Location: Muskegon, MI

Re: can't connect to mysql host after windows update

Post by drtbar » Wed May 16, 2018 7:19 am

I was able to get it going, but don't really have a definitive solution. With the help of James on chat support, I tried typing the ip of the server to get past connecting to the mysql server screen, then it hung on looking for a-z folder, which it would not accept the "ip\opendentimages" so I went back to the default "\\server" and it worked. No idea why it hung to begin with or why the same setting before all of a sudden worked. Just to let others know what worked for me. Hopefully it helps someone else.

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: can't connect to mysql host after windows update

Post by wjstarck » Wed May 16, 2018 10:40 am

Shouldn't it have been \\IP\opendentimages?
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: can't connect to mysql host after windows update

Post by Tom Zaccaria » Wed May 16, 2018 2:22 pm

I have had this problem from time to time after an update. Very frustrating.
I usually just Right click on the Start Menu, Select File Explorer, Navigate to our server which is the 'F' drive.

The server usually has a red 'X' over it which means the local machine is not connected to the server. I right click on the server, the red 'X' goes away and OD behaves as normal.
Hope this helps.
drtmz

psculldmd
Posts: 2
Joined: Mon May 21, 2018 10:00 am

Re: can't connect to mysql host after windows update

Post by psculldmd » Mon May 21, 2018 10:04 am

I am having this same problem but, nothing is working to reconnect to the MySQL server.
Anyone else have a solution?
Thanks

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: can't connect to mysql host after windows update

Post by jsalmon » Mon May 21, 2018 11:02 am

For whatever reason my MySQL service didn't automatically start after the most recent Windows Update and I had to manually go into my Services and start the MySQL service.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

psculldmd
Posts: 2
Joined: Mon May 21, 2018 10:00 am

Re: can't connect to mysql host after windows update

Post by psculldmd » Mon May 21, 2018 11:14 am

MySQL service is up and running, OD works fine on computers not updated. Only the 2 computers with the spring update can not connect.

Tabakdds
Posts: 4
Joined: Thu Mar 26, 2015 5:41 pm

Re: can't connect to mysql host after windows update

Post by Tabakdds » Tue May 22, 2018 7:21 pm

I have the same problem after windows update. Half of my client computers are working, half are not connecting, even though I can see all the files on the server. I tried everything from reinstalling client version, restarting the client PC, I ran compatibility to version 8, then after clicking ok several times the computer randomly connects. I wish I knew the sequence of what needs to done in order to fix it. If anyone knows definitive solution please post it. Thank you.

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: can't connect to mysql host after windows update

Post by rhaber123 » Sat May 26, 2018 10:34 am

Thiis is a network issue, not OD ISSUE.

Option 1
ON YOUR SERVER, find the ip address of the server,
and on your workstations, when you start OD and you enter the database location screen in OD, enter the ip address instead of entering the name of the server


Option 2, and for a permanent solution

ON YOUR ROUTER,
you can specify that your server will ALWAYS have the same IP address that you will assign to it.,
There are a lot of instructions on youtube that shows you how to assign an ip address to a computer on your router

AND ON YOUR WORKSTATIONS
go to C:\Windows\System32\drivers\etc\hosts , and in the "hosts" text file you can add the ip address of the server and its name.
This will allow window to know that your"server' has that specific IP address.
But to add it, you MUST edit the hosts file as an ADMINISTRATOR.it means right click on notepad, and open it as an administrator, and save it after.
Image
Last edited by rhaber123 on Tue Nov 24, 2020 3:49 pm, edited 3 times in total.

tomql
Posts: 2
Joined: Sat Nov 08, 2008 12:59 pm

Re: can't connect to mysql host after windows update

Post by tomql » Sat Jun 02, 2018 6:41 pm

I have the same problem. None of my client terminals is able to connect to MySQL hosts. I tried entering IP address to the server name and it is still not working. Does anyone have a suggestion?

Thanks.

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: can't connect to mysql host after windows update

Post by tgriswold » Mon Jun 04, 2018 12:03 pm

We've had a few different issues and solutions here on this forum so i'm going to try and point you in the right direction of where to troubleshoot if you're having an issue. As always, if you are still having issues you can contact support and we'll do our best to help you.

1.) No workstations are able to connect.
  • Check to make sure mysql is running on the server. If it isn't you may need to start it manually, or see if restarting the server machine fixes the issue.
  • Try connecting to the server using IP address rather than computer name. If this works and you want to use computer name, flushing DNS may work, or see rhaber123's post above to edit the hosts file to override it.
  • Check if you have connection issues between your workstation and the server. Can you browse to the server? Can you ping the server? This is likely a networking issue, contact your IT.
2.) Some workstations are able to connect but not others.
  • Try connecting to the server using IP address rather than computer name. If this works and you want to use computer name, flushing DNS may work, or see rhaber123's post above to edit the hosts file to override it.
  • Check if you have connection issues between your workstation and the server. Can you browse to the server? Can you ping the server? This is likely a networking issue, contact your IT.
3.) OD is able to connect to server but is hanging on startup looking for A-Z folder.
  • If you are using a network drive as the A-Z folder path, try using a full directory path instead (\\server\blah folder\ rather than \\NetworkDriveA\
Travis Griswold
Open Dental Software
http://www.opendental.com

erik
Posts: 6
Joined: Wed Apr 20, 2016 8:42 pm

Re: can't connect to mysql host after windows update

Post by erik » Mon Jun 04, 2018 11:28 pm

The recent Windows update triggered a bunch of problems at our office, too. It showed up after hours and seemed to have broken our whole network. Not fun. This was not an Open Dental issue, but as always, OD support was graciously helpful in resolving.

Ultimately, what worked for us was:
  • Modifying everything within Open Dental that pointed to our server and replacing it with the server IP address 192.168.XXX.XXX. This includes location of the database and the OpenDentImages folder.
  • Adding a single line of code at the end of our my.ini file, "skip-name-resolve" (without the quotes)
This has to be done on every workstation and this approach will break if your server IP isn't static. Doing something similar also fixed our issues with our digital imaging software, XDR.

Given the number of similar networking issues with many other programs (e.g. Sonos), my guess is that the problem stems from something related to Microsoft disabling SMB 1.0 with the latest update. But that's no more than a guess.

stjames70
Posts: 101
Joined: Fri Dec 18, 2009 3:24 am

Re: can't connect to mysql host after windows update

Post by stjames70 » Tue Jun 05, 2018 11:41 am

After the latest Feature update to Windows 10, version 1803, some of my workstations refused to connect to the server.

I called Open Dental support, and they solved it within a few minutes.

Instead of using all capital letters for the server name, we switched to all lower case and voila, it connected to the server.

Now, the behavior was inconsistent as some of the workstations did not develop the inability to connect to the server database.

So we only switched to lower case when we had a problem with a particular workstation, but that ended up working on the problematic workstations.

User avatar
Justin Shafer
Posts: 596
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Re: can't connect to mysql host after windows update

Post by Justin Shafer » Tue Jun 05, 2018 12:09 pm

I had an office with this issue.. the doc tried to fix it himself which to me just mucks up the waters.. I ended up just taking a freshly loaded computer and comparing the services startup type and programs and features (he installed SMB1)... not really sure what happened honestly... but so far it seems okay.....

??????

teethdood
Posts: 267
Joined: Sun Jul 29, 2007 12:39 am
Location: Visalia, CA
Contact:

Re: can't connect to mysql host after windows update

Post by teethdood » Wed Jun 06, 2018 1:18 pm

Windows messes up IPv6 support for certain ethernet/wifi cards. Try disabling IPv6 and using only IPv4.
Philip H. Doan, DDS
http://www.kaweahdental.com/

User avatar
Justin Shafer
Posts: 596
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Re: can't connect to mysql host after windows update

Post by Justin Shafer » Fri Jun 08, 2018 3:08 pm

I have found that on networks that don't have Server 2016 and a domain....

That this seems to help:

Setting these services to automatic instead of enabling SMB1...

DNS Client
Function Discovery Resource Publication
SSDP Discovery
UPnP Device Host

At least that fixes Network Discovery issues with 1803...

ejanson
Posts: 10
Joined: Tue Oct 23, 2007 12:54 pm

Re: can't connect to mysql host after windows update

Post by ejanson » Thu Jun 14, 2018 1:18 pm

I have the opposite solution to stjames70 above. I can access my server by now using all capitals to log in, instead of all lower case which I've always used in the past. Thanks for the clue, stjames70!

User avatar
dgraffeo
Posts: 147
Joined: Wed Sep 24, 2014 3:19 pm

Re: can't connect to mysql host after windows update

Post by dgraffeo » Fri Jun 15, 2018 10:05 am

Sometimes it really seems that there's some shadowy figure sitting behind a desk at Microsoft laughing maniacally while he flips random switches. These switches control various aspects of how Windows works.
"To understand what recursion is, you must first understand recursion."

David Graffeo
Open Dental Software
http://www.opendental.com

pid_user
Posts: 67
Joined: Thu Jun 04, 2015 9:31 am

Re: can't connect to mysql host after windows update

Post by pid_user » Sun Jul 22, 2018 9:10 pm

stjames70 wrote: Instead of using all capital letters for the server name, we switched to all lower case and voila, it connected to the server.
thanks for sharing. It helped me too.

drtbar
Posts: 72
Joined: Wed Dec 26, 2007 6:43 pm
Location: Muskegon, MI

Re: can't connect to mysql host after windows update

Post by drtbar » Fri Sep 14, 2018 5:30 am

Any other updates? The most recent issue I've been having is I can connect to the server first thing in the morning, and then after a few minutes, I get the error "lost connection to mysql server." Then I'm forced to exit the program and restart the program and it connects fine. Is it time to move to a true server OS?

Post Reply