• 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

      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

        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

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • B
            bbroersma
            last edited by

            [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

              “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

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • B
                  bbroersma
                  last edited by

                  This post is deleted!
                  1 Reply Last reply Reply Quote 0
                  • B
                    bbroersma
                    last edited by

                    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

                      This post is deleted!
                      1 Reply Last reply Reply Quote 0
                      • B
                        bbroersma
                        last edited by

                        This post is deleted!
                        1 Reply Last reply Reply Quote 0
                        • B
                          bbroersma
                          last edited by

                          This post is deleted!
                          1 Reply Last reply Reply Quote 0
                          • S
                            sam-white
                            last edited by

                            [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

                              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

                                Glad you figured it out. 🙂

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

                                158

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project