Create users who can only use the function WOL

Fernando Gietz

FOG can not do the thing that you say. You can control the access to the main menus using the controlAccess Plugin, with this plugin you can “erase” the icons in the menu bar, in this way you can enable the access to some users to Dashboard, Hosts, Groups and Logout entries in the menu bar.

Lenain

Hello,
Thank you for your answer, I will try this Plugin.

Lenain

Hello,
I have installed the plugin but when I try to add user to be member of the Access Control role nothing happen.
Does this plugin work with 1.5.5?
Thanks

Fernando Gietz

Hello @Lenain ,

Do you assign rules to the role?

By default are two roles: Administrator and technician. And when you install the plugin, the plugin creates some default rules. These rules can be to config the main menu, the top tool bar, and to config the access to the submenus.

First assign users to the role
Second assign rules to the role.

Lenain

Hello @Fernando-Gietz ,
Thank’s for your help.
I’ve tried to assign users to the role before assign rules but it don’t work.
I check the box to see users, I check the user and click Add button but it is not assign to the role.

Fernando Gietz

The user, is local? Do you create it from web user interface?

Lenain

@Fernando-Gietz
The user have been created from the web user interface.

Fernando Gietz

@Lenain I think that you find a bug XD.
Well, I think that we can apply a workaround.

Go to the database:
select * from roleUserAssoc;
±------±--------±----------±----------+
| ruaID | ruaName | ruaRoleID | ruaUserID |
±------±--------±----------±----------+
| 27 | | 2 | 180 |
| 96 | | 1 | 216 |

Is your user in this table?
Do you use the LDAP plugin?

Lenain

Hello @Fernando-Gietz,
I don’t use LDAP plugin, here the result of mysql:
text alternatif
I have 3 users and I can only see one:

Thanks for your help ^^

Fernando Gietz

@Lenain Can you see all users in the Users page (Users -> List All Users)?
Please, can you show the users table in the database?

Lenain

Hi @Fernando-Gietz,
Here sql:
text alternatif
Here All Users:

Does it help?

Fernando Gietz

@Lenain Do you assign the prof user (uId = 4) to the Profs role? or to technician role (rID = 2)

#select * from roles;

This Profs role, has any rule associated?
Has technician role any rule associated?

#select * from roleRuleAssoc;

Fernando Gietz

How create roles and rules:
https://forums.fogproject.org/topic/9624/control-access-plugin/14

Lenain

Hi @Fernando-Gietz,
-My problem is that I can’t assign a user to a role. When I try to add it (select the user and click on add) nothing happen, the member section of Profs role stay empty.
-Yes the Profs role have rules but technician have nothing:
text alternatif
I’ve tried to use technician instead but I have the same problem.
-Here the result of mysql:

Fernando Gietz

Hi @Lenain ,

When you try to assign an user, does the php log throw an error?

Your version is 1.5.5, no? Can you update it from working branch?

Lenain

Hi @Fernando-Gietz,
I got no error from php, but I got this from mysql:
MysqlError

I already have installed it from working branch, does an update will help?

Thanks for your help ^^

Sebastian Roth

@Lenain About crashed tables and how to recover, read this: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Repair_broken_database

If that doesn’t help, the web is full of help on this… https://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed

Lenain

hello @Sebastian-Roth,
Thank you for the tip, I don’t have any error with mysql ^^
But sadly it doesn’t solve my problem with Access Control Management…

Fernando Gietz

That is very strange!!

Let’s go to begin again. We will to reset all

Unistall the plugin
Verify that the tables roleRuleAssoc, roleUserAssoc, roles and rules are being erased from the database by the uninstall process.
Reinstall the plugin
To test if the plugin works fine, we will not create a new role, we use the roles that the install process create. For example, administrator role.
After install the plugin, go to users page -> List all Users. Does appear a new column named “Role”?
Go to AccessControl Page -> List all Roles. Select Administrator role.
Go to Rules tab -> Check the checkbox to see the rules that can be assign.
Select MAIN_MENU-about, MAIN_MENU-printer adn MAIN_MENU-storage.
Go to Members tab -> Check the checkbox to see the users that can be added.
Select fog user (for example, you can select profs users if you want). Does appear the fog user in the list of members?
Go to User Page -> list all users. Does appear in the role column the name of the role in fog row?
Any error log in the apache log?

Lenain

@Fernando-Gietz

Unistall the plugin -> Ok

Verify that the tables roleRuleAssoc, roleUserAssoc, roles and rules are being erased from the database by the uninstall process. -> Ok

Reinstall the plugin -> Ok

To test if the plugin works fine, we will not create a new role, we use the roles that the install process create. For example, administrator role. -> Ok

After install the plugin, go to users page -> List all Users. Does appear a new column named “Role”? -> No, there is no column “Role” only "API, “Username” and “Friendly Name”. In mysql the table “users” have uID, uName, uPass, uCreateDate, uCreateBy, uType, uDisplay, UAllowAPI, uAPIToken.

Do I have to add uRole in users table?

Create users who can only use the function WOL

146

11.7k

17.2k

154.7k