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

SQL Database doesn't match Web Interface

Scheduled Pinned Locked Moved
FOG Problems
1
1
921
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 Jul 3, 2013, 2:44 PM

    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
    1 / 1
    • First post
      1/1
      Last post

    214

    Online

    12.1k

    Users

    17.3k

    Topics

    155.3k

    Posts
    Copyright © 2012-2024 FOG Project