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

Multiple MAC crash my fog DB

Scheduled Pinned Locked Moved
General Problems
3
4
582
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
    Seydoo
    last edited by Seydoo Sep 5, 2018, 6:46 AM Sep 5, 2018, 12:43 PM

    Hello everybody

    My system :
    CentOS 7
    FOG 1.4.4 SVN 6077

    Yesterday, my fog server suddenly crash, httpd was swapping a lot and finally the system killed mysql
    I had to stop httpd service
    In the morning 2 snapins were deployed (slowly) so I first thought there were still tasks pending and blcking the system
    I delete all tasks in tasks and snapinTasks table
    It didn’t work, so the problem was elsewhere
    the night pass (perhaps httpd will do what he wanted to do and all will be clear this morning) but still the same problem
    after a long moment of solitude in front of my VM i have a flash of light and looked in hostMAC table
    around 67000 rows for 300-330 hosts, that make a loooooot of MAC just for 1 host (~200)
    delete from hosts
    delete from hostMAC

    ==> at last my system is responding after restart of httpd service

    So my question is, what can i do to avoid this issue in the future ?
    I reimported an old csv with my host (created when i upgrade from 1.3.5) ans i have lots of new MAC to approve for my hosts, all these MAC seem to be virtual, but… globally my users don’t have VM on their computers (only ~10 users have vmware installed on their windows)

    Is there a way to stop getting “false” mac adress ?

    here is a PrintScreen of the pending mac page

    0_1536151552090_b8017d36-1676-4ef2-b892-d63a896975c0-image.png

    1 Reply Last reply Reply Quote 0
    • S
      Sebastian Roth Moderator
      last edited by Sebastian Roth Sep 5, 2018, 4:43 PM Sep 5, 2018, 10:42 PM

      @Seydoo Is this Windows 10? Please read through this: https://forums.fogproject.org/topic/10827/computer-getting-4-new-mac-address-daily (aka - this is not a bug, it’s a feature)

      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
      • S
        Seydoo
        last edited by Sep 6, 2018, 6:03 AM

        Hello Sebastian
        Thank you for your response, all my computers are with W10, I’ll check this
        I love Windows with these… “features”…

        1 Reply Last reply Reply Quote 0
        • Q
          Quazz Moderator
          last edited by Sep 6, 2018, 2:19 PM

          For some reason Microsof thought it would be a great idea to constantly fake your Wifi MAC. Despite the MAC being a common identifier for various purposes.

          And of course they enable it by default so that it’s the maximum amount of pain for everyone.

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

          244

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project