It says “Configuring OpenEMR”, then “Connecting to MySQL Server…”
then nothing. It will not return an error message, or connect, it just sits there saying connecting; however, it says ‘done’ in the bottom left of the firefox window. MySQL and PHP are both configured, up, and running. Trying to install through Fedora, btw.
hey,
I’m guessing your php is haveing problems communicating with your mysql server. Check your php log. If can’t fix from that then paste the log here, and give what openemr package your using ( 3.0.1, cvs, cvs-3.1.0) and your mysql/php versions.
-brady
Hi, thanks for the response.
I’m using openemr v. 3.0.1, mysql v. 5.0.77, PHP v. 5.2.9, using Fedora
I didn’t have any php error log, so I edited the ‘php.ini’ file, error_log was blank so i set it to /var/log/php-errors.log. However, it won’t write anything to that file, it remains empty.
One more thing, I realized I had to install odbc. In case this is relevant, this is what my system shows now:
rpm -qa | grep -i odbc
libgda-odbc-3.1.2-6.fc10.i386
unixODBC-2.2.12-9.fc10.i386
libgda-odbc-devel-3.1.2-6.fc10.i386
libiodbc-3.52.6-4.fc10.i386
libiodbc-devel-3.52.6-4.fc10.i386
mysql-connector-odbc-5.1.5-0.i386
ogdi-odbc-3.2.0-0.12.beta2.fc10.i386
php-odbc-5.2.9-2.fc10.i386
mysql-connector-odbc-3.51.26r1127-1.fc10.i386
hey,
I forgot to mention ensure the following php settings in php.ini are set (also include the log_errors flag):
short_open_tag = On
max_execution_time = 60
max_input_time = 90
memory_limit = 128M
display_errors = Off
log_errors = On
register_globals = Off
post_max_size = 30M
magic_quotes_gpc = On
file_uploads = On
upload_max_filesize = 30M
I changed those settings, also restarted the server. For some reason the thing STILL won’t write to the designated file, however I can read the error log through syslog. When I run the openemr setup, it hits me with about 30 “Undefined Index” errors like this:
PHP Notice: Undefined index: server in /srv/www/htdocs/openemr-3.0.1/setup.php on line 110
Undefined index: port in /srv/www/htdocs/openemr-3.0.1/setup.php on line 111
Undefined index: dbname in /srv/www/htdocs/openemr-3.0.1/setup.php on line 112
Undefined index: root in /srv/www/htdocs/openemr-3.0.1/setup.php on line 113
Undefined index: login in /srv/www/htdocs/openemr-3.0.1/setup.php on line 114
and it keeps going for about 20 more errors
But I downloaded the openemr file from sourceforge?? It seems like files are unconfigured or missing.
However I suspect the problem is this line, the last error it reports: PHP Fatal error: Call to undefined function mysql_connect() in /srv/www/htdocs/openemr-3.0.1/setup.php on line 209
I think the ‘Undefined index’ are just benign warnings. I think setting following in your php.ini will avoid filling your syslog with this benign stuff:
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
Sounds like you may need the php-mysql module for Fedora.
I’m having the exact same problem with Windows. I’ve had MySQL and Apache 2.0.52. running on this computer for about a year, so I downloaded php5. I created a database “openemr” and assigned a user “openemr” with password “open3emr”; I can use those credentials to log onto the local instance of MySQL. And this php script works:
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
echo ‘<p>This is a <i>test</i> of php</p>’;
$dbhost = ‘localhost’;
$dbuser = ‘openemr’;
$dbpass = ‘open3emr’;
echo ‘<p>Created variables OK</p>’;
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
echo ‘<p>executed mysqli_connect</p>’;
if ($conn)
{ echo ‘connected!<br/>’;
}
if (!$conn)
{
echo ‘<p>Unable to connect to MySQL localhost</p>’;
}
$dbname = ‘openemr’;
echo ‘<p>selecting openemr database</p>’;
if (mysqli_select_db($conn,$dbname))
{
echo ‘<p>Connected to database ‘.$dbname.’</p>’;
}
?>
</body>
</html>
I get a web page that gives me all the messages I expect, ending in the one for a successful connection to the database openemr.
But when I run the setup.php script, it hangs at “Connecting to MySQL Server…”
I also can’t get any error messages to show in the error log.
I’m not very familiar with php; I’ve tried making the recommended changes to the php.ini script.
Any help is appreciated.