• 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.
    • 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

                        195

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project