How to install OpenDental trial to Linux server?

[JLM]

Can the trial install the database to a linux server running MySql? Or the full version? Is there a guide somewhere?

Jim Margarit

[JLM]

I gave up on the idea. Basically, MySQL on linux is a waste of time. As installed, MySQL is configured to *NOT* start at boot and *NOT* allow clients to connect to it and *NOT* allow you to specify a data directory other than the default. Hours of google-ing couldn't overcome the boot issue and eventually resulted in ubuntu being unable to shutdown at all.

JLM

[drtech]

I have been running MySQL on an UBUNTU server for years. Fantastic. Maybe I can write up a tutorial sometime...but it does take a bit of time...

[Ralph McElmurry]

We ran servers on Ubuntu for several years. When OD went with a newer version of Mysql Ubuntu did not upgrade for a while so we had to go to Win7 servers. We gained significant aggravation and annoyance for our trouble.

[jsalmon]

We have some general steps to help user install MySQL on Linux. You probably want to install MySQL 5.5 instead of 5.0 like the instructions say. Also know that we do not give Linux support. We will tell you things in theory and you will need to make those things happen.

MySQL Installation:


Install from RPM or install package that best matches system from

http://dev.mysql.com/downloads/mysql/5.0.html

To setup grant tables on Linux run the following commands:

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '';

GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY '';

This is documented at:

http://dev.mysql.com/doc/refman/5.0/en/grant.html

Next, 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. Open the my.cnf file and 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 here:

http://www.opendental.com/manual/mysqls ... ables.html

There should not be a lot of additional clutter.

Lastly, you will need to 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=". Once you have determined the database path, copy the database files to a folder that you create in the data directory. For example, if the path /var/lib/mysql then you would have the database files iin /var/lib/mysql/opendental/ if opendental was to be the name of your new database. You must also make sure that the newly created database folder has permissions for MySQL to access the files. Either set the owner to the "mysql" user or set the permissions to the folder to allow access to the files for all users. This can be accomplished by opening a terminal window and typing 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".



Setting up your file share (OpenDentImages):


You may set this up however you wish, this is just like setting up any other fileshare on a Linux Machine. All of your users will need to be able to have full permissions such as read, write and delete. A good option is to set up Samba, then set up the share. Here are some web sites that have directions:

http://www.samba.org/samba/docs/man/Sam ... ollection/

http://samba.netfirms.com/

This is what I did to set up my share:

1. install webmin, access it via http://ipaddress:10000 logon, as root or other userwith adequate permissions click servers tab, choose Samba windows filesharing

2. create fileshare, then edit securities to set <writeable> and <guest access> to yes.

3. open an SSH terminal to your linux machine, logon as root or other user with adequate permissions

4. navigate to immediate parent directory of shared directory

5. type chmod -R 777 foldername

6. you are done, ls - l will show the permissions for all of the child folders including your share.

After the share is set up, copy the contents of OpenDentImages to this new share and then set your datapaths to this location;

http://www.opendental.com/manual/paths.html

[JLM]

Thanks for your replies!

Things I discovered along the way that might help others (not that I was successful)....
You cannot directly edit my.cnf anymore. You have to jump through hoops first.
see: http://www.ubuntugeek.com/how-to-change ... ctory.html
The real show stopper for me was that I couldn't get mysql to start at boot. I tried a half dozen "solutions" that didn't work.

My goal was to get a vmware server appliance created that other users could download and run with much reduced hassles. I love the idea of a virtual server that can backed up nightly and rsynced to my home server every night.

JLM

[drtech]

you should be able to do what you need. I am running Ubuntu 11 I think and mysql starts fine...I wonder why it isn't working for you.... Install Webmin also to config it...very useful.

[morphologyfan1]

Hi JLM,

This may work...aptitude may need to be installed, the terminal should do that with your sudo y/n approval, then rerun the cmd's.

Code: Select all

chmod 644 /etc/mysql/my.cnf
aptitude remove mysql-server
aptitude install mysql-server
aptitude install mysql-common

found here >>>http://stackoverflow.com/questions/7584 ... sql-server

Good Luck,
Brent

[rajg]

I have already moved the images folder to a SAMBA share on a freebsd server and it has been very stable.

Next step is to move MySQL and I just came across this thread. In addition to the instructions here and the doc help page on the website, do I need to consider anything else? Any guidance from the advanced users is appreciated. I understand that Opendent folks will not support my unix db server but what about the actual client software running on the Windows desktop? Our office is on a support contract.