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