Middle Tier on Amazon EC2 running Linux

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

Middle Tier on Amazon EC2 running Linux

Postby Justin Shafer » Sun Mar 11, 2018 7:59 pm


Rough draft notes.. will edit this more:

Setup Mono XSP4 and MySQL with Ubuntu 16.04 and Open Dental 17.4 (no samba yet)
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 3FA7E0328081BFF6A14DA29AA6A19B38D3D831EF
echo "deb http://download.mono-project.com/repo/debian preview main"
sudo apt-get update
sudo apt-get install mono-devel mono-complete ca-certificates-mono mono-xsp4 unzip
sudo apt-get install mysql-server
sudo ufw allow 3306
sudo ufw allow 9000
sudo service ufw restart
sudo pico /etc/mysql/mysql.conf.d/mysqld.conf

#Edit File!
#bind-address =
max_allowed_packet = 40M
#Save File and restart mysql
sudo service mysql restart

#Add mysql access from outside the host
mysql -uroot -ppassword

Use SSH\SCP and MySQL Workbench to upload database and OpenDental
Be SURE Interop.Word.dll and ODCrypt.dll are in the OpenDental bin folder AND you setup OpenDentalServerConfig.xml

Setup VPN

Start XSP4 by going into the Open Dental directory and typing xsp4, then connect from a client on port 9000 after editing Amazon EC2 Security group to allow port 9000 incoming traffic:
http://ip address:9000/ServiceMain.asmx

How should we handle HIPAA? Need to make XSP4 boot automatically, deal with encryption at rest and maybe a VPN for encrypting the traffic.

Notes for a faster Open Dental client?
User avatar
Justin Shafer
Posts: 535
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 1 guest