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

[BusyTech]

@Wayne-Workman

Okay I think I have found what the next step is. As you can see from my previous posts (I forgot to link them to you…long day) that it ran into an error and said unable to locate package svn. Isn’t it referred to as subversion so I would have to run

sudo apt-get install subversion

Please confirm as I don’t want to mess this server up any more than I already have with my stupid mistake.
Thanks

[Wayne Workman]

@BusyTech I would still suggest using git instead.

[BusyTech]

@Wayne-Workman Okay I will go do that now. I was wondering about that.

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