enginama1 wrote on Friday, September 16, 2011:
Installing 4.0.0 on linux PHP 5.2 and MySQL 5.0.
ON Step 3 it stops with the below text on page, no error_log file is generated :
OpenEMR Setup
Step 3
Configuring OpenEMR…
Connecting to MySQL Server… OK.
OK.
enginama1 wrote on Friday, September 16, 2011:
Also checked the DB, 94 tables created. Not sure if that helps.
marka1211 wrote on Friday, September 16, 2011:
make sure you have php5-mysql installed.
enginama1 wrote on Friday, September 16, 2011:
Yes I am running:
PHP version 5.2.17
MySQL version 5.0.91
I did remove everything and downloaded openemr 3.2.0 and it got this far (but stopped):
OpenEMR Setup
Step 3
Configuring OpenEMR…
Connecting to MySQL Server… OK.
Opening database…OK.
Creating Main tables… OK
Creating Language Translation (latin1) tables… Creating Language Translation (latin1) tables…
Any help???
enginama1 wrote on Friday, September 16, 2011:
Also noted collation is picking latin 1 by default, but there is nothing in the install parameters to force it to utf8 general_ci, which is the norm.
marka1211 wrote on Friday, September 16, 2011:
open a terminal window. Type:
sudo apt-get install dpkg -l php5-mysql ( <- that’s a lower case “L” after the hyphen)
In addition to having php and mysql, the php5-mysql package lets the php language connect to the database. If it isn’t installed, you get the mysterious hang you are describing.
enginama1 wrote on Friday, September 16, 2011:
I’ve got other apps installed which have worked fine…unfortunately I do not have command line access to the server.
I am trying to install this on a hosted linux web server without command line access.
marka1211 wrote on Friday, September 16, 2011:
Then how are you installing openemr?
enginama1 wrote on Friday, September 16, 2011:
ftp and cpanel
marka1211 wrote on Friday, September 16, 2011:
I’m not familiar with cpanel. Can you contact the site admin and ask them if php5-mysql is installed?
Some time ago, I purged an old openemr installation, then went to re-install the current version. It hung at Step 3, as you describe. The php5-mysql package was missing. Once that was installed, everything was fine.
enginama1 wrote on Friday, September 16, 2011:
OK I ran it with monitoring the script(through the help of my server supplier)…although the webpage stops reporting what it is doing, the php script still runs (monitoring the PID)
enginama1 wrote on Friday, September 16, 2011:
also checked with them on the php5-mysql and it’s running PHP5-mysql
marka1211 wrote on Saturday, September 17, 2011:
I don’t have anything else to offer. Step 3 is when the php code starts communicating with the mysql database, and it seems that if something isn’t working, it can wait forever without issuing an error. As I said, my problem was not having the php-mysql linkage package installed.
Good luck.
bradymiller wrote on Sunday, September 18, 2011:
Hi,
Are there any other options that you can select on the UTF-8 collation selector (specifically, ‘General’) during step 3.
-brady
enginama1 wrote on Sunday, September 18, 2011:
When starting the DB build, I am pre-building the database (as I don’t have root access, letting the install create database won’t work).
So with the install program using the ‘create database for me’ option you can set the collation.
I used the 'I have already created the database option, which doesn’t have the option to set collation.
but when I go into myphpadmin after the install has frozen in step 3, the tables collation are all set to latin1_swedish_ci, so I’m wondering if the collation is the problem and where would I go to force the install to use utf8?
I checked on the phpmyadmin page and the MySQL connection collation is set to utf8.
Does this info help or am I just going down the wrong path?
Thanks for all your help
bradymiller wrote on Monday, September 19, 2011:
Hi,
This may not fix your issue, but it’s definitely desirable to use UTF8 rather than latin1 for your database encoding. The encoding is set up when you pre-build the database; if your using phpmyadmin to pre-build the database then there should be this option when you create the new database (if not, then would ask your site admin). Let us know how this goes.
-brady
enginama1 wrote on Monday, September 19, 2011:
mysqladmin is what is used to build the db and there are no collation options for database creation.
MyPHPadmin is what would be used to build the tables and the collation option is set there … but it auto defaults to utf8, so on table creation is their something in the script which defines collation I can edit?
jojohit wrote on Monday, September 19, 2011:
Can you try creating a test table using phpMyAdmin and using the same root account parameters that you use in the setup ?