Open Dental Forum

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