Anyway to share database on multiple computer

bradymiller wrote on Saturday, May 08, 2010:

hey,
Change the directory name of the old xampp directory to ‘old_xampp’ directory; that should do it :slight_smile:
I am suspicious you may need to remove/add the services (see step 1-2 and 6-7 from most recent instruction set above) to ensure new mysql/apache instances from your new directory are being used.
-brady

cadprofessor wrote on Saturday, May 08, 2010:

It would not let me rename the dir…something still using it.  I got this error when trying to start the apache service….
The Apache service named  reported the following error:
>>> httpd.exe: Syntax error on line 42 of D:/shares/openemr/xampp/apache/conf/httpd.conf: ServerRoot must be a valid directory 

I will take a look…

cadprofessor wrote on Saturday, May 08, 2010:

I changed this ServerRoot “/shares/openemr/xampp/apache” and the documentroot….did not help error message when starting

DocumentRoot “/xampp/htdocs” needs to be changed?

I think I may need to start from scratch….

cadprofessor wrote on Saturday, May 08, 2010:

Just keeps getting better…the service manager shows both apache and mysql running to the correct path on D:

The Apache service named  reported the following error:
>>> httpd.exe: Syntax error on line 483 of D:/shares/openemr/xampp/apache/conf/httpd.conf: Syntax error on line 8 of D:/shares/openemr/xampp/apache/conf/extra/httpd-xampp.conf: Cannot load D:/xampp/apache/bin/php5apache2_2.dll into server: The specified modul  

bradymiller wrote on Saturday, May 08, 2010:

hey,
maybe when you copied the entire xampp folder, you missed some vital files (if they are in use, which is suggested since you couldn’t rename the original xampp directory). I’d re-start from scratch.
-brady

cadprofessor wrote on Saturday, May 08, 2010:

I have removed everything from the server….I am wondering if the problem is that I am using a different path than what is being used when it install on dirve c.  Maybe you can not do what I want it to….I did get the database folder to move to drive D: using the same path …I even renamed the database folder on drive c: and openemr worked fine….

I am calling it a day …will look at it again on Monday.  I thank you for all your efforts and help.  Please send any other information that you might think will work….

cadprofessor wrote on Saturday, May 08, 2010:

I got it to work….
1. use winrar to extract into temp folder on another machine
2. copy all files over the server into D:
3. edit global.php   make changes in path making sure to add to the front of the path only
4. start xampp
5 installed apache service
6. install myphp service
7 tested from another machine  ……it works.

I have not tried to change the listen port.  I hope that will not mess things up.

cadprofessor wrote on Saturday, May 08, 2010:

Well….it worked until I shutdown all the services to backup all the files…when I tried to restart mysql and apache would not start…hope it is not back to the drawing board…

cadprofessor wrote on Sunday, May 09, 2010:

update……rebooted the server.  Seems to running find expect for the  openports.exe error message I got when the server booted.  I will have to look into that.   

bradymiller wrote on Sunday, May 09, 2010:

hey,
The following worked for me:
1) Uninstall the apache service: double-click c:\xampp\apache\apache_uninstallservice.bat
2) Uninstall the mysql service: double click c:\xampp\mysql\mysql_uninstallservice.bat
3) Copy/move the entire xampp directory to your new directory (I suggest ensuring the full path to the xampp directory has no spaces in it)
4) Double click this file in your new directory …\xampp\setup_xampp.bat
5) Edit the …/xampp/htdocs/openemr/interface/globals.php file and set the $webserver_root, perl_din_dir_win, and mysql_bin_diw_win variables to the new path
6) Install the apache service: double-click in new directory …\xampp\apache\apache_installservice.bat
7) Iinstall the mysql service: double click in new directory …\xampp\mysql\mysql_installservice.bat
6) go to OpenEMR in your browser

(you need to ensure you run the disable scripts before doing any copying/moving of the xampp directory)(also note it worked just fine after a restart of windows)
-brady

bradymiller wrote on Sunday, May 09, 2010:

Note step 4 is very important (sometimes need to type ‘1’ in the console menu after run this script), because it sets up all the correct paths in xampp.

cadprofessor wrote on Sunday, May 09, 2010:

Brady,

I think I have it working now.  I think the last way I tried works the best since I don’t have to worried about services running while copy files.  I followed all your steps except I installed all the files into the target folder without having to first install on c:. I used winrar to extract all the files from the install exe file. I then copied them to the servers folder.    I then followed your steps 4 through 6. 

cadprofessor wrote on Sunday, May 09, 2010:

I also found this on the net explaining how to set a new port and SSL port.  It was very easy to follow

I found out what exactly needs to be changed to allow XAMPP to co-exist with IIS configured to run on Port 80, and Apache (in my case) to run on Port 8080 (and SSL running on Port 4499):
C:\xampp\apache\conf\httpd.conf:
* Search for “Listen 80?, change to “Listen 8080?
* Search for “ServerName localhost:80?, change to “ServerName localhost:8080?
C:\xampp\apache\conf\extra\httpd-ssl.conf
* Search for “Listen 443?, change to “Listen 4499?
* Search for “<VirtualHost _default_:443>”, change to “<VirtualHost _default_:4499>”
* Search for “ServerName localhost:443?, change to “ServerName localhost:4499?

Can you help me how can i do it?