Server
- FOG Version: 1.3.4 stable
- OS: centos-release-6-6.el6.centos.12.2.x86_64
Client
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