Avoiding server conflicts

For complex topics that regular users would not be interested in. For power users and database administrators.

Avoiding server conflicts

Postby JLM » Thu Jan 03, 2019 11:26 am

I run our office servers in a virtual machine. I also develop software for my office and don't want to code against the production server so I work with a copy of the virtual machine.
The two servers are never on the same subnet at the same time. For example, I am coding at home right now and have the server up and running at home and the identical server running at the office.

Are there any issues regarding OD that I should be aware of when doing this? As a precaution, I have made OpenDentalEConnector and OpenDentalService services manual rather than automatic start on the development machine.
The only eservice I am using currently is the texting for appointment reminders.

Thanks

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby Arna » Thu Jan 03, 2019 1:30 pm

Are you using the "same" database for both environments?
I try to use unique registration keys for production vs. development environments.
Entropy isn't what it used to be...

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

Re: Avoiding server conflicts

Postby JLM » Thu Jan 03, 2019 1:41 pm

Yes. It is an exact copy of the production database, albeit out of date by days or weeks. Does OD issue registration keys for developer use?

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby cmcgehee » Thu Jan 03, 2019 4:26 pm

Yes, we do issue developer registration keys. Throw an email over to vendor.relations@opendental.com and include your name, the name of our company, and what type of software you're creating. However, developer registration keys are not meant to be used with live patient data. Once you get a developer key, I would recommend creating a database that only contains test data and doing your development against that database.
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 604
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Avoiding server conflicts

Postby JLM » Fri Jan 04, 2019 7:27 pm

cmcgehee wrote:Yes, we do issue developer registration keys. Throw an email over to vendor.relations@opendental.com and include your name, the name of our company, and what type of software you're creating. However, developer registration keys are not meant to be used with live patient data. Once you get a developer key, I would recommend creating a database that only contains test data and doing your development against that database.


I would never be developing against the live DB at the office. I would be developing against a copy of it that is slightly out of date(hours -> days). My main concern is that, while the server vm is up on my development computer, I don't want it sending out appointment reminders based on obsolete data. ie 'you have an appointment tomorrow' when they cancelled that appointment yesterday.

That's why I was asking if simply disabling the opendental services would keep that from happening. Maybe I should disable internet access for the development vm as well?

Thanks for your help

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby JLM » Sun Jan 06, 2019 7:46 pm

Or maybe just firewall opendental on the development vm from accessing the internet?

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby cmcgehee » Mon Jan 07, 2019 9:05 am

Our recommendation is to use a database that has 0 real patient data present. If you do decide to develop against a copy of your live data, I would say to do it on a VM that has no internet access, and to never run the Open Dental Service or the eConnector against that database.
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 604
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Avoiding server conflicts

Postby JLM » Mon Jan 07, 2019 9:18 am

OK, thanks.
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby JLM » Mon Jan 07, 2019 9:33 am

Sorry to keep bugging you about this.
Can I simply uninstall OpenDental from my copy of the server but leave mysql running and serving the opendental DB? ie. Does opendental itself have to be installed on the server for the workstations to operate?

Thanks

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby jsalmon » Mon Jan 07, 2019 10:08 am

JLM wrote:Can I simply uninstall OpenDental from my copy of the server but leave mysql running and serving the opendental DB? ie. Does opendental itself have to be installed on the server for the workstations to operate?

Open Dental is not required to be installed for MySQL to run / serve the database (lots of our users have a Linux operating system hosting their database which cannot run Open Dental "natively").
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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

Re: Avoiding server conflicts

Postby JLM » Tue Jan 08, 2019 10:43 am

Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level.

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby jsalmon » Tue Jan 08, 2019 11:04 am

JLM wrote:Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level.

JLM

That's because the installer doesn't install the services.
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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm

Re: Avoiding server conflicts

Postby JLM » Sat Jan 12, 2019 7:53 pm

jsalmon wrote:
JLM wrote:Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level.

JLM

That's because the installer doesn't install the services.


More of a head's up to let you know your uninstall process doesn't remove running services that interact with the internet on computers that store PHI.

JLM
JLM
 
Posts: 118
Joined: Wed Dec 05, 2012 1:52 pm

Re: Avoiding server conflicts

Postby jsalmon » Sun Jan 13, 2019 8:14 am

JLM wrote:
jsalmon wrote:
JLM wrote:Uninstalling OD does not remove the services it installs. I have no idea if they phone home once OD is uninstalled. As a precaution, I have blocked internet access for the VM at the router level.

JLM

That's because the installer doesn't install the services.


More of a head's up to let you know your uninstall process doesn't remove running services that interact with the internet on computers that store PHI.

JLM

I'm surprised that we don't even have an uninstall process documented in the first place. I'll get the documentation team on that.
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
User avatar
jsalmon
 
Posts: 1486
Joined: Tue Nov 30, 2010 1:33 pm


Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 4 guests