Do you use or administer OpenEMR? Take the General Satisfaction Survey to help improve the product

Copy local openEMR to server

Hello Everyone,
I am new to this openEMR, I installed openEMR successfully in my local and it works perfectly fine. Now I need to copy the code from my local to server. Is there any way to change my hostname, username, and password in my local ?? If it is possible, could you please tell me the path to configure the values?

Thanks in advance.

OpenEMR can be copied from one server to another, without much trouble. You could specify which server it is on (Windows, Linux) and where you want to copy it (windows, Linux). Before copying you should change the passwords and the hostname does not matter.
regards
luis

Thanks for your reply.
We did the following steps :
I copied my openEMR project code from local to server and I copied the MySQL database file too.
And then I modified details of hostname, username, and password from the path of >>sites>>default>> sqlconf.php.
After doing all these I’ve run my project on the server but it goes to the setup page again which is used to createDB again.
Are there any ways to skip the creation of DB ?? or any other tips to run my project on the server ??
Any suggestions are acceptable.

Thanks in advance.

hi @Nandini-Routhu, not sure if this will get you where you need to be but to disable setup just set this to 1

while we set the value to 1, i got internal server error like this

maybe you have to export and then import the db instead of copying the file

I tried but when i run openEMR on my server, database is corrupted and then got Internal sever error again like above

may have to drop the database first and this guide will help import

yes i did same as above. but it is getting Internal server error again and again and DB is corrupted

what version of xampp?

Platform Type: Debian
MySQL Version: 6.32
Perl Version: 5.8.8
PHP Version: 7.3.2
Ubuntu 16.4

I’ve my server in Linux

ok, nice, what’s the apache log say? /var/log/apache2/error.log

223.196.160.71 - - [31/Mar/2021:15:19:46 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
223.196.160.71 - - [31/Mar/2021:15:19:46 -0400] “GET /openemr/interface/login/login.php?site=default HTTP/1.1” 500 519 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:09 -0400] “GET /openemr HTTP/1.1” 301 241 “-” “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:09 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:09 -0400] “GET /openemr/interface/login/login.php?site=default HTTP/1.1” 500 519 “-” “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:22 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:22 -0400] “GET /openemr/interface/login/login.php?site=default HTTP/1.1” 500 519 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:20:28 -0400] “GET /favicon.ico HTTP/1.1” 200 - “http://apps.dinkhoo.com/openemr/interface/login/login.php?site=default” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:31:51 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:31:51 -0400] “GET /openemr/interface/login/login.php?site=default HTTP/1.1” 500 519 “-” “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
223.196.160.71 - - [31/Mar/2021:15:32:28 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:32:42 -0400] “GET /openemr HTTP/1.1” 301 241 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:32:42 -0400] “GET /openemr/ HTTP/1.1” 302 20 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”
74.102.220.142 - - [31/Mar/2021:15:32:42 -0400] “GET /openemr/interface/login/login.php?site=default HTTP/1.1” 500 519 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36”

think that’s the access.log

Typically, since I have several projects going on at once and I have about 8 different instances of OpenEMR that I develop on my local box I do that following:

First step: Make sure that your virtual host is set up correctly.
If you are on a linux machine like Ubuntu, before you sync your code from the git repo into your web root directory (/var/www/html/openemr), create a single file called index.php and put the following code in it"

<?php echo "my virtual host is working correctly" ?>

like so:

When I go to localhost/openemr-test I see the following:

If you don’t see the following, you might want to make sure that you have correctly configured your /etc/apache/sites-available/openemr.conf file.

You also might want to checkout out your /etc/hosts file as well.

The reason why I think your virtual host is not configured correctly is the error you are getting.

Now, if your VH is set up correctly, I always find it easier to create a new database and call it a name like “database_delete”, let the install script do what it needs to do, then delete the ‘fake’ database and have the sites/default/sqlconfig.php file point to your desired database.

If you can successfully complete the install script creating a new database with your code, you should be able to easily set up the sqlconfig file to access that database.