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

    SQL Database doesn't match Web Interface

    Scheduled Pinned Locked Moved
    FOG Problems
    1
    1
    914
    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.
    • M
      moss
      last edited by

      Due to the way we work, once a machine is imaged the hostname changer service setting needs to be disabled.
      I have been doing this two different ways, initially I was using an SQL event setup through PHPMyAdmin running the following every evening:
      [CODE]UPDATE moduleStatusByHost SET msState=0 WHERE msModuleID=‘hostnamechanger’[/CODE]
      I’ve had a few issues with the event scheduler turning itself off, so I’ve since moved to a cronjob running the same command piped into an SQL/bash script.

      This had been working fine, however, I’ve just noticed that if I run the following:
      [CODE]SELECT * FROM moduleStatusByHost WHERE msState LIKE ‘1’[/CODE]
      I get no results returned and actually looking at the moduleStatusByHost table, every msState field is set to 0. However in the web interface, numerous hosts do have this option selected. I’ve even ran:
      [CODE]UPDATE moduleStatusByHost SET msState=0[/CODE]
      Even through the database shows its disabled, the service is definitely enabled for some hosts, if I change the hostname on one of these hosts, Fog renames them back.
      If I disable then re-enable the service through the web interface for a host, then re-run the SQL script to disable it, it works as it should.

      It seems as if the SQL database and the Web interface are out of sync, even though Fog seems to operate as normal with regards to imaging etc.
      Does anyone have any ideas what could cause this?
      Thanks!

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

      149

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project