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

FOG Sql

Scheduled Pinned Locked Moved Solved
General
4
6
1.7k
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.
  • N
    Nika
    last edited by Feb 3, 2016, 1:44 PM

    hi!

    How can i properly remove a host and all others files( Adress Mac, Serial number, …) in fog with sql request ?

    W 1 Reply Last reply Feb 3, 2016, 1:47 PM Reply Quote 0
    • W
      Wayne Workman @Nika
      last edited by Wayne Workman Feb 3, 2016, 7:48 AM Feb 3, 2016, 1:47 PM

      @Nika

      there are two ways.

      mysql
      use fog
      truncate table hosts;
      truncate table hostMAC;
      
      mysql
      use fog
      delete from table hosts where 1;
      delete from table hostMAC where 1;
      

      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
      • N
        Nika
        last edited by Feb 3, 2016, 2:20 PM

        thaks. πŸ˜‰

        1 Reply Last reply Reply Quote 0
        • J
          jc35
          last edited by Mar 17, 2016, 1:03 PM

          Hello,
          Why when I delete a hots on fog 1.2.0 in GUI, all the table with a hosts are not delete ?
          For example in table inventory when a host is delete, this is not delete in the inventory table and another table why ?
          I think when a host is deleted, the host must be deleted in the following table :
          hosts, hostmac, greenfog, groupmembers, hostautologout, hostscreensetting, inventory, modulestatusbyhosts, nfsfailures, pendingmacs, printerassoc, sheduledTasks,snapinassoc, snapinjob, usertracking, imaginlog.

          We delete a host with a script python with with url : β€œhttp://localhost/fog/management/index.php?node=host&sub=delete&id=%s”
          Where β€œ%s” is a hostid.

          Sorry for my bad english.

          W 1 Reply Last reply Mar 17, 2016, 1:05 PM Reply Quote 0
          • W
            Wayne Workman @jc35
            last edited by Mar 17, 2016, 1:05 PM

            @jc35 We should ask the @Developers to see if this is done in the current Trunk versions or not, let’s see what they say.

            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/

            T 1 Reply Last reply Mar 17, 2016, 1:07 PM Reply Quote 0
            • T
              Tom Elliott @Wayne Workman
              last edited by Mar 17, 2016, 1:07 PM

              @Wayne-Workman YUP.

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

              269

              Online

              12.0k

              Users

              17.3k

              Topics

              155.2k

              Posts
              Copyright Β© 2012-2024 FOG Project