CentOS 6.6, FOG 1.3.4, missing fog DB table?

[PeterAxis]

Server

• FOG Version: 1.3.4 stable
• OS: centos-release-6-6.el6.centos.12.2.x86_64

Client

• Service Version:
• OS:

Description

Synopsis of the problem from installer logs:

* Setting up and starting MySQL...............................grep: /etc/alternatives/jre/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_1.7.0/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_openjdk/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_1.7.0/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_openjdk/lib/audio/default.sf2: No such file or directory
OK
* Backing up user reports.....................................Done
* Stopping web service........................................OK
* Removing vhost file.........................................OK
* Setting up Apache and PHP files.............................OK
* Testing and removing symbolic links if found................OK
* Backing up old data.........................................OK
* Copying new files to web folder.............................OK
* Creating config file........................................OK
* Unzipping the binaries......................................Done
* Copying binaries where needed...............................Done
* Enabling apache and fpm services on boot....................OK
* Creating SSL Certificate....................................OK
* Creating auth pub key and cert..............................OK
* Resetting SSL Permissions...................................OK
* Setting up SSL FOG Server...................................OK
* Restarting Apache2 for fog vhost............................OK
* Changing permissions on apache log files....................OK
* Backing up database.........................................OK

* You still need to install/update your database schema.
* This can be done by opening a web browser and going to:

  http://xxx.xxx.xxx.xxx/fog/management

* Press Enter key when database is updated/installed

Now I know that looks like a typo but it isn’t. The grep stuff comes right on the end of the MySQL setup.

When I look to the target URL http://xxx.xxx.xxx.xxx/fog/management I get the following:

Database Schema Installer / Updater
Your database connection appears to be invalid. FOG is unable to communicate with the database. There are many reasons why this could be the case. Please check your credentials in /var/www/html/fog/lib/fog/config.class.php. Also confirm that the database is indeed running. If credentials are correct, and if the Database service is running, check to ensure your filesystem has enough space.

Working through various forum posts I came to the following common-sense nugget, which produced unexpected results:

[root@dumbo fog_1.3.4]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11622
Server version: 5.5.54 MySQL Community Server (GPL) by Remi

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use fog
ERROR 1049 (42000): Unknown database 'fog'
mysql> exit
Bye

I’m assuming something has gone wrong with the MySQL installation? Can anyone point out what?

I’m off to try full uninstall / reinstall as per https://wiki.fogproject.org/wiki/?title=Uninstall_FOG

Will update when I get something

[Tom Elliott]

Please install the RC version of FOG.

[PeterAxis]

After uninstall and during reinstall, looks like more of same:

./installfog.sh
Installing LSB_Release as needed
 * Attempting to get release information.......................Done


   +------------------------------------------+
   |     ..#######:.    ..,#,..     .::##::.  |
   |.:######          .:;####:......;#;..     |
   |...##...        ...##;,;##::::.##...      |
   |   ,#          ...##.....##:::##     ..:: |
   |   ##    .::###,,##.   . ##.::#.:######::.|
   |...##:::###::....#. ..  .#...#. #...#:::. |
   |..:####:..    ..##......##::##  ..  #     |
   |    #  .      ...##:,;##;:::#: ... ##..   |
   |   .#  .       .:;####;::::.##:::;#:..    |
   |    #                     ..:;###..       |
   |                                          |
   +------------------------------------------+
   |      Free Computer Imaging Solution      |
   +------------------------------------------+
   |  Credits: http://fogproject.org/Credits  |
   |       http://fogproject.org/Credits      |
   |       Released under GPL Version 3       |
   +------------------------------------------+


   Version: 1.3.4 Installer/Updater

