Cannot enter FOG Web Interface: "Not Allowed Here"

[***Redbob]

Hi!

I changed fog user permissions, due to another issue I posted (https://forums.fogproject.org/post/103617). Now the problem is that I cannot enter with fog user because it’s “not allowed here” (attached image).

I reinstalled FOG and the password was reset to ‘password’ default. But fog permissions were not changed, so I may understand that new FOG instalation didn’t reset user permissions.

I created another user with admin permissions before FOG reinstall (because I cannot enter WEB interface anymore), but I don’t remember who is he. Any solution for me, please?!

[Wayne Workman]

@redbob I’ve updated the wiki to include details for creating a user in FOG in 1.4.0 and 1.5.0. Future readers can find that information here: https://wiki.fogproject.org/wiki/index.php?title=Password_Central#Web_Interface

[***Redbob]

@wayne-workman, I found the admin password I created days ago. It was written in a paper in a desk. So I got enter web interface and recreated other users. Thanks!!

[Wayne Workman]

@redbob Then create a new user as I suggested in the below post, it should not have any restrictions on it since it’s a new user.

[***Redbob]

@wayne-workman I could delete fog user by your suggest, but when I try to insert a user I have this error:

mysql> INSERT INTO `users` (`uName`,`uPass`,`uCreateBy`,`uType`) VALUES ('fog','$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.','localAdmin','0');
ERROR 1364 (HY000): Field 'uCreateDate' doesn't have a default value
mysql> INSERT INTO `users` (`uName`,`uPass`,`uCreateBy`,`uType`) VALUES ('bob','$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.','localAdmin','0');
ERROR 1364 (HY000): Field 'uCreateDate' doesn't have a default value
mysql> 

I reinstalled fog Normal server using my 3g (just 23MB). At first try, fog user was “invalig login”. After I changed password by here

UPDATE `users` SET `uPass` = '$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.' WHERE `uName` = 'fog';

the answer was “Not Allowed Here”

[Wayne Workman]

@redbob Then you probably need to delete the FOG user and then recreate it via SQL. The commands for that should be:

mysql -D fog
DELETE FROM `users` WHERE `uName` = 'fog';
INSERT INTO `users` (`uName`,`uPass`,`uCreateBy`,`uType`) VALUES ('fog','$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.','localAdmin','0');
quit

Alternatively, you can create a brand-new username bob like this:

mysql -D fog
INSERT INTO `users` (`uName`,`uPass`,`uCreateBy`,`uType`) VALUES ('bob','$2y$11$g0Hu8OaOStuPk7WWYGh6Wu4PLlZDZGOkzMwEEAk.rZMrI9IdDwno.','localAdmin','0');
quit

The password for those hashes is just password

[***Redbob]

@wayne-workman, I did that before, but the issue here is not about passwords. If the password were wrong, the message would be “invalid logon”. I changed permissions to user FOG, not allowing web access. If I could find where in Apache or Mysql to revert it without need to access WEB interface, this issue could be solved. At the other hand, I did a full server install. Reinstall it will solve this issue? Because I Already did that.

[Wayne Workman]

@redbob Also you might try this: https://wiki.fogproject.org/wiki/index.php?title=Password_Central#Web_Interface

[Wayne Workman]

@redbob said in Cannot enter FOG Web Interface: “Not Allowed Here”:

I cannot access Ondrej repository due to firewall issues!!!

You should request that the site be allowed. This is an open source repository for used for Linux package install and patching purposes - there’s no reason to block it.

[***Redbob]

@wayne-workman, I did a full server install. It’s too painful to reinstall FOG, because at work I cannot access Ondrej repository due to firewall issues!!! Everytime I have to reinstall, I have to carry server home to do at my network…

[Wayne Workman]

@redbob Typically that message is only given when you try to access the GUI on a storage node. Did you do a full server install or a storage node install? Make sure you do the right installation. It’s OK to re-run the installer to do the correct installation.