Problem during upgrade from 1.5.0 to 1.5.2

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421 said in Problem during upgrade from 1.5.0 to 1.5.2:

sudo ps aux|grep php-fpm

My server is running on centos 6.9

[root@fogus ~]# sudo php -v
PHP 5.6.35 (cli) (built: Mar 29 2018 07:37:47) 
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
[root@fogus ~]# sudo ps aux|grep php-fpm
root      8254  0.0  0.1 383720  6976 ?        Ss   12:04   0:00 php-fpm: master process (/etc/php-fpm.conf)
apache    8255  0.0  0.1 395964  6948 ?        S    12:04   0:00 php-fpm: pool www            
apache    8256  0.0  0.1 395964  6948 ?        S    12:04   0:00 php-fpm: pool www            
apache    8257  0.0  0.1 395964  6948 ?        S    12:04   0:00 php-fpm: pool www            
apache    8258  0.0  0.1 395964  6952 ?        S    12:04   0:00 php-fpm: pool www            
apache    8259  0.0  0.1 395964  6952 ?        S    12:04   0:00 php-fpm: pool www            
root      8586  0.0  0.0 103348   860 pts/1    S+   13:52   0:00 grep php-fpm

george1421

@lebrun78 This next step will tell us if the php engine is working correctly.

Create a new file /var/www/html/fog/phpinfo.php

Insert the following text into it.

<html>
<body>

<?php
 phpinfo();
?>

</body>
</html>

Save and exit the editor.

Then call that web page using a broswer http://<fog_server_ip>/fog/phpinfo.php
Tell me what the server api value says.

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421
I get nothing

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

I have also no error neigther in apache log nor in php-fpm log.

george1421

@lebrun78 it doesn’t even display just the php code? That IS very strange.

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

Before update fog , I have updated centos (just yum update) , it has updated many packages:

