• 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
    6.3k
    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.
    • LenainL
      Lenain @Fernando Gietz
      last edited by

      @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

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

        LenainL 1 Reply Last reply Reply Quote 0
        • LenainL
          Lenain @Fernando Gietz
          last edited by

          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

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

            LenainL 1 Reply Last reply Reply Quote 0
            • LenainL
              Lenain @Fernando Gietz
              last edited by

              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

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

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

                  1 Reply Last reply Reply Quote 0
                  • LenainL
                    Lenain @Fernando Gietz
                    last edited by

                    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

                      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?

                      LenainL 1 Reply Last reply Reply Quote 0
                      • LenainL
                        Lenain @Fernando Gietz
                        last edited by

                        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

                          @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

                          LenainL 1 Reply Last reply Reply Quote 0
                          • LenainL
                            Lenain @Sebastian Roth
                            last edited by

                            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

                              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?
                              LenainL 1 Reply Last reply Reply Quote 1
                              • LenainL
                                Lenain @Fernando Gietz
                                last edited by

                                @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

                                  @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

                                  LenainL 1 Reply Last reply Reply Quote 0
                                  • LenainL
                                    Lenain @Fernando Gietz
                                    last edited by

                                    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

                                      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

                                        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

                                        LenainL 1 Reply Last reply Reply Quote 0
                                        • LenainL
                                          Lenain @Fernando Gietz
                                          last edited by

                                          Hello @Fernando-Gietz,
                                          Ok, when the rules are applied the icons disappear it work!
                                          it work
                                          But the “members” section of “roles” stay empty.
                                          text alternatif
                                          text alternatif
                                          Is it possible to hide “Access Controls” to? Is it possible to hide “snapins” or “printers” in group management? In “Basic Tasks” could we only show “Wake-Up”?

                                          Thanks for your help ^^

                                          1 Reply Last reply Reply Quote 0
                                          • F
                                            Fernando Gietz Developer
                                            last edited by

                                            @Lenain said in Create users who can only use the function WOL:

                                            Is it possible to hide “Access Controls” to?

                                            Yes, you can add a new rule.

                                            • Access Control -> Add new rule
                                            Rule Type: MAIN_MENU
                                            Parent: main
                                            Node Parent: [empty]
                                            Value: accesscontrol
                                            

                                            Is it possible to hide “snapins” or “printers” in group management? In “Basic Tasks” could we only show “Wake-Up”?

                                            No, the rules are applied to the icons of the top toolbar (MAIN_MENU rules) and to the items of the Principal Menu section (SUB_MENULINK rules)

                                            LenainL 1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post

                                            143

                                            Online

                                            12.1k

                                            Users

                                            17.3k

                                            Topics

                                            155.3k

                                            Posts
                                            Copyright © 2012-2024 FOG Project