Hah! I tried your command and got the error Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’.

We ran that and voila! Our FOG server is back.

You guys are truly wonderful.

Hello all. I’m looking for some guidance.

I have a new install of Fog on an existing Ubuntu machine, which is actually a VM.

So far, great. I copied the /opt folder from the physical machine which the VM is replacing. Everything should be the same. FOG installed just fine, but when I went to click the update schema button, everything fails and I get a long page full of failed MySQL commands.

Some pertinent information:

The machine has two interfaces: eth0 is the private interface and eth1 is the public interface.
Eth0 is on a VLAN with no DHCP server or outside inet access. Eth1 has a static DHCP configuration from the school’s internal network.

The machine does not use the local MySQL installation, but instead utilizes a MySQL server that is not on the VLAN, but has a public IP.

The settings in /var/www/fog/lib/fog/Config.class.php are correct, as are the settings in /opt/fog/.fogsettings

When I change the settings to use the local SQL database, the schema updates just fine.

Now, I said everything is the same with the config files from the physical machine to the VM, but there is a difference, eth0 was on the public side of the network before and eth1 on the private side. I don’t know if this has any bearing, but /etc/network/interfaces has been updated to reflect eth0 as on a 192. network while eth1 is DHCP.

What I think is happening, but I don’t know how to find out if it is the case is that fog is trying to use the VLAN interface (eth0) to access the SQL server, which is only accessible from the public IP (eth1).

If you have read this far, thank you. Here is tail /var/log/apache2/error.log

[Wed Dec 17 15:39:13.053490 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Wed Dec 17 15:39:13.053507 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Wed Dec 17 15:39:13.053524 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
[Wed Dec 17 15:39:13.053534 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180
[Wed Dec 17 15:39:13.054035 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Wed Dec 17 15:39:13.054061 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89
[Wed Dec 17 15:39:13.054072 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180
[Wed Dec 17 15:39:13.054114 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::escape_string(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 247
[Wed Dec 17 15:39:13.054171 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: mysqli::query(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 89

[Wed Dec 17 15:39:13.054184 2014] [:error] [pid 10329] [client 134.124.24.231:61753] PHP Warning: MySQL::sqlerror(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 180

My network admin and I are sure this is a terribly simple problem that we just haven’t got figured out. We’re hoping someone can give us a hand.

[I]Some [/I]snapins cause the server to return a 503 error. All of this done on the same client running the same image.

Other snapins install without a problem.

To make matters more interesting, all snapins install fine to a VM which is wired into the network or when the machine is VPN’ing into the network.

The server is Ubuntu 14.04, a complete reinstall in order to upgrade from Ubuntu 12.04
This happened before on Ubuntu 12.04, but that was specific to a single machine (or image, can’t remember).
Running FOG 1.2

I’ve disabled UFW. We have gone over and over the config files and the tables, looking for something that looks awry. There’s global read privileges in /opt/fog/snapins.

I don’t think the size of the snapin is a problem. A 750MB snapin installs, while a 508K snapin throws the 503.

I would appreciate any help. If I can provide you any information to help fix this, please let me know.

You sir, are my hero.

May someone buy you a beer on my behalf!

I recently upgraded from .32 to 1.1 to 1.2.

Imaging seems to work fine, along with other fog services, but I cannot get snapins to download. They cue up appropriately in the active tasks, but are never downloaded. The log on the client computer displays the following exception recursively. The information listed is wrong as the snap in is much newer than 2011, but made a couple months ago. This is not limited to one snap in or one computer, but happens across the board.

Obviously this is not enough information to help me, but if anyone could tell me what information to provide, I’ll be happy to post it.

9/8/2014 2:11 PM FOG::SnapinClient Attempting to connect to fog server…
9/8/2014 2:11 PM FOG::SnapinClient Module is active…
9/8/2014 2:12 PM FOG::SnapinClient Snapin Found:
9/8/2014 2:12 PM FOG::SnapinClient ID: 61
9/8/2014 2:12 PM FOG::SnapinClient RunWith:
9/8/2014 2:12 PM FOG::SnapinClient RunWithArgs:
9/8/2014 2:12 PM FOG::SnapinClient Name:
9/8/2014 2:12 PM FOG::SnapinClient Created: 2011-01-14 09:31:32
9/8/2014 2:12 PM FOG::SnapinClient Args:
9/8/2014 2:12 PM FOG::SnapinClient Reboot: No
9/8/2014 2:12 PM FOG::SnapinClient Starting FOG Snapin Download
9/8/2014 2:12 PM FOG::SnapinClient Failed to download file.
9/8/2014 2:12 PM FOG::SnapinClient An exception occurred during a WebClient request.
9/8/2014 2:12 PM FOG::SnapinClient at System.Net.WebClient.DownloadFile(Uri address, String fileName)
at FOG.SnapinClient.startWatching()
9/8/2014 2:12 PM FOG::SnapinClient Attempting to connect to fog server…
9/8/2014 2:12 PM FOG::SnapinClient Module is active…
9/8/2014 2:12 PM FOG::SnapinClient Snapin Found:
9/8/2014 2:12 PM FOG::SnapinClient ID: 61
9/8/2014 2:12 PM FOG::SnapinClient RunWith:
9/8/2014 2:12 PM FOG::SnapinClient RunWithArgs:
9/8/2014 2:12 PM FOG::SnapinClient Name:
9/8/2014 2:12 PM FOG::SnapinClient Created: 2011-01-14 09:31:32
9/8/2014 2:12 PM FOG::SnapinClient Args:
9/8/2014 2:12 PM FOG::SnapinClient Reboot: No
9/8/2014 2:12 PM FOG::SnapinClient Starting FOG Snapin Download
9/8/2014 2:12 PM FOG::SnapinClient Failed to download file.
9/8/2014 2:12 PM FOG::SnapinClient An exception occurred during a WebClient request.
9/8/2014 2:12 PM FOG::SnapinClient at System.Net.WebClient.DownloadFile(Uri address, String fileName)
at FOG.SnapinClient.startWatching()