Create users who can only use the function WOL

Lenain · Jan 18, 2019, 2:40 PM

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 · Jan 18, 2019, 2:52 PM

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

Lenain · Jan 18, 2019, 3:25 PM

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

Fernando Gietz · Jan 18, 2019, 9:50 AM

@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 · Jan 21, 2019, 8:56 AM

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 · Jan 21, 2019, 4:14 PM

@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 · Jan 22, 2019, 9:58 AM

Hi @Fernando-Gietz,
Here sql:

Here All Users:

Does it help?

Fernando Gietz · Jan 22, 2019, 3:14 PM

@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 · Jan 23, 2019, 12:15 PM

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

Lenain · Jan 25, 2019, 7:21 AM

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 · Jan 25, 2019, 3:30 PM

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 · Jan 28, 2019, 9:12 AM

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 · Jan 28, 2019, 5:25 AM

@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 · Jan 28, 2019, 11:49 AM

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 · Jan 28, 2019, 1:06 PM

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 · Jan 28, 2019, 1:37 PM

@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 · Jan 28, 2019, 2:15 PM

@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 · Jan 28, 2019, 3:15 PM

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.