• 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

      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

                          118

                          Online

                          12.1k

                          Users

                          17.3k

                          Topics

                          155.3k

                          Posts
                          Copyright © 2012-2024 FOG Project