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



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


  • Developer

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



  • 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’.


  • Developer

    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??



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


  • Developer

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



  • 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
    
    

  • Developer

    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



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



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



  • 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


  • Testers

    This is what I use.

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


  • 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
    

  • Moderator

    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.


  • Senior Developer

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


Log in to reply
 

444
Online

6.2k
Users

13.6k
Topics

128.0k
Posts