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

    After mysql root passwort reset no login and webgui available

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    14
    4.5k
    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.
    • B
      BryceZ
      last edited by

      Check /var/www/fog/commons/config.php on your FOG server to make sure MYSQL_PASSWORD matches with the new password.

      1 Reply Last reply Reply Quote 0
      • N
        n1ete
        last edited by

        Thanks the WebUI is back online but i still can’t log in?! any ideas?

        1 Reply Last reply Reply Quote 0
        • B
          BryceZ
          last edited by

          I’d suggest resetting the WebUI password, but you said you already did that. What sort of message does it give you when you try to log in?

          1 Reply Last reply Reply Quote 0
          • N
            n1ete
            last edited by

            no, message, nothing it trows me back on the login site with blank fields

            1 Reply Last reply Reply Quote 0
            • B
              BryceZ
              last edited by

              The only time I’ve ever encountered a blank refresh of the login page is from attempting to login without a password. What happens if you try to put in an incorrect password? You might want to reset the WebUI password just to be certain.

              1 Reply Last reply Reply Quote 0
              • N
                n1ete
                last edited by

                mmh tryed it with a wrong password and its the same, after reset the the webui password again i recognize that it gives me back: rows matched:0 changed:0 warnings:0
                this should be more like 1 1 0 or?

                1 Reply Last reply Reply Quote 0
                • B
                  BryceZ
                  last edited by

                  Yeah, that sounds like there is a problem with the syntax. Could you paste a copy of the commands you used and their output?

                  1 Reply Last reply Reply Quote 0
                  • N
                    n1ete
                    last edited by

                    [quote=“BryceZ, post: 12877, member: 2”]Yeah, that sounds like there is a problem with the syntax. Could you paste a copy of the commands you used and their output?[/quote]
                    mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;
                    Query OK, 0 rows affected (0.00 sec)
                    Rows matched: 0 Changed: 0 Warnings: 0

                    thats it!

                    after that an flush und a quit

                    1 Reply Last reply Reply Quote 0
                    • B
                      BryceZ
                      last edited by

                      Hmmmm…

                      What do you get from running:
                      [CODE]SELECT * FROM users;[/CODE]

                      1 Reply Last reply Reply Quote 0
                      • N
                        n1ete
                        last edited by

                        its a bit hard to give everything 1 to 1 back because fog is running at an esxi in VM

                        there is only one entry with uID 1 and uName admin uPass “hash” uCreateDate 0000-00-00 00:00:00

                        is it possible that the first tutorial something broke??

                        1 Reply Last reply Reply Quote 0
                        • B
                          BryceZ
                          last edited by

                          Did you rename the WebUI account to admin? It looks like you just need to change the WebUI password reset from:
                          [CODE]UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;[/CODE]
                          to:
                          [CODE]UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘admin’;[/CODE]

                          1 Reply Last reply Reply Quote 0
                          • N
                            n1ete
                            last edited by

                            Thank you so much!so apparently i changed the user to admin?! i realy shouldnt setup server in the late night 🙂
                            mmh now if i want to deploy an image it says:
                            “[CENTER][SIZE=16px][FONT=Ubuntu][COLOR=#333333]Unable to connect to tftp server.”[/COLOR][/FONT][/SIZE][/CENTER]

                            [CENTER][SIZE=16px][FONT=Ubuntu][COLOR=#333333]so there are maybe several files where i have to change the password too…can you help me with that also? :)[/COLOR][/FONT][/SIZE][/CENTER]

                            1 Reply Last reply Reply Quote 0
                            • N
                              n1ete
                              last edited by

                              update: i use this how to but nothing changed…did i have to change the usernamen from fog to admin as well?

                              [url]http://www.fogproject.org/wiki/index.php/Unable_to_connect_to_TFTP[/url]

                              the other thing is every changed password is now in cleartext visible?!

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

                              150

                              Online

                              12.1k

                              Users

                              17.3k

                              Topics

                              155.3k

                              Posts
                              Copyright © 2012-2024 FOG Project