Problem during upgrade from 1.5.0 to 1.5.2

[george1421]

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

[lebrun78]

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]

@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]

@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]

@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]

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]

@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.

1. Install FOG until it says to connect to the web management page to update the database.

2. 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.

3. Update the following file: /etc/httpd/conf.d/fog.conf

4. 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

5. Save and exit your text editor
6. Restart apache service httpd restart
7. Return to the web browser and access the management page to update the database as normal.
8. Finish the FOG setup in the first window where you started the FOG installation.
9. 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]

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]

@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.

[lebrun78]

@george1421
Ok great