Surface Pro 4 unable to image

[Tom Elliott]

@Scott-Adams Can you get the output of mysql command:

show create table fog.globalSettings

[Scott Adams]

@Tom-Elliott

[Scott Adams]

@Tom-Elliott I have also checked .fogsettings, config.class.php and sql username/passwords match. I also tested the storage node mysql username/password (following the troubleshooting mysql wiki) and credentials worked. It is just something with the WebUI itself or how the WebUI communicates to the mysql database.

[Tom Elliott]

@Scott-Adams Can you check the schema out? It appears, from what I can see, you’re missing a few global settings from the table, though I have no idea what.

Would you be able to set the schemaVersion to say 200?

UPDATE fog.schemaVersion SET vValue=200;

Go to the gui and approve it to update.

[Scott Adams]

@Tom-Elliott I did. I then received the attached errors when I approved.

I have since logged in and am able to navigate the webui. However, I am still unable to save any changes within FOGSettings.

When I re-run the show create table fog.globalSettings, all settings look the same, only the AUTO_INCREMENT has changed to 188

[Scott Adams]

@Tom-Elliott This is the same issue I reported on a few weeks ago.
https://forums.fogproject.org/topic/7276/after-upgrade-to-trunk-7324-no-settings-available-under-fog-configuration-fog-settings

[Scott Adams]

Any thoughts or ideas yet? I am completely at a loss. Once again, I updated versions to see if that would fix. No go.

[Tom Elliott]

@Scott-Adams Anything under apache error logs?

[Scott Adams]

@Tom-Elliott It says “unable to open file for reading”. It does this for all the apache logs under log viewer…

[Tom Elliott]

@Scott-Adams So you can get to the GUI?

[Scott Adams]

@Tom-Elliott Yes sir! I can created hosts, create images (capture and deploy). From within FOG Configuration, I can change settings in the iPXE Menu Cusomtization. I can download new kernels.

The only restriction so far is for any changes I make to the FOG Settings under FOG Configuration. I know this is not the original topic of this thread, but the troubleshooting for this topic led us down this path.

[Tom Elliott]

@Scott-Adams The unable to read files is probably because ubuntu is extremely a PITA lately.

When they run logrotates, the change the permissions of the file to what they think should be set, rather than just move the file and continue on.

So you probably need to re-run the installer and have it try to see the files again.

[Scott Adams]

@Tom-Elliott What installer do I need to rerun? I just re-updated SVN yesterday.

[Tom Elliott]

@Scott-Adams SVN installer.

Logrotate usually happens daily on Ubuntu systems.

[Scott Adams]

@Tom-Elliott So, rerun the SVN to go up to the next version of FOG?

[Tom Elliott]

@Scott-Adams Yes.

Remember I commit MANY MANY MANY times in a day (sometimes more than that even).

[Scott Adams]

@Tom-Elliott Updated to SVN 7597. Did not ask to upgrade schema after install. Am now able to get Apache log errors.

[Thu May 12 13:48:29.351592 2016] [:error] [pid 4826] [client 10.10.101.4:61421] PHP Warning: Error while sending QUERY packet. PID=4826 in /var/www/html/fog/lib/db/mysql.class.php on line 47, referer: http://fog/fog/management/index.php?node=about&sub=settings
[Thu May 12 13:48:13.616051 2016] [:error] [pid 2303] [client 10.10.101.4:61410] PHP Fatal error: Function name must be a string in /var/www/html/fog/lib/client/printerclient.class.php on line 7

[Scott Adams]

@Scott-Adams If I’m reading this right, line 47 is:

self::$link->query(“SET SESSION sql_mode=‘’”);

[Tom Elliott]

@Scott-Adams That line is unlikely causing the issue you’re seeing. The function as a string is probably a partial point of the issue. I’ve added code to set the query packet size a little more implicitly and give a timeout value in hopes to help correct this. Please update and let us know if this is or isn’t working for you.

[Scott Adams]

@Tom-Elliott Updated to SVN 7603. Still unable to make changes in FOG Settings, and now Apache error logs show:

[Fri May 13 07:47:41.982694 2016] [:error] [pid 600] [client 10.10.101.4:49903] PHP Warning: mysqli::mysqli(): MySQL server has gone away in /var/www/html/fog/lib/db/mysql.class.php on line 25, referer: http://fog/fog/management/index.php?node=about&sub=logviewer
[Fri May 13 07:47:41.459485 2016] [:error] [pid 64683] [client 10.10.101.4:49914] PHP Warning: mysqli::mysqli(): MySQL server has gone away in /var/www/html/fog/lib/db/mysql.class.php on line 25, referer: http://fog/fog/management/index.php?node=about&sub=logviewer