Fresh install, not talking to databse

[riomaha]

Hi,

My issue is that somehow the new installation is talking to the database but not able to write to it or perform some functions.

I know it can read from the database server and write to it because the install created the tables, and the new admin account. When I point to an older DB, it shows list of products listed.

However, when I try to login, or user wrong password to login as admin, no record of me ever trying to login is recorded in DB. The database user has full access to the schema, and I am connecting to the proper schema and server.

I tried with different browsers, over SSL and without, and I tried to manually define the admin path.

I am not new to installing ZC but we all have our moments. I am running a RHEL7, Apache 2.4, PHP7.2 with ZC 1.5.6a. I have done a fresh install not modifications. My httpd.conf has the following

<Directory "/opt/rh/httpd24/root/var/www/html/folder">
    AllowOverride All
    Order allow,deny
    allow from all
</Directory>

and

    RewriteEngine On
    RewriteCond %{REQUEST_METHOD} ^(TRACE|TRACK)
    RewriteRule .* - [F]
Header set Set-Cookie HttpOnly;Secure

P.S. I tried remove the 2nd part of the code and restarted httpd and still no luck on my issue.

my .htaccess files are generic.
When I hit the admin login page, I can't login, no errors messages on page. When I try to go to store front and create a user account, I get session timed out. I looked at the database and there are no records of invalid logins, or password reset requests.

I have an older ZC installed 1.5.5a which was working fine with PHP 5.4 and 7.1 but I was told I have to move on to PHP7.2. Since installing PHP 7.2, the old installation isn't talking to the database either "e.g. recording invalid logins" again for old or new installation. I know 1.5.5a doesn't work with PHP7.2.

to recap, I don't have unusual .htaccess files, my httpd.conf is simple, my Selinux is set to enforcing fresh install, new database schema, folder permissions are properly set.

any help is greatly appreciated.

[riomaha]

Just to add to that, My server log indicate

[Thu Jan 10 15:51:36.544929 2019] [core:notice] [pid 22524] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Thu Jan 10 15:51:36.546302 2019] [suexec:notice] [pid 22524] AH01232: suEXEC mechanism enabled (wrapper: /opt/rh/httpd24/root/usr/sbin/suexec)
[Thu Jan 10 15:51:36.572506 2019] [http2:warn] [pid 22524] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.
[Thu Jan 10 15:51:36.573053 2019] [lbmethod_heartbeat:notice] [pid 22524] AH02282: No slotmem from mod_heartmonitor
[Thu Jan 10 15:51:36.595066 2019] [mpm_prefork:notice] [pid 22524] AH00163: Apache/2.4.34 (Red Hat) OpenSSL/1.0.2k-fips PHP/7.2.10 configured -- resuming normal operations
[Thu Jan 10 15:51:36.595100 2019] [core:notice] [pid 22524] AH00094: Command line: '/opt/rh/httpd24/root/usr/sbin/httpd -D FOREGROUND'

When I tried disabling mpm and enabling mpm event and/or worker, httpd wont restart.

[Design75]

I am not a server expert, but if you want to use http2, mpm_prefork does not work, youneed to enable mpm_event

Just to add to that, My server log indicate

[Thu Jan 10 15:51:36.544929 2019] [core:notice] [pid 22524] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Thu Jan 10 15:51:36.546302 2019] [suexec:notice] [pid 22524] AH01232: suEXEC mechanism enabled (wrapper: /opt/rh/httpd24/root/usr/sbin/suexec)
[Thu Jan 10 15:51:36.572506 2019] [http2:warn] [pid 22524] AH10034: The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive.
[Thu Jan 10 15:51:36.573053 2019] [lbmethod_heartbeat:notice] [pid 22524] AH02282: No slotmem from mod_heartmonitor
[Thu Jan 10 15:51:36.595066 2019] [mpm_prefork:notice] [pid 22524] AH00163: Apache/2.4.34 (Red Hat) OpenSSL/1.0.2k-fips PHP/7.2.10 configured -- resuming normal operations
[Thu Jan 10 15:51:36.595100 2019] [core:notice] [pid 22524] AH00094: Command line: '/opt/rh/httpd24/root/usr/sbin/httpd -D FOREGROUND'

When I tried disabling mpm and enabling mpm event and/or worker, httpd wont restart.

[mc12345678]

Verify the settings/differences in the DB_XXX settings of includes/configure.php and YOUR_SECRET_ADMIN/includes/configure.php. They should be the same for both files.

Next would be to review any php.ini file that you have as it almost sounds like there may be a sessions issue, especially if each php version references a different php.ini file (as in the php.ini file for your earlier php version worked fine, but when upgrading, the php.ini file applied against your newer version may not have some of the same values).

If you create a file like php_info.php that contains the following:

<?php echo php_info();

and access the file from your browser you can search for sessions and identify your session settings.

I don't believe that this is related to .htaccess.

[riomaha]

Than you guys. I believe I resolved the issue. I simply uninstalled httpd24 all packages and reinstalled the ones below

httpd24.x86_64 
httpd24-httpd.x86_64 
httpd24-httpd-tools.x86_64 
httpd24-libnghttp2.x86_64 
httpd24-mod_ssl.x86_64 
httpd24-runtime.x86_64

Thanks a million. I am loving the new admin page for 1.5.6. Too bad there aren't more pre-builtin modules like COWA or ability to define product weights. I would love to see more shipping modules too but I could see that being an issue since providers might make changes to their tools.