Researching OpenDental Software
-
This piqued my interest enough to go looking for a EULA.
MySQL is not allowed any external connections according to the EULA. None.
-
@EddieJennings said in Researching OpenDental Software:
This piqued my interest enough to go looking for a EULA.
MySQL is not allowed any external connections according to the EULA. None.
Yeah, I didn't know that about MySQL either.. seems odd, from this person who's never used it directly before.
-
@Dashrender said in Researching OpenDental Software:
@EddieJennings said in Researching OpenDental Software:
This piqued my interest enough to go looking for a EULA.
MySQL is not allowed any external connections according to the EULA. None.
Yeah, I didn't know that about MySQL either.. seems odd, from this person who's never used it directly before.
This was the first thing I found: https://downloads.mysql.com/docs/licenses/mysqld-8.0-com-en.pdf
-
You are out of context.
@scottalanmiller is stating MySQL on Windows has that restriction. -
@JaredBusch said in Researching OpenDental Software:
You are out of context.
@scottalanmiller is stating MySQL on Windows has that restriction.I see. I made the mistake of interpreting "the EULA" as "its EULA."
-
Doing a demo install of it so that we can learn about it. Apparently Patterson EagleSoft doesn't believe that their own product is production ready (no current Windows support, no VM support... basically unsupported and abandoned according to their own people, not even attempting to be a production system in a modern sense) so the number of viable vendors in the dental space are few and far between. We support a bit of everything in the dentistry space, and what people get is pretty unprofessional at best, most of the time.
-
@scottalanmiller said in Researching OpenDental Software:
Doing a demo install of it so that we can learn about it. Apparently Patterson EagleSoft doesn't believe that their own product is production ready (no current Windows support, no VM support... basically unsupported and abandoned according to their own people, not even attempting to be a production system in a modern sense) so the number of viable vendors in the dental space are few and far between. We support a bit of everything in the dentistry space, and what people get is pretty unprofessional at best, most of the time.
Seriously, does any software vendor just not suck? So many have turned out to be just junk recently.
-
https://www.opendental.com/site/sourcecode.html
Tortoise SVN.............
You have to install the trial version to get the initial database tables set up? What is this?
-
@stacksofplates said in Researching OpenDental Software:
https://www.opendental.com/site/sourcecode.html
Tortoise SVN.............
You have to install the trial version to get the initial database tables set up? What is this?
Everything on their site is crazy.
-
I'm honestly surprised it's not built with FoxPro.
-
@stacksofplates said in Researching OpenDental Software:
I'm honestly surprised it's not built with FoxPro.
It sure feels like it is!!
-
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
-
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
-
@scottalanmiller said in Researching OpenDental Software:
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
I've seen the prices they are paying, I don't think it would be hard to build a cheaper mouse trap too.
-
@flaxking said in Researching OpenDental Software:
@scottalanmiller said in Researching OpenDental Software:
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
I've seen the prices they are paying, I don't think it would be hard to build a cheaper mouse trap too.
Oh I know, but even cheaper often doesn't matter. There is a pain to switching, and that alone is more than many will contemplate, regardless of potential profits.
-
PHI complicates things ALOT, too.
-
@scottalanmiller said in Researching OpenDental Software:
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
This is so true. It's not simply buying the new software, it's moving the old data over, or the customer now having to deal with two systems, for god knows how long... it's generally pretty damned expensive to change systems...
-
@Dashrender said in Researching OpenDental Software:
@scottalanmiller said in Researching OpenDental Software:
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
This is so true. It's not simply buying the new software, it's moving the old data over, or the customer now having to deal with two systems, for god knows how long... it's generally pretty damned expensive to change systems...
And don't forget learning curve.
-
@scottalanmiller said in Researching OpenDental Software:
@Dashrender said in Researching OpenDental Software:
@scottalanmiller said in Researching OpenDental Software:
@flaxking said in Researching OpenDental Software:
There's so many industries with niche LoB applications that are ripe for a shake-up by modern competitors. The issue is getting the business knowledge in order to make a competing product.
And getting the customers to care. In many cases, just because you make a better mouse trap, doesn't mean that someone will buy it.
This is so true. It's not simply buying the new software, it's moving the old data over, or the customer now having to deal with two systems, for god knows how long... it's generally pretty damned expensive to change systems...
And don't forget learning curve.
Exactly.
I'm having this exact with with a client now. They have a 20+ year old AS/400, yes a real AS/400 that is still running their back end systems... I've been talking to them for 5+ years to upgrade to at least a current version of their system or move to something else... still waiting.
-
Linux MySQL Install....
MySQL
Install MySQL from RPM or install package that best matches system from http://dev.mysql.com/downloads/mysql/5.5.html.
Setup grant tables on Linux by running the following commands. This is documented at: http://dev.mysql.com/doc/refman/5.5/en/grant.html.GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '';GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY '';Edit the MySQL configuration file named my.cnf to disable the use of innoDB tables by default. The my.cnf file is usually located at the path /etc/init.d/my.cnf. Add the following text on its own line: default-storage-engine=MyISAM​.
When done, the my.cnf file should look very similar to the my.ini file that's described on MySQL Server Variables. There should not be a lot of additional clutter.
Copy a blank or current OpenDental database to the Linux server.
Each Linux installation might have a different MySQL data location or path. The database path is documented in my.cnf and is defined on a line starting with datadir=.
Copy the database files to a folder that you create in the data directory. For example, if the path is /var/lib/mysql and opendental is the name of your new database, copy to /var/lib/mysql/opendental/.
Ensure the newly created database folder has permissions for MySQL to access the files. Either set the owner to the mysql user or set the folder permissions to allow access to all users. Open a terminal window and type one of the two commands (change the directory path to match your actual database path): chown -R mysql:mysql /var/lib/mysql/opendental or chmod -R 777 /var/lib/mysql/opendental.
