Standard storage nodes or multiple TFTP servers in MPLS cloud?

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

[Sebastian Roth]

@moses Did you try connecting to the DB using the mysql command line client yet? Login to the console of your storage node and run mysql --user root --password (enter PW when prompted)

[moses]

@Sebastian-Roth I never set a mysql password on the storage node. What or where is it?

@Tom-Elliott Maybe I don’t know which passwords to use. There appears to be a thousand different usernames/passwords and another thousand different references to them.

On the main server, I added the storage node using the “management” username and password that the node spat out when running the installer:

[Tom Elliott]

@Tom-Elliott said:

FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER

FOG Configuration Page->FOG Settings->FOG Storage Nodes->FOG_STORAGENODE_MYSQLPASS/FOG_STORAGENODE_MYSQLUSER

[Tom Elliott]

@moses Information was all correct.

The reason there was a problem was ubuntu using bind-address in the my.cnf file.

Commented that line and restarted mysql, and everything started working properly.