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

How to change webui passwords w/o using webui

Scheduled Pinned Locked Moved
FOG Problems
2
14
3.9k
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
    bbroersma
    last edited by Apr 20, 2012, 7:13 PM

    Hello all,

    I am trying to figure out where FOG stores it’s usernames and passwords. I am working on a tftp issue and for some reason can NOT log in to the web UI. I’ve tried every possible combination that it could be and still no luck. I found the following, but it didn’t help:

    [url]http://fogproject.org/wiki/index.php?title=Reset_WebUI_FOG_password[/url]

    Anyone have any ideas or know which file stores them so I can manually edit them? Thank you for your time!

    1 Reply Last reply Reply Quote 0
    • S
      sam-white
      last edited by Apr 23, 2012, 1:05 PM

      Have you tried logging into MySQL using root and changing the password for the fog user?

      1 Reply Last reply Reply Quote 0
      • S
        sam-white
        last edited by Apr 23, 2012, 1:06 PM

        This post is deleted!
        1 Reply Last reply Reply Quote 0
        • B
          bbroersma
          last edited by Apr 23, 2012, 1:18 PM

          [quote=“sam-white, post: 2993, member: 118”]Have you tried logging into MySQL using root and changing the password for the fog user?[/quote]
          The link I have in my post is the method you are speaking of isn’t it? If not then no, I haven’t.

          1 Reply Last reply Reply Quote 0
          • S
            sam-white
            last edited by Apr 23, 2012, 1:22 PM

            “sudo” basically means run as root under this user. If you only used “sudo mysql” it should ask you for a root password. I would use the command “mysql -u root -p” to log into root and then try the link you posted.

            1 Reply Last reply Reply Quote 0
            • B
              bbroersma
              last edited by Apr 23, 2012, 5:44 PM

              This post is deleted!
              1 Reply Last reply Reply Quote 0
              • B
                bbroersma
                last edited by Apr 23, 2012, 5:47 PM

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • B
                  bbroersma
                  last edited by Apr 23, 2012, 5:50 PM

                  I did as you said and received this in response:

                  mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;
                  Query OK, 0 rows affected (0.00 sec)
                  Rows matched: 1 Changed: 0 Warnings: 0

                  I tried logging in using fog as the uname and password as the passwd and nothing happens. It doesn’t log in or give me an error, just reloads the log in page basically. Is there no way to manually edit these files without going through the terminal or mysql?

                  1 Reply Last reply Reply Quote 0
                  • B
                    bbroersma
                    last edited by Apr 23, 2012, 6:04 PM

                    This post is deleted!
                    1 Reply Last reply Reply Quote 0
                    • B
                      bbroersma
                      last edited by Apr 23, 2012, 6:05 PM

                      This post is deleted!
                      1 Reply Last reply Reply Quote 0
                      • B
                        bbroersma
                        last edited by Apr 23, 2012, 6:08 PM

                        This post is deleted!
                        1 Reply Last reply Reply Quote 0
                        • S
                          sam-white
                          last edited by Apr 24, 2012, 12:05 PM

                          [FONT=Arial][COLOR=#111111]Try the below. I would also look at “/var/www/fog/commons/config.php” and “/opt/fog/service/etc/config.php” to make sure your mysql info is defined. Since fog uses MySQL, the user and passwords are stored there. You can also install “phpmyadmin” and see if your fog user is there. If you can log into root, you should be able to change the password and assign permissions to that user.[/COLOR][/FONT]
                          [LIST=1]
                          [][FONT=Arial][COLOR=#111111]mysql -u root -p[/COLOR][/FONT]
                          [
                          ][FONT=Arial][COLOR=#111111]mysql> use mysql;[/COLOR][/FONT]
                          [*][FONT=Arial][COLOR=#111111]mysql> update user set password=PASSWORD(“NEW-PASSWORD-HERE”) where User=‘fog’;[/COLOR][/FONT]
                          [/LIST]

                          1 Reply Last reply Reply Quote 0
                          • B
                            bbroersma
                            last edited by Apr 25, 2012, 5:06 PM

                            That did not work either, but the problem has been solved! Thank you very, extremely, much for helping me try to figure this thing out. It turns out somehow the only user we had in the database was [U]NOT[/U] the admin for some reason, my friendly neighborhood programmer found that issue and resolved it.

                            1 Reply Last reply Reply Quote 0
                            • S
                              sam-white
                              last edited by Apr 25, 2012, 5:17 PM

                              Glad you figured it out. 🙂

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

                              143

                              Online

                              12.0k

                              Users

                              17.3k

                              Topics

                              155.2k

                              Posts
                              Copyright © 2012-2024 FOG Project