Can't login after accidentally setting fog user to quick deployment

[BusyTech]

@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 with

mysql

It 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?

[Wayne Workman]

@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

[BusyTech]

@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…

[BusyTech]

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.

[Wayne Workman]

@BusyTech Did you first delete the existing fog user?

[BusyTech]

@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.

[Wayne Workman]

@BusyTech You could just truncate the table I guess.

Between the use fog and the rest of the steps, do this: truncate table users;

[BusyTech]

@Wayne-Workman
Sorry I didn’t see that as part of the instructions. Is it:

sudo userdel fog

[BusyTech]

@Wayne-Workman
That did not work either. Should I try
sudo userdel fog

and 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.

[Wayne Workman]

@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.

[BusyTech]

@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.

[Wayne Workman]

@BusyTech

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.

[BusyTech]

@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.

[BusyTech]

@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.

[Wayne Workman]

@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.

[BusyTech]

@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!