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

    Can't login to management after saving FOG settings

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    58
    15.6k
    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.
    • M
      Mark Pickard
      last edited by

      [quote=“Uncle Frank, post: 43614, member: 28116”]Would it be possible to dump your whole FOG database and upload that dump file to this forum?? I’d love to push this data into my database to see if it looks me out as well… I hope there is no sensitive data in it. Please look through the file an delete password hashes before posting the file here!
      [CODE]$ mysqldump --databases fog --user <your-db-user> -p > fog_dump.sql[/CODE][/quote]

      Have at it. 🙂

      [url=“/_imported_xf_attachments/1/1779_fog_dump.zip?:”]fog_dump.zip[/url]

      1 Reply Last reply Reply Quote 0
      • S
        Sebastian Roth Moderator
        last edited by

        Alright, I think I found it! It’s one single setting in the ‘globalSettings’ table…

        Go to phpmyadmin, select ‘fog’ database, then ‘globalSettings’, find the value with ID ‘106’ and name ‘FOG_INACTIVITY_TIMEOUT’. I guess it is set to ‘fog’ (at least it was in the dump). Change it to ‘1’ (one) and you should be able to login again…

        The rest is up to Tom I am afraid as I don’t know the web interface enough to see where this could happen. You said that it happended twice when you changed settings… Maybe Tom has an idea!?

        But I am still wondering why this is only happening to you?! So many people out there using it and I’ve never seen anyone reporting this. How come??

        Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

        Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

        1 Reply Last reply Reply Quote 0
        • M
          Mark Pickard
          last edited by

          [quote=“Uncle Frank, post: 43740, member: 28116”]Alright, I think I found it! It’s one single setting in the ‘globalSettings’ table…

          Go to phpmyadmin, select ‘fog’ database, then ‘globalSettings’, find the value with ID ‘106’ and name ‘FOG_INACTIVITY_TIMEOUT’. I guess it is set to ‘fog’ (at least it was in the dump). Change it to ‘1’ (one) and you should be able to login again…

          The rest is up to Tom I am afraid as I don’t know the web interface enough to see where this could happen. You said that it happended twice when you changed settings… Maybe Tom has an idea!?

          But I am still wondering why this is only happening to you?! So many people out there using it and I’ve never seen anyone reporting this. How come??[/quote]

          That’s it! Bonus points for Uncle Frank!! Changed the FOG_INACTIVITY_TIMEOUT value to a 1 and got right in.

          Yes, both times this has happened (on two separate installations) I was changing settings on the FOG configuration page at /fog/management/index.php?node=about&sub=settings. Once it was AD settings and the other it was TFTP settings. As soon as I hit the “Save Changes” button it booted me back to the sign in page and from that point I could never sign back in. Previous to that I had changed other settings without any problems. And on my latest install (in a VM) I’ve been changing settings without issue too.

          Uncle Frank, thanks for the help and for sticking with me on this.

          Tom, any idea why this happened and how do I make sure it doesn’t happen on my latest VM install?

          1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott
            last edited by

            No idea why it changed to FOG. It’s on a slider so it should only allow the values within the range bar. I’ve added some checkers to the elements for ensuring it’s only ever going to be a numeric value though.

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by

              [quote=“Mark Pickard, post: 43751, member: 609”]… and how do I make sure it doesn’t happen on my latest VM install?[/quote]
              Make sure you always have phpmyadmin installed and you’ll be back in the game…

              Can you reproduce this again?? Install phpmyadmin (if not installed already), make changes to your settings till you get locked off. Let yourself in again and try again… We need to reproduce the error to be able to fin a fix!

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • D
                Digital Dog
                last edited by

                I’m having the same problem. I just finished setting up my first FOG server. I made some changes through the web interface, and now I am unable to log back in. I’ve read the thread, but am uncertain what I need to do. As some of you who helped me earlier know, I’ve only been working with Ubuntu for the past couple of days. I have zero understanding of MySQL. If you can provide some guidance perhaps my situation can help you find a fix. Thanks again.

                1 Reply Last reply Reply Quote 0
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  [code]mysql -u root fog
                  update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
                  exit;
                  [/code]

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                  1 Reply Last reply Reply Quote 0
                  • D
                    Digital Dog
                    last edited by

                    [quote=“Tom Elliott, post: 43757, member: 7271”][code]mysql -u root fog
                    update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
                    exit;
                    [/code][/quote]

                    Tom,
                    I’m getting a message “Access denied for user ‘root’ @ ‘localhost’ (using password: NO)”.

                    1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      So you set a password for your mysql?

                      Change the code to:
                      [code]mysql -u root -p fog[/code]

                      Enter the password set for the mysql user. Once in:

                      [code]
                      update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
                      exit;[/code]

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • D
                        Digital Dog
                        last edited by

                        [quote=“Tom Elliott, post: 43762, member: 7271”]So you set a password for your mysql?

                        Change the code to:
                        [code]mysql -u root -p fog[/code[

                        Enter the password set for the mysql user. Once in:

                        [code]
                        update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
                        exit;[/code][/quote]

                        Ok Tom, I’m clearly typing something incorrectly. Received "Unknown database ‘fog[/code[’ I’ve tried several different ways of typing it but no luck.

                        1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott
                          last edited by

                          remove the [/code[ part of the command that was a typo on my side

                          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • D
                            Digital Dog
                            last edited by

                            [quote=“Tom Elliott, post: 43772, member: 7271”]remove the [/code[ part of the command that was a typo on my side[/quote]

                            I made the changes, but it did not resolve the issue. I finally just wiped the server and started over. I’m back in the management portal, but am concerned to make any changes. Does anyone know which items are causing this problem?

                            1 Reply Last reply Reply Quote 0
                            • Wayne WorkmanW
                              Wayne Workman
                              last edited by

                              We need to troubleshoot EXACTLY what change in the web GUI is causing this… wiping/reinstalling (while I understand you need to remain productive at work) does not help us do that.

                              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                              Daily Clean Installation Results:
                              https://fogtesting.fogproject.us/
                              FOG Reporting:
                              https://fog-external-reporting-results.fogproject.us/

                              1 Reply Last reply Reply Quote 0
                              • D
                                Digital Dog
                                last edited by

                                [quote=“Wayne Workman, post: 43803, member: 28155”]We need to troubleshoot EXACTLY what change in the web GUI is causing this… wiping/reinstalling (while I understand you need to remain productive at work) does not help us do that.[/quote]

                                I appreciate the feedback, however, as you said, I have to remain productive at work. I have been without an imaging server for 3 days now and the customers aren’t going to continue to wait. I have made changes via the web GUI without any issues so far. In order to try to determine which changes are causing the problem, I am saving after each change instead of waiting to save once all changes are done. It’s tedious, but it might help isolate the problem. I will re-post if I experience it again. Thank you all for you assistance.

                                1 Reply Last reply Reply Quote 0
                                • Tom ElliottT
                                  Tom Elliott
                                  last edited by

                                  [quote=“Digital Dog, post: 43811, member: 28953”]I appreciate the feedback, however, as you said, I have to remain productive at work. I have been without an imaging server for 3 days now and the customers aren’t going to continue to wait. I have made changes via the web GUI without any issues so far. In order to try to determine which changes are causing the problem, I am saving after each change instead of waiting to save once all changes are done. It’s tedious, but it might help isolate the problem. I will re-post if I experience it again. Thank you all for you assistance.[/quote]

                                  That shouldn’t really matter. The reason is for all of the save buttons on that page, it saves all entries. The button’s only there to help you know where you last made changes at.

                                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                                  Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                  Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                  1 Reply Last reply Reply Quote 0
                                  • M
                                    Mark Pickard
                                    last edited by

                                    [quote=“Uncle Frank, post: 43753, member: 28116”]Make sure you always have phpmyadmin installed and you’ll be back in the game…

                                    Can you reproduce this again?? Install phpmyadmin (if not installed already), make changes to your settings till you get locked off. Let yourself in again and try again… We need to reproduce the error to be able to fin a fix![/quote]

                                    I’ve been using my new setup in the vm without any problems. Have made several changes to the settings without issue. So no, I haven’t been able to reproduce it. 😞 But, two things I did not install on the new vm were phpmyadmin and webmin - didn’t need them since I can easily access the server directly through VMware. Don’t know if one of them is maybe the culprit.

                                    1 Reply Last reply Reply Quote 0
                                    • S
                                      Sebastian Roth Moderator
                                      last edited by

                                      Thanks for reporting back although I am not happy that at least two people had an issue with this but we are unable to find out why! I have phpmyadmin installed on all my FOG servers so I suspect it to not be the problem. And I’d really wonder if webmin plays a role in this either. But could you still install webmin just to make sure??

                                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                      1 Reply Last reply Reply Quote 0
                                      • M
                                        Mark Pickard
                                        last edited by

                                        [quote=“Uncle Frank, post: 44104, member: 28116”]Thanks for reporting back although I am not happy that at least two people had an issue with this but we are unable to find out why! I have phpmyadmin installed on all my FOG servers so I suspect it to not be the problem. And I’d really wonder if webmin plays a role in this either. But could you still install webmin just to make sure??[/quote]

                                        I hate to try to break a working server but since it’s a vm I guess it’s not a big deal - just take a snapshot before I do it. So…for the greater good…I’m off to try to crash my server. 🙂

                                        1 Reply Last reply Reply Quote 0
                                        • M
                                          Mark Pickard
                                          last edited by

                                          [quote=“Mark Pickard, post: 44113, member: 609”]I hate to try to break a working server but since it’s a vm I guess it’s not a big deal - just take a snapshot before I do it. So…for the greater good…I’m off to try to crash my server. :)[/quote]

                                          Installed phpmyadmin and webmin on my working vm after taking a snapshot. Signed in to both to confirm that they’re working. In the FOG web interface I went to FOG Configuration | Active Directory Defaults (this is one of the areas that made it stop working before). I made some changes and then clicked the Save Changes button…and of course it works without any problem. Went down to the TFTP section (which was where it crashed the very first time) and made some changes. Hit the Save Changes button - no problem.

                                          Couple of observations:
                                          1.) This vm Ubuntu install (12.04) has current updates installed. My first two that crashed did not.
                                          2.) Don’t know if the order of install makes any difference (phpmyadmin before webmin or vice versa).

                                          Gotta love seemingly unrepeatable bugs. 😞

                                          1 Reply Last reply Reply Quote 0
                                          • Wayne WorkmanW
                                            Wayne Workman
                                            last edited by

                                            So,

                                            Does anyone care to install Ubuntu 12.04 and apply no updates, then install phpmyadmin and webmin, and then jack around with TFTP and AD passwords?

                                            NOT ME. I is happily Fedora going. 🙂

                                            I’ll catch the next Fedora bug we find 😉

                                            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                                            Daily Clean Installation Results:
                                            https://fogtesting.fogproject.us/
                                            FOG Reporting:
                                            https://fog-external-reporting-results.fogproject.us/

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

                                            237

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project