Standard storage nodes or multiple TFTP servers in MPLS cloud?

[george1421]

@moses It depends on how much risk you can tolerate. Bugs in the trunk version tend to get a lot of attention so they get resolved pretty quick. (0-3 days for simple ones). If you can tolerate that risk then the trunk build is fine.

If I had to deploy 100 systems by this friday without exception then I might think otherwise.

I can tell you that the 1.2.0 stable version does not handle gpt disks memblock disk, and efi booting very well at all. The devs have everything worked out except the efi booting on some of the new surface pro 4 class tablets (hp and lenovo of this also has issues).

[moses]

@george1421 @Wayne-Workman

Okay, thanks for both of your help!

[moses]

@george1421 @Wayne-Workman

Quick question regarding this setup on trunk: for the DCHP servers that are each site, should they point to the Master FOG server at the HQ location, or should they point to the storage node that is onsite? Keep in mind the goal is to have clients download images from whichever server is at the site they happen to be at.

[Wayne Workman]

@moses said:

@george1421 @Wayne-Workman

Quick question regarding this setup on trunk: for the DCHP servers that are each site, should they point to the Master FOG server at the HQ location, or should they point to the storage node that is onsite? Keep in mind the goal is to have clients download images from whichever server is at the site they happen to be at.

Either will work with newer systems and most older ones, but based on my recent experience with this, I would recommend you setup each site’s DHCP to point to that site’s storage node.

[moses]

@Wayne-Workman I set the DHCP server up at one remote site to point to the local storage node that is set up there. I verified that the images are replicating normally.

However, when testing PXE boot with a VM in Hyper-V, I get the following:

When I take a gander at http://192.168.2.66/fog/service/ipxe/boot.php:

