bradymiller wrote on Saturday, November 12, 2011:
Also, ensure you have the following php settings in the php.ini file at \xampp\php\php.ini (if change any settings, need to restart the apache server) :
http://open-emr.org/wiki/index.php/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F
-brady
drjohnloes wrote on Saturday, November 12, 2011:
Hello,
We installed xampp separately . The directory above openemr is :C:\xampp\htdocs I just see folders for xampp, openemrsaved and openemr. What am I supposed to see?
The apache error log is Terminating on signal SIGTERM(15)
pid file C:/xampp/apache/logs/httpd.pid overwritten - Unclean shutdown of previous Apache run?
Digest: generating secret for digest authentication …
Digest: done
Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 configured - resuming normal operations
Server built: Nov 11 2009 14:29:03
Parent: Created child process 1712
Digest: generating secret for digest authentication …
Digest: done
Child 1712: Child process is running
Child 1712: Acquired the start mutex.
Child 1712: Starting 150 worker threads.
Child 1712: Starting thread to listen on port 443.
Child 1712: Starting thread to listen on port 80.
Session site ID has been set to ‘AAFMC’
File does not exist: C:/xampp/htdocs/favicon.ico
File does not exist: C:/xampp/htdocs/favicon.ico
Session site ID has been set to ‘AAFMC’
File does not exist: C:/xampp/htdocs/favicon.ico
File does not exist: C:/xampp/htdocs/favicon.ico
Hope this helps.
Thanks,
John
bradymiller wrote on Sunday, November 13, 2011:
Hi,
What browser are you using? And are you using an address like:
html://localhost/
make sure you are just not simply going to it via a file directory
Also need to ensure the php settings are set correctly in the c:\xampp\php\php.ini (if change any settings, need to restart the apache server); see following link for required settings:
http://open-emr.org/wiki/index.php/FAQ#What_are_the_correct_PHP_settings_.28can_be_found_in_the_php.ini_file.29_.3F
And restart your apache server (if not sure what I mean, then restart your computer) after.
-brady
bradymiller wrote on Sunday, November 13, 2011:
error above, mean address like:
http://localhost/
drjohnloes wrote on Sunday, November 13, 2011:
Hello,
I changed the php.ini as suggested and then restarted my computer; however, didn’t help.
I am using Mozilla Firefox 8.0
Not sure what you mean but I’m using Windows XP and click “my computer” from start menu; then click “local Disc C” then “xampp”; " htdocs …
bradymiller wrote on Sunday, November 13, 2011:
Hi,
OpenEMR is a server-based program, so you need to use it like you would use a website on the internet. For example, this should get you to the sql_upgrade.php script correctly if typed into the browser address:
http://localhost/sql_upgrade.php
You should not be using the filename path (ie. c:/ etc.).
-brady
bradymiller wrote on Sunday, November 13, 2011:
Error above, the command should be:
http://localhost/openemr/sql_upgrade.phpdrjohnloes wrote on Sunday, November 13, 2011:
Hello,
A little light went on inside my head as I read your last few notes. Unfortunately, I am not able to connect to server and get the following error: Check that mysqld is running. Did I do something wrong in php.ini??
Thanks,
John
drjohnloes wrote on Sunday, November 13, 2011:
Hi,
yes, I can get connected to local host and have used it to bring up xampp.
John
drjohnloes wrote on Sunday, November 13, 2011:
Hello,
It was working perfectly. Looks like I jumped out of the fry pan but into the fire.
John
bradymiller wrote on Sunday, November 13, 2011:
Hi,
Won’t be too tough to deal with this. In your previous version, what directories do you have at c:\xampp\htdocs\openemr\sites
-brady
drjohnloes wrote on Sunday, November 13, 2011:
Hi, two folders: aafmc and default
John
bradymiller wrote on Sunday, November 13, 2011:
To figure out whether you were using default or aafmc:
On the previous version, how were you logging into OpenEMR (what link were you putting in the web browser). For example, were you using admin.php.
Also, in the previous version, which directory contains documents/directories:
openemr\sites\default\documents\
or
openemr\sites\aafmc\documents\
Also, in the previous version, where do you have variables that appear personalized
openemr\sites\defaultsqlconf.php
or
openemr\sites\aafmc\sqlconf.php
-brady
drjohnloes wrote on Monday, November 14, 2011:
Hello,
A friend helped me set up the computer so that when I started my browser openemr login screen would show in one of the tabs ( he obviously knew to use localhost :) http://localhost/openemr/interface/login/login_frame.php?site=AAFMC. I have personalized variables in :openemr\sites\aafmc\sqlconf.php. and I believe that the documents were in openemr\sites\aafmc\documents.
Thanks,
Johhn
bradymiller wrote on Monday, November 14, 2011:
Try the following for an upgrade:
1. Move current(4.0.0) /openemr directory to a backup directory
2. Unpackage 4.1.0 openemr into web directory and rename the directory to openemr
3. Move following directories from old 4.0.0 version to /openemr directory:
openemr/sites/aafmc/documents
openemr/sites/aafmc/edi
openemr/sites/aafmc/era
openemr/sites/aafmc/letter_templates
4. Record the openemr/sites/aafmc/sqlconf.php file variables from your old 4.0.0 version, and type these into the openemr/sites/aafmc/sqlconf.php file in new openemr version
5. In the openemr/sites/aafmc/sqlconf.php file, set the $config variable (found near bottom of file within bunch of slashes) to 1 ($config = 1;).
6. Open openemr/sql_upgrade.php?site=aafmc ( http://localhost/openemr/sql_upgrade.php?site=aafmc ) in web browser, choose 4.0.0 and click ‘Upgrade Database’
7. Open openemr/acl_upgrade.php?site=aafmc (http://localhost/openemr/acl_upgrade.php?site=aafmc ) in web browser
8. Configure optional settings in openemr/sites/aafmc/config.php files
9. To login use http://localhost/openemr/interface/login/login_frame.php?site=aafmc
-brady
drjohnloes wrote on Tuesday, November 15, 2011:
Brady,
I appreciate all your efforts; However, I think that i made some fundamental mistakes when I changed my php.ini setting (in the file directory) ;when I attempt to go through localhost/openemr I get error 404 (i’ve also gotten Error 401).
when I attempt to get to my back-up openemr,I get :
Check that mysqld is running.
ERROR: Could not connect to server!
I didn’t get the difference in opening through web directory or file directory at first (but I do now) ; Any ideas? Maybe just delete and download the new version w xampp attached, there is nothing of critical value in 4.0.0 - just trying to figure this thing out!
Thanks,
John
Thanks,
drjohnloes wrote on Wednesday, November 16, 2011:
Hello,
I did some research w xampp and a common reason for not being able to connect to mysqld is corrupt ntwdblib.dll file. I did download and re-install this file but didn’t help. A little more searching and I found in c:/xampp/mysql/data/mysql.err that:
InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB’s files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error. I am theorizing that I inadvertantly mis-placed a copy of openemr and I question whether I should remove and re-install mysql and or xampp (uninstall_xampp.bat asks if I want to remove Apache htdocs directory and/or mysql data directory? DO I?) Thanks,
John
gutiersa wrote on Thursday, November 17, 2011:
Nah, don’t delete them, or better yet copy htdocs to another place, and let uninstall delete it if you really want a fresh xampp installed. also save the
c:\xampp\mysql folder,
your database is there. Remember you are gonna have to make all the changes to the configuration files for php, and apache (httpd)
From reading this, I think that your best bet at the very begining, would have been to re copy a new version 4.1, then the patch, and then run sql_upgrade.php, before investigating anything else. the upgrade does work. At least for Vista.
I have a test installation in windows vista and xampp version 1.7.3, also had working openemr 4.0.0, then upgraded succesfully to 4.1 then added the patches. You seem to have everything in the right place, ie xampp in c:, openemr in htdocs.
good luck
sandra