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
Middle Tier on Amazon EC2 running Linux
- Justin Shafer
- Posts: 596
- Joined: Sat Jul 28, 2007 7:34 pm
- Location: Fort Worth, TX.
Middle Tier on Amazon EC2 running Linux
Justin Shafer
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com
Re: Middle Tier on Amazon EC2 running Linux
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