• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

FOG installation errors

Scheduled Pinned Locked Moved Solved
FOG Problems
4
54
9.9k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T
    TaTa @Daniel Miller
    last edited by Nov 15, 2019, 6:00 PM

    @Daniel-Miller You are right. I checked my other fog server and it does have a wildcard but this one is localhost.

    i’m getting this error when creating one using the wildcard (after dropping fogstorage user).
    ERROR 1396 (HY000): Operation CREATE USER failed for ‘fogstorage’@‘%’

    ±--------------±--------------+
    | user | host |
    ±--------------±--------------+
    | root | [myserverIP |
    | fogstorage | localhost |
    | mysql.session | localhost |
    | mysql.sys | localhost |
    | root | localhost |
    ±--------------±--------------+

    D 1 Reply Last reply Nov 15, 2019, 7:01 PM Reply Quote 0
    • S
      Sebastian Roth Moderator
      last edited by Nov 15, 2019, 6:26 PM

      @TaTa said in FOG installation errors:

      ERROR 1396 (HY000): Operation CREATE USER failed for ‘fogstorage’@’%’

      No more error message???

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      1 Reply Last reply Reply Quote 0
      • T
        TaTa
        last edited by Nov 15, 2019, 6:51 PM

        @Sebastian-Roth No more. Just that single line.

        1 Reply Last reply Reply Quote 0
        • D
          Daniel Miller @TaTa
          last edited by Nov 15, 2019, 7:01 PM

          @TaTa each username-host pairing is considered a distinct user, so there is no need to drop fogstorage@localhost before adding fogstorage@‘%’. That being said, if the user fogstorage@‘%’ has existed in the MySQL instance at any time since either A) the MySQL service has been restarted or B) the privilege table has been reloaded, the user you are attempting to add likely still exists in memory which would result in error 1396 if you attempt to add the same user again. Try restarting the mysql service or performing a flush privileges; in mysql and try again.

          T 1 Reply Last reply Nov 15, 2019, 7:08 PM Reply Quote 0
          • T
            TaTa @Daniel Miller
            last edited by Nov 15, 2019, 7:08 PM

            @Daniel-Miller I did flush privileges a few times before reporting it. I even restarted the server a few times/ stopped/started mysql but no go.

            D 1 Reply Last reply Nov 15, 2019, 9:24 PM Reply Quote 0
            • D
              Daniel Miller @TaTa
              last edited by Nov 15, 2019, 9:24 PM

              @TaTa What is the result of select vvalue from fog.schemaVersion;?

              T 1 Reply Last reply Nov 18, 2019, 3:21 PM Reply Quote 0
              • T
                TaTa @Daniel Miller
                last edited by Nov 18, 2019, 3:21 PM

                @Daniel-Miller I was able to update database schema. I have to created the account with localhost and altered fogstorage account and set the host to ‘%’ but storage node and create new image still didn’t work. Then I deleted fogstorage and fog database and uninstalled fog and then reinstalled FOG and was able to update database schema without issue. But Storage node and creating new image still don’t work. I’m pretty sure there are some settings in mysql that is causing this.

                D 1 Reply Last reply Nov 18, 2019, 5:14 PM Reply Quote 0
                • D
                  Daniel Miller @TaTa
                  last edited by Nov 18, 2019, 5:14 PM

                  @TaTa said in FOG installation errors:

                  But Storage node and creating new image still don’t work.

                  What message(s) appear when accessing the storage node or attempting to create a new image? Can you post the Apache error (/var/log/httpd/error_log), php error (/var/log/php*-fpm.log), and mysql error logs (/var/log/mysql/error)? It may also be helpful to verify your error log verbosity is at least 2 in your my.cnf.

                  1 Reply Last reply Reply Quote 0
                  • T
                    TaTa
                    last edited by Nov 18, 2019, 5:30 PM

                    I re-ran the installation. Everything was working properly. I rebooted the server. the same issues came back. Re-ran installation, issue fixed. How do I make sure all of the required services are running?

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by Nov 18, 2019, 8:47 PM

                      @TaTa said in FOG installation errors:

                      the same issues came back.

                      Which exact issue do you mean. Since starting the topic we ran into half a dozen issues and I am not sure which one you see now.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      T 1 Reply Last reply Nov 18, 2019, 9:10 PM Reply Quote 0
                      • T
                        TaTa @Sebastian Roth
                        last edited by Nov 18, 2019, 9:10 PM

                        @Sebastian-Roth Storage Node unable to connect and create a new image in Images/Create new images

                        1 Reply Last reply Reply Quote 0
                        • S
                          Sebastian Roth Moderator
                          last edited by Sebastian Roth Nov 18, 2019, 4:29 PM Nov 18, 2019, 10:28 PM

                          @TaTa Can you please take a picture of the actual error(s) and post here. From the sound of things it’s caused by a messed up Linux account fogproject. This is a service account used by the FOG server and you shouldn’t use it to login or even change it’s password.

                          Please take a look at the config in /var/www/html/fog/lib/fog/config.class.php (TFTP_FTP_PASSWORD) to see what password it should be set to. As well check /opt/fog/.fogsettings to make sure it’s the same in there. Then use an FTP client (like WinSCP, FileZilla, …) and try to connect to your FOG server via FTP using those credentials.

                          It’s interesting you say that it works after re-running the installer but has issues when restarting the server. Please try rebooting your server and check for vsftpd process/service running after it booted up.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • T
                            TaTa
                            last edited by Nov 18, 2019, 10:53 PM

                            @Sebastian-Roth You are right. vsftpd service wasn’t running. I have noticed vsftpd service gets disabled/deleted after a period of time or on reboot. xinetd and tftp service turns of by itself. I followed instructions on wiki page to disable selinux but it keeps on coming back. Any idea why?

                            D 1 Reply Last reply Nov 18, 2019, 11:08 PM Reply Quote 0
                            • D
                              Daniel Miller @TaTa
                              last edited by Nov 18, 2019, 11:08 PM

                              @TaTa You mentioned early on that this machine is managed by an external entity. You may want to check with them to see if they are using some tool to enforce a desired state, such as Ansible, Puppet, or Chef.

                              T 1 Reply Last reply Nov 18, 2019, 11:11 PM Reply Quote 0
                              • T
                                TaTa @Daniel Miller
                                last edited by Nov 18, 2019, 11:11 PM

                                @Daniel-Miller Thanks Daniel. They use puppet. I’ll shoot them an email.

                                Thanks again everyone for all the help.

                                1 Reply Last reply Reply Quote 0
                                • 1
                                • 2
                                • 3
                                • 3 / 3
                                3 / 3
                                • First post
                                  49/54
                                  Last post

                                159

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project