Apr 13 11:54:49 Updated: php-common-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:49 Updated: php-mbstring-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:49 Updated: php-xml-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:49 Updated: php-symfony-common-2.8.38-1.el6.remi.noarch
Apr 13 11:54:49 Updated: php-symfony-class-loader-2.8.38-1.el6.remi.noarch
Apr 13 11:54:49 Updated: libgcc-4.4.7-18.el6_9.2.x86_64
Apr 13 11:54:50 Updated: libstdc++-4.4.7-18.el6_9.2.x86_64
Apr 13 11:54:50 Updated: php-cli-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:50 Updated: php-process-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:50 Updated: libsss_idmap-1.13.3-58.el6_9.x86_64
Apr 13 11:54:50 Installed: php-PsrLog-1.0.2-2.el6.remi.noarch
Apr 13 11:54:50 Installed: php-symfony-process-2.8.38-1.el6.remi.noarch
Apr 13 11:54:50 Updated: php-symfony-expression-language-2.8.38-1.el6.remi.noarch
Apr 13 11:54:50 Updated: php-pdo-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:51 Updated: php-phpmyadmin-motranslator-4.0-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-symfony-filesystem-2.8.38-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-symfony-finder-2.8.38-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-symfony-yaml-2.8.38-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-symfony-config-2.8.38-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-symfony-dependency-injection-2.8.38-1.el6.remi.noarch
Apr 13 11:54:51 Installed: php-twig-1.35.3-1.el6.remi.5.6.x86_64
Apr 13 11:54:51 Updated: php-bcmath-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:51 Updated: libipa_hbac-1.13.3-58.el6_9.x86_64
Apr 13 11:54:51 Updated: 12:dhcp-common-4.1.1-53.P1.el6.centos.3.x86_64
Apr 13 11:54:52 Updated: php-phpmyadmin-sql-parser-4.2.4-3.el6.remi.noarch
Apr 13 11:54:52 Updated: php-mysqlnd-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:52 Installed: php-symfony-debug-2.8.38-1.el6.remi.noarch
Apr 13 11:54:52 Installed: php-jsonlint-1.7.1-1.el6.remi.noarch
Apr 13 11:54:52 Installed: php-justinrainbow-json-schema5-5.2.7-1.el6.remi.noarch
Apr 13 11:54:53 Updated: libstdc++-devel-4.4.7-18.el6_9.2.x86_64
Apr 13 11:54:54 Installed: libicu-last-50.1.2-11.el6.remi.x86_64
Apr 13 11:54:54 Installed: php-intl-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:54 Installed: php-symfony-css-selector-2.8.38-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-symfony-dom-crawler-2.8.38-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-symfony-browser-kit-2.8.38-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-password-compat-1.0.4-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-composer-semver-1.4.2-2.el6.remi.noarch
Apr 13 11:54:54 Installed: php-seld-cli-prompt-1.0.3-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-paragonie-random-compat-2.0.11-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-symfony-polyfill-1.7.0-2.el6.remi.noarch
Apr 13 11:54:54 Installed: php-symfony-http-foundation-2.8.38-1.el6.remi.noarch
Apr 13 11:54:54 Installed: php-composer-ca-bundle-1.1.1-1.el6.remi.noarch
Apr 13 11:54:54 Updated: php-tidy-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:54 Updated: php-gmp-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:54 Updated: php-phpseclib-2.0.10-2.el6.noarch
Apr 13 11:54:54 Installed: php-seld-phar-utils-1.0.1-2.el6.remi.noarch
Apr 13 11:54:54 Installed: php-composer-spdx-licenses-1.3.0-1.el6.remi.noarch
Apr 13 11:54:54 Updated: php-recode-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:54 Installed: php-psr-container-1.0.0-1.el6.remi.noarch
Apr 13 11:54:54 Updated: gd-last-2.2.5-2.el6.remi.x86_64
Apr 13 11:54:54 Updated: php-gd-5.6.35-1.el6.remi.x86_64
Apr 13 11:54:55 Updated: php-tcpdf-6.2.17-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony-var-dumper-2.8.38-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony-console-2.8.38-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony-event-dispatcher-2.8.38-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony-http-kernel-2.8.38-1.el6.remi.noarch
Apr 13 11:54:55 Installed: composer-1.6.3-3.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony3-common-3.4.8-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-symfony3-translation-3.4.8-1.el6.remi.noarch
Apr 13 11:54:55 Installed: php-twig-extensions-1.5.1-1.el6.remi.noarch
Apr 13 11:54:56 Updated: sssd-client-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-common-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-krb5-common-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-common-pac-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-ipa-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-ad-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-krb5-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-ldap-1.13.3-58.el6_9.x86_64
Apr 13 11:54:56 Updated: sssd-proxy-1.13.3-58.el6_9.x86_64
Apr 13 11:55:00 Updated: kernel-firmware-2.6.32-696.23.1.el6.noarch
Apr 13 11:55:06 Installed: kernel-2.6.32-696.23.1.el6.x86_64
Apr 13 11:55:06 Updated: libgomp-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:06 Updated: python-sssdconfig-1.13.3-58.el6_9.noarch
Apr 13 11:55:07 Updated: cpp-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:08 Updated: gcc-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:09 Updated: libgfortran-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:10 Updated: gcc-gfortran-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:10 Updated: gcc-c++-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:10 Updated: sssd-1.13.3-58.el6_9.x86_64
Apr 13 11:55:11 Updated: 2:irqbalance-1.0.7-8.el6_9.1.x86_64
Apr 13 11:55:13 Updated: phpMyAdmin-4.8.0-2.el6.remi.noarch
Apr 13 11:55:13 Updated: php-tcpdf-dejavu-sans-fonts-6.2.17-1.el6.remi.noarch
Apr 13 11:55:13 Updated: 12:dhcp-4.1.1-53.P1.el6.centos.3.x86_64
Apr 13 11:55:13 Updated: 12:dhclient-4.1.1-53.P1.el6.centos.3.x86_64
Apr 13 11:55:13 Updated: python-libipa_hbac-1.13.3-58.el6_9.x86_64
Apr 13 11:55:14 Updated: php-5.6.35-1.el6.remi.x86_64
Apr 13 11:55:23 Updated: firefox-52.7.2-1.el6.centos.x86_64
Apr 13 11:55:26 Updated: libgcj-4.4.7-18.el6_9.2.x86_64
Apr 13 11:55:26 Updated: php-ldap-5.6.35-1.el6.remi.x86_64
Apr 13 11:55:27 Updated: php-fpm-5.6.35-1.el6.remi.x86_64
Apr 13 11:55:27 Updated: php-mcrypt-5.6.35-1.el6.remi.x86_64
Apr 13 11:55:28 Updated: kernel-headers-2.6.32-696.23.1.el6.x86_64
Apr 13 11:55:28 Updated: python-sss-murmur-1.13.3-58.el6_9.x86_64
Apr 13 11:55:28 Updated: 1:libvorbis-1.2.3-5.el6_9.1.x86_64
Apr 13 11:55:28 Updated: libzip5-1.5.1-1.el6.remi.x86_64
Apr 13 11:55:36 Installed: kernel-devel-2.6.32-696.23.1.el6.x86_64
Apr 13 11:55:36 Updated: tzdata-java-2018d-1.el6.noarch
Apr 13 11:55:37 Updated: tzdata-2018d-1.el6.noarch

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421
nothing

