I am trying to get OpenEMR to work with WinXP Pro (SP2)
I am using XAMPP, and everything seems to be working fine there.
I then downloaded OpenEMR v2.7.2-rc2
(the only version I could find apart from the automated Mandrake installer) and set it up in the appropriate directory for XAMPP to find it.
I then went through the setup process, and completed it.
I try to login, and this is what I get -
Warning: main(/openemr/library/md5.js): failed to open stream: No such file or directory in I:\apachefriends\xampp\htdocs\openemr\interface\login\login.php on line 4
Warning: main(): Failed opening ‘/openemr/library/md5.js’ for inclusion (include_path=’.;I:\apachefriends\xampp\php\pear’) in I:\apachefriends\xampp\htdocs\openemr\interface\login\login.php on line 4
Warning: main(/openemr/library/sql.inc): failed to open stream: No such file or directory in I:\apachefriends\xampp\htdocs\openemr\interface\login\login.php on line 5
Warning: main(): Failed opening ‘/openemr/library/sql.inc’ for inclusion (include_path=’.;I:\apachefriends\xampp\php\pear’) in I:\apachefriends\xampp\htdocs\openemr\interface\login\login.php on line 5
Fatal error: Call to undefined function: sqlstatement() in I:\apachefriends\xampp\htdocs\openemr\interface\login\login.php on line 20
Any thoughts on where to go from here?
Trying a Linux install is not an option for me.
OpenEMR in its current form does not work with Windows.
There’s a post on 5/10 by drbowen in the Developers forum about a modified version that’s reported to work; however nobody has submitted those changes in a form that is suitable for inclusion into the source repository (i.e., changes that are compatible across platforms).
If you are serious about OpenEMR, you really need to dip your toes into the Linux waters. It’s really easy with a preconfigured machine. Send me a note if you’d like some help.
This looks like a path failure not allowing you to read the configuration files and is likely due to an incorrectly set path in globals.php. Check lines 9 and 16 and make sure your document root is pointed at the correct directories in:
openemr/interface/globals.php
I’m guessing but (line 9) probably:
\apachefriends\xampp\htdocs\openemr
or
I:\apachefriends\xampp\htdocs\openemr
and line 16:
\openemr
Your may have to use forward slashes / instead of \ .
md5.js is a javascript function created to encrypt the password into the md5 format to allow a database connection. You should be able to see this file in openemr at
openemr\library\md5.js
Also the XAMPP is making calls to PEAR but OpenEMR uses ADODB. The PEAR module might be interfering with the calls to ADODB.
It seems that I have had something similar happen when the database tables are not set up correctly. The last line is an SQL select statement that has to pull the group name to show the login user and password boxes.
Lets back up a bit.
Is your MySQL server running?
Have you checked to see if you can connect to your MySQL server with the mysql root user?
If you can you should be able to
> \u openemr
> SHOW TABLES;
and get a list of all the openemr tables.
When you were setting up the (setup.php) database tables did you create a new OpenEMR user and password?
Did you use the MySQL root user to set up the OpenEMR tables?
Ok. I want to make one thing clear. OpenEMR works on Windows 2000 and XP. I didn’t use the v2.7.2-rc2 version, but the one previous to this.
Then Freeb is a pain on Windows, though I should say I haven;t tweaked the code. I expected it to work without any changes. But lack of documentation is the reason.
Coming to your problem:
You mentioned that Database setup didn’t work.
What was the problem with it? Did you increase the execution time in php.ini to around 1500, as loading the codes tables takes around this time.
Did you change the path variables in the interface/globals.php?