unsure how to fix this error message

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

unsure how to fix this error message

Post by ramzi »

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 »

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: 46
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi »

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 »

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 »

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: 46
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi »

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: 1609
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: unsure how to fix this error message

Post by jsalmon »

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: 46
Joined: Sun Jun 01, 2008 9:39 am

Re: unsure how to fix this error message

Post by ramzi »

the fix worked, thanks so much guys (girls)

ramzi :)
Post Reply