tmccormi wrote on Monday, June 16, 2014:
I just tripped across this. https://sourceforge.net/projects/wampserver/
Might be a better way to support OpenEMR on a windows machine than the Xampp package.
–Tony
juggernautsei wrote on Monday, June 16, 2014:
Tony,
It is. I tried both in the beginning and the last 4 years I have been using Wampserver only. It is much easier to configure and get up and running fast.
Just my two cents.
fsgl wrote on Tuesday, June 17, 2014:
Regarding separate installs, the webpage for Windows can be revised to add WAMPP as an alternative to XAMPP if the consensus is that WAMPP is the easier choice.
For the DIY practice with no IT background, the XAMPP-OpenEMR package remains the quickest way to install. Such a practice will find the XAMPP/WAMPP configuration or any configuration, for that matter, intimidating.
htuckjr wrote on Wednesday, July 02, 2014:
Hi Folks-
Emboldened by Sherwin’s positive two cents I got Wampserver and gave it a shot. I had less than complete success but learned a whole lot about Windows that I never knew, so I thought I’d share my experiences in case they might benefit somebody else.
My setup for this project is Linux Mint 13 64bit on a Lenovo x120e netbook with 4gb ram. Windows 7 Home Premium 64bit runs just fine in a Oracle VirtualBox VM given 2gb ram, and I’ve installed/ run without problems the xampp OpenEMR package in this same VM configuration.
First I tried wampserver on a 32bit Win XP VM because I figured XP was still worth knowing about. Downloaded wampserver 2.5 and followed the simple install instructions. After installing multiple Visual C++ Redistributable packages up to and including “VC Redist - Visual Studio 2012 Update 4”, wampserver repeatedly gave an error message that “Aestan tray menu has encountered a problem.”… eventually found per Stackoverflow (http://stackoverflow.com/questions/23961651/wamp-windows-xp-httpd-exe-aestan-tray-menu) that wampserver version 2.5 does not install on Win XP, only Win 7.
So. I installed the VS 2012 redist for 64 bit on that Win 7 VM and wampserver consented to install and run.
Then modified the values in the new php.ini (C:\wamp\bin\apache\apache2.4.9\bin\php.ini) to those given in the OpenEMR FAQ for the entries that did exist and added the ones that didn’t exist.
Since php.ini didn’t have the following items, I placed them at the top of the file:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
register_globals = Off
; If using a php version of 5.3.9 or greater, then also need:
max_input_vars = 3000
Added the access control code per Step 6 of the OpenEMR Windows Installation instruction in the wiki, to the Apache config file at C:\wamp\bin\apache\apache2.4.9\conf\httpd.conf
Finally, to disable strict mode in MySQL. The file “my.cfg” mentioned in the install instructions is for is for *nix; in Windows the file is C:\wamp\bin\mysql\mysql5.6.17\my.ini.
To disable strict mode I put in at the top of my.ini:
sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
Obtained openemr-4.1.2.zip and followed the instructions, unzipped/ renamed/ moved the openemr-4.1.2 folder to c:\wamp\www\openemr\ then surfed to http://localhost/openemr/setup.php.
The install script proceeded through the steps as shown in the wiki page then hung on step 3 after displaying, “Connecting to MySQL Server… OK.”
I’m no php dev but looking through the setup.php it appears to have hung on line 404, trying to load the database files.
That’s my story and I’m sticking to it.
blankev wrote on Wednesday, July 02, 2014:
Harley,
this is a very nice explanation of many options to run OpenEMR, and also using a different DB packet.
Since you are the WIKI-Guru for OpenEMR do you have the intention to include this in the WIKI Pages and what will be the most optional place for this? FAQ…
It has not much to do with OpenEMR but very much with the installations Xampp, Wampp MySql PHP and a little of OpenEMR stuff to make it complete.
This is an OVERALL article worth to preserve on a different place than these Fora, an article that can be updated if new options become available.
fsgl wrote on Wednesday, July 02, 2014:
Thanks, Harley, for writing about your adventure.
Since you’re at an impasse with MySql, have you reverted to the virtualized XAMPP-OpenEMR? Any plans to upgrade to LM 17 and install Brady’s newest Ubuntu-Debian package?
You seem to be comfortable with Linux. In my online travels, Linux users tend to be a bit supercilious about Windows. See attachment.
Why retain the “inferior” operating system in the VM? Is is nostalgia? Or dare I say that Windows is not without its virtues? (I’m quite content with the “dumbed-down” version for production.)
htuckjr wrote on Wednesday, July 02, 2014:
Hi Folks-
Pieter- Me the wiki guru? Who resigned and left me in charge? I agree that docs on Windows+wampserver would make a great addition to the corpus. I posted that little fragment hoping that somebody who had years of success with Windows+wampserver (Sherwin?) might correct my mistakes and show us how to actually make it work. Then I’d be happy to write it up for the wiki.
As far as placement, I don’t think the wampserver docs need a different writeup for each OpenEMR version, do they? I’d just put the document in one place and link to it right next to the xampp links; specifically, on the ‘OpenEMR Installation Guides’ page, the Windows installation page, and in the user docs for each version. What do you think?
fsgl- I do intend to upgrade soon from my current Mint 13 to 17, though to play with (ahem, ‘test’) Brady’s Ubuntu-Debian package, I will probably make a VM of LMDE, the other Mint project which is based on Debian.
That’s a cute wallppaper- I see it going nicely in my Windows VM’s. Yes, I’m comfortable with Linux, both philosophically and in practice. I only explored wamp+Windows on a whim; I’m not good enough at Windows to go further into it. I would say MS Windows has its ‘uses’ rather than its ‘virtues’; I keep it around purely because of the unfortunate fact that it is the world- dominant computer OS. I’ve needed Windows in school because incredibly my alma mater, the State Tech Institute of Linus Torvalds’ state of residence, teaches only 1 (one) sophomore level class in Linux! Also, I haven’t outgrown all of my childishness so when I want to indulge in a little supercilliosity I throw a few barbs at the most deserving target I know of.
fsgl wrote on Thursday, July 03, 2014:
A number of forum members have gotten stuck with step 3. Perhaps a search of those threads will trigger a brainstorm.
I have had a problem running the backup utility in Brady’s new package. The stumbling block is probably related to the relocation of the web directory to var/www/html, which had occurred with the latest Ubuntu, Linux Mint and even Debian versions. Because it’s the test copy, I’ve not done too much in trying to get it to work.
The same French artist (Cathbard) who did the Tux vs. MicroSoft picture also has one of Tux on a riparian camping trip gathering Mint leaves. Very charming.
Attached are the downloads for the Greeters, or the login screens. The first is a Super Mario Brothers theme; the second, Tux gathering Mint leaves; the third, “eOS” is a primordial seascape in teal-aquamarine; the last is Tux getting ready to swat MS (shown above).
It’s not quite obvious how to install them. Feel free to ask if you encounter a problem.
fsgl wrote on Thursday, July 03, 2014:
Pimm may not disagree that Harley is Phiz, while Brady is Boz.
Having been a resident during the reign of His Majesty, GR VI, it should not be necessary to explain the analogy.
htuckjr wrote on Friday, July 04, 2014:
Searching the fora for clues about hanging at step 3 was not very productive. I had made enough poorly considered changes to my system trying to fix it that I really didn’t know what I was dealing with. The best idea came from somebody’s idle remark that made me think I ought to simply start from scratch with a new install.
That led directly to me migrating my netbook to Mint 17 and Brady’s .deb package of 4.1.2, which installed like a dream except that the gdebi panels wouldn’t stop acting like they were still installing OpenEMR after it was all finished. But that was pretty trival.
I commence to Phiz the Imitable.
fsgl wrote on Friday, July 04, 2014:
Sounds like you are ready to reign over a caliphate. Whimsical.
I agree that if OpenEMR can be installed painlessly, one should use the package. Don’t quite understand why some choose not to. Maybe it has something to do with manliness. A puzzlement.
Happy Fourth.
bradymiller wrote on Saturday, July 05, 2014:
Hi,
Unable to confirm this. I just installed the deb package via new Mint 17 install and the gdebi panel did not hang.
-brady
OpenEMR
htuckjr wrote on Tuesday, July 08, 2014:
Hi Brady-
I went back to recreate it and it worked fine again. Just like the first time the gdebi panel showed a greyed- out “Installing package” on the bottom edge after all system activity had stopped. I shut it manually and everything worked. My diagnosis is errant gamma rays.
htuckjr wrote on Tuesday, July 08, 2014:
It’s amazing to me what communicates manliness to (or by) a geek. For some it seems to be never changing how they do things until their last 8" floppy spins into dust; to others it may be imagining the balance on one’s head of a turban sporting a feather 3’ long.
fsgl wrote on Tuesday, July 08, 2014:
In my very limited Mint experience, the GDebi Installer tends to be erratic. Had to installed 16 three separate times to get it to work. Also unable to remove Ubuntu-Debian package because GDebi could not remove one of the dependencies.
With 17, took the precaution of checking the MD5 sum before copying .iso to memory stick. GDebi works more consistently and faster (took 1/2 of the time to install Brady’s package) in 17.
Nice progress on the 4.1.3 User Guide.
fsgl wrote on Tuesday, July 08, 2014:
Question for Brady:
If it had been easier to configure OpenEMR with LAMPP as a package, it would have been done. What are the reasons against a XAMPP-OpenEMR package for Ubuntu/Debian?
htuckjr wrote on Tuesday, July 08, 2014:
Gdebi required me to do “sudo apt-get install -f” to fix some missing dependencies, but then worked well afterwards. I wonder if it’s because I haven’t yet fully updated this new Mint 17 install. And so saying I will do that asap.
Re: the docs, I really wanted to get that Nav menu fully layed out- it seemed like such a necessary thing. Now I’ll proceed to fill in its details.
htuckjr wrote on Tuesday, July 08, 2014:
[editing malfunction]
Re: the docs, thanks, fsgl, for the compliment; I really wanted to get that Nav menu fully layed out- it seemed like such a necessary thing. Now I’ll proceed to fill in its details.
I was thinking of linking each major menu item to a new page describing it with new screenshots, since the interface has changed for many of them. I also wanted to cross-link the new pages to existing work such as the Supplementary Topics which don’t change as much between releases, then document the new workflows that have been developed for 4.1.3. And I am actively soliciting suggestions from any and all before I dive into that.
fsgl wrote on Tuesday, July 08, 2014:
Plans for Wiki article are very good. Loads of pictures, please.
Do you want to redo some of the videos as well? Closeups (zoom in), please.
Time to start a new thread for the 4.1.3 User Guide.
Sounds like you did an upgrade to LM 17 instead of a re-install. These are Clement LeFebvre’s reasons for re-install. I figured the man knows what he’s talking about, so I re-installed. Jack Chan in Kuala Lumpur said it took him 24 hours to upgrade to LM17.
Mintbackup did not work well probably because I didn’t understand what I was doing. It was easier to just copy the home directory and re-install gpaint, gufw, Bluefish, OpenEMR & the printer drivers. Done. Only problem is that Firefox hangs a bit, which never occurred in LM 16.
htuckjr wrote on Tuesday, July 08, 2014:
Re: LM 17, I did do a new install from bootable usb. My system has a root (/) and a /home partition so I just format / and install the new OS to it; /home stays untouched and intact, and all settings for my installed apps are carried forward to the new OS. By updating, I meant that I hadn’t updated my system with the repository changes that have occurred since the version I downloaded was released.
I feel for Jack Chan! Hope things worked out for him; when I’ve done monster updates like that I always end up with too many broken things; much faster/ cleaner to reinstall.