• 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.
    • 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

                            242

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project