george1421

@lebrun78 Would you post the output of this file.
/etc/httpd/conf.d/fog.conf ?

I’m looking specifically for this section

    <FilesMatch "\.php$">
        SetHandler "proxy:fcgi://127.0.0.1:9000/"
    </FilesMatch>

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421 said in Problem during upgrade from 1.5.0 to 1.5.2:

/etc/httpd/conf.d/fog.conf

I restored my server, I have just updated fog, not centos. and I get the same problem.

Here is what you requested

[root@fogus bin]# cat /etc/httpd/conf.d/fog.conf
<VirtualHost *:80>
    <FilesMatch "\.php$">
        SetHandler "proxy:fcgi://127.0.0.1:9000/"
    </FilesMatch>
    KeepAlive Off
    ServerName 148.60.15.217
    DocumentRoot /var/www/html/
    RewriteEngine On
    RewriteCond %{REQUEST_METHOD} ^(TRACE|TRACK)
    RewriteRule .* - [F]
    <Directory /var/www/html/fog/>
        DirectoryIndex index.php index.html index.htm
        RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-f
        RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_FILENAME} !-d
        RewriteRule ^/(.*)$ /fog/api/index.php [QSA,L]
    </Directory>
</VirtualHost>

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421
That seems to be working :

 netstat -natp |grep 9000
tcp        0      0 127.0.0.1:9000              0.0.0.0:*                   LISTEN      4837/php-fpm ```

george1421

I guess I need to debug this in my home lab. I did just happen to spin up a centos 6.9 instance last night to compile dnsmasq under centos 6.9. I guess I can install FOG on it and see if I get the same results. What you are saying doesn’t connect the dots. It appears everything is running, and yet its not.

Just for clarity you only have FOG running on the fog server, its not shared with another service right?

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

Yes only one fog server on this computer (libvirt virtual machine)

Wayne Workman

@george1421 said in Problem during upgrade from 1.5.0 to 1.5.2:

@lebrun78 it doesn’t even display just the php code? That IS very strange.

Permissions…

@lebrun78 Set the ownership of the file to apache:apache and see what happens. Also, you put the file inside of /var/www/html right? Or was it just /var/www on centos 6? idk.

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@wayne-workman
For the test /var/www/html/fog/phpinfo.php I set apache.apache and 775.
It did not work better

Wayne Workman

@lebrun78 Try to temporarily turn off SELinux with setenforce 0

george1421

I confirmed that this happens with FOG 1.5.1 or 1.5.2 running on Centos 6.9. I didn’t have time this weekend to fully debug but I have a short term work around.

Install FOG until it says to connect to the web management page to update the database.
Open a second connection to your fog server, for example using putty. The idea is to keep the installer waiting for you to update the database while you make this adjustment.
Update the following file: /etc/httpd/conf.d/fog.conf
Update the code to look like this. We need to comment out instruction to use php-fpm and to reenable the apache internal php engine.

<VirtualHost *:80>
    <FilesMatch "\.php$">
        #SetHandler "proxy:fcgi://127.0.0.1:9000/"
        SetHandler application/x-httpd-php
    </FilesMatch>
    KeepAlive Off
    ServerName 148.60.15.217

Save and exit your text editor
Restart apache service httpd restart
Return to the web browser and access the management page to update the database as normal.
Finish the FOG setup in the first window where you started the FOG installation.
Done.

I’m going to look into why this is happening. I just didn’t have as much extra time this weekend to understand why.

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

Thank you George, it works.
I have just add the line “SetHandler application/x-httpd-php”

george1421

@lebrun78 Make sure you comment out the “proxy:fcgi://127.0.0.1:9000/” entire line or you may get unexpected results. The pound (hashtag) at the start of the line indicates it commented out.

lebrun78 · Fog Version: Fog 1.5.10 Server OS: AlmaLinux release 8.8

@george1421
Hello,
This problem reapair updating to 1.5.3 on my test server running with centos 6.9.
The solution you proposed is always available.

Thank you for you work

george1421

@lebrun78 Just to let you know the developers added this function to what will be FOG 1.5.4 (when it is released) so you will not have to do this patch in the future.

Problem during upgrade from 1.5.0 to 1.5.2

167

12.0k

17.3k

155.2k