NFS Mount Fails... Network Unreachable

[Wayne Workman]

@mmethe not sure on the last question, but you can follow this guide to get the latest kernels:
https://wiki.fogproject.org/wiki/index.php?title=Kernel_Update

It’s written for fog trunk, but the steps in 1.2.0 are similar.

[mmethe]

@Wayne-Workman Thank You. the problem I am seeing is that the most updated kernel is dated July 22, 2015. Seems a little old. Is there a repository where I can look for something more current than a year ago?

[Wayne Workman]

@mmethe FOG Trunk comes with the latest kernels, your problem might go away.

[mmethe]

@Wayne-Workman So, I am using the SVN method to switch to trunk. All goes well until I am told to hot the GUI and do the schema update. When I hit the GUI URL I get:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘hosts.hostPending’ in ‘where clause’ SQL: [94] SELECT COUNT(hosts.hostID) AS total FROM hosts WHERE hosts.hostPending=‘1’ LIMIT 1 Params: 0

SQL is running. There were no errors reported during the installation script execution.

Thanks!!

[Wayne Workman]

@mmethe Ok. @Tom-Elliott ideas?

[Tom Elliott]

Please update to latest and see if this issue is corrected for. I love prepared statements, but they can be a PITA as well.

I was able to fix the other thread that had the issue. I commented the lines that were causing the offending issues.

I’ve made a more appropriate fix in the latest and just have not got a good way to test it currently.

[mmethe]

@Wayne-Workman Can I simply obtain the most current kernel somehow and point to it?

[Wayne Workman]

@mmethe when you run the fog trunk installer, it downloads the very latest kernels and inits for you. If this didn’t happen, you’d get a big fat failure message telling you about it during installation. Right now you have a different issue, and tom suggested updating to fix that, which will likely fix it.

[Wayne Workman]

@mmethe said in NFS Mount Fails... Network Unreachable:

@Wayne-Workman So, I am using the SVN method to switch to trunk. All goes well until I am told to hot the GUI and do the schema update. When I hit the GUI URL I get:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘hosts.hostPending’ in ‘where clause’ SQL: [94] SELECT COUNT(hosts.hostID) AS total FROM hosts WHERE hosts.hostPending=‘1’ LIMIT 1 Params: 0

SQL is running. There were no errors reported during the installation script execution.

Thanks!!

Cross linking similar threads:

https://forums.fogproject.org/topic/7855/sql-error-when-upgrading-database-schema

https://forums.fogproject.org/topic/7876/installation-error-fresh-install-with-current-git-trunk-version

https://forums.fogproject.org/topic/7873/sql-error-after-updating-to-trunk-at-login

https://forums.fogproject.org/topic/7870/chromium-os-woes/9

https://forums.fogproject.org/topic/7862/nfs-mount-fails-network-unreachable/16

[Tom Elliott]

This should now be fixed.