[Rev 4201] blank page when trying to install/update database schema

[Stefan Kaegi]

Hi,

I updated my Debian wheezy system via ‘apt-get update && apt-ger upgrade’. After that I also updated to the new subversion (4201) of fog.
When I run ‘./installfog.sh’ everything looks ok. But when I try to update the database schema via ‘http://172.30.40.25/fog/management’ I only see a blank page. I tried to skip the database update and finish the installation. But all i can see now when going to ‘http://172.30.40.25/fog’ or ‘http://172.30.40.25/fog/management’ is a blank page. Hard refreshing the page didn’t help.

Debian GNU/Linux 7.9 (wheezy)
fog svn 4201

Thanks for your help.
Stefan

[Tom Elliott]

Can you try again and immediately after it blanks grab a copy of the error logs from Apache and post them here?

[george1421]

Just a contributor here:

We had a similar issue here after a trunk upgrade. The OP needs to check the Apache error log in (at least in the Redhat realm) /var/log/httpd/error_log

The OP can run the <…>/fog/management/ url to generate the blank page then immediately run this command from the linux console.

tail /var/log/httpd/error_log

That should show the OP the error that generated the blank page.

[irishfoguser]

Hi i got this as well apache log

Fri Oct 23 13:00:02 2015] [notice] Apache/2.2.22 (Debian) mod_ssl/2.2.22 OpenSSL/1.0.1e configured -- resuming normal operations
[Fri Oct 23 13:01:12 2015] [error] [client ::1] File does not exist: /var/www/favicon.ico
[Fri Oct 23 13:02:04 2015] [error] [client 192.168.2.1] PHP Fatal error:  Call to a member function query() on null in /var/www/html/fog/lib/fog/FOGCore.class.php on line 276
[Fri Oct 23 13:02:04 2015] [error] [client 192.168.2.1] File does not exist: /var/www/favicon.ico
[Fri Oct 23 13:02:14 2015] [error] [client ::1] PHP Fatal error:  Call to a member function query() on null in /var/www/html/fog/lib/fog/FOGCore.class.php on line 276
[Fri Oct 23 13:06:14 2015] [error] [client ::1] PHP Fatal error:  Call to a member function query() on null in /var/www/html/fog/lib/fog/FOGCore.class.php on line 276
[Fri Oct 23 14:27:52 2015] [notice] caught SIGTERM, shutting down
[Fri Oct 23 14:29:53 2015] [notice] Apache/2.2.22 (Debian) mod_ssl/2.2.22 OpenSSL/1.0.1e configured -- resuming normal operations
[Fri Oct 23 14:29:58 2015] [notice] Graceful restart requested, doing restart
apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
[Fri Oct 23 14:29:58 2015] [notice] Apache/2.2.22 (Debian) mod_ssl/2.2.22 OpenSSL/1.0.1e configured -- resuming normal operations
[Fri Oct 23 14:33:36 2015] [notice] caught SIGTERM, shutting down
[Fri Oct 23 14:48:41 2015] [notice] Apache/2.2.22 (Debian) mod_ssl/2.2.22 OpenSSL/1.0.1e configured -- resuming normal operations
[Fri Oct 23 14:51:11 2015] [error] [client ::1] PHP Fatal error:  Call to a member function query() on null in /var/www/html/fog/lib/fog/FOGCore.class.php on line 276
[Fri Oct 23 14:51:11 2015] [error] [client ::1] File does not exist: /var/www/favicon.ico```

also is this still the way to get the latest fog svn?

svn co https://svn.code.sf.net/p/freeghost/code/trunk /opt/fog_latest
cd /opt/fog_latest/bin
./installfog.sh

[Joseph Hales]

This is what I use.

 sudo svn checkout https://svn.code.sf.net/p/freeghost/code/trunk

[Wayne Workman]

I suppose this is as good a time as ever to recommend the troubleshooting script…

https://forums.fogproject.org/topic/4581/let-s-make-scripts

[Stefan Kaegi]

My error.log is 260M! I attached the end of the file.
error.log

[Stefan Kaegi]

And here the logfile of the troubleshooting script:
FOGtroubleshoot.log

[Sebastian Roth]

Could you please tell us which version of php is installed now? dpkg -l | grep php (post the full output here)

The syntax there looks pretty good to me (other foreach loops with reference just a few lines of code earlier seam to work?!?): http://sourceforge.net/p/freeghost/code/4201/tree/trunk/packages/web/lib/fog/FOGBase.class.php#l412

[Stefan Kaegi]

ii  libapache2-mod-php5                5.4.45-0+deb7u1               amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  php-gettext                        1.0.11-1                      all          read gettext MO files directly, without requiring anything other than PHP
ii  php5                               5.4.45-0+deb7u1               all          server-side, HTML-embedded scripting language (metapackage)
ii  php5-cli                           5.4.45-0+deb7u1               amd64        command-line interpreter for the php5 scripting language
ii  php5-common                        5.4.45-0+deb7u1               amd64        Common files for packages built from the php5 source
ii  php5-curl                          5.4.45-0+deb7u1               amd64        CURL module for php5
ii  php5-fpm                           5.4.45-0+deb7u1               amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php5-gd                            5.4.45-0+deb7u1               amd64        GD module for php5
ii  php5-mcrypt                        5.4.45-0+deb7u1               amd64        MCrypt module for php5
rc  php5-mysql                         5.4.39-0+deb7u2               amd64        MySQL module for php5
ii  php5-mysqlnd                       5.4.45-0+deb7u1               amd64        MySQL module for php5 (Native Driver)
ii  phpmyadmin                         4:3.4.11.1-2+deb7u1           all          MySQL web administration tool

[Sebastian Roth]

Could you please try checking out the newest SVN version and run the installer again?

[Stefan Kaegi]

Unfortunately that didn’t help. I now have Rev 4219.

[Sebastian Roth]

AFAIK there should be a php version from another repo installed in current FOG trunk. php version 5.6.14… on my system. Do you see any errors while installfog.sh is running??

[Stefan Kaegi]

I installed the php version you have from the http://packages.dotdeb.org repo.

root@FOGAGH01:~/# dpkg -l | grep php
ii  libapache2-mod-php5                5.6.14-1~dotdeb+7.1           amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  php-gettext                        1.0.11-1                      all          read gettext MO files directly, without requiring anything other than PHP
ii  php5                               5.6.14-1~dotdeb+7.1           all          server-side, HTML-embedded scripting language (metapackage)
ii  php5-cli                           5.6.14-1~dotdeb+7.1           amd64        command-line interpreter for the php5 scripting language
ii  php5-common                        5.6.14-1~dotdeb+7.1           amd64        Common files for packages built from the php5 source
ii  php5-curl                          5.6.14-1~dotdeb+7.1           amd64        CURL module for php5
ii  php5-fpm                           5.6.14-1~dotdeb+7.1           amd64        server-side, HTML-embedded scripting language (FPM-CGI binary)
ii  php5-gd                            5.6.14-1~dotdeb+7.1           amd64        GD module for php5
ii  php5-mcrypt                        5.6.14-1~dotdeb+7.1           amd64        MCrypt module for php5
rc  php5-mysql                         5.4.39-0+deb7u2               amd64        MySQL module for php5
ii  php5-mysqlnd                       5.6.14-1~dotdeb+7.1           amd64        MySQL module for php5 (Native Driver)
ii  php5-readline                      5.6.14-1~dotdeb+7.1           amd64        Readline module for php5
ii  phpmyadmin                         4:3.4.11.1-2+deb7u1           all          MySQL web administration tool

I then updated to the newest svn. I now have rev 4227. After that I tried to install fog again.
Here is the output of installfog.sh:

root@FOGAGH01:~# ./installfog.sh

       ..#######:.    ..,#,..     .::##::.
  .:######          .:;####:......;#;..
  ...##...        ...##;,;##::::.##...
     ,#          ...##.....##:::##     ..::
     ##    .::###,,##.   . ##.::#.:######::.
  ...##:::###::....#. ..  .#...#. #...#:::.
  ..:####:..    ..##......##::##  ..  #
      #  .      ...##:,;##;:::#: ... ##..
     .#  .       .:;####;::::.##:::;#:..
      #                     ..:;###..

  ###########################################
  #     FOG                                 #
  #     Free Computer Imaging Solution      #
  #                                         #
  #     http://www.fogproject.org/          #
  #                                         #
  #     Credits:                            #
  #     http://fogproject.org/Credits       #
  #     GNU GPL Version 3                   #
  ###########################################

  Version: 5098 Installer/Updater


  * Found FOG Settings from previous install at: /opt/fog/.fogsettings
  * Performing upgrade using these settings...


  Starting Debian based Installation



  #####################################################################

  FOG now has everything it needs to setup your server, but please
  understand that this script will overwrite any setting you may
  have setup for services like DHCP, apache, pxe, tftp, and NFS.

  It is not recommended that you install this on a production system
  as this script modifies many of your system settings.

  This script should be run by the root user on Redhat or with sudo on Ubuntu.

  ** Notice ** Redhat users will need to disable SELinux and iptables in
  order to use FOG
  Please see our wiki for more information at http://www.fogproject.org/wiki


  Here are the settings FOG will use:
         Base Linux: Debian
         Detected Linux Distribution: Debian GNU/Linux
         Installation Type: Normal Server
         Server IP Address: 172.30.40.25
         DHCP router Address: 172.30.40.5
         DHCP DNS Address: 172.30.40.1
         Interface: eth0
         Using FOG DHCP: 0
         Internationalization: 0
         Image Storage Location: /images
         MySQL Connection Type: MYSQLI_ASYNC
         Donate: 0

         DHCP will NOT be setup but you must setup your
         current DHCP server to use FOG for PXE services.

         On a Linux DHCP server you must set:
             next-server

         On a Windows DHCP server you must set:
             option 066 & 067

                   Option 066 is the IP of the FOG Server: (e.g. 172.30.40.25)
                   Option 067 is the undionly.kpxe file: (e.g. undionly.kpxe)

  Are you sure you wish to continue (Y/N) y

  Installation Started...

  Installing required packages, if this fails
  make sure you have an active internet connection.

 * Adding needed repository....................................OK
 * Preparing Package Manager...................................OK
 * Packages to be installed:

         apache2 php5 php5-json php5-gd php5-cli php5-curl mysql-server mysql-client tftpd-hpa tftp-hpa nfs-kernel-server vsftpd net-tools wget xinetd sysv-rc-conf tar gzip build-essential cpp gcc g++ m4 htmldoc lftp openssh-server php-gettext php5-mcrypt php5-mysqlnd curl libc6 libcurl3 zlib1g php5-fpm libapache2-mod-php5


 * Skipping package: apache2...................................(Already Installed)
 * Skipping package: php5......................................(Already Installed)
 * Skipping package: php5-common...............................(Already Installed)
 * Skipping package: php5-gd...................................(Already Installed)
 * Skipping package: php5-cli..................................(Already Installed)
 * Skipping package: php5-curl.................................(Already Installed)
 * Skipping package: mysql-server..............................(Already Installed)
 * Skipping package: mysql-client..............................(Already Installed)
 * Skipping package: tftpd-hpa.................................(Already Installed)
 * Skipping package: tftp-hpa..................................(Already Installed)
 * Skipping package: nfs-kernel-server.........................(Already Installed)
 * Skipping package: vsftpd....................................(Already Installed)
 * Skipping package: net-tools.................................(Already Installed)
 * Skipping package: wget......................................(Already Installed)
 * Skipping package: xinetd....................................(Already Installed)
 * Skipping package: sysv-rc-conf..............................(Already Installed)
 * Skipping package: tar.......................................(Already Installed)
 * Skipping package: gzip......................................(Already Installed)
 * Skipping package: build-essential...........................(Already Installed)
 * Skipping package: cpp.......................................(Already Installed)
 * Skipping package: gcc.......................................(Already Installed)
 * Skipping package: g++.......................................(Already Installed)
 * Skipping package: m4........................................(Already Installed)
 * Skipping package: htmldoc...................................(Already Installed)
 * Skipping package: lftp......................................(Already Installed)
 * Skipping package: openssh-server............................(Already Installed)
 * Skipping package: php-gettext...............................(Already Installed)
 * Skipping package: php5-mcrypt...............................(Already Installed)
 * Skipping package: php5-mysqlnd..............................(Already Installed)
 * Skipping package: curl......................................(Already Installed)
 * Skipping package: libc6.....................................(Already Installed)
 * Skipping package: libcurl3..................................(Already Installed)
 * Skipping package: zlib1g....................................(Already Installed)
 * Skipping package: php5-fpm..................................(Already Installed)
 * Skipping package: libapache2-mod-php5.......................(Already Installed)
 * Updating packages as needed.................................OK

  Confirming package installation.

 * Checking package: apache2...................................OK
 * Checking package: php5......................................OK
 * Checking package: php5-json.................................OK
 * Checking package: php5-gd...................................OK
 * Checking package: php5-cli..................................OK
 * Checking package: php5-curl.................................OK
 * Checking package: mysql-server..............................OK
 * Checking package: mysql-client..............................OK
 * Checking package: tftpd-hpa.................................OK
 * Checking package: tftp-hpa..................................OK
 * Checking package: nfs-kernel-server.........................OK
 * Checking package: vsftpd....................................OK
 * Checking package: net-tools.................................OK
 * Checking package: wget......................................OK
 * Checking package: xinetd....................................OK
 * Checking package: sysv-rc-conf..............................OK
 * Checking package: tar.......................................OK
 * Checking package: gzip......................................OK
 * Checking package: build-essential...........................OK
 * Checking package: cpp.......................................OK
 * Checking package: gcc.......................................OK
 * Checking package: g++.......................................OK
 * Checking package: m4........................................OK
 * Checking package: htmldoc...................................OK
 * Checking package: lftp......................................OK
 * Checking package: openssh-server............................OK
 * Checking package: php-gettext...............................OK
 * Checking package: php5-mcrypt...............................OK
 * Checking package: php5-mysqlnd..............................OK
 * Checking package: curl......................................OK
 * Checking package: libc6.....................................OK
 * Checking package: libcurl3..................................OK
 * Checking package: zlib1g....................................OK
 * Checking package: php5-fpm..................................OK
 * Checking package: libapache2-mod-php5.......................OK

  Configuring services.

 * Stopping FOGMulticastManager Service........................OK
 * Stopping FOGImageReplicator Service.........................OK
 * Stopping FOGSnapinReplicator Service........................OK
 * Stopping FOGScheduler Service...............................OK
 * Stopping FOGPingHosts Service...............................OK
 * Setting up and starting MySQL...............................OK
 * Backing up user reports.....................................OK
 * Stopping web service........................................OK
 * Removing vhost file.........................................OK
 * Setting up Apache and PHP files.............................OK
 * Backing up old data.........................................OK
 * Copying back old web folder as is...........................OK
 * Copying new files to web folder.............................OK
 * Creating config file........................................OK
 * Downloading inits and kernels...............................Backgrounded
 * Downloading New FOG Client file.............................Backgrounded
 * Enabling apache and fpm services on boot....................OK
 * Creating SSL Certificate....................................OK
 * Creating auth pub key and cert..............................OK
 * Resetting SSL Permissions...................................OK
 * Setting up SSL FOG Server...................................OK
 * Restarting Apache2 for fog vhost............................OK
 * Changing permissions on apache log files....................OK

  You still need to install/update your database schema.
  This can be done by opening a web browser and going to:

      http://172.30.40.25/fog/management

  Press [Enter] key when database is updated/installed.

 * Setting up storage..........................................OK
 * Setting up and starting DHCP Server.........................Skipped
 * Setting up and starting TFTP and PXE Servers................OK
 * Setting up and starting VSFTP Server........................OK
 * Setting up FOG Snapins......................................OK
 * Setting up UDPCast..........................................OK
 * Configuring UDPCast.........................................OK
 * Building UDPCast............................................OK
 * Installing UDPCast..........................................OK
 * Installing FOG System Scripts...............................OK


  * Configuring FOG System Services


 * Setting FOGMulticastManager script executable...............OK
 * Enabling FOGMulticastManager Service........................OK
 * Setting FOGImageReplicator script executable................OK
 * Enabling FOGImageReplicator Service.........................OK
 * Setting FOGSnapinReplicator script executable...............OK
 * Enabling FOGSnapinReplicator Service........................OK
 * Setting FOGScheduler script executable......................OK
 * Enabling FOGScheduler Service...............................OK
 * Setting FOGPingHosts script executable......................OK
 * Enabling FOGPingHosts Service...............................OK
 * Setting up FOG Services.....................................OK
 * Setting up FOG Utils........................................OK
 * Starting FOGMulticastManager Service........................OK
 * Starting FOGImageReplicator Service.........................OK
 * Starting FOGSnapinReplicator Service........................OK
 * Starting FOGScheduler Service...............................OK
 * Starting FOGPingHosts Service...............................OK
 * Setting up exports file.....................................OK
 * Setting up and starting RPCBind.............................OK
 * Setting up and starting NFS Server..........................OK

  Setup complete!

  You can now login to the FOG Management Portal using
  the information listed below.  The login information
  is only if this is the first install.

  This can be done by opening a web browser and going to:

      http://172.30.40.25/fog/management

      Default User:
             Username: fog
             Password: password

But I still get the blank page when going to ’http://172.30.40.25/fog’ or ’http://172.30.40.25/fog/management’.

[Sebastian Roth]

@Stefan-Kaegi said:

rc  php5-mysql                         5.4.39-0+deb7u2 ....

Seams like you still have old stuff sitting there. ‘r’ means marked for remove and ‘c’ means config-files are still installed. Run sudo apt-get purge php5-mysql to make sure this is not getting in your way. Probably best to restart the server to make sure no one is using the old configs anymore.

Are you still stuck with the database schema updater. Could you please check your apache error log again while accessing the web interface and running the schema updater.

[Stefan Kaegi]

I removed php5-mysql and restarted the server. But I still get the blang page. Yes, im still stuck at the database schema updater.
I attached my apache error log file (last 100 lines) while accessing the web interface.
error.log
I get this error every second. Even when i don’t access the webinterface. My current error.log file is 514M at the moment. The previous one is 787M. The ones before are arounc 1-15K.

[Sebastian Roth]

You see so many errors because your clients also access the web pages to get information. Error is a bit confusing as FOGCore.class.php does not even have 300 lines of code (http://sourceforge.net/p/freeghost/code/HEAD/tree/trunk/packages/web/lib/fog/FOGCore.class.php)!

PHP Fatal error:  Call to a member function query() on null in /var/www/html/fog/lib/fog/FOGCore.class.php on line 310

Maybe have a look at that file on your server and tell us what’s in line 310 or better try updating again. Are you sure you do checkout/update the full source code when running an update??

svn checkout https://svn.code.sf.net/p/freeghost/code/trunk
cd trunk/bin
sudo ./installfog.sh

[Sebastian Roth]

@Stefan-Kaegi Seams like I was wrong with the mysql package for debian. Please install php5-mysql (which will uninstall php5-mysqlnd instead) by sudo apt-get install php5-mysql

I hope this will solve the ‘query() on null’ error for you!

[Tom Elliott]

@Stefan-Kaegi said:

When I run ‘./installfog.sh’ everything looks ok. But when I try to update the database schema via ’http://172.30.40.25/fog/management’ I only see a blank page. I tried to skip the database update and finish the installation. But all i can see now when going to ’http://172.30.40.25/fog’ or ’http://172.30.40.25/fog/management’ is a blank page. Hard refreshing the page didn’t help.

I believe i figured out the issue, as well as the error you were seeing from FOGCore.

Query was null because the link was not connected due to the load issues we’ve been trying to fight lately

I believe I finally got to the bottom of it.

[Sebastian Roth]

@Tom-Elliott Could be related to load but in this case I am fairly sure that query() on null is coming from mysqli class not being available. I just had that on one of my test debian systems when playing with the different php mysql packages. Seams like php5-mysqlnd from dotdeb is not properly configured to offer mysqli as it is used in FOG. Maybe it’s just a php.ini thing, I am not sure.
Exchanging php5-mysqlnd with php5-mysql solved that for me!