unsure how to fix this error message

For users or potential users.
Post Reply
ramzi
Posts: 39
Joined: Sun Jun 01, 2008 9:39 am

unsure how to fix this error message

Post by ramzi » Sat Nov 26, 2016 7:03 am

OD is not opening up on one of my work stations can someone please help me figure out this error message and how to fix?,see below for the error message, im not sure how to post a screen shot onto this forum, thanks any help is appreciated.


Host 'FOUAD-DIM' is blocked because of too many connection errors; unblock with 'mysqladmin flush-hosts'

User avatar
Arna
Posts: 444
Joined: Tue Jul 09, 2013 3:16 pm

Re: unsure how to fix this error message

Post by Arna » Mon Nov 28, 2016 6:01 am

If you can access Open Dental on another machine, go to Reports > User Query.
Type in

Code: Select all

flush hosts
and click 'OK"
Try reopening the workstation
Entropy isn't what it used to be...

Arna Meyer

ramzi
Posts: 39
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi » Wed Nov 30, 2016 6:53 am

ok sorry I tried that with no luck

I may be doing something wrong, do I type all that into the box that says "query" above the "title box"?

should it look like this in the box?

CODE: SELECT ALL
flush hosts


then hit "submit query"?

im using version 13.1.42.0


thanks for your help

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: unsure how to fix this error message

Post by cmcgehee » Wed Nov 30, 2016 8:22 am

That is the correct place to be running a query. If the FLUSH HOSTS command did not work try increasing the maximum number of connection errors using this command:

SET GLOBAL max_connect_errors=1000;

Note that this will only be in effect until you restart your MySQL service. To make this setting permanent, add this line to your my.ini file:

max_connect_errors=1000
Chris McGehee
Open Dental Software
http://www.opendental.com

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

Re: unsure how to fix this error message

Post by dgraffeo » Wed Nov 30, 2016 9:33 am

FLUSH HOSTS should be the only thing in the box. If you give us a call mentioning this forum thread we can probably get it sorted for you
"To understand what recursion is, you must first understand recursion."

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

ramzi
Posts: 39
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi » Wed Nov 30, 2016 9:40 am

i dont pay for support any more...so i dont feel right wasting supports time


is it possible to pay for support to fix this issue? by logging into the computer

if not I understand it was my decision not to pay support so ill have to figure it out


thanks

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

Re: unsure how to fix this error message

Post by jsalmon » Wed Nov 30, 2016 10:07 am

We do have Incident Support
If you are no longer on a support contract, we sometimes provide support for an isolated incident.
http://www.opendental.com/manual/fees.html
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

ramzi
Posts: 39
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi » Thu Dec 01, 2016 9:35 am

the fix worked, thanks so much guys (girls)

ramzi :)

Post Reply