[Rev 4201] blank page when trying to install/update database schema
-
And here the logfile of the troubleshooting script:
FOGtroubleshoot.log -
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
-
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 -
Could you please try checking out the newest SVN version and run the installer again?
-
Unfortunately that didn’t help. I now have Rev 4219.
-
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??
-
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 toolI 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: passwordBut I still get the blank page when going to ’http://172.30.40.25/fog’ or ’http://172.30.40.25/fog/management’.
-
@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-mysqlto 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 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. -
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 310Maybe 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 -
@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-mysqlI hope this will solve the ‘query() on null’ error for you!
-
@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.
-
@Tom-Elliott Could be related to load but in this case I am fairly sure that
query() on nullis 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 likephp5-mysqlndfrom 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! -
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 -
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.
-
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. -
Here is my FOGCore.class.php file:
FOGCore.class.php -
Thanks for uploading FOGCore.class.php. But without knowing the exact line number where the error happened I am unable to help you. I am very sorry for all this messages forth an back without getting anywhere yet. But we need full information to be able to help you. Line number (error log) and code (either upload or tell us the exact revision number).
I tried to reproduce this but I can’t unfortunately!! Installed php5-mysqlnd (which removed php5-mysql) and it is still working for me here. I wish I would have payed more attention on why it didn’t work for me in the first place but I guess it was just too late at night.
-
@irishfoguser it appears you are not updating. I state this because ‘PHP Warning: mysqli::query() expects parameter 2 to be long, string given’ will only occur in async mysqli calls specifically from the poll method. I have moved away from async calls.
How exactly are you updating and reinstalling? My guess is you are in bin which will not update all of the files. If svn is downloaded to /root under folder trunk, you must be in /root/trunk not /root/trunk/bin.
-
I udpated again today. So now I’m on Rev 4244.
Apache error.log: error.log
FOGCore.class.php: FOGCore.class.php
