maximum connections

[Tom Zaccaria]

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

[cmcgehee]

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.

[stjames70]

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....

[cmcgehee]

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.

[stjames70]

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.

[Tom Zaccaria]

The .ini trick seemed to work for now.
Thanks
drtmz

[mmd]

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?

[wjstarck]

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?

[cmcgehee]

Another option for running OD on Macs is by using Remote Apps.
viewtopic.php?f=1&t=6679