Dell Venue 11 Pro

[dutchers4]

Thanks in advance for the help as I am pretty new to both Linux and Fog. I did review the links regarding a Dell Venue 8 Pro successful project and the necessary changes to DHCP, but the instructions that I found were related to Windows Server 2012 and our VLAN that is hosting the FOG Server environment has DHCP running on a Windows Server 2003 Box. So I am in need of some further guidance.

Dell Venue 11 Pro - can’t get it to work, using Legacy Mode with USB Network ASIX AX88772A/B device
Running Fog 1.2 Ubuntu 14.04
Using a DHCP server running Windows Server 2003
undionly.kpxe hangs on iPXE Initialising devices
unidionly.kkpxe does a Boot Loop

[Wayne Workman]

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

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

[dutchers4]

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

[Wayne Workman]

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

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

[Tom Elliott]

@dutchers4 more info please? Error logs, and a disk space usage of the fog server would be extremely helpful.

[Wayne Workman]

Also, @ch3i might be able to help with the errors in Ubuntu 14. The guy is a whiz at Ubuntu.

[dutchers4]

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

[Wayne Workman]

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

[dutchers4]

[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:~$

[dutchers4]

I have 15 GB Free of Disk Space on /dev/sda1 and 1.2 TB Free on /dev/sdb1

[Wayne Workman]

@dutchers4 Make sure MySQL is running

sudo service mysql restart

[dutchers4]

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

[Sebastian Roth]

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.

[dutchers4]

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

[Sebastian Roth]

@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

[dutchers4]

Still no go, Still showing the Database Schema Installer.

[Sebastian Roth]

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)

[Sebastian Roth]

@dutchers4 Any news on this?

[Wayne Workman]

I was really strongly wanting to see this thread solved…