• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

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

Scheduled Pinned Locked Moved Solved
FOG Problems
8
55
25.9k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I
    irishfoguser
    last edited by Oct 23, 2015, 2:45 PM

    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
    
    1 Reply Last reply Reply Quote 0
    • J
      Joseph Hales Testers
      last edited by Oct 23, 2015, 8:11 PM

      This is what I use.

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

      RTFM

      1 Reply Last reply Reply Quote 0
      • W
        Wayne Workman
        last edited by Oct 23, 2015, 9:02 PM

        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

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
        Daily Clean Installation Results:
        https://fogtesting.fogproject.us/
        FOG Reporting:
        https://fog-external-reporting-results.fogproject.us/

        1 Reply Last reply Reply Quote 0
        • S
          Stefan Kaegi
          last edited by Oct 27, 2015, 7:42 AM

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

          1 Reply Last reply Reply Quote 0
          • S
            Stefan Kaegi
            last edited by Oct 27, 2015, 7:53 AM

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

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Oct 27, 2015, 10:05 AM

              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

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • S
                Stefan Kaegi
                last edited by Oct 27, 2015, 10:11 AM

                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
                
                
                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Oct 27, 2015, 10:59 AM

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

                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                  1 Reply Last reply Reply Quote 0
                  • S
                    Stefan Kaegi
                    last edited by Oct 27, 2015, 11:04 AM

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

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by Oct 27, 2015, 11:05 AM

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

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • S
                        Stefan Kaegi
                        last edited by Oct 28, 2015, 8:19 AM

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

                        1 Reply Last reply Reply Quote 0
                        • S
                          Sebastian Roth Moderator
                          last edited by Oct 28, 2015, 8:59 AM

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

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • S
                            Stefan Kaegi
                            last edited by Oct 28, 2015, 9:52 AM

                            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.

                            1 Reply Last reply Reply Quote 0
                            • S
                              Sebastian Roth Moderator
                              last edited by Sebastian Roth Oct 28, 2015, 6:20 AM Oct 28, 2015, 12:19 PM

                              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
                              

                              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                              1 Reply Last reply Reply Quote 0
                              • S
                                Sebastian Roth Moderator
                                last edited by Sebastian Roth Oct 28, 2015, 5:37 PM Oct 28, 2015, 11:36 PM

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

                                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  Tom Elliott
                                  last edited by Oct 29, 2015, 1:06 AM

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

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                  1 Reply Last reply Reply Quote 1
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by Sebastian Roth Oct 29, 2015, 2:13 AM Oct 29, 2015, 8:12 AM

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

                                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                    1 Reply Last reply Reply Quote 0
                                    • I
                                      irishfoguser
                                      last edited by Oct 29, 2015, 10:29 AM

                                      Hi

                                      i have tried to fix this using this command but no joy

                                      sudo apt-get install php5-mysql .

                                      i still am getting a blank page. I am using the svn

                                      13 2015] [notice] Apache/2.2.22 (Debian) mod_ssl/2.2.22 OpenSSL/1.0.1e configured – resuming normal operations
                                      [Thu Oct 29 10:33:52 2015] [error] [client ::1] PHP Warning: mysqli::query() expects parameter 2 to be long, string given in /var/www/html/fog/lib/db/MySQL.class.php on line 63
                                      [Thu Oct 29 10:33:52 2015] [error] [client ::1] PHP Warning: mysqli::query() expects parameter 2 to be long, string given in /var/www/html/fog/lib/db/MySQL.class.php on line 63
                                      [Thu Oct 29 10:33:52 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
                                      [Thu Oct 29 10:33:52 2015] [error] [client ::1] File does not exist: /var/www/favicon.ico

                                      Tom ElliottT 1 Reply Last reply Oct 30, 2015, 1:55 AM Reply Quote 0
                                      • S
                                        Sebastian Roth Moderator
                                        last edited by Sebastian Roth Oct 29, 2015, 4:44 AM Oct 29, 2015, 10:44 AM

                                        Please update to trunk and try again. Those lines of code do not match with what I see in the code. Very hard to find an issue then. Update can be done as you described earlier in this thread.

                                        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                        1 Reply Last reply Reply Quote 0
                                        • S
                                          Stefan Kaegi
                                          last edited by Oct 29, 2015, 10:56 AM

                                          I installed php5-mysql (and removed php5-mysqlnd) , updated trunk as you described and run the installfog.sh again. But I still get the blank page. It seems like installfog.sh installs php5-mysqlnd again:

                                          ...
                                           * Installing package: php5-mysqlnd............................OK
                                          ...
                                          

                                          It doesn’t work either when I try to install php5-mysql after the installation again.
                                          My apache error log file stills looks the same.

                                          1 Reply Last reply Reply Quote 0
                                          • 1
                                          • 2
                                          • 3
                                          • 1 / 3
                                          1 / 3
                                          • First post
                                            13/55
                                            Last post

                                          230

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project