Create users who can only use the function WOL

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

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:

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:

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:

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

1. Unistall the plugin
2. Verify that the tables roleRuleAssoc, roleUserAssoc, roles and rules are being erased from the database by the uninstall process.
3. Reinstall the plugin
4. 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.
5. After install the plugin, go to users page -> List all Users. Does appear a new column named “Role”?
6. Go to AccessControl Page -> List all Roles. Select Administrator role.
7. Go to Rules tab -> Check the checkbox to see the rules that can be assign.
8. Select MAIN_MENU-about, MAIN_MENU-printer adn MAIN_MENU-storage.
9. Go to Members tab -> Check the checkbox to see the users that can be added.
10. Select fog user (for example, you can select profs users if you want). Does appear the fog user in the list of members?
11. Go to User Page -> list all users. Does appear in the role column the name of the role in fog row?
12. 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?

[Fernando Gietz]

@Lenain Do you update the version from working branch, no? In the plugin description, does appear “The access control can restrict using different roles and rules. Version 1.5.5”?

[Lenain]

Ok @Fernando-Gietz I haven’t update to working yet, it’s done now.

Everything seams fine except “Select fog user (for example, you can select profs users if you want). Does appear the fog user in the list of members?” The list of members still empty.

I’ve tried to connect with the limited user but it can access to every menu.

[Fernando Gietz]

Ok @Lenain , step by step

Do you see the new “Role” column in the user page?