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

    Group Service settings not applying, sort of...

    Scheduled Pinned Locked Moved Solved
    Bug Reports
    groups service-setting
    3
    13
    3.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.
    • JJ FullmerJ
      JJ Fullmer Testers
      last edited by

      @Senior-Developers Updated and tried it again. Still broken.

      Have you tried the FogApi powershell module? It's pretty cool IMHO
      https://github.com/darksidemilk/FogApi
      https://fogapi.readthedocs.io/en/latest/
      https://www.powershellgallery.com/packages/FogApi
      https://forums.fogproject.org/topic/12026/powershell-api-module

      Tom ElliottT 1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott @JJ Fullmer
        last edited by

        @JJ-Fullmer please check the groupMembers table. I have. Suspicion of 0 host ids somewhere

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

        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

        1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott
          last edited by

          Or group ids

          Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          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

          JJ FullmerJ 1 Reply Last reply Reply Quote 0
          • JJ FullmerJ
            JJ Fullmer Testers @Tom Elliott
            last edited by

            @Tom-Elliott 0 host id’s?
            So like go into command line and search for host id’s with 0 in the id?

            Have you tried the FogApi powershell module? It's pretty cool IMHO
            https://github.com/darksidemilk/FogApi
            https://fogapi.readthedocs.io/en/latest/
            https://www.powershellgallery.com/packages/FogApi
            https://forums.fogproject.org/topic/12026/powershell-api-module

            Tom ElliottT 1 Reply Last reply Reply Quote 0
            • Tom ElliottT
              Tom Elliott @JJ Fullmer
              last edited by

              @JJ-Fullmer On the groupMembers table yes

              Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

              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

              JJ FullmerJ 2 Replies Last reply Reply Quote 0
              • JJ FullmerJ
                JJ Fullmer Testers @Tom Elliott
                last edited by

                @Tom-Elliott

                MariaDB [fog]> select * from groupMembers;
                +------+----------+-----------+
                | gmID | gmHostID | gmGroupID |
                +------+----------+-----------+
                |    1 |       17 |        10 |
                |  100 |     1493 |         3 |
                |   72 |      128 |        15 |
                |    4 |      153 |        13 |
                |    5 |      154 |        13 |
                |    6 |       42 |         5 |
                |    7 |       93 |         4 |
                |    8 |        9 |         4 |
                |    9 |      126 |        15 |
                |   10 |      155 |        13 |
                |   11 |      129 |        15 |
                |   12 |      156 |        11 |
                |   13 |      157 |        11 |
                |   79 |      448 |        16 |
                |   78 |       69 |        16 |
                |   16 |      151 |        11 |
                |   17 |      152 |        11 |
                |   18 |      158 |        11 |
                |   19 |      150 |        11 |
                |   20 |      280 |        11 |
                |   21 |      302 |        11 |
                |   22 |      317 |         3 |
                |   77 |      395 |        16 |
                |   76 |      197 |        16 |
                |   75 |     1458 |        16 |
                |   26 |      145 |         7 |
                |   27 |      107 |         7 |
                |   28 |     1062 |         3 |
                |   29 |     1062 |         7 |
                |   30 |     1456 |         3 |
                |   31 |       34 |         3 |
                |   32 |       34 |         7 |
                |   33 |     1457 |         3 |
                |   34 |     1457 |        12 |
                |   35 |      135 |         3 |
                |   36 |      135 |         1 |
                |   37 |     1458 |         3 |
                |   74 |      358 |        16 |
                |   73 |      143 |        16 |
                |   40 |       89 |         3 |
                |   41 |       89 |         6 |
                |   42 |     1459 |         2 |
                |   43 |     1459 |         3 |
                |   44 |      106 |         3 |
                |   45 |      106 |        15 |
                |   49 |     1463 |         3 |
                |   47 |     1461 |         3 |
                |   50 |     1464 |         3 |
                |   51 |     1465 |         3 |
                |   52 |       48 |         3 |
                |   53 |       48 |         5 |
                |   54 |      139 |         3 |
                |   55 |      139 |         5 |
                |   56 |       98 |         3 |
                |   57 |       98 |        15 |
                |   59 |       10 |        15 |
                |   60 |       29 |        10 |
                |   61 |       21 |        10 |
                |   62 |      113 |        10 |
                |   63 |       31 |        10 |
                |   64 |       94 |        10 |
                |   99 |     1492 |        10 |
                |   66 |      112 |        10 |
                |  107 |       82 |         3 |
                |   68 |       28 |        10 |
                |   69 |       15 |         3 |
                |   70 |     1470 |        11 |
                |   81 |     1475 |        11 |
                |   80 |     1473 |        11 |
                |   82 |     1476 |        11 |
                |   83 |     1477 |        11 |
                |   84 |     1478 |        11 |
                |   85 |     1479 |        11 |
                |   86 |     1480 |        11 |
                |   87 |     1481 |        11 |
                |   88 |     1482 |        16 |
                |   89 |     1474 |        11 |
                |   94 |     1488 |         3 |
                |   95 |     1488 |        10 |
                |   96 |        7 |        13 |
                |   97 |        7 |         3 |
                |   98 |      140 |         8 |
                |  101 |     1493 |        10 |
                |  102 |     1494 |         3 |
                |  103 |     1494 |        10 |
                |  104 |       97 |         3 |
                |  105 |       97 |         7 |
                |  108 |       82 |         5 |
                |  109 |       83 |         3 |
                |  110 |       14 |         3 |
                |  111 |       26 |         3 |
                |  112 |      138 |         3 |
                |  113 |       78 |         3 |
                |  114 |       77 |         3 |
                |  115 |       32 |         3 |
                |  116 |     1485 |         3 |
                |  117 |      147 |         3 |
                |  118 |     1467 |         3 |
                |  119 |     1466 |         3 |
                |  120 |     1490 |         3 |
                |  121 |     1495 |         3 |
                |  122 |       10 |         3 |
                |  123 |     1469 |         3 |
                |  124 |      109 |         3 |
                |  125 |       36 |         3 |
                |  126 |      101 |         3 |
                |  127 |       11 |         3 |
                |  128 |      144 |         3 |
                |  129 |      110 |         3 |
                |  130 |       33 |         3 |
                |  131 |     1468 |         3 |
                |  132 |        6 |         3 |
                |  133 |      155 |         3 |
                |  134 |      154 |         3 |
                |  135 |      153 |         3 |
                |  136 |       57 |         3 |
                |  137 |       44 |         3 |
                |  138 |      107 |         3 |
                |  139 |      143 |         3 |
                |  140 |      151 |         3 |
                |  141 |      156 |         3 |
                |  142 |      152 |         3 |
                |  143 |      158 |         3 |
                |  144 |      157 |         3 |
                |  145 |      150 |         3 |
                |  146 |     1470 |         3 |
                |  147 |       85 |         3 |
                |  148 |       76 |         3 |
                |  149 |       72 |         3 |
                |  150 |      130 |         3 |
                |  151 |      137 |         3 |
                |  152 |       16 |         3 |
                |  153 |       86 |         3 |
                |  154 |       91 |         3 |
                |  155 |       42 |         3 |
                |  156 |      358 |         3 |
                |  157 |      141 |         3 |
                |  158 |      100 |         3 |
                |  159 |      302 |         3 |
                |  160 |     1477 |         3 |
                |  161 |     1478 |         3 |
                |  162 |     1479 |         3 |
                |  163 |       65 |         3 |
                |  164 |       93 |         3 |
                |  165 |        9 |         3 |
                |  166 |       20 |         3 |
                |  167 |       19 |         3 |
                |  168 |       92 |         3 |
                |  169 |      108 |         3 |
                |  170 |      142 |         3 |
                |  171 |      124 |         3 |
                |  172 |      127 |         3 |
                |  173 |       50 |         3 |
                |  174 |     1489 |         3 |
                |  175 |       24 |         3 |
                |  176 |      125 |         3 |
                |  177 |      102 |         3 |
                |  178 |      118 |         3 |
                |  179 |       41 |         3 |
                |  180 |      132 |         3 |
                |  181 |      103 |         3 |
                |  182 |       22 |         3 |
                |  183 |       35 |         3 |
                |  184 |       80 |         3 |
                |  185 |       84 |         3 |
                |  186 |      136 |         3 |
                |  187 |       27 |         3 |
                |  188 |       18 |         3 |
                |  189 |      280 |         3 |
                |  190 |       66 |         3 |
                |  191 |       95 |         3 |
                |  192 |     1472 |         3 |
                |  193 |      133 |         3 |
                |  194 |       51 |         3 |
                |  195 |       96 |         3 |
                |  196 |       47 |         3 |
                |  197 |      197 |         3 |
                |  198 |     1481 |         3 |
                |  199 |     1480 |         3 |
                |  200 |      120 |         3 |
                |  201 |      111 |         3 |
                |  202 |      395 |         3 |
                |  203 |      105 |         3 |
                |  204 |     1482 |         3 |
                |  205 |      140 |         3 |
                |  206 |      131 |         3 |
                |  207 |       25 |         3 |
                |  208 |       17 |         3 |
                |  209 |       69 |         3 |
                |  210 |      145 |         3 |
                |  211 |     1474 |         3 |
                |  212 |     1473 |         3 |
                |  213 |     1476 |         3 |
                |  214 |     1475 |         3 |
                |  215 |      104 |         3 |
                |  216 |      448 |         3 |
                |  217 |      134 |         3 |
                |  218 |       43 |         3 |
                |  219 |      121 |         3 |
                |  220 |       13 |         3 |
                |  221 |     1492 |         3 |
                |  222 |      112 |         3 |
                |  223 |       21 |         3 |
                |  224 |       28 |         3 |
                |  225 |     1491 |         3 |
                |  226 |       31 |         3 |
                |  227 |      128 |         3 |
                |  228 |       94 |         3 |
                |  229 |      113 |         3 |
                |  230 |       29 |         3 |
                |  231 |      119 |         3 |
                |  232 |       12 |         3 |
                |  233 |      122 |         3 |
                |  234 |      116 |         3 |
                |  235 |       37 |         3 |
                |  236 |      129 |         3 |
                |  237 |      126 |         3 |
                |  238 |       64 |         3 |
                |  239 |       79 |         3 |
                |  240 |       90 |         3 |
                |  241 |       88 |         3 |
                |  242 |      108 |         6 |
                |  243 |      142 |         6 |
                |  244 |      124 |         6 |
                |  245 |      127 |         6 |
                |  246 |       50 |         6 |
                |  247 |      147 |        17 |
                |  259 |      110 |        13 |
                |  249 |     1466 |        17 |
                |  250 |     1490 |        17 |
                |  251 |     1495 |        17 |
                |  252 |       10 |        17 |
                |  253 |     1469 |        17 |
                |  254 |      109 |        17 |
                |  255 |     1496 |         3 |
                |  256 |     1496 |         9 |
                |  257 |     1497 |         3 |
                |  258 |     1497 |         6 |
                |  260 |       33 |        13 |
                |  261 |     1468 |        13 |
                |  262 |        6 |        13 |
                |  263 |      105 |        13 |
                |  264 |     1498 |        10 |
                |  265 |     1498 |         3 |
                +------+----------+-----------+
                244 rows in set (0.00 sec)
                
                MariaDB [fog]> select * from groupMembers where gmHostID=0;
                Empty set (0.00 sec)
                
                MariaDB [fog]> select * from groupMembers where gmID=0;
                Empty set (0.00 sec)
                
                MariaDB [fog]> select * from groupMembers where gmGroupID=0;
                Empty set (0.00 sec)
                
                

                Have you tried the FogApi powershell module? It's pretty cool IMHO
                https://github.com/darksidemilk/FogApi
                https://fogapi.readthedocs.io/en/latest/
                https://www.powershellgallery.com/packages/FogApi
                https://forums.fogproject.org/topic/12026/powershell-api-module

                1 Reply Last reply Reply Quote 0
                • JJ FullmerJ
                  JJ Fullmer Testers @Tom Elliott
                  last edited by

                  @Tom-Elliott

                  MariaDB [fog]> select * from groupMembers where gmHostID not in (select hostID from hosts);
                  Empty set (0.00 sec)
                  

                  Have you tried the FogApi powershell module? It's pretty cool IMHO
                  https://github.com/darksidemilk/FogApi
                  https://fogapi.readthedocs.io/en/latest/
                  https://www.powershellgallery.com/packages/FogApi
                  https://forums.fogproject.org/topic/12026/powershell-api-module

                  1 Reply Last reply Reply Quote 0
                  • Wayne WorkmanW
                    Wayne Workman
                    last edited by

                    I never understood why hosts can’t have a zero for their ID.

                    Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                    Daily Clean Installation Results:
                    https://fogtesting.fogproject.us/
                    FOG Reporting:
                    https://fog-external-reporting-results.fogproject.us/

                    Tom ElliottT 1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott
                      last edited by

                      Found the issue and it appears to be related to some rc11 changes to how inserts happen. There was a minor mistake on my part in that I wasn’t cleaning up a variable that desperately needed it, but this issue would have still happened just to how the query is passed. To prevent the issues specifically to module updates from groups, for now, I’ve made the insert occur in 500 item chunks, though I will likely do this for the method as a whole as mass inserting can be problematic if you just dump a ton of data anyway. The largest of these happens to be service settings and probably the only thing to notice these issues any way.

                      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      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

                      JJ FullmerJ 1 Reply Last reply Reply Quote 0
                      • Tom ElliottT
                        Tom Elliott @Wayne Workman
                        last edited by

                        @Wayne-Workman it isn’t a valid ‘real’ auto increment number in SQL, therefore the only way to get a 0 is a bad call or manually define it.

                        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                        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

                        1 Reply Last reply Reply Quote 0
                        • JJ FullmerJ
                          JJ Fullmer Testers @Tom Elliott
                          last edited by

                          @Tom-Elliott Updated and confirmed working 😃

                          Have you tried the FogApi powershell module? It's pretty cool IMHO
                          https://github.com/darksidemilk/FogApi
                          https://fogapi.readthedocs.io/en/latest/
                          https://www.powershellgallery.com/packages/FogApi
                          https://forums.fogproject.org/topic/12026/powershell-api-module

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

                          189

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project