I would very much like to join the discussion on this. Please remember though that I am just simply a computer tech for a school district. I don’t have the background or knowledge on software development or programming or anything like that. My main goal is simply trying to install printers that are already created on our print server in our district. Previously we had Novell Zenworks, the printer management in that was pretty great. I don’t know how familiar you are with Zenworks, but we simply made a printer policy which basically made a policy that linked a printer on our print server to a machine. Everytime a user logged in it would install the printer if it was not already created for the user, since we made the printer policy for the device and not the user.

As mentioned in this thread, the printer is created in FOG and the printer is pushed out to the machine, but we also need it to remove the printer. In my case it is not removing. I would need to manually remove it. I have not had time to try on different models to see if it’s a model specific problem, but this is where I am at now. In the future I plan to try other models, but since this is not high priority right now, I have pushed printer management to the side.

On the bottom right corner on the dashboard it says Version 1.5.6.

@sebastian-roth
I changed the passwords for this post.

MariaDB [(none)]> SELECT * FROM mysql.user;
+-----------+------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-----------------------+
| Host      | User       | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin                | authentication_string |
+-----------+------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-----------------------+
| localhost | root       | *7FB1F1B8AD1B4CFD57ERT8E761B6ADFF70D04FA0 | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            | Y                      |          |            |             |              |             0 |           0 |               0 |                    0 |                       |                       |
| 127.0.0.1 | root       |                                           | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            | Y                      |          |            |             |              |             0 |           0 |               0 |                    0 | mysql_native_password |                       |
| ::1       | root       |                                           | Y           | Y           | Y           | Y           | Y           | Y         | Y           | Y             | Y            | Y         | Y          | Y               | Y          | Y          | Y            | Y          | Y                     | Y                | Y            | Y               | Y                | Y                | Y              | Y                   | Y                  | Y                | Y          | Y            | Y                      |          |            |             |              |             0 |           0 |               0 |                    0 | mysql_native_password |                       |
| %         | fogstorage | *35C8661957485DE278FFGH9B7C348770BB41AD4C | N           | N           | N           | N           | N           | N         | N           | N             | N            | N         | N          | N               | N          | N          | N            | N          | N                     | N                | N            | N               | N                | N                | N              | N                   | N                  | N                | N          | N            | N                      |          |            |             |              |             0 |           0 |               0 |                    0 |                       |                       |
+-----------+------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+-----------------------+-----------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> 

@sebastian-roth

Yes, I know the root password.

[root@fogserver ~]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 14
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> 

@sebastian-roth
I set the name ‘fogstorage’. There was already a randomly generated password in the line below.

No success opening WebUI.

private static function _dbSettings()
    {
        define('DATABASE_TYPE', 'mysql'); // mysql or oracle
        define('DATABASE_HOST', 'localhost');
        define('DATABASE_NAME', 'fog');
        define('DATABASE_USERNAME', 'fogstorage');

@sebastian-roth
I changed snmysqluser to ‘fogmaster’. It was previously ‘foguser’. Re-ran installer. It stopped at same error.

Failed!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!! The installer was not able to run all the way to the end as   !!
!! something has caused it to fail. The following few lines are  !!
!! from the error log file which might help us figure out what's !!
!! wrong. Please add this information when reporting an error.   !!
!! As well you might want to take a look at the full error log   !!
!! in /root/fogproject/bin/error_logs/fog_error_1.5.9.log !!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

chsh: Shell not changed.
Changing shell for fogproject.
New password: Retype new password: Changing password for user fogproject.
passwd: all authentication tokens updated successfully.
ERROR 1396 (HY000) at line 31: Operation CREATE USER failed for ''@'localhost'
[root@fogserver bin]# 

@sebastian-roth

I may have changed something during that first update, I vaguely remember changing a username.

[root@fogserver bin]# grep DATABASE_USERNAME /var/www/html/fog/lib/fog/config.class.php
        define('DATABASE_USERNAME', '');
You have new mail in /var/spool/mail/root
[root@fogserver bin]# 

[root@fogserver fogproject]# git status
# On branch master
nothing to commit, working directory clean

@sebastian-roth

I have done an update before. I forget what the beginning version for me was, but I believe I may have done that install with tar.gz. I was following the installation instructions from the wiki. When I updated to 1.5.9RC1, just before last summer I believe, I did that one through github. I only say that because I remember asking to have that site open since our firewall was blocking it. Now I am using github to update. I ran these commands for the update I am attempting now from another post.

cd /root/fogproject
git checkout master
git pull
cd bin
./installfog.sh

Separate thing I noticed was that I was trying to use the GUI to navigate to the .sql file but it has an X on the root folder.

Not sure if that means anything. I cannot open it. Forgive me for not being more in depth if needed, I am new to linux.

@sebastian-roth
I was already running installer with sudo -i, but I also went back and tried it with sudo su - but with same result. Ran command. I deleted the passwords for this post.

[root@fogserver bin]# cat /root/fogproject/tmp/fog-db-and-user-setup.sql
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI' ;
DELETE FROM mysql.user WHERE User='' ;
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1') ;
DROP DATABASE IF EXISTS test ;
DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%' ;
CREATE DATABASE IF NOT EXISTS fog ;
USE fog ;
DROP PROCEDURE IF EXISTS fog.create_user_if_not_exists ;
DELIMITER 7061
CREATE PROCEDURE fog.create_user_if_not_exists()
BEGIN
  DECLARE masteruser BIGINT DEFAULT 0 ;
  DECLARE storageuser BIGINT DEFAULT 0 ;

  SELECT COUNT(*) INTO masteruser FROM mysql.user
    WHERE User = '' and  Host = 'localhost' ;
  IF masteruser > 0 THEN
    DROP USER ''@'localhost';
  END IF ;
  CREATE USER ''@'localhost' IDENTIFIED BY '' ;
  GRANT ALL PRIVILEGES ON fog.* TO ''@'localhost' ;

  SELECT COUNT(*) INTO storageuser FROM mysql.user
    WHERE User = 'fogstorage' and  Host = '%' ;
  IF storageuser > 0 THEN
    DROP USER 'fogstorage'@'%';
  END IF ;
  CREATE USER 'fogstorage'@'%' IDENTIFIED BY '' ;
END ;7061
DELIMITER ;
CALL fog.create_user_if_not_exists() ;
DROP PROCEDURE IF EXISTS fog.create_user_if_not_exists ;
FLUSH PRIVILEGES ;
SET SQL_MODE=@OLD_SQL_MODE ;
[root@fogserver bin]# 

@sebastian-roth

Yes, I re-ran installer making sure to use sudo, but came back with same issue. Here are the results of the command you asked for.

[root@fogserver bin]# grep snmysqluser /opt/fog/.fogsettings
snmysqluser='fogstorage'

I am trying to upgrade from 1.5.9 RC1 to 1.5.9 on CentOS 7. I run the installer and I get to this point with an error.

I have no idea what it means and I try to access the error log file just so I can see and I get this.

Also, I have no access to FOG web interface now. I get “Database Connection unavailable” now on the page.

Any guidance would be appreciated. Thank you.

I recently had to change the IP address of the fog server. I followed this guide and changed all IP address settings from 192.168.10.200 to the new one of 10.4.1.100

https://wiki.fogproject.org/wiki/index.php?title=Change_FOG_Server_IP_Address

Problem is when I do pxe boot, the HTTP portion is wrong. Where do I go to change this?