• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Create users who can only use the function WOL

Scheduled Pinned Locked Moved
Feature Request
3
31
5.6k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L
    Lenain @Fernando Gietz
    last edited by 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.

    1 Reply Last reply Reply Quote 0
    • F
      Fernando Gietz Developer
      last edited by Jan 18, 2019, 2:52 PM

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

      L 1 Reply Last reply Jan 18, 2019, 3:25 PM Reply Quote 0
      • L
        Lenain @Fernando Gietz
        last edited by Jan 18, 2019, 3:25 PM

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

        1 Reply Last reply Reply Quote 0
        • F
          Fernando Gietz Developer
          last edited by Fernando Gietz Jan 18, 2019, 9:50 AM Jan 18, 2019, 3:47 PM

          @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?

          L 1 Reply Last reply Jan 21, 2019, 8:56 AM Reply Quote 0
          • L
            Lenain @Fernando Gietz
            last edited by Jan 21, 2019, 8:56 AM

            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:
            text alternatif
            Thanks for your help ^^

            1 Reply Last reply Reply Quote 0
            • F
              Fernando Gietz Developer
              last edited by 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?

              L 1 Reply Last reply Jan 22, 2019, 9:58 AM Reply Quote 0
              • L
                Lenain @Fernando Gietz
                last edited by Jan 22, 2019, 9:58 AM

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

                Does it help?

                1 Reply Last reply Reply Quote 0
                • F
                  Fernando Gietz Developer
                  last edited by 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;
                  
                  L 1 Reply Last reply Jan 25, 2019, 7:21 AM Reply Quote 0
                  • F
                    Fernando Gietz Developer
                    last edited by Jan 23, 2019, 12:15 PM

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

                    1 Reply Last reply Reply Quote 0
                    • L
                      Lenain @Fernando Gietz
                      last edited by 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:
                      text alternatif
                      I’ve tried to use technician instead but I have the same problem.
                      -Here the result of mysql:
                      text alternatif

                      1 Reply Last reply Reply Quote 0
                      • F
                        Fernando Gietz Developer
                        last edited by 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?

                        L 1 Reply Last reply Jan 28, 2019, 9:12 AM Reply Quote 0
                        • L
                          Lenain @Fernando Gietz
                          last edited by Jan 28, 2019, 9:12 AM

                          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 ^^

                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by Sebastian Roth Jan 28, 2019, 5:25 AM Jan 28, 2019, 11:23 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

                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                            L 1 Reply Last reply Jan 28, 2019, 11:49 AM Reply Quote 0
                            • L
                              Lenain @Sebastian Roth
                              last edited by 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…

                              1 Reply Last reply Reply Quote 0
                              • F
                                Fernando Gietz Developer
                                last edited by Jan 28, 2019, 1:06 PM

                                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?
                                L 1 Reply Last reply Jan 28, 2019, 1:37 PM Reply Quote 1
                                • L
                                  Lenain @Fernando Gietz
                                  last edited by 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?

                                  1 Reply Last reply Reply Quote 0
                                  • F
                                    Fernando Gietz Developer
                                    last edited by 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”?

                                    Screenshot_2019-01-28 Plugins instalados.png

                                    L 1 Reply Last reply Jan 28, 2019, 3:15 PM Reply Quote 0
                                    • L
                                      Lenain @Fernando Gietz
                                      last edited by 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.

                                      1 Reply Last reply Reply Quote 0
                                      • F
                                        Fernando Gietz Developer
                                        last edited by Jan 28, 2019, 3:19 PM

                                        Ok @Lenain , step by step 🙂

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

                                        Screenshot_2019-01-28 Todos Usuarios.png

                                        1 Reply Last reply Reply Quote 0
                                        • F
                                          Fernando Gietz Developer
                                          last edited by Fernando Gietz Jan 28, 2019, 10:14 AM Jan 28, 2019, 3:51 PM

                                          In the new version appears a new option in the user edit page. From here you can assign a role to the user too.

                                          Screenshot_2019-01-28 User API Settings.png

                                          When you assign a role to an user, the rules are applied inmediately. Be sure that the icons of About, Printer and Storage desappear.

                                          Screenshot_2019-01-28 User API Settings(2).png

                                          The rules are applied:
                                          Screenshot_2019-01-28 Dashboard.png

                                          L 1 Reply Last reply Feb 4, 2019, 10:39 AM Reply Quote 0
                                          • 1
                                          • 2
                                          • 2 / 2
                                          2 / 2
                                          • First post
                                            15/31
                                            Last post

                                          195

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project