Openemr setup hangs in FEMP stack

Management and Administration
#1

Ok, here is my setup. I have been at this for days. I need help.
FreeBSD 12.1
Nginx 1.18
Mysql 8.0
PHP 7.4
I would like to make this work. However, my logs are not very forthcoming at all.
The install is hanging at the setup step:

Nginx error log says:

2020/04/29 00:14:00 [error] 6023#100984: *1 FastCGI sent in stderr: “PHP message: PHP Notice: Undefined index: collate in /usr/local/www/openemr/setup.php on line 984” while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: myserver.com, request: “POST /setup.php?site=default HTTP/2.0”, upstream: “fastcgi://unix:/tmp/php-fpm.sock:”, host: “myserver.com”
2020/04/29 00:15:00 [error] 6023#100984: *1 upstream timed out (60: Operation timed out) while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: myserver.com, request: “POST /setup.php?site=default HTTP/2.0”, upstream: “fastcgi://unix:/tmp/php-fpm.sock”, host: “myserver.com”

php-fpm log just says:

ready to handle connections

I am not sure how to see the MySQL 8 log, but I have created the openemr user, with the mysql_native_password, and the database has been created. The problem started initially, when the program attempted to switch to the openemr user. I noticed that it had not been given privileges, so I set that up manually in Mysql 8.
Still, the install is not progressing.

Any advice will be greatly appreciated.

Sandra

Project - Hybrid App with Image Processing
#2

I dropped the database and restarted setup. Now I get this message from openemr:

ERROR . unable to execute SQL: ‘INSERT INTO lang_definitions VALUES (109553, 584, 23, ‘E’ stato creato e linkato un oggetto GCAC incompleto. E’ necessario completarlo in seguito.’)’ due to: Writing one row to the row-based binary log failed

Sandra

#3

Hi Sandra,

MySQL 8 broke some things in the codebase. You may want to consider using a slightly older version.

If MySQL 8 is a hard requirement there should hopefully be some fixes in the next patch.

#4

I see, so no one has been able to set up openemr with MySQL 8?

#5

hi @gutiersa, pretty sure it’s running, haven’t loaded the insane environment in a little while but sounds like it’s time to check in on it.

#6

Hi Sandra,

Looks like the patch with some MySQL 8 fixes was just posted a few hours ago.

Are you using docker? If you repull the flex docker it might fix things for you.

1 Like
#7

Unfortunately docker is broken for FreeBSD.

#8

Apart from few checks, primary task of setup is running mysql LOAD statement. If you are developer, you can help by loading database.sql directly - either from shell or other tools like phpmyadmin. If import is ok that eliminates mysql setup issues and isolates problem to setup.exe load code.

1 Like
#9

Ok, then. This is my setup now:
FreeBSD 12.1
Nginx 1.18
Mysql 5.7
PHP 7.4
OpenSSL 1.1.1d-freebsd
Openemr 5.0.2 patch 2

I am able to install openemr but when login in as the administrator, I get the blank screen.
My address bar has:

https://example.com/interface/main/tabs/main.php?token_main=a really long string here.

My error logs are pretty useless.

#10

Seems that it is my very aggressive SSL configuration that is breaking my install.
I will update this thread when I know more.

#11

I haven’t checked the docker or a specific release but but the master source code works fine with mysql8. I haven’t caught up in any error since i started. I can try setting up a same enviornmt as yours if you are still planning to use mysql8 .

#12

Yes, I think it is important for improved security.

#13

It will be a great help to reproduce the error If you can specify the instruction you followed to run openemr with mysql.