Middle Tier on Amazon EC2 running Linux

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
Justin Shafer
Posts: 596
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.

Middle Tier on Amazon EC2 running Linux

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

http://justinshafer.blogspot.com/2018/0 ... -tier.html

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 = 127.0.0.1
max_allowed_packet = 40M
sql_mode="NO_AUTO_CREATE_USER"
#Save File and restart mysql
sudo service mysql restart

#Add mysql access from outside the host
mysql -uroot -ppassword
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
quit

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?
viewtopic.php?f=1&t=6742#p30203

User avatar
Ardavan
Posts: 106
Joined: Sat May 15, 2010 9:10 am

Re: Middle Tier on Amazon EC2 running Linux

Post by Ardavan » Mon May 28, 2018 1:47 pm

Thank you for sharing, I was searching for a method to secure an internet exposed middle tier when I discovered this post by accident. Have you or anyone you know ran the middle tier (or the client application for that matter) on a linux machine in production?
There are 10 types of people in this world, those who will laugh at this joke, and those who won't. ~Annonymous Bug Writer

Post Reply