• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.
  • W
    Wayne Workman @Joe Gill
    last edited by May 17, 2017, 2:07 AM

    @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
    • T
      Tom Elliott
      last edited by May 17, 2017, 2:15 AM

      @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

      W 1 Reply Last reply May 17, 2017, 3:13 AM Reply Quote 1
      • W
        Wayne Workman @Tom Elliott
        last edited by Wayne Workman May 16, 2017, 9:14 PM May 17, 2017, 3:13 AM

        @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 May 17, 2017, 1:06 PM

          @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 May 17, 2017, 1:07 PM Reply Quote 0
          • J
            Joe Gill @Joe Gill
            last edited by May 17, 2017, 1:07 PM

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

            W 1 Reply Last reply May 17, 2017, 1:08 PM Reply Quote 0
            • W
              Wayne Workman @Joe Gill
              last edited by Wayne Workman May 17, 2017, 7:09 AM May 17, 2017, 1:08 PM

              @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 May 17, 2017, 1:25 PM

                @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
                • T
                  Tom Elliott
                  last edited by May 17, 2017, 2:28 PM

                  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 May 17, 2017, 2:29 PM Reply Quote 0
                  • J
                    Joe Gill @Tom Elliott
                    last edited by May 17, 2017, 2:29 PM

                    @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 May 17, 2017, 2:58 PM

                      @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?

                      W 1 Reply Last reply May 17, 2017, 4:25 PM Reply Quote 0
                      • W
                        Wayne Workman @Joe Gill
                        last edited by May 17, 2017, 4:25 PM

                        @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 May 17, 2017, 5:00 PM Reply Quote 0
                        • J
                          Joe Gill @Wayne Workman
                          last edited by Wayne Workman Jan 22, 2018, 2:21 PM May 17, 2017, 5:00 PM

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

                          ERROR 1045 (28000): Access denied for user 'root@localhost' (using password: NO)
                          
                          T W 2 Replies Last reply May 17, 2017, 5:08 PM Reply Quote 0
                          • T
                            Tom Elliott @Joe Gill
                            last edited by May 17, 2017, 5:08 PM

                            @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
                            • W
                              Wayne Workman @Joe Gill
                              last edited by May 17, 2017, 5:57 PM

                              @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
                              1 / 1
                              • First post
                                12/16
                                Last post

                              121

                              Online

                              12.1k

                              Users

                              17.3k

                              Topics

                              155.3k

                              Posts
                              Copyright © 2012-2024 FOG Project