Dell Venue 11 Pro
-
The first thing necessary is to upgrade to trunk.
https://wiki.fogproject.org/wiki/index.php/Upgrade_to_trunk
It’s advised to backup your database and export your hosts (and label the files) prior to upgrading. You can do that like this on 1.2.0 and higher:
FOG Configuration -> Configuration Save -> Export
Host Management -> Export Hosts -> ExportIf you’d like, it’s OK to build a new test server and temporarily use a DHCP reservation to just point the MAC address of the Venue 11 to the new server using the new server’s IP for option 066 and the proper bootfile for option 067. This will cause just that one tablet to try to network boot to the new fog server.
Or, if your current fog server is virtualized, just take a snapshot (and still do your DB and host backups) and then try to upgrade to trunk.
After you have a FOG Server with the latest trunk running on it, we can continue to the DHCP stuff and configuration for your device.
sounds like a lot, but really it’s not. we’re here to help you with every step.
-
After Upgrade to trunk - localhost/fog/management page keeps going to Database Schema Installer / Updater after I completed the update.
I tried a:
service mysql restart -
@dutchers4 said:
After Upgrade to trunk - localhost/fog/management page keeps going to Database Schema Installer / Updater after I completed the update.
I tried a:
service mysql restartDid you go through the installer completely? It sounds like you didn’t come back to the installation script after updating the database scheme.
Beyond that, Ubuntu 13 and 14 are slightly troublesome with MySQL and FOG only because our developers don’t have time to perfect the installer for those versions. The latest FOG Trunk has been verified to work on Ubuntu 15.04. If you have a reason to stay with Ubuntu 14, you might look towards the bottom of this article and try those steps: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL
Or, You could do a clean installation using CentOS 7 or Fedora 21 or 22 using this guide: https://wiki.fogproject.org/wiki/index.php/Fedora_21_Server
Personally, I’d recommend going with this option simply because there are less known problems with these distributions. At both work and home, I use Fedora 21, but I know FOG Trunk works fine on Fedora 22 and CentOS 7. -
@dutchers4 more info please? Error logs, and a disk space usage of the fog server would be extremely helpful.
-
Also, @ch3i might be able to help with the errors in Ubuntu 14. The guy is a whiz at Ubuntu.
-
@Tom-Elliott As I am very new to Linux (Windows Server and Network Admin) what would be the easiest way to get you the needed information.
-
@dutchers4 for disk usage:
df -h
For the logs, I don’t know which ones he’s asking for specifically. https://help.ubuntu.com/community/LinuxLogFiles
If I had to guess, probably Apache logs.
/var/log/apache2/error.log
so viewing that with something liketail -100 /var/log/apache2/error.log
would show you the last 100 lines in the file.You can post the info here using the codebox tool. It’s right above the text editor box for forum posts.
-
[Thu Oct 08 13:31:59.970940 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.970940 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.970977 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971007 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971037 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971066 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971098 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971128 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971157 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971186 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971218 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971252 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971283 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971313 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971342 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971374 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971406 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971436 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971474 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971505 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971538 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.971569 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.991950 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::mysqli(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/fog/lib/db/MySQL.class.php on line 39, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.992012 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::mysqli(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /var/www/html/fog/lib/db/MySQL.class.php on line 39, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.992558 2015] [:error] [pid 26258] [client ::1:52519] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://localhost/fog/management/?node=schemaupdater [Thu Oct 08 13:31:59.992756 2015] [:error] [pid 26258] [client ::1:52519] PHP Fatal error: Call to a member function save() on null in /var/www/html/fog/lib/pages/SchemaUpdaterPage.class.php on line 38, referer: http://localhost/fog/management/?node=schemaupdater hbcadministrator@HBCELGFOG01:~$
-
I have 15 GB Free of Disk Space on /dev/sda1 and 1.2 TB Free on /dev/sdb1
-
@dutchers4 Make sure MySQL is running
sudo service mysql restart
-
sudo service mysql restart mysql stop/waiting mysql start/running, process 31786 hbcadministrator@HBCELGFOG01:~$ sudo tail -25 /var/log/apache2/error.log [Thu Oct 08 14:03:52.583384 2015] [:error] [pid 31644] [client 10.21.0.61:54362] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 64, referer: http://10.21.0.4/fog/management/?node=schemaupdater [Thu Oct 08 14:03:52.594358 2015] [:error] [pid 31644] [client 10.21.0.61:54362] PHP Warning: mysqli::real_escape_string(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 191, referer: http://10.21.0.4/fog/management/?node=schemaupdater
I trimmed it down… After Restarting Service
-
Are you still seeing the update schema page? Looking through the error logs again I noticed this:
... php_network_getaddresses: getaddrinfo failed: Name or service not known ...
Sounds a bit like the hostname cannot be resolved. But as I see in the other errors you have the database on the same host as the webserver (as pretty much everyone else) using
localhost
as hostname. Maybe your /etc/hosts files is gone wild. Please take a look and post the content of /etc/hosts file on your FOG server. -
127.0.0.1 localhost 127.0.1.1 HBCELGFOG01 # The following lines are desirable for IPv6 capable hosts ::1 localhost ip6-localhost ip6-loopback ff02::1 ip6-allnodes ff02::2 ip6-allrouters
-
@dutchers4 Sorry for taking so long to answer. Your /etc/hosts looks good to me. Re-reading all the posts here and thinking about this a little more I wonder if restarting MySQL just is not enough. See here: https://github.com/fogproject/fogproject/issues/1
-
Still no go, Still showing the Database Schema Installer.
-
Do you still see errors in your apache log?
Maybe try upgrading again and running the FOG install script. Sorry for not having a clear answer. It’s very hard to find an issue not sitting in front of the machine. Need more information.
Edit: MySQL logs to syslog in standard configuration. See what you get from those logs by running this command:
grep mysql /var/log/syslog
(output might be long! See if you find errors) -
@dutchers4 Any news on this?
-
I was really strongly wanting to see this thread solved…