install.php returns an empty page

[Patrick]

Hi all,
I'm a linux admin, new to refbase, and I try to setup a test VM. My OS is Alma Linux 8 (RHEL8). But loading install.php returns an empty page.
Prerequisites are deployed from rpms.
- Apache is working
- php 7.2.24 is working (I can load a basic php page, just calling phpinfo(), remotely in a web browser)
- mysql 8.0.26 is working.

I've tried a manual setup but install.sql is not correct with mysql 8.0.26: I had to change all occurences of TYPE=MyISAM by ENGINE=MyISAM and the the script execute successfuly to create all the tables using mysql -u root -p --database=xxxxxx < install.sql

But index.php still returns an empty page.

Thanks for your help.
Patrick

[Knut]

What about the error.log?
I do not know RHEL but it should be at /var/log/httpd/error_log

[Patrick]

Hi Knut,
thanks for replying. I worked a little bit on this problem this morning. There ar nothing interesting ins access and error files. I ran the install.php file with "php install.php" and get an error message of a missing ";" at the end of the url I had set (my fault). So now I reach the first page, giving the password for the database but again if I click on "install" I get an empty page in firefox.
I've dropped the database created manualy from the script, but it did not help.
Launching "php install.php" give a lot of warnings but may be it is because it is not running within a web browser ? I've very little experience with PHP.

PHP Warning:  include(initialize/db.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 25
PHP Warning:  include(): Failed opening 'initialize/db.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 25
PHP Warning:  include(initialize/ini.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 26
PHP Warning:  include(): Failed opening 'initialize/ini.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 26
PHP Warning:  include(includes/transtab_unicode_ascii.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 29
PHP Warning:  include(): Failed opening 'includes/transtab_unicode_ascii.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 29
PHP Warning:  include(includes/transtab_latin1_ascii.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 30
PHP Warning:  include(): Failed opening 'includes/transtab_latin1_ascii.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 30
PHP Warning:  include(includes/transtab_unicode_latin1.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 31
PHP Warning:  include(): Failed opening 'includes/transtab_unicode_latin1.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 31
PHP Warning:  include(includes/transtab_unicode_refbase.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 32
PHP Warning:  include(): Failed opening 'includes/transtab_unicode_refbase.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 32
PHP Notice:  Undefined variable: contentTypeCharset in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 34
PHP Warning:  include_once(includes/transtab_latin1_charset.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 37
PHP Warning:  include_once(): Failed opening 'includes/transtab_latin1_charset.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 37
PHP Notice:  Undefined index: HTTP_HOST in /var/www/html/refbase-0.9.6/initialize/ini.inc.php on line 82
PHP Warning:  preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /var/www/html/refbase-0.9.6/initialize/ini.inc.php on line 82
PHP Warning:  include(includes/transtab_refbase_html.inc.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/initialize/ini.inc.php on line 790
PHP Warning:  include(): Failed opening 'includes/transtab_refbase_html.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/initialize/ini.inc.php on line 790
PHP Notice:  Undefined variable: transtab_refbase_html in /var/www/html/refbase-0.9.6/initialize/ini.inc.php on line 801
PHP Warning:  include(locales/core.php): failed to open stream: No such file or directory in /var/www/html/refbase-0.9.6/includes/locales.inc.php on line 26
PHP Warning:  include(): Failed opening 'locales/core.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/refbase-0.9.6/includes/locales.inc.php on line 26
....
PHP Warning:  preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in /var/www/html/refbase-0.9.6/includes/include.inc.php on line 2046

Patrick

[Knut]

you should launch install.php with the webbrowser. Than you can proceed with the installation process.
your https://yourRefbasedomain.com/install.php
and yourRefbasedomain.com schoul point to the directory where install.php is located.

Does the "failed to open stream:" error occur at the console or with web browser?

[Patrick]

When using a browser, after setting the root password for the Mysql Administrator and launch install, I get an empty page in firefox (checked with acces to the raw content of the page after waiting several minutes).
So I try to debug with the console to check errors or warnings. And this is what I report but may be it is a bad idea to launch install in a console. My goal was to check if something was going wrong whith install.php.

[Knut]

What about

Important note:
Before executing this script, it is highly recommended to open the include file initialize/db.inc.php in a text editor and edit the values of the variables $databaseName, $username and $password to suit your setup! Then, proceed with this form: 

and did you try the credentials form the console?

[Knut]

As i know you can fill in the credentials and import the install.sql with console access

[Patrick]

Yes of course. I've set the variables.
Mysql is working too.
Now I'm using the svn repo as version 0.9.6 doesn't seam to support php7 and things get a little bit better with PHP. Now it is Mysql 8.6 that do not accept "IDENTIFIED BY" tokens in the GRANT command. I remove it fom the command but I've again a syntax error with the CREATE DATABASE... some lines after.
If think I am going to use a CentOS7 VM insted of RHEL8 with older Mysql, older PHP to test refbase even if some tools like PHP5 are not maintained anymore. I'm not enought familar with PHP and Mysql to track these errors.

[Knut]

And by the way, I am using php 5.6.33 for the refbase

php 7.2 f.e throws: stderr: PHP Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in