cat: /etc/NetworkManager/system-connections/*: No such file or directory
  What version of Linux would you like to run the installation for?

          1) Redhat Based Linux (Redhat, CentOS, Mageia)
          2) Debian Based Linux (Debian, Ubuntu, Kubuntu, Edubuntu)
          3) Arch Linux

  Choice: 1 1



  Starting Redhat based Installation


  FOG Server installation modes:
      * Normal Server: (Choice N)
          This is the typical installation type and
          will install all FOG components for you on this
          machine.  Pick this option if you are unsure what to pick.

      * Storage Node: (Choice S)
          This install mode will only install the software required
          to make this server act as a node in a storage group

  More information:
     http://www.fogproject.org/wiki/index.php?title=InstallationModes

  What type of installation would you like to do?

   ######################################################################
   #     FOG now has everything it needs for this setup, but please     #
   #   understand that this script will overwrite any setting you may   #
   #   have setup for services like DHCP, apache, pxe, tftp, and NFS.   #
   ######################################################################
   # It is not recommended that you install this on a production system #
   #        as this script modifies many of your system settings.       #
   ######################################################################
   #             This script should be run by the root user.            #
   #      It will prepend the running with sudo if root is not set      #
   ######################################################################
   #           ** Notice ** FOG is difficult to setup securely          #
   #        SELinux and IPTables are usually asked to be disabled       #
   #           There have been strides in adding capabilities           #
   #          The recommendations would now be more appropriate         #
   #    to set SELinux to permissive and to disable firewall for now.   #
   #  You can find some methods to enable SELinux and maintain firewall #
   #   settings and ports. If you feel comfortable doing so please do   #
   ######################################################################
   #            Please see our wiki for more information at:            #
   ######################################################################
   #             https://wiki.fogproject.org/wiki/index.php             #
   ######################################################################

 * Here are the settings FOG will use:
 * Base Linux: Redhat
 * Detected Linux Distribution: CentOS
 * Server IP Address: 192.168.8.22
 * Server Subnet Mask: 255.255.255.0
 * Interface: eth0
 * Installation Type: Normal Server
 * Donate: 0
 * Internationalization: 0
 * Image Storage Location: /images
 * Using FOG DHCP: No
 * DHCP will NOT be setup but you must setup your
 | current DHCP server to use FOG for PXE services.

 * On a Linux DHCP server you must set: next-server and filename

 * On a Windows DHCP server you must set options 066 and 067

 * Option 066/next-server is the IP of the FOG Server: (e.g. 192.168.8.22)
 * Option 067/filename is the bootfile: (e.g. undionly.kpxe)


 * Are you sure you wish to continue (Y/N) Y

 * Installation Started

 * Installing required packages, if this fails
 | make sure you have an active internet connection.

 * Adding needed repository....................................OK
 * Preparing Package Manager...................................OK
 * Packages to be installed:

        bc curl gcc gcc-c++ gzip httpd lftp m4 make mod_ssl mysql mysql-server net-tools nfs-utils php php-bcmath php-cli php-common php-fpm php-gd php-ldap php-mbstring php-mcrypt php-mysqlnd php-process tar tftp-server unzip vsftpd wget xinetd


 * Skipping package: bc........................................(Already Installed)
 * Skipping package: curl......................................(Already Installed)
 * Skipping package: gcc.......................................(Already Installed)
 * Skipping package: gcc-c++...................................(Already Installed)
 * Skipping package: gzip......................................(Already Installed)
 * Skipping package: httpd.....................................(Already Installed)
 * Skipping package: lftp......................................(Already Installed)
 * Skipping package: m4........................................(Already Installed)
 * Skipping package: make......................................(Already Installed)
 * Skipping package: mod_ssl...................................(Already Installed)
 * Skipping package: mysql.....................................(Already Installed)
 * Skipping package: mysql-server..............................(Already Installed)
 * Skipping package: net-tools.................................(Already Installed)
 * Skipping package: nfs-utils.................................(Already Installed)
 * Skipping package: php.......................................(Already Installed)
 * Skipping package: php-bcmath................................(Already Installed)
 * Skipping package: php-cli...................................(Already Installed)
 * Skipping package: php-common................................(Already Installed)
 * Skipping package: php-fpm...................................(Already Installed)
 * Skipping package: php-gd....................................(Already Installed)
 * Skipping package: php-ldap..................................(Already Installed)
 * Skipping package: php-mbstring..............................(Already Installed)
 * Skipping package: php-mcrypt................................(Already Installed)
 * Skipping package: php-mysqlnd...............................(Already Installed)
 * Skipping package: php-process...............................(Already Installed)
 * Skipping package: tar.......................................(Already Installed)
 * Skipping package: tftp-server...............................(Already Installed)
 * Skipping package: unzip.....................................(Already Installed)
 * Skipping package: vsftpd....................................(Already Installed)
 * Skipping package: wget......................................(Already Installed)
 * Skipping package: xinetd....................................(Already Installed)
 * Updating packages as needed.................................OK

 * Confirming package installation

 * Checking package: bc........................................OK
 * Checking package: curl......................................OK
 * Checking package: gcc.......................................OK
 * Checking package: gcc-c++...................................OK
 * Checking package: gzip......................................OK
 * Checking package: httpd.....................................OK
 * Checking package: lftp......................................OK
 * Checking package: m4........................................OK
 * Checking package: make......................................OK
 * Checking package: mod_ssl...................................OK
 * Checking package: mysql.....................................OK
 * Checking package: mysql-server..............................OK
 * Checking package: net-tools.................................OK
 * Checking package: nfs-utils.................................OK
 * Checking package: php.......................................OK
 * Checking package: php-bcmath................................OK
 * Checking package: php-cli...................................OK
 * Checking package: php-common................................OK
 * Checking package: php-fpm...................................OK
 * Checking package: php-gd....................................OK
 * Checking package: php-ldap..................................OK
 * Checking package: php-mbstring..............................OK
 * Checking package: php-mcrypt................................OK
 * Checking package: php-mysqlnd...............................OK
 * Checking package: php-process...............................OK
 * Checking package: tar.......................................OK
 * Checking package: tftp-server...............................OK
 * Checking package: unzip.....................................OK
 * Checking package: vsftpd....................................OK
 * Checking package: wget......................................OK
 * Checking package: xinetd....................................OK

 * Configuring services

 * Setting up fog user.........................................OK
 * Setting up fog password.....................................OK
 * Stopping FOGMulticastManager Service........................OK
 * Stopping FOGImageReplicator Service.........................OK
 * Stopping FOGSnapinReplicator Service........................OK
 * Stopping FOGScheduler Service...............................OK
 * Stopping FOGPingHosts Service...............................OK
 * Stopping FOGSnapinHash Service..............................OK
 * Setting up and starting MySQL...............................grep: /etc/rc4.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc4.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc4.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc4.d/S95FOGScheduler: No such file or directory
grep: /etc/rc4.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc4.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc5.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc5.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc5.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc5.d/S95FOGScheduler: No such file or directory
grep: /etc/rc5.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc5.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc2.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc2.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc2.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc2.d/S95FOGScheduler: No such file or directory
grep: /etc/rc2.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc2.d/S95FOGPingHosts: No such file or directory
grep: /etc/fog: No such file or directory
grep: /etc/alternatives/jre/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_1.7.0/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_openjdk/lib/audio/default.sf2: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc4.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc4.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc4.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc5.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc5.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc5.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc2.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc2.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc2.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc3.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc3.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc3.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc3.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc3.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc3.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc3.d/S95FOGScheduler: No such file or directory
grep: /etc/rc3.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc3.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc4.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc4.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc4.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc4.d/S95FOGScheduler: No such file or directory
grep: /etc/rc4.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc4.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc5.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc5.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc5.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc5.d/S95FOGScheduler: No such file or directory
grep: /etc/rc5.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc5.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc2.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc2.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc2.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc2.d/S95FOGScheduler: No such file or directory
grep: /etc/rc2.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc2.d/S95FOGPingHosts: No such file or directory
grep: /etc/fog: No such file or directory
grep: /etc/alternatives/jre/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_1.7.0/lib/audio/default.sf2: No such file or directory
grep: /etc/alternatives/jre_openjdk/lib/audio/default.sf2: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc4.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc4.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc4.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc4.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc5.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc5.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc5.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc5.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc2.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc2.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc2.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc2.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc.d/rc3.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc.d/rc3.d/S95FOGScheduler: No such file or directory
grep: /etc/rc.d/rc3.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc.d/rc3.d/S95FOGPingHosts: No such file or directory
grep: /etc/rc3.d/S97FOGSnapinReplicator: No such file or directory
grep: /etc/rc3.d/S97FOGSnapinHash: No such file or directory
grep: /etc/rc3.d/S96FOGMulticastManager: No such file or directory
grep: /etc/rc3.d/S95FOGScheduler: No such file or directory
grep: /etc/rc3.d/S97FOGImageReplicator: No such file or directory
grep: /etc/rc3.d/S95FOGPingHosts: No such file or directory
OK
 * Backing up user reports.....................................Done
 * Stopping web service........................................OK
 * Removing vhost file.........................................OK
 * Is the MySQL password blank? (Y/n)
 * Setting up Apache and PHP files.............................OK
 * Testing and removing symbolic links if found................OK
 * Backing up old data.........................................OK
 * Copying new files to web folder.............................OK
find: `/home//fog_web_1.3.4.BACKUP/management/other/': No such file or directory
 * Creating config file........................................OK
 * Unzipping the binaries......................................Done
 * Copying binaries where needed...............................Done
 * Enabling apache and fpm services on boot....................OK
 * Creating SSL CA.............................................OK
 * Creating SSL Private Key....................................OK
 * Creating SSL Certificate....................................OK
 * Creating auth pub key and cert..............................OK
 * Resetting SSL Permissions...................................OK
 * Setting up SSL FOG Server...................................OK
 * Restarting Apache2 for fog vhost............................OK
 * Changing permissions on apache log files....................OK
 * Backing up database.........................................OK

 * You still need to install/update your database schema.
 * This can be done by opening a web browser and going to:

   http://192.168.8.22/fog/management

 * Press Enter key when database is updated/installed.

This time when I point a browser at the URL I get:

The 192.168.8.22 page isn’t working

192.168.8.22 is currently unable to handle this request.
HTTP ERROR 500

Friday evening fun

Just to qualify, we still have our FOG 1.2.0 server running (have had it going for what seems like years) but we’re installing a new FOG 1.3.4 system to start grappling with Windows 10 issues.

[Tom Elliott]

@PeterAxis And I repeat again, please install the 1.3.5-RC series. It will work.

[george1421]

OR to translate what Tom said:

cd <place_where_to_save_installer_files>
git clone https://github.com/fogproject/fogproject.git
cd fogproject
git checkout dev-branch
cd bin
./installfog.sh -y

[Wayne Workman]

@PeterAxis

Direct quote from https://www.centos.org/download/

Legacy versions of CentOS are no longer supported.

Community Enterprise Operating System (CentOS) is free to all, so please use the latest version.

[PeterAxis]

I appreciate the feedback if not the message and it’s delivery method. Thank you.

Whilst I understand the desire to have more people on latest versions, I’m interested in stable rather than RC, hence the choice of 1.3.4 version. A simple “FOG 1.3.4 needs CentOS 7” would have been sufficient. Rather than critiquing my choice of OS time might be better spent on updating documentation.

Quoting from the FOG 1.3.4 installation.txt file that I uncompressed yesterday:

Overview
--------

FOG is an Open-Source computer imaging solution. It currently works with
        Windows XP, Windows Vista, Windows 7, Windows 8, and Linux ext 2,3,4
        (beta). FOG ties together many open-source applications and adds a web
        interface to manage everything.

Installation
------------

The installer is only known to work correctly on:
        Ubuntu 10.04, 12.04, 13.10
        CentOS 6.4,6.5 (assumed RHEL of same versions)
        Earlier than Fedora 19
        Debian 7.4, 7.5
Assumed Actions before installing;
 * Update OS, yum -y update, or sudo apt-get update, or whatever your OS uses
 ** for managing updates.
 * disable firewall (ufw/iptables)
 * disable selinux
 * default packages
 * static IP v4 address

Likewise wiki doesn’t appear to state that CentOS 6 should be avoided. Unless I missed something? Simple table of versions and OS requirements?

Please consider this one closed.

[Tom Elliott]

@PeterAxis the installation.txt file that you obtained that from is leftover and I felt needed to remain for “historical” reasons. That particular file was essentially the same as had been from 1.2.0. Since that point we’ve moved into a more heavily used method of instruction as described from the https://github.com/fogproject/fogproject.git

That all said, I try to make the installation as OS agnostic as possible. While CentOS may not give up a lot of information in “legacy” versions, FOG itself tries to keep using things. For most CentOS installations work just fine and I know for a fact this is the case. 1.3.4 had some issues with which I was made mainly aware for the case of Ubuntu versions. I only recommend attempting the RC’s because they present more progress in fixing problems while being, for the most part, stable “enough” versions. The RC’s are attempts to work out any unexpected bugs but ultimately minimal changes to the overall code base.

I understand wanting to be on the “stable” releases, but as you are seeing “stable” can be a very relative term.

[Tom Elliott]

I say all of this as I run CentOS 6 on two of my “test” systems.

[Joe Schmitt]

@PeterAxis

@Wayne-Workman provided a recommendation on upgrading to the latest version of Cent OS. That is not critiquing. Secondly, the solution to your problem was the first post on this thread, thanks to @Tom-Elliott. A bug was found in the latest release with CentOS 6, and was patched in our current RCs.

To be blunt here, providing unneeded hostility does not help. We’re a completely free open source project developed and supported by people donating their spare time because they want to help further FOGs goal. Our documentation is mostly community built; if you see an issue with it, politely report it or even request wiki write access and help fix it.

[Wayne Workman]

You can find an installation guide for CentOS 7 here: https://wiki.fogproject.org/wiki/index.php?title=CentOS_7