• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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 Jul 5, 2013, 1:55 PM

    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 Jul 8, 2013, 12:40 PM

      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 Jul 8, 2013, 1:11 PM

        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 Jul 8, 2013, 1:18 PM

          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 Jul 8, 2013, 1:23 PM

            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 Jul 8, 2013, 1:31 PM

              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 Jul 8, 2013, 1:33 PM

                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 Jul 8, 2013, 2:24 PM

                  [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 Jul 8, 2013, 2:25 PM

                    Hmmmm…

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

                    1 Reply Last reply Reply Quote 0
                    • N
                      n1ete
                      last edited by Jul 8, 2013, 2:35 PM

                      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 Jul 8, 2013, 2:46 PM

                        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 Jul 9, 2013, 7:39 AM

                          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 Jul 9, 2013, 1:21 PM

                            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
                            1 / 1
                            • First post
                              11/14
                              Last post

                            140

                            Online

                            12.1k

                            Users

                            17.3k

                            Topics

                            155.3k

                            Posts
                            Copyright © 2012-2024 FOG Project