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

    Bulk editing hosts

    General
    3
    4
    259
    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.
    • S
      svalding last edited by

      FOG Version 1.5.4 on Debian 8

      I’m trying to manipulate all the hosts in our FOG server to turn HostnameChanger off. I’d like to run this SQL against the database:

      UPDATE ‘moduleStatusByHost’ SET ‘msState’ = ‘0’ WHERE ‘msModuleID’ = ‘9’;

      On a test case where I did just one host ID, the value in the database changed as expected, but the change isn’t reflected in the WebUI. What additional steps need I take to make this change work correctly?

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

        @george1421 said in Bulk editing hosts:

        If you are going to mass update the database like this, stop apache and php-fpm first, then run your update, and finally restart php-fpm and then apache. Both php-fpm and apache cache database values for faster access. You are changing the underlying database but its not seen in the UI because of the cache.

        #wiki worthy.

        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/

        1 Reply Last reply Reply Quote 0
        • S
          svalding @george1421 last edited by

          @george1421 Awesome! Thanks for the help! I’ll give that a test and see what comes of it.

          1 Reply Last reply Reply Quote 0
          • george1421
            george1421 Moderator last edited by

            If you are going to mass update the database like this, stop apache and php-fpm first, then run your update, and finally restart php-fpm and then apache. Both php-fpm and apache cache database values for faster access. You are changing the underlying database but its not seen in the UI because of the cache.

            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!

            S Wayne Workman 2 Replies Last reply Reply Quote 1
            • 1 / 1
            • First post
              Last post

            184
            Online

            10.4k
            Users

            16.4k
            Topics

            150.6k
            Posts

            Copyright © 2012-2023 FOG Project