Difference between revisions of "Hosted OpenEMR"
From OpenEMR Project Wiki
		| Line 15: | Line 15: | ||
:* The user you create must have all privileges.  | :* The user you create must have all privileges.  | ||
[[File:Privileges.png|center]]  | [[File:Privileges.png|center]]  | ||
:* Write down the credentials for use in Step 2 of the OpenEMR setup.  | :* Write down the credentials for use in Step 2 of 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.  | ||
Revision as of 12:28, 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.
 - The user you create must have all privileges.
 
- Write down the credentials for use in Step 2 of 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.




