Fog WebUI Password Successfully Reset But Still Can't Login

[Sebastian Roth]

@lmioperations No what Tom meant was to actually run the command exactly as he posted because the MD5() is a mysql function that does generate a hash from that string. So try:

UPDATE `users` SET `uPass` = MD5('password') WHERE `uName` = 'fog';

And see if login works using password

[lmioperations]

@sebastian-roth Sebastian… I’m confused… I posted the exact command that I typed, and it DOES include “MD5()” with the password hash inside it. I did it correctly already, right?

[lmioperations]

I think I may have found the problem! I’m kinda surprised nobody thought to try this! I just ran:

mysql> select user from mysql.user;
+------------------+
| user             |
+------------------+
| fogstorage       |
| debian-sys-maint |
| mysql.session    |
| mysql.sys        |
| root             |
+------------------+
5 rows in set (0.00 sec)

Notice there’s no “fog” user! This is especially confusing to me since I followed these instructions to a tee!:
https://wiki.fogproject.org/wiki/index.php?title=Restoring_FOG_from_Backup

[Tom Elliott]

No, copy my command exactly. Not changing 'password' at all. Of course using the MD5 you could use any plain text.

Right now, your password is set literally to:
$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.

[lmioperations]

@tom-elliott Ah, I get what you’re saying now, sorry 'bout that; my bad.

OK, so I copied and pasted this (exactly) and here are the results:

UPDATE `users` SET `uPass` = MD5('password') WHERE `uName` = 'fog';

I just tried logging in with “fog” and “password”, but it still fails.

Did you notice my post earlier where I said that I don’t see a “fog” user in the mySQL db?

[Tom Elliott]

@lmioperations You’re not changing the fog user password for mysql. You’re changing the user that sits in fog.users

[lmioperations]

@tom-elliott Dang, this is getting more confusing :D.

[Tom Elliott]

Are you sure caps-lock isn’t set and all. I know it seems stupid, but this doesn’t make sense.

What if you copy the word password and use the copy paste to the password field.

[lmioperations]

@tom-elliott Capslock is definitely not on. You saw exactly what I pasted into the shell prompt (what you see in my previous post is what I copied straight out of my shell prompt from the server) :-X…

[Tom Elliott]

In chat requested @lmioperations edit /opt/fog/.fogsettings and remove the packages line. Then re-run the installer. All things seemed to point that mcrypt packages weren’t installed or enabled.

After rerunning the installer @lmioperations is able to login to the GUI using the password as set.

[lmioperations]

@tom-elliott You rock Tom! Thanks for the help man! : )