phyzeeks wrote on Saturday, March 11, 2006:
Hello All:
I posted a while back about a starting pediatric office interested in using this system. I was side tracked by other projects. But I have finally installed it on a Fedora Core 4 system.
First I tried installing it on a Win2K system.
Setup:
PC - P4 2.8GHz
OS - Win2K Service Pack 4 and all updated
Web Server - Apache 2.0.55
DB Server - MySQL 4.1.11
PHP - 4.4.2
I ran into some problems with the “setup.php” execution.
A. Setup.php couldn’t create DB
B. Setup.php couldn’t create all tables.
The setup started fine until I went to create the databases and I got the:
“Client does not support authentication protocol requested
by server; consider upgrading MySQL client” Error 1251.
I tried on two seperate PC’s running Win2K and the same error surfaced.
I solved the error by using the restting the password to an old standard -
"Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR
-> ‘some_user’@‘some_host’ = OLD_PASSWORD(‘newpwd’);"
And modifying the setup.php code to do the same for the created user for OpenEMR.
The setup was able to create the Database, next came the creation of the tables.
This one is truely odd since i cannot create it consistently. The setup would start to create the tables but it would suddenly stop in the middle and leave the page that comes up on step 3 is stuck on “creating tables” , I believe, on the “file dump”/“file upload” portion of the code.
It creates only 6 tables and stops at random points in the database.sql file. But at least it stops in the 6th table fill reliably. I have not been able to figure this one out and will post more on this issue in coming weeks.
In the meantime, it installed beautifully on my Fedora Core 4 Machine and I will be playing around with it alot in the coming weeks.
Thanks and I hope this is the right part of the Forum to Post this stuff up on.
Gabriel Campos
San Antonio, TX