Deploying OpenEMR on Azure

[DavidMGinn]

Open EMR Deployment

Below is a detailed guide to installing OpenEMR Leveraging Azure Web Apps + Database. This walkthrough will guide you in:

• Creating the Web App + Database
• Downloading the OpenEMR Source Code
• Deploying the Source to your Azure Web App
• Running the database installScript from a command prompt
• Video Demonstration - https://youtu.be/rhRzC28nI7g

Not an Azure customer yet? Click here to sign up and get $200 in free Azure credit.

1. Browse to the Azure Portal and select “Create a Resource”

2. Search for and select “Web App + Database
”

3. Click “Create”

4. Complete the form (note - only PHP 8.1 and lower have been tested) and click “Review and Create”

5. Review Settings - be sure to capture username / password for your database for later use, and then click “Create”

6. Wait for deployment to complete and click “Go to resource”

7. Download openemr-7.0.0.zip from here: https://www.open-emr.org/wiki/index.php/OpenEMR_7.0.0_Windows_Installation
8. Extract and open the extracted folder within Visual Studio Code
9. Ensure that the Azure App Service Extension is installed in Visual Studio Code

10. In the Azure Portal, browse to the resource group that was chosen as part of your deployment and find the “Azure Database for MySQL flexible server” resource

11. Select the “Connect” blade under the “Settings” section, and click “Download SSL Certificate”

12. Open Visual Studio Code and copy the downloaded certificate into the “/sites/default/documents/certificates” folder and rename it to “mysql-ca” with no file extension

13. Within Visual Studio Code, navigate to “/contrib/util/installScripts/InstallerAuto.php “ and comment out the “exit;” statement on line 78, then save the file

14. Select the Azure icon in Visual Studio Code. You may need to sign-in at this stage. Once you’ve signed in, expand the Azure Subscription and App Services and look for the App Service you created in Step 5.


15. Right click on the desired App Service, and click “Deploy to Web App”

16. Select the source folder you wish to deploy. By default this will be the current folder open in Visual Studio Code

17. Click “Deploy”


18. Open the output window to view the progress. This may take some time

19. Upon successful completion, browse back to the selected Resource Group, and select your App Service

20. Select “SSH” Under “Development Tools”, and click “Go ->”

21. Navigate to the installScripts folder using the command “cd site/wwwroot/contrib/util/installScripts"

22. Execute the command “php -f InstallerAuto.php server=<server-name> loginhost=% root=<username> rootpass=<password> login=<openemr-db-user> pass=<openemr-db-pass>” using the username noted in step 5 for “root” and password noted in step 5 for "rootpass" and a username and password of your choosing for “openemr-db-user “openemr-db-pass”. You may optionally include any of the parameters located on lines 84-102 of “installerAuto.php” if you wish to change any settings from their defaults. For a production installation, it is recommended to change any username and password settings from their default value.
    
    You can obtain the server name by browsing to your resource group and clicking the Azure Database for MySQL flexible server resource and copying the “Server name” property







23. Execute the above command, it will take some time to complete.

Once this command completes and returns to the command prompt, you may close the SSH browser tab to return back to your Azure Web App
24. Select the “Overview” blade and click the “URL” to browse to your site

25. If your install was successful, you will see the OpenEMR Login Screen. By default, the username is “admin” and password is “pass” unless these were changed when running the install command from step 22.

26. Congratulations! You have successfully installed OpenEMR on Azure!

Walkthrough Video Demonstration