Can't login after accidentally setting fog user to quick deployment
-
@Wayne-Workman Okay I will go do that now. I was wondering about that.
-
@Wayne-Workman
Okay I have completed the upgrading but now I am trying to reset my fog user account. When I use the second set of instructions that start withmysqlIt comes up that access is denied for user root. I know I set a password for the sql database but I cannot find instructions for the trunk on how to access mysql. Am I doing something wrong?
-
@BusyTech The password would (or should) still be present inside of .fogsettings, labeled as snmysqlpass or something like that. Run this command to see the file:
cat /opt/fog/.fogsettings -
@Wayne-Workman
Okay I have completed all of the steps and when I try to login as fog via the web interface it still says invalid login.
Now what?At least I have the latest trunk…
-
What is interesting is that before I did all of the steps I could login into the mobile section using fog and the password but I was unable to login into the regular page. Now I am unable to login into either. So it definitely reset something but I don’t know what.
-
@BusyTech Did you first delete the existing fog user?
-
@Wayne-Workman
No I did not as that was not part of the instructions. How do I do that? This is where being a noob makes it a little harder.
Thanks for all of your help. -
@BusyTech You could just truncate the table I guess.
Between the
use fogand the rest of the steps, do this:truncate table users; -
@Wayne-Workman
Sorry I didn’t see that as part of the instructions. Is it:sudo userdel fog -
@Wayne-Workman
That did not work either. Should I try
sudo userdel fogand then follow the instructions to create a user named fog? With the amount of time I have spent on this I could have rebuilt the entire virtual machine.
Thanks for your help.
-
@BusyTech Oh no, no no no. Don’t do that.
I think there is some confusion here.
You lost web access - this has absolutely nothing to do with the local fog user whatsoever.
This only requires work in MySQL to fix - that’s it.
-
@Wayne-Workman
Okay. I am glad you clarified. I only lost web access when I checked the box to allow that user to do quick deployments. Which, if I understand it correctly, changes that user to mobile access only. Unfortunately, I do not know how to reset that user to give them web access again.I would rather not rebuild the whole thing but nothing seems to be working. I am learning a lot about it though. I guess that is the silver lining.
-
mysql use fog; truncate table users; INSERT INTO `users` (`uName`,`uPass`,`uCreateBy`,`uType`) VALUES ('fog','$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.','localAdmin','0');then try to log in.
After doing that, you’ll probably need to re-run the installer since you deleted the local fog user.
-
@Wayne-Workman
Just so you know I never ran the one command to delete the local fog user. I was just asking if that was the command.
Should i still do the above commands if haven’t deleted it?
Sorry for the confusion. I just know you are probably helping other people too. -
@Wayne-Workman
Completed that step. It came back as Query OK 1 row affected but NO LUCK. I did not delete the local fog user, at least not to the best of my knowledge. so I did not re-run the installer. -
@BusyTech You need to run all those commands I posted, in order. If you did not run the command to delete the local fog user then you don’t need to re-run the installer - but you should know it isn’t ever a bad thing to re-run the installer. It can help you solve issues.
-
@Wayne-Workman
I ran the codes in order that you posted. Unfortunately, it did not work. I will try running the installer but is there something else I should try?By the way, I am watching your Hitchhikers video. It is quite good. i really enjoyed the guy playing the guitar!
