maximum connections

For users or potential users.

maximum connections

Postby Tom Zaccaria » Wed Oct 25, 2017 4:16 am

Having an issue connecting to mysql that network guys can't seem to fix.

Getting an error message 'unable to connect to mysql, maximum connections reached'.
We are running windows server 2012, mysql 5.5, OD 17.2.13 with a combination of 20 desktops, laptops and notebooks, some wireless, some hard wired. It works fine for 19 connections but not with 20. IT guys say that the connections are not being released when someone logs off as it should. We tried increasing the number of connected files to 150 or more but that doesn't help. The only way to get all 20 computers connected is to stop the mysql service and restart it again. This is a pain bc I am the only one that know how to do that. Plus stopping and starting should'n be necessary.

Any thoughts or help would be appreciated.

drtmz
Tom Zaccaria
 
Posts: 215
Joined: Mon Feb 25, 2008 4:09 am

Re: maximum connections

Postby cmcgehee » Wed Oct 25, 2017 7:41 am

You should be able to fix this by increasing the max_connections variable on the server. Be sure to put it in the .ini file so it sticks when restarting the MySQL service. If someone logs out of Open Dental but keeps the program open, the database connection will be retained. To end the database connection, it is necessary to close the program completely.
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 252
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: maximum connections

Postby stjames70 » Wed Oct 25, 2017 9:22 am

We switched to Windows Server 2012 so that we could prevent that error from ever showing up. We have at 20+ connections all the time without running into that particular error you speak of.

Seriously, this problem you are having should never have surfaced -- it only happens in the Windows world and it is annoying and time consuming when it happens.

Have you given any thought to releasing a Mac version? We run OD under virtualization right now without any issues, but from personal experience, we have a lot less issues with connectivity with OSX systems. I am certain you would get a lot less service calls which waste your time if you had a Mac platform.

Just my two cents....
stjames70
 
Posts: 92
Joined: Fri Dec 18, 2009 4:24 am

Re: maximum connections

Postby cmcgehee » Wed Oct 25, 2017 9:41 am

This particular error is coming from MySQL so it is independent of the operating system. We have not looked seriously at programming a Mac version of Open Dental because there has been little interest from our customers. To avoid the issue of reaching the maximum number of connections for Windows file share, you have the option of using Linux for your server.
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 252
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: maximum connections

Postby stjames70 » Thu Oct 26, 2017 1:04 pm

Although there is little interest for it from your current customers, I think there would be a lot of interest for OSX based dental offices who use OSX based practice management software.

I guess you will just never find out.
stjames70
 
Posts: 92
Joined: Fri Dec 18, 2009 4:24 am

Re: maximum connections

Postby Tom Zaccaria » Fri Oct 27, 2017 2:39 am

The .ini trick seemed to work for now.
Thanks
drtmz
Tom Zaccaria
 
Posts: 215
Joined: Mon Feb 25, 2008 4:09 am

Re: maximum connections

Postby mmd » Sat Nov 11, 2017 5:13 pm

Open Dental has been recommended to us by a friend who has run 13 offices on it and loves it. We are on Macs now (Macpractice) after transition from Dentrix 3 years ago. Really hate reporting, accounting, and marketing in Macpractice. Clinical is fair. We left Dentrix due to our system being too unstable with 20+ computers. Stability is great with Macs. It's just that we hate Macpractice. So- just voicing our wish that Open Dental was available for Macs, without running the parallels. I bet there are more people out there who would like this too?
mmd
 
Posts: 1
Joined: Sat Nov 11, 2017 5:06 pm

Re: maximum connections

Postby wjstarck » Sun Nov 12, 2017 11:19 am

mmd wrote:Open Dental has been recommended to us by a friend who has run 13 offices on it and loves it. We are on Macs now (Macpractice) after transition from Dentrix 3 years ago. Really hate reporting, accounting, and marketing in Macpractice. Clinical is fair. We left Dentrix due to our system being too unstable with 20+ computers. Stability is great with Macs. It's just that we hate Macpractice. So- just voicing our wish that Open Dental was available for Macs, without running the parallels. I bet there are more people out there who would like this too?


Why don't you just run OD in VMWare Fusion (free) on the Macs?
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
TX, USA
User avatar
wjstarck
 
Posts: 705
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX

Re: maximum connections

Postby cmcgehee » Mon Nov 13, 2017 8:26 am

Another option for running OD on Macs is by using Remote Apps.
http://opendentalsoft.com/forum/viewtopic.php?f=1&t=6679
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 252
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon


Return to Main Forum

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 5 guests