Can't login to management after saving FOG settings
-
It seems awfully odd that this is a “FOG” specific problem considering there’s how many different users out there, and from what I can tell you’re the first who seems to get completely locked out of the system in such a manner.
-
What else are you doing on this Linux VM? Just FOG? What’s all the things that are installed? What versions?
-
[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]
Yeah, especially other PHP “apps” (other than phpmyadmin). In the end phpmyadmin might play a role too!!! But so far I don’t have any trouble and use it on most of my FOG servers… -
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=“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?
