Revisión actual del 15:23 14 abr 2010

Contenido

1 Introduction
2 Using MySQL database on Linux
3 Backups
- 3.1 Scripts
  - 3.1.1 mysql-Hot_Backup-One_database
  - 3.1.2 backup-system-total-consul
4 Misc
- 4.1 Download Manual
5 Multiple servers
- 5.1 OpenDent to another server
- 5.2 Multiple monitors
6 Errors
- 6.1 Security Policy

Introduction

License: GPL Developed in .NET (Current estimate on running Open Dental on Linux or Mac is December 2006 using Mono)

Installation tutorial

http://www.opendental-solutions.com/

Using MySQL database on Linux

Distribution: Debian/Ubuntu

On Windows machine

Install opendental on a windows computer with local db - complete install
Make sure it works ok, put some data
Backup the MySQL database using MySQL with something like (using this as a guide http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/)

cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysqldump --add-drop-table opendental > \opendental.sql

this puts all the data into a single file, including the db meta info

On Linux server

apt-get update
apt-get install mysql-server mysql-client apache2 phpmyadmin samba php5 libapache2-mod-php5

Samba configuration

/etc/samba/smb.conf

[global]
       workgroup = Consul
       server string = %h Consul (Samba %v)
       security = SHARE
       map to guest = Bad User
       passdb backend = tdbsam
       syslog = 0
       log file = /var/log/samba/log.%m
       max log size = 1000
       time server = Yes
       panic action = /usr/share/samba/panic-action %d
       invalid users = root

[OpenDentalData]
       comment = OpenDentalData
       path = /srv/OpenDental/OpenDentalData
       valid users = gacq
       read only = no
       create mask = 0640
       directory mask = 0750

smbpasswd gacq
mkdir -p /srv/OpenDental/OpenDentalData
chown gacq.users /srv/OpenDental/OpenDentalData
/etc/init.d/samba restart

MySQL configuration

SET PASSWORD FOR 'root'@ 'consul' = PASSWORD( '***********' ) 
CREATE DATABASE `consul01` ;
CREATE USER 'consul'@ '%' IDENTIFIED BY '********';
GRANT USAGE ON * . * TO 'consul'@ '%' IDENTIFIED BY '********' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0   MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON `consul01` . * TO 'consul'@'%' WITH GRANT OPTION ;

Load database

mysql -u gacq -p opendental < opendental.sql

Enable remote connections at /etc/mysql/my.cnf commenting out

#bind-address           = 127.0.0.1

/etc/init.d/mysql restart

Apache configuration

Pointing Open Dental to new the server

Copy all file under C:\OpenDentalData to the new network share
Import database data
Change configuration parameter at OpenDent

References

Backups

Scripts

These scripts were made for Debian and Ubuntu

mysql-Hot_Backup-One_database

Backup one database in a compressed dump file. For a hot backup every 30 minutes put something like this in a new file in /etc/cron.d:

MAILTO=root
*/30 * * * *    root /usr/local/scripts/mysql-Hot_Backup-One_database <mysql_root_passwd> <OD_database> <directory>

and restart cron:

/etc/init.d/cron restart

backup-system-total-consul

Backup OD A-Z files, system config and a mySQL cold backup Configure the script and put it in your /etc/cron.daily

Misc

Download Manual

To download full user manual and images and recreate internal links structure for off line reading use:

wget -c -t 50 -T 5 -w 1 -e robots=off -r -k -I manual,images http://www.open-dent.com/manual/toc.html

Multiple servers

OpenDent to another server

Make backup of existing files using the backup feature in the manage module. One of those USB Flash Drives work well.
Install OD in new server. Be sure to install as Server (includes MySQL).
Run OD on the new server and go to the Manage module. Select the backup/restore function.
Restore from the backup.

Very easy. You could also do it by copying the database folder (Opendental) and the A-Z folders.

Multiple monitors

This is how it done

Hardware. A new dual-head video card (or add another video card to your existing computer) and 2 monitors
You know you can open 2 (or more) OD window by just clicking at OD icon one more time, then move that new OD window to the other monitor.

Errors

Security Policy

After build the installer when you try to install Open Dent in a clean PC you get the following error:

Microsoft .NET Framework
Application attempted to perform an operation not allowed by the security policy. To grant..........
......
......
Request for the permission of type
'System.Security.Permissions.FileIOPermission, mscorlib,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=.....' failed
Details:
************** Exception Text **************
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
 at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
......
 at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
 at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Security.Permissions.FileIOPermission
The Zone of the assembly that failed was:
Internet

Resolutions:

You have to execute the installer from a local drive, See this page

@@ Línea 5: / Línea 5: @@
 **[http://www.open-dent.com/manual/toc.html Manual]
 **[http://www.open-dent.com/OpenDentalDocumentation.xml Database documentation]
+**[http://www.open-dent.com/manual/previous.html Previous Versions - changelog]
+**[http://www.bcdentalcare.ca/CosmeticDentistry/tabid/471/Default.aspx Dentist Thornhill]
 *[http://www.ecuaodontologos.com/aorybg/opendent/index.html Descripción en español]
@@ Línea 20: / Línea 22: @@
 *Backup the MySQL database using MySQL with something like (using this as a guide http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/)
   cd C:\Program Files\MySQL\MySQL Server 5.0\bin
-  mysqldump --add-drop-table opendental > \OpenDental.sql
+  mysqldump --add-drop-table opendental > \opendental.sql
 this puts all the data into a single file, including the db meta info
 '''On Linux server'''
   apt-get update
-  apt-get install mysql-server mysql-client apache2 phpmyadmin samba
+  apt-get install mysql-server mysql-client apache2 phpmyadmin samba php5 libapache2-mod-php5
 ==Samba configuration==
@@ Línea 56: / Línea 58: @@
 ==MySQL configuration==
+ SET PASSWORD FOR 'root'@ 'consul' = PASSWORD( '***********' )
+ CREATE DATABASE `consul01` ;
+ CREATE USER 'consul'@ '%' IDENTIFIED BY '********';
+ GRANT USAGE ON * . * TO 'consul'@ '%' IDENTIFIED BY '********' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0   MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
+ GRANT ALL PRIVILEGES ON `consul01` . * TO 'consul'@'%' WITH GRANT OPTION ;
+Load database
+ mysql -u gacq -p opendental < opendental.sql
+Enable remote connections at /etc/mysql/my.cnf commenting out
+ #bind-address           = 127.0.0.1
+ /etc/init.d/mysql restart
 ==Apache configuration==
 ==Pointing Open Dental to new the server==
@@ Línea 61: / Línea 77: @@
 *Import database data
 *Change configuration parameter at OpenDent
+==References==
+*[http://freedental.forumco.com/topic~TOPIC_ID~486~SearchTerms~,.asp Another procedure]
+*[http://wwww.bcdentalcare.ca Richmond Hill dentist]
+=Backups=
+==Scripts==
+These scripts were made for Debian and Ubuntu
+===mysql-Hot_Backup-One_database===
+Backup one database in a compressed dump file.
+For a hot backup every 30 minutes put something like this in a new file in /etc/cron.d:
+ MAILTO=root
+ */30 * * * *    root /usr/local/scripts/mysql-Hot_Backup-One_database <mysql_root_passwd> <OD_database> <directory>
+and restart cron:
+ /etc/init.d/cron restart
+===backup-system-total-consul===
+Backup OD A-Z files, system config and a mySQL cold backup
+Configure the script and put it in your /etc/cron.daily
 =Misc=

Diferencia entre revisiones de «Open Dental»