Difference between revisions of "Securing OpenEMR"

From OpenEMR Project Wiki
(22 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=Securing OpenEMR=
=Securing OpenEMR=
==Overview==
==Overview==
:With the advent of the Patient Portals, the community is now addressing the issues of how to best secure OpenEMR instances that are open to the web. Doing this requires a firm understanding of securing several parts, which at least include OpenEMR itself, Apache, MySQL, PHP, firewall, router, https, certficates, etc. A forum that began to discuss this issue can be [http://sourceforge.net/projects/openemr/forums/forum/202505/topic/4769926 found here].
:Securing OpenEMR requires a firm understanding of securing several parts, which at least include OpenEMR itself, Apache, MySQL, PHP, firewall, router, https, certficates, etc. A forum that began to discuss this issue can be [https://community.open-emr.org/t/onsite-or-offsite-patient-portal/2234 found here].


:There is also a very nice write up on [http://www.oemr.org/wiki/Security_Assessment Security Assessment] for EMRs (especially regarding HIPAA compliance) on the OEMR Organization wiki.
:There is also a very nice write up on [http://open-emr.org/wiki/index.php/Security_Assessment Security Assessment] for EMRs (especially regarding HIPAA compliance) on the wiki.


:<span style="color:red;">'''This document is still a work in progress; hopefully as members of the community begin securing their OpenEMR instances for the web, they will place things they learned here in order to help others.'''</span>
:<span style="color:red;">'''This document is always a work in progress.'''</span>


==OpenEMR==
==OpenEMR==
*For OpenEMR versions 4.1.1 or less, remove the following file and directory, if they exist:
*After installation/upgrade '''<span style="color:red;">remove the setup.php script</span>''', which is not needed for general OpenEMR use.
:*FILE: library/openflashchart/php-ofc-library/ofc_upload_image.php
*After installation/upgrade, '''<span style="color:red;">strongly recommend removing</span>''' (or ensuring no access to) to the following scripts, which are not needed for general OpenEMR use:
:*DIRECTORY: library/openflashchart/tmp-upload-images/
*After installation/upgrade consider removing(or ensuring no access to) to the following scripts, which are not needed for general OpenEMR use:
:*acl_setup.php
:*acl_setup.php
:*acl_upgrade.php
:*acl_upgrade.php
:*admin.php
:*admin.php
:*sl_convert.php
:*sl_convert.php
:*setup.php
:*sql_patch.php
:*sql_upgrade.php
:*sql_upgrade.php
:*gacl/setup.php
:*gacl/setup.php
Line 22: Line 20:
:*entire contrib directory
:*entire contrib directory
::*(except for the contrib/icd9, contrib/icd10, contrib/snomed and contrib/rxnorm directories)
::*(except for the contrib/icd9, contrib/icd10, contrib/snomed and contrib/rxnorm directories)
:*entire Tests directory
:*entire tests directory (for versions prior to 5.0.1, this is the Tests directory)
:*entire phpmyadmin directory
:*entire phpmyadmin directory (you do not need to do this for versions 5.0.1 and later, since phpmyadmin is not included in these versions)
::*This is a rather controversial recommendation(some users rely on this tool). If you need to maximize security, then should consider removing this.
*After installing a patch, '''<span style="color:red;">strongly recommend removing</span>''' (or ensuring no access to) the following script, which is not needed for general OpenEMR use:
*After installing a patch consider removing (or ensuring no access to) the following script, which is not needed for general OpenEMR use:
:*sql_patch.php
:*sql_patch.php
*Passwords
*Passwords
:*Enforce strong/unique passwords, which can be set in Administration->Globals->Security.
:*Enforce strong/unique passwords, which can be set in Administration->Globals->Security.
:*Enforce password expiration, which can be set in Administration->Globals->Security.
:*Enforce password expiration, which can be set in Administration->Globals->Security.
*For OpenEMR versions 4.1.1 or less, remove the following file and directory, if they exist:
:*FILE: library/openflashchart/php-ofc-library/ofc_upload_image.php
:*DIRECTORY: library/openflashchart/tmp-upload-images/


==Network==
==Network==
Line 36: Line 36:


==Apache==
==Apache==
*General hardening of Apache, which is [http://www.learncomputer.com/secure-apache/ described here], and here for [http://httpd.apache.org/docs/2.4/misc/security_tips.html apache2.4].  
*General hardening of Apache, which is [http://www.learncomputer.com/secure-apache/ described here], and here for [http://httpd.apache.org/docs/2.4/misc/security_tips.html apache2.4].
*Only allow https (ie. turn off http)
*Only allow https (ie. turn off http).  It's pretty easy to setup for  [https://www.digitalocean.com/community/tutorials/how-to-create-a-ssl-certificate-on-apache-for-ubuntu-14-04 Debian/Ubuntu].
*Do not allow direct web access to the following directories
*Do not allow direct web access to the following directories
:*sites/*/documents
:*sites/*/documents
Line 57: Line 57:
*If you are using XAMPP, note that this software is extremely unsecure after installation and you need to secure it by configuring the Security Console.
*If you are using XAMPP, note that this software is extremely unsecure after installation and you need to secure it by configuring the Security Console.


*Navigate to the Security Console via http://localhost/security/xamppsecurity.php in the URL address bar.   
*for newer versions of XAMPP please see this:
Information on setting a root password for the database can be found in the "HOW-TO Guides" for XAMPP for windows version 5.6.20 (enter localhost in browser).
 
*for older versions (~pre 2016) Navigate to the Security Console via http://localhost/security/xamppsecurity.php in the URL address bar.   


*If the Welcome page is in German, it can be changed in the left sidebar, under Sprachen. Language selection can also be accomplished from the splash page or in the upper right hand corner of a webpage.
*If the Welcome page is in German, it can be changed in the left sidebar, under Sprachen. Language selection can also be accomplished from the splash page or in the upper right hand corner of a webpage.
Line 83: Line 86:
*Navigate to the Status section from the left sidebar.  If there are 3 green "Secure" bars, this exercise has been successful.
*Navigate to the Status section from the left sidebar.  If there are 3 green "Secure" bars, this exercise has been successful.
[[File:Secure2.png|center]]
[[File:Secure2.png|center]]
==Nginx and PHP-FPM==
Check out this article which includes ssl files for securing openemr:
::[https://www.open-emr.org/wiki/index.php/OpenEMR_with_nginx_and_php-fpm OpenEMR with Nginx and PHP-FPM]


==Codebase==
==Codebase==
*[[Codebase_Security|Ongoing project to prevent sql-injection and cross-scripting attacks.]]
*[[Codebase_Security|Ongoing project to maintain security of the codebase.]]
*Consider adding a specific sqlconf.php override settings when using the patient portal (especially the onsite portal), which can be used to use a separate mysql user (and possibly database).
*Consider adding a specific sqlconf.php override settings when using the patient portal (especially the onsite portal), which can be used to use a separate mysql user (and possibly database).
<br>
<br>

Revision as of 16:44, 19 June 2019

Securing OpenEMR

Overview

Securing OpenEMR requires a firm understanding of securing several parts, which at least include OpenEMR itself, Apache, MySQL, PHP, firewall, router, https, certficates, etc. A forum that began to discuss this issue can be found here.
There is also a very nice write up on Security Assessment for EMRs (especially regarding HIPAA compliance) on the wiki.
This document is always a work in progress.

OpenEMR

  • After installation/upgrade remove the setup.php script, which is not needed for general OpenEMR use.
  • After installation/upgrade, strongly recommend removing (or ensuring no access to) to the following scripts, which are not needed for general OpenEMR use:
  • acl_setup.php
  • acl_upgrade.php
  • admin.php
  • sl_convert.php
  • sql_patch.php
  • sql_upgrade.php
  • gacl/setup.php
  • ippf_upgrade.php
  • entire contrib directory
  • (except for the contrib/icd9, contrib/icd10, contrib/snomed and contrib/rxnorm directories)
  • entire tests directory (for versions prior to 5.0.1, this is the Tests directory)
  • entire phpmyadmin directory (you do not need to do this for versions 5.0.1 and later, since phpmyadmin is not included in these versions)
  • After installing a patch, strongly recommend removing (or ensuring no access to) the following script, which is not needed for general OpenEMR use:
  • sql_patch.php
  • Passwords
  • Enforce strong/unique passwords, which can be set in Administration->Globals->Security.
  • Enforce password expiration, which can be set in Administration->Globals->Security.
  • For OpenEMR versions 4.1.1 or less, remove the following file and directory, if they exist:
  • FILE: library/openflashchart/php-ofc-library/ofc_upload_image.php
  • DIRECTORY: library/openflashchart/tmp-upload-images/

Network

  • On server, consider only opening port 443 (https).
  • Consider a firewall that only allows port 443 (https) traffic to the server.

Apache

  • General hardening of Apache, which is described here, and here for apache2.4.
  • Only allow https (ie. turn off http). It's pretty easy to setup for Debian/Ubuntu.
  • Do not allow direct web access to the following directories
  • sites/*/documents
  • sites/*/era
  • sites/*/edi
  • Do not allow use of .htaccess files in Apache (ie. turn off the AllowOverride setting).
  • If not using portal and want to allow users to access over the internet, then consider using client-sided certificates to only allow users access to site
  • If using third party patient portal, then use the current method whereby your instance is not on the internet and connects to the third party patient portal via vpn.
  • If want to give access to the onsite patient portal over the internet, then consider using a client-sided certificate to only allow users access to the main OpenEMR login page (this is not optimal, though).

MySQL

  • Ensure the root password is set to something.

PHP

XAMPP

  • If you are using XAMPP, note that this software is extremely unsecure after installation and you need to secure it by configuring the Security Console.
  • for newer versions of XAMPP please see this:

Information on setting a root password for the database can be found in the "HOW-TO Guides" for XAMPP for windows version 5.6.20 (enter localhost in browser).

  • If the Welcome page is in German, it can be changed in the left sidebar, under Sprachen. Language selection can also be accomplished from the splash page or in the upper right hand corner of a webpage.
1deutsche.png


  • Navigate to the Security section.
Secure.png


  • The first task is to set the MySQL root password. The question under "Security Risk!" asks if you wish to store the password in plain text. The first word is a verb, not an adjective; "save" instead of "safe". Users who are apt to losing things may wish to choose this option despite an increased risk. Click "Password Changing" button to save.
  • The second task is to set the password to the Security Console. Click "Make safe the XAMPP directory" button to save.
  • If this password is lost and not saved in plain text, it would be very difficult to gain access to the Security Console to change the MySQL root password. Knowing the MySQL root password allows the user to import the database to a new device or installation of OpenEMR at some future time.
  • If the user needs to gain access to phpMyAdmin externally (outside of OpenEMR), he must know the MySQL root password.
  • If the user opts to save the passwords in plain text, the paths to the folders containing the passwords are given.
Secure1.png


  • Navigate to the Status section from the left sidebar. If there are 3 green "Secure" bars, this exercise has been successful.
Secure2.png

Nginx and PHP-FPM

Check out this article which includes ssl files for securing openemr:

OpenEMR with Nginx and PHP-FPM

Codebase


Security Assessment

  • A security risk assessment is a requirement in the US for compliance with HIPAA and Meaningful Use. There is a very nice write up on this topic on the Security Assessment wiki page.