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

FOG NODE - Access Denied

Scheduled Pinned Locked Moved
FOG Problems
4
11
2.7k
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.
  • I
    ITCC
    last edited by Jul 14, 2016, 10:52 AM

    Just updated to latest SVN and noticed access denied in out put.
    Is this an issue?

    0_1468493564713_upload-2e4f1e43-35a7-4a41-96ca-11b6d0cfdf74

    1 Reply Last reply Reply Quote 0
    • Q
      Quazz Moderator
      last edited by Jul 14, 2016, 11:28 AM

      Could we have some more details such as OS, FOG version, do you have storage nodes, etc

      1 Reply Last reply Reply Quote 0
      • I
        ITCC
        last edited by Jul 14, 2016, 11:36 AM

        this is the storage node.
        V 1.2.0 (8581) (Debian)

        IP in the error relates to itself, not the FOG Master

        Q 1 Reply Last reply Jul 14, 2016, 11:42 AM Reply Quote 0
        • T
          Tom Elliott
          last edited by Jul 14, 2016, 11:41 AM

          As this is a node you installed, most likely there’s two things causing this.

          First, you’re logging in with the mysql root user. This will not work (Redhat, Fedora, Debian, Ubuntu, etc…) unless you create the wildcard to enable users to login with that.

          Second, if it is of the debian variants (Ubuntu, Debian, etc…) you likely need to disable bind-address to enable the wildcard users access.

          Third, why are you using the root mysql user on a node? The installation points you at exactly where you need to get this information during the initial install.

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          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 2
          • Q
            Quazz Moderator @ITCC
            last edited by Jul 14, 2016, 11:42 AM

            This post is deleted!
            1 Reply Last reply Reply Quote 0
            • Q
              Quazz Moderator
              last edited by Jul 14, 2016, 11:45 AM

              See also:

              https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#MySQL_credentials_for_FOG_Main_and_Storage_Nodes

              1 Reply Last reply Reply Quote 1
              • W
                Wayne Workman
                last edited by Jul 14, 2016, 12:11 PM

                Tom and Quazz are correct.

                The storage node installation now checks to see if the machine it’s running on exists as a storage node in the fog DB on the main server. If it does not exist, it tries to register itself.

                In this case, because it couldn’t contact the main server’s database due to incorrect snmysqluser, snmysqlpass, and snmysqlhost being set inside of /opt/fog/.fogsettings on that storage node.

                Additionally, because that one part failed due to credentials, that storage node isn’t functioning correctly, won’t be able to report progress, won’t be able to host boot roms at all, and probably other things won’t work either.

                You can find the correct credentials in the web interface here:
                Web Interface -> FOG Configuration -> FOG Settings -> FOG Storage Nodes -> FOG_STORAGENODE_MYSQLPASS
                And set those inside of /opt/fog/.fogsettings correctly.

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                Daily Clean Installation Results:
                https://fogtesting.fogproject.us/
                FOG Reporting:
                https://fog-external-reporting-results.fogproject.us/

                1 Reply Last reply Reply Quote 1
                • I
                  ITCC
                  last edited by Aug 1, 2016, 8:07 AM

                  Thanks for the reply, sorry for the delay (holiday).

                  Looking at MySQL, looks like root can’t be used (if i’m reading it right) unless i make a change.
                  Although, should i not be using fogstorage?? what would the password be.

                  0_1470038717588_upload-c97bde50-ae0b-4f5f-b2f2-9b37267481f0

                  T 1 Reply Last reply Aug 1, 2016, 9:38 AM Reply Quote 0
                  • T
                    Tom Elliott @ITCC
                    last edited by Aug 1, 2016, 9:38 AM

                    @ITCC correct. Root access to a database is very typically blocked except for coming from the localhost (ipv4 localhost = localhost or 127.0.0.1, ipv6 = ::1).

                    You can fix it, but seeing as this is a node, FOG creates the “fogstorage” user you see, which is done on a “wildcard” or the %. This enables any host to connect to that user. That user is restricted to ONLY the FOG Database, and the password is generated during the first install.

                    If you need help with this, please let us know, but as @Wayne-Workman, @Quazz, and I have already stated, just update the node’s snmysqluser, snmysqlpass, and snmysqlhost to match that of what is stored in your database. The snmysqlhost will be set to whatever your FOG Server’s primary GUI access IP address will be.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                    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

                    I 1 Reply Last reply Aug 1, 2016, 9:59 AM Reply Quote 1
                    • I
                      ITCC @Tom Elliott
                      last edited by Aug 1, 2016, 9:59 AM

                      @Tom-Elliott

                      I have updated the /opt/fog/.fogsettings file on the NODE to use the username / password found in:
                      Web Interface -> FOG Configuration -> FOG Settings -> FOG Storage Nodes -> FOG_STORAGENODE_MYSQLPASS and FOG_STORAGENODE_MYSQLUSER

                      is there a way to test it’s working as when you took a look the other day, it seemed OK and then i found this only after.
                      When we looked at location setup, it seemed to be working fine.

                      Q 1 Reply Last reply Aug 1, 2016, 10:40 AM Reply Quote 0
                      • Q
                        Quazz Moderator @ITCC
                        last edited by Aug 1, 2016, 10:40 AM

                        @ITCC You need to run installfog.sh again after updating .fogsettings

                        1 Reply Last reply Reply Quote 1
                        • 1 / 1
                        • First post
                          Last post

                        226

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project