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

    Fog WebUI Password Successfully Reset But Still Can't Login

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    25
    3.2k
    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.
    • L
      lmioperations @Tom Elliott
      last edited by lmioperations

      @tom-elliott I just did a show databases; and this is the results:

      mysql> show databases;
      +--------------------+
      | Database           |
      +--------------------+
      | information_schema |
      | fog                |
      | mysql              |
      | performance_schema |
      | sys                |
      +--------------------+
      5 rows in set (0.00 sec)
      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        Can you try:

        UPDATE `users` SET `uPass` = MD5('password') WHERE `uName` = 'fog';
        

        I know you’re using 1.3 or higher, but the MD5 mechanism should work as well.

        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

        L 1 Reply Last reply Reply Quote 1
        • L
          lmioperations @Tom Elliott
          last edited by lmioperations

          @tom-elliott Let me know if I did this correctly (it looks like I did):

          mysql> UPDATE `users` SET `uPass` = MD5('$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.') WHERE `uName` = 'fog';
          Query OK, 1 row affected (0.00 sec)
          Rows matched: 1  Changed: 1  Warnings: 0
          

          Was I supposed to use the ( and ) in that command?

          I just tested my login again (“fog” as the username and “password” as the password), and got the same results 😞 (the login screen clears and there’s no message or error).

          BTW, the “Changed: 1” is because I hadn’t changed/updated it since running the “test” earlier.

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator
            last edited by

            @lmioperations No what Tom meant was to actually run the command exactly as he posted because the MD5() is a mysql function that does generate a hash from that string. So try:

            UPDATE `users` SET `uPass` = MD5('password') WHERE `uName` = 'fog';
            

            And see if login works using password

            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

            L 1 Reply Last reply Reply Quote 1
            • L
              lmioperations @Sebastian Roth
              last edited by

              @sebastian-roth Sebastian… I’m confused… I posted the exact command that I typed, and it DOES include “MD5()” with the password hash inside it. I did it correctly already, right?

              1 Reply Last reply Reply Quote 0
              • L
                lmioperations
                last edited by

                I think I may have found the problem! I’m kinda surprised nobody thought to try this! I just ran:

                mysql> select user from mysql.user;
                +------------------+
                | user             |
                +------------------+
                | fogstorage       |
                | debian-sys-maint |
                | mysql.session    |
                | mysql.sys        |
                | root             |
                +------------------+
                5 rows in set (0.00 sec)
                

                Notice there’s no “fog” user! This is especially confusing to me since I followed these instructions to a tee!:
                https://wiki.fogproject.org/wiki/index.php?title=Restoring_FOG_from_Backup

                1 Reply Last reply Reply Quote 0
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  No, copy my command exactly. Not changing 'password' at all. Of course using the MD5 you could use any plain text.

                  Right now, your password is set literally to:
                  $2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.

                  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

                  L 1 Reply Last reply Reply Quote 0
                  • L
                    lmioperations @Tom Elliott
                    last edited by

                    @tom-elliott Ah, I get what you’re saying now, sorry 'bout that; my bad.

                    OK, so I copied and pasted this (exactly) and here are the results:

                    UPDATE `users` SET `uPass` = MD5('password') WHERE `uName` = 'fog';
                    

                    I just tried logging in with “fog” and “password”, but it still fails.

                    Did you notice my post earlier where I said that I don’t see a “fog” user in the mySQL db?

                    Tom ElliottT 1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott @lmioperations
                      last edited by

                      @lmioperations You’re not changing the fog user password for mysql. You’re changing the user that sits in fog.users

                      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

                      L Tom ElliottT 2 Replies Last reply Reply Quote 0
                      • L
                        lmioperations @Tom Elliott
                        last edited by

                        @tom-elliott Dang, this is getting more confusing :D.

                        1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott @Tom Elliott
                          last edited by

                          Are you sure caps-lock isn’t set and all. I know it seems stupid, but this doesn’t make sense.

                          What if you copy the word password and use the copy paste to the password field.

                          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

                          L 1 Reply Last reply Reply Quote 0
                          • L
                            lmioperations @Tom Elliott
                            last edited by lmioperations

                            @tom-elliott Capslock is definitely not on. You saw exactly what I pasted into the shell prompt (what you see in my previous post is what I copied straight out of my shell prompt from the server) :-X…

                            1 Reply Last reply Reply Quote 0
                            • Tom ElliottT
                              Tom Elliott
                              last edited by

                              In chat requested @lmioperations edit /opt/fog/.fogsettings and remove the packages line. Then re-run the installer. All things seemed to point that mcrypt packages weren’t installed or enabled.

                              After rerunning the installer @lmioperations is able to login to the GUI using the password as set.

                              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

                              L 1 Reply Last reply Reply Quote 2
                              • L
                                lmioperations @Tom Elliott
                                last edited by

                                @tom-elliott You rock Tom! Thanks for the help man! : )

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

                                147

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project