Difference between revisions of "Hosted OpenEMR"
From OpenEMR Project Wiki
| Line 14: | Line 14: | ||
:* [http://hints.steptoinstall.com/create-new-database-database-user-cpanel.html Database Creation Tutorial]. | :* [http://hints.steptoinstall.com/create-new-database-database-user-cpanel.html Database Creation Tutorial]. | ||
:* Pay close attention to Permissions. | :* Pay close attention to Permissions. | ||
[[File:Privileges.png|center]] | |||
:* Write down the credentials for use later in the OpenEMR setup. | :* Write down the credentials for use later in the OpenEMR setup. | ||
:* Be certain the collation of your tables matches that in the most current Demo. [http://kb.siteground.com/how_can_i_change_my_mysql_database_collation/ Guide] for changing the collation. Mismatch of collations is a very common setup error. | :* Be certain the collation of your tables matches that in the most current Demo. [http://kb.siteground.com/how_can_i_change_my_mysql_database_collation/ Guide] for changing the collation. Mismatch of collations is a very common setup error. | ||
[[File:Hostedutf8.png|center]] | [[File:Hostedutf8.png|center]] | ||
==OpenEMR Setup== | ==OpenEMR Setup== | ||
Revision as of 12:22, 16 March 2015
Foreword
Installation of OpenEMR will require a number of distinct steps that often trip up the user in a hosted environment.
OpenEMR Location
- Open File Manager in cPanel.
- Select your domain's document root. Make sure you are in your domain's public_html folder.
MySQL Creation
- You have to set up your database. Go back to your cPanel -> select Database Wizard.
- Database Creation Tutorial.
- Pay close attention to Permissions.
- Write down the credentials for use later in the OpenEMR setup.
- Be certain the collation of your tables matches that in the most current Demo. Guide for changing the collation. Mismatch of collations is a very common setup error.
OpenEMR Setup
- There will a series of entries which are very different from a localhost installation.
- In Step 1 select second option, "I have already created the database".
- In Step 2 carefully complete the MySQL Server section.
- The Server Host is not localhost, but the IP address of the server running MySQL.
- Enter the Database Name, Login Name and Password from MySQL Creation above.
- The User Hostname is not localhost, but the IP address of the server running Apache/PHP.
- Incorrect entries will mean an installation failure.
- Complete the setup according to the Linux Installation Guide.
Article courtesy of Jeyasithar of the OpenEMR Forums.
