Can't login to management after saving FOG settings
-
[quote=“Wayne Workman, post: 43510, member: 28155”]What else are you doing on this Linux VM? Just FOG? What’s all the things that are installed? What versions?[/quote]
On the FOG VM (this is the new install that’s currently working) all I’ve got going is FOG (other than Samba and RDP).
-
[quote=“Wayne Workman, post: 43523, member: 28155”]Tom suggested that you check this (on the broken FOG vm) in the FOG data base: [FONT=arial][COLOR=#222222]Globalsettings.[/COLOR][/FONT][FONT=arial][COLOR=#222222]fog_regenerate_[/COLOR][/FONT][FONT=arial][COLOR=#222222]timeout[/COLOR][/FONT]
[FONT=arial][COLOR=#222222]That’s the table and field for the timeout setting. it should NOT be set to zero…[/COLOR][/FONT]
[FONT=arial][COLOR=#222222]beyond that, I’ve got nothing.[/COLOR][/FONT][/quote]
[FONT=arial][COLOR=#222222]Globalsettings.[/COLOR][/FONT][FONT=arial][COLOR=#222222]fog_regenerate_[/COLOR][/FONT][FONT=arial][COLOR=#222222]timeout is set to [/COLOR][/FONT]0.5
And just to review: my first two FOG installations that ended up locking me out were both on physical machines (both on the same hardware). I just recently brought up a third install in a VM as per your suggestion. That one is working OK so far.
-
[quote=“Mark Pickard, post: 43549, member: 609”][FONT=arial][COLOR=#222222]Globalsettings.[/COLOR][/FONT][FONT=arial][COLOR=#222222]fog_regenerate_[/COLOR][/FONT][FONT=arial][COLOR=#222222]timeout is set to [/COLOR][/FONT]0.5
And just to review: my first two FOG installations that ended up locking me out were both on physical machines (both on the same hardware). I just recently brought up a third install in a VM as per your suggestion. That one is working OK so far.[/quote]
That’s good. Just make a snapshot before each config change, and after each successful major change like a new image, new hosts, etc. Just be smart with your snapshots, you don’t need a whole lot. I normally keep just two.
-
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=“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]
-
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=“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?
-
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.
-
[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!
-
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.
-
[code]mysql -u root fog
update globalSettings set settingValue=‘1’ where settingKey=‘FOG_INACTIVITY_TIMEOUT’;
exit;
[/code] -
[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)”. -
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=“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.
-
remove the [/code[ part of the command that was a typo on my side
-
[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?
-
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=“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.
-
[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.
-
[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.
