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

    Authentication Error

    Scheduled Pinned Locked Moved Unsolved
    FOG Problems
    3
    16
    3.6k
    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.
    • Wayne WorkmanW
      Wayne Workman @Joe Gill
      last edited by

      @Joe-Gill Going off of this thread, I think your DB is dirty.
      Please try the database maintenance commands here. Please report back with the outcome.

      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
      • Tom ElliottT
        Tom Elliott
        last edited by

        @Joe-Gill said in Authentication Error:

        5/16/2017 3:48 PM Middleware::Response Error multiple hosts returned for list of mac addresses

        The quoted text is the problem, which means it doesn’t know which host to associate with.

        I don’t know that the DB is necessarily “dirty” persay, but most likely one of the mac’s being passed is associated to more than one host. (This is bad and technically dirty I suppose, but can happen for more reasons than “corrupt” database though much less likely now than in the past.)

        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

        Wayne WorkmanW 1 Reply Last reply Reply Quote 1
        • Wayne WorkmanW
          Wayne Workman @Tom Elliott
          last edited by Wayne Workman

          @Tom-Elliott I guess we need a maintenance command to delete MACs that are associated to more than one host. Dirty isn’t the same as corrupt - corrupt is a question of integrity being compromised. Dirty is just things not being right. Like a typo in a text file is dirty, and half the text file just going missing one day is corrupt.

          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 0
          • J
            Joe Gill
            last edited by

            @Tom-Elliott
            @Wayne-Workman

            Well I may have bigger issues than this… mysql will not run… not even as root.

            root@fogserver:~# mysql -D fog
            ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
            J 1 Reply Last reply Reply Quote 0
            • J
              Joe Gill @Joe Gill
              last edited by

              Nevermind… I see that mysql can be a problem with Ubuntu… I will follow the steps in the Wiki and report back.

              Wayne WorkmanW 1 Reply Last reply Reply Quote 0
              • Wayne WorkmanW
                Wayne Workman @Joe Gill
                last edited by Wayne Workman

                @Joe-Gill It doesn’t mention that if you have a password set, you should use the password option. I figure that’s something the admin should just know… but it should be in the wiki.

                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 0
                • J
                  Joe Gill
                  last edited by

                  @Tom-Elliott
                  @Wayne-Workman

                  Well, I followed the steps in the Wiki to resolve the mysql issue with zero luck. I also tried to re-install mysql and did not succeed.

                  I verified that the Username and Password were correct from the /var/www/fog/lib/fog/Config.class.php and /opt/fog/.fogsettings files… and re-ran sudo dpkg-reconfigure mysql-server-5.5… I even tried re-running this command with the password found in the Config.class.php file. The command ran but I was still getting the same error.

                  Any ideas?

                  root@fogserver:~# sudo apt-get install mysql-server-5.5
                  Reading package lists... Done
                  Building dependency tree
                  Reading state information... Done
                  mysql-server-5.5 is already the newest version.
                  mysql-server-5.5 set to manually installed.
                  The following packages were automatically installed and are no longer required:
                    libonig2 libqdbm14
                  Use 'apt-get autoremove' to remove them.
                  0 upgraded, 0 newly installed, 0 to remove and 7 not upgraded.
                  root@fogserver:~# mysql
                  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
                  root@fogserver:~#
                  
                  1 Reply Last reply Reply Quote 0
                  • Tom ElliottT
                    Tom Elliott
                    last edited by

                    You need to find the mac’s that system is sending, and figure out which one is already associated to another host.

                    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

                    J 1 Reply Last reply Reply Quote 0
                    • J
                      Joe Gill @Tom Elliott
                      last edited by

                      @Tom-Elliott

                      I can do that. But do I need to find them within the SQL database and if so, what do I do since I can’t seem to access the database?

                      1 Reply Last reply Reply Quote 0
                      • J
                        Joe Gill
                        last edited by

                        @Tom-Elliott

                        I got it figured out. Yes there were multiple machines with the same Mac addresses. I removed one and that resolved the issue. Thanks for making me look harder!

                        Now… As for the mysql problem. Do you have any ideas on how to resolve that?

                        Wayne WorkmanW 1 Reply Last reply Reply Quote 0
                        • Wayne WorkmanW
                          Wayne Workman @Joe Gill
                          last edited by

                          @Joe-Gill

                          sudo -i
                          mysql -u root -D fog

                          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/

                          J 1 Reply Last reply Reply Quote 0
                          • J
                            Joe Gill @Wayne Workman
                            last edited by Wayne Workman

                            @Wayne-Workman
                            I tried that… I’m still getting this.

                            ERROR 1045 (28000): Access denied for user 'root@localhost' (using password: NO)
                            
                            Tom ElliottT Wayne WorkmanW 2 Replies Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott @Joe Gill
                              last edited by

                              @Joe-Gill Does your mysql root user have a password?

                              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 1
                              • Wayne WorkmanW
                                Wayne Workman @Joe Gill
                                last edited by

                                @Joe-Gill look in the .fogsettings file and see if there is a password set for the mysql one.

                                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 0
                                • 1 / 1
                                • First post
                                  Last post

                                185

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project