#!ipxe
set fog-ip
set fog-webroot
set boot-url http://${fog-ip}/${fog-webroot}
cpuid --ext 29 && set arch x86_64 || set arch i386
goto get_console
:console_set
colour --rgb 0x00567a 1 ||
colour --rgb 0x00567a 2 ||
colour --rgb 0x00567a 4 ||
cpair --foreground 7 --background 2 2 ||
goto MENU
:alt_console
cpair --background 0 1 ||
cpair --background 1 2 ||
goto MENU
:get_console
console --picture http:///service/ipxe/bg.png --left 100 --right 80 && goto console_set || goto alt_console
:MENU
menu
colour --rgb 0xff0000 0 ||
cpair --foreground 1 1 ||
cpair --foreground 0 3 ||
cpair --foreground 4 4 ||
item --gap Host is NOT registered!
item --gap -- -------------------------------------
choose --default fog.local --timeout 0 target && goto ${target}
:bootme
chain -ar http:///service/ipxe/boot.php##params ||
goto MENU
autoboot```

This line doesn't look right:

console --picture http:///service/ipxe/bg.png --left 100 --right 80 && goto console_set || goto alt_console

[Wayne Workman]

@moses That error your seeing was literally just fixed yesterday. re-update the main and nodes and then re-run the installer on them. You can speed things up by using the -y argument like this: ./installfog.sh -y

See if the boot.php file displays something different afterwards.

[moses]

@Wayne-Workman Strange, as I installed it today. I’ll pull it again and run the installer again.

[Wayne Workman]

@moses said:

@Wayne-Workman Strange, as I installed it today. I’ll pull it again and run the installer again.

Please provide your apache errors from your storage nodes. Here’s the command for Fedora / CentOS
tail -n 100 /var/log/httpd/error_log

Use the codebox feature to post it here.

[moses]

@moses Ran the installer on both the main and the node, but the boot file is unchanged on the node. Same error when I attempt to boot from it.

Anything else I can try?

[moses]

@Wayne-Workman said:

tail -n 100 /var/log/httpd/error_log

Here’s the output (I’m on debian, if it matters):

[Wed Feb 24 16:18:06.725033 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:18:06.725582 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:18:06.725605 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:18:06.726153 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:18:06.726177 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:18:06.726734 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:18:06.726757 2016] [:error] [pid 2555] [client 192.168.1.66:39049] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:18:18.217956 2016] [mpm_prefork:notice] [pid 2552] AH00169: caught SIGTERM, shutting down
[Wed Feb 24 16:18:54.471845 2016] [mpm_prefork:notice] [pid 1341] AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2f configured -- resuming normal operations
[Wed Feb 24 16:18:54.523741 2016] [core:notice] [pid 1341] AH00094: Command line: '/usr/sbin/apache2'
[Wed Feb 24 16:19:26.046943 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 30
[Wed Feb 24 16:19:26.047007 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::set_charset(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 31
[Wed Feb 24 16:19:26.047029 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.047047 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.047056 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.047129 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.047153 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.056425 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.056458 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.056533 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.056542 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.056564 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.056571 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.058533 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.058550 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.058986 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.058999 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.060113 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.060130 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.061297 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.061311 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.062463 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.062476 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.063788 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.063805 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.064616 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.064642 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.114507 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 115
[Wed Feb 24 16:19:26.114688 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 116
[Wed Feb 24 16:19:26.121503 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121544 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121566 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121587 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121608 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121629 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121649 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121669 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:19:26.121687 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.121694 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.121866 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.121877 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.122577 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.122589 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:19:26.122709 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:19:26.122720 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.410922 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 30
[Wed Feb 24 16:20:35.410978 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::set_charset(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 31
[Wed Feb 24 16:20:35.411000 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.411031 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.411047 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.411165 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.411184 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.412506 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.412529 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.412621 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.412639 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.412681 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.412696 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.414839 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.414867 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.415481 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.415508 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.416543 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.416572 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.417197 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.417239 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.417859 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.417884 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.418502 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.418527 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.419161 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.419186 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.427855 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 115
[Wed Feb 24 16:20:35.428021 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Strict Standards:  Only variables should be passed by reference in /var/www/html/fog/lib/fog/bootmenu.class.php on line 116
[Wed Feb 24 16:20:35.428975 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429007 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429031 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429052 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429072 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429093 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429113 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429134 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::real_escape_string(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 152
[Wed Feb 24 16:20:35.429152 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.429159 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.429336 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.429347 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.430020 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.430032 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52
[Wed Feb 24 16:20:35.430150 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::select_db(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 40
[Wed Feb 24 16:20:35.430161 2016] [:error] [pid 1346] [client 192.168.2.132:51726] PHP Warning:  mysqli::query(): invalid object or resource mysqli\n in /var/www/html/fog/lib/db/mysql.class.php on line 52

[Sebastian Roth]

@moses Are you able to access the web interface without any issue? If yes, check to see if the settings FOG_WEB_HOST (your FOG server IP) and FOG_WEB_ROOT (normally /fog/) are properly set. The mysql errors don’t look good. Is the MySQL DB running (service mysql status)?

[Tom Elliott]

@moses said:

[Wed Feb 24 16:19:26.046943 2016] [:error] [pid 1345] [client 192.168.1.116:61510] PHP Warning: mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/html/fog/lib/db/mysql.class.php on line 30

The quoted line is of concern.

As @Sebastian-Roth requested, can you restart mysql service? Also, can you double check disk usage on the server with df -h?

[moses]

@Sebastian-Roth I can access the web interface on the main FOG server with no issues, and there are no problems there. Mysql is confirmed to be running. This issue is with a storage node, and the web interface is disabled with the “This is a storage node, please do not access the web ui here!” message.

@Tom-Elliott Plenty of storage space to go around on the node, so no problems there. This the df -h output on the node, the main server is pretty much the same, with about 30 GB of images taken up on sda1:

Filesystem      Size  Used Avail Use% Mounted on
udev            1.9G  4.0K  1.9G   1% /dev
tmpfs           381M  860K  381M   1% /run
/dev/sda1       290G  3.6G  272G   2% /
none            4.0K     0  4.0K   0% /sys/fs/cgroup
none            5.0M     0  5.0M   0% /run/lock
none            1.9G     0  1.9G   0% /run/shm
none            100M     0  100M   0% /run/user

[Tom Elliott]

@moses Are you running a firewall that’s blocking the node’s access to the FOG Server?

Is the storage nodes connected using fogstorage and the fogstorage password located on the main server at: FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER?

[moses]

@Tom-Elliott No firewall blocking, these are connected via MPLS on a clean Ubuntu 14.04 install.

I’ve got the user/pass for fogstorage from the main server, how would I go about checking to make sure that is set correctly on the node?

[Tom Elliott]

@moses What’s in the node’s config.class.php (/var/www/html/fog/lib/fog/config.class.php)

The account information should show up under the mysql information.

[Sebastian Roth]

@moses By using the mysql command like client: mysql --user root --password (enter PW when prompted)

[moses]

@Tom-Elliott Yes, the username and password for fogstorage match on the node/server.

[moses]

If it’s at all helpful, here’s a screenshot of the node’s configuration on the main server:

[Tom Elliott]

@moses The picture you provided is off the Storage node, that username and password are not the same as the fogstorage mysql user and password.