Navigation

    FOG Project

    • Register
    • Login
    • Search
    • Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    1. Home
    2. lebrun78
    L
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    lebrun78

    @lebrun78

    Université de Rennes 1

    12
    Reputation
    290
    Posts
    4181
    Profile views
    1
    Followers
    1
    Following
    Joined Last Online
    Location France

    lebrun78 Follow

    Best posts made by lebrun78

    • RE: FOG 1.4.0 Officially Released

      thanks for your great work

      posted in Announcements
      L
      lebrun78
    • RE: Kernel panic -not syncing: VFS: Unable to mount root fs on unknown-block(1,0)

      @george1421
      I had Pxelinux.0 in my dhcp, the new code replace it now.

      posted in FOG Problems
      L
      lebrun78
    • RE: Set Host Product Key no logger works

      Yes, restart computer > ok
      If I restart the fogservice, it works too

      posted in Windows Problems
      L
      lebrun78
    • RE: FOG 1.6 Testing Needed - Help would be greatly appreciated as needed

      @joe-gill
      https://forums.fogproject.org/category/11/feature-request

      posted in Announcements
      L
      lebrun78
    • can't install fog client 0.11.19 "Unable to install CA certificate"

      Hello
      I upgraded my server from 1.5.7.60 to 1.5.8 yesterday.
      I can’t install my fog client using msi file.
      I get “Unable to install CA certificate”
      Could you help me ?

      Arnaud

      posted in FOG Problems
      L
      lebrun78
    • RE: Problem PXE boot since windows 10 1803

      I use fog 1.4.4 on centos 6.8.
      I use non-resizable image but the problem seem to be on boot chaining between ipxe and windows.

      posted in Windows Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421

      mysql> use fog;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Database changed
      mysql> ALTER TABLE groups ENGINE=InnoDB;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ENGINE=InnoDB' at line 1
      mysql> ALTER TABLE `groups` ENGINE=InnoDB;
      Query OK, 69 rows affected (0.02 sec)
      Records: 69  Duplicates: 0  Warnings: 0
      
      
      posted in FOG Problems
      L
      lebrun78
    • RE: Problem PXE boot since windows 10 1803

      May be I am not clear.
      All my compututer are boot first on pxe controlled by FOG.
      But I have no problem with computer that are running Linux and Windows10 =< 1709.
      But for computer that are running Windows 10 1803, available for 2 weeks, boot chainon between pxe and harddrive doesn’t work.
      To start this machine I have to disable PXE.in bios or escape oduring PXE loading.

      posted in Windows Problems
      L
      lebrun78
    • RE: Problem PXE boot since windows 10 1803

      This morning, I have the problem on several machines which have get 1803 update…
      I have changed the dhcp configuration for this machine to point to my testing fog server. (1.5.2)
      On this server, I have applied Quazz solution to set grub in place of sanboot and now my Dell machines on 1803 have started passing by PXE…

      Now I have to set it to my production fog server…

      Thanks for your help

      posted in Windows Problems
      L
      lebrun78
    • RE: UEFI pxe boot problem from a network

      @george1421

      Here is the post:
      https://lists.isc.org/pipermail/dhcp-users/2020-April/022039.html

      posted in Windows Problems
      L
      lebrun78

    Latest posts made by lebrun78

    • RE: FOG Multicast Not starting anymore

      @george1421
      changed to pm.max_spare_servers = 35
      other paramaters had the correct value

      The hardware :
      PowerEdge R440
      Intel® Xeon® Silver 4208 CPU @ 2.10GHz
      memory size: 16GiB
      network BCM57412 NetXtreme-E 10Gb

      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421

      Geoges, should I use this topic as a reference ?
      https://forums.fogproject.org/topic/10717/can-php-fpm-make-fog-web-gui-fast/2

      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @sebastian-roth
      Here is the access.log:

      ip.lan.1.41 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:04:B0:BB%7C14:B3:1F:04:B0:BB%7C14:B3:1F:04:B0:BB%7CFE:11:E3:62:00:00%7C02:42:6A:7F:73:A2&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.1.65 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.122 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.41 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.65 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.81 - - [14/Jan/2022:14:40:09 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.1.41 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.81 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:48:91%7C14:B3:1F:02:48:91%7C14:B3:1F:02:48:91%7C02:42:F2:07:9B:73&newService&json HTTP/1.1" 200 841 "-" "-"
      ip.lan.3.81 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.114 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.3.48 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.3.81 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.114 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=78:AC:C0:B1:AB:2E%7C76:7F:5C:90:EF:0A%7C02:42:F9:20:A5:67&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.3.48 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:8A:29%7C14:B3:1F:02:8A:29%7C14:B3:1F:02:8A:29%7C02:42:67:E3:1C:6C&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.3.48 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.114 - - [14/Jan/2022:14:40:10 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.48 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.114 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.7.11 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.7.11 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=74:E6:E2:DA:C1:2C&newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.7.61 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/management/other/ssl/srvpublic.crt HTTP/1.1" 200 1740 "-" "-"
      ip.lan.3.103 - - [14/Jan/2022:14:40:11 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.7.61 - - [14/Jan/2022:14:40:11 +0100] "POST /fog/management/index.php?sub=requestClientInfo&authorize&newService HTTP/1.1" 200 15 "-" "-"
      ip.lan.3.103 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=B8:85:84:C5:BA:0E&newService&json HTTP/1.1" 200 809 "-" "-"
      ip.lan.7.61 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.103 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.7.61 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.103 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.67 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.1.67 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:4E:F6%7C14:B3:1F:02:4E:F6%7C14:B3:1F:02:4E:F6%7CFE:11:E7:61:00:34%7C02:42:30:08:E2:16&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.1.67 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.67 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.103 - - [14/Jan/2022:14:40:12 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.1.103 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=78:AC:C0:AF:BE:3F%7C42:14:34:62:41:59%7C02:42:07:3A:5E:1C&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.3.106 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.12.64 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.3.106 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=E4:B9:7A:F1:33:DC&newService&json HTTP/1.1" 200 809 "-" "-"
      ip.lan.1.103 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.106 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.106 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.12.64 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=0A:00:27:00:00:0C%7C14:B3:1F:19:82:1D%7C00:50:56:C0:00:01%7C00:50:56:C0:00:08&newService&json HTTP/1.1" 200 841 "-" "-"
      ip.lan.12.64 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.12.64 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.103 - - [14/Jan/2022:14:40:13 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.7 - - [14/Jan/2022:14:40:15 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:15 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.1.7 - - [14/Jan/2022:14:40:15 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:4F:E9%7C14:B3:1F:02:4F:E9%7C14:B3:1F:02:4F:E9%7CFE:11:E7:61:01:54%7C02:42:93:0B:C7:73&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:15 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=9C:8E:99:F5:68:BF%7C0E:EA:59:3A:BB:36%7C02:42:1F:87:5F:23&newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.7 - - [14/Jan/2022:14:40:15 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/other/ssl/srvpublic.crt HTTP/1.1" 200 1740 "-" "-"
      ip.lan.1.7 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.22 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.3.11 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.3.22 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=E4:B9:7A:F1:2A:DF&newService&json HTTP/1.1" 200 713 "-" "-"
      ip.lan.3.22 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.11 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=E4:B9:7A:F1:2B:23&newService&json HTTP/1.1" 200 713 "-" "-"
      ip.lan.3.22 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:16 +0100] "POST /fog/management/index.php?sub=requestClientInfo&authorize&newService HTTP/1.1" 200 326 "-" "-"
      ip.lan.3.11 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.11 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=9C:8E:99:F5:68:BF%7C0E:EA:59:3A:BB:36%7C02:42:1F:87:5F:23&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:16 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.5.12 - - [14/Jan/2022:14:40:17 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.6.72 - - [14/Jan/2022:14:40:17 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.6.72 - - [14/Jan/2022:14:40:18 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:75:0B%7C14:B3:1F:02:75:0B%7C14:B3:1F:02:75:0B%7C02:42:F2:20:16:E9&newService&json HTTP/1.1" 200 809 "-" "-"
      ip.lan.6.72 - - [14/Jan/2022:14:40:18 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.6.72 - - [14/Jan/2022:14:40:18 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.88 - - [14/Jan/2022:14:40:19 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.3.88 - - [14/Jan/2022:14:40:19 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:01:C2:54%7C14:B3:1F:01:C2:54%7C14:B3:1F:01:C2:54%7C02:42:42:16:8A:D1&newService&json HTTP/1.1" 200 841 "-" "-"
      ip.lan.3.88 - - [14/Jan/2022:14:40:19 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.88 - - [14/Jan/2022:14:40:19 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.33 - - [14/Jan/2022:14:40:19 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.6.70 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.1.33 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:48:A9%7C14:B3:1F:02:48:A9%7C14:B3:1F:02:48:A9%7CFE:11:E3:62:00:02%7C02:42:F5:A3:8B:48&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.3.37 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.6.70 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:01:0C:11%7C14:B3:1F:01:0C:11%7C14:B3:1F:01:0C:11%7C02:42:E5:32:78:6B&newService&json HTTP/1.1" 200 809 "-" "-"
      ip.lan.1.33 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.37 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:50:03%7C14:B3:1F:02:50:03%7C14:B3:1F:02:50:03%7C02:42:A0:AE:A0:52&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.6.70 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.33 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.37 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.6.70 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.87 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.3.37 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.32 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.3.87 - - [14/Jan/2022:14:40:20 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:48:D7%7C14:B3:1F:02:48:D7%7C14:B3:1F:02:48:D7%7C02:42:CE:55:48:81&newService&json HTTP/1.1" 200 841 "-" "-"
      ip.lan.3.32 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:50:7A%7C14:B3:1F:02:50:7A%7C14:B3:1F:02:50:7A%7C02:42:5E:15:79:9F&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.3.87 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.32 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.3.87 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.3.32 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.34 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 141 "-" "-"
      ip.lan.1.1 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/management/index.php?sub=requestClientInfo&configure&newService&json HTTP/1.1" 200 142 "-" "-"
      ip.lan.1.34 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:01:C1:34%7C14:B3:1F:01:C1:34%7C14:B3:1F:01:C1:34%7CFE:11:E7:61:00:41%7C02:42:A9:06:FE:3A&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.1.1 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/management/index.php?sub=requestClientInfo&mac=14:B3:1F:02:48:80%7C14:B3:1F:02:48:80%7C14:B3:1F:02:48:80%7CFE:11:E7:61:01:92&newService&json HTTP/1.1" 200 745 "-" "-"
      ip.lan.1.34 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.1 - - [14/Jan/2022:14:40:21 +0100] "GET /fog/service/getversion.php?clientver&newService&json HTTP/1.1" 200 7 "-" "-"
      ip.lan.1.34 - - [14/Jan/2022:14:40:22 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      ip.lan.1.1 - - [14/Jan/2022:14:40:22 +0100] "GET /fog/service/getversion.php?newService&json HTTP/1.1" 200 5 "-" "-"
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @sebastian-roth
      Hello Sebastian,
      Here is the tail of /var/log/httpd/error.log file:

      [Fri Jan 14 08:46:48.363434 2022] [ssl:info] [pid 11396:tid 140375024985856] [client ip.lan.3.77:25158] AH01964: Connection to child 134 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.706587 2022] [ssl:info] [pid 11620:tid 140375417497344] [client ip.lan.6.71:59922] AH01964: Connection to child 192 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.768993 2022] [ssl:info] [pid 11620:tid 140375400711936] [client ip.lan.12.61:61280] AH01964: Connection to child 194 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.858436 2022] [ssl:info] [pid 11620:tid 140375134025472] [client ip.lan.12.61:61281] AH01964: Connection to child 201 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.868198 2022] [ssl:info] [pid 11620:tid 140374957876992] [client ip.lan.6.71:59924] AH01964: Connection to child 205 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.961868 2022] [ssl:info] [pid 11620:tid 140374597154560] [client ip.lan.12.61:61282] AH01964: Connection to child 215 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:48.990680 2022] [ssl:info] [pid 11620:tid 140375167596288] [client ip.lan.3.11:9250] AH01964: Connection to child 197 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.011505 2022] [ssl:info] [pid 11620:tid 140375383926528] [client ip.lan.12.61:61283] AH01964: Connection to child 196 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.088755 2022] [ssl:info] [pid 11620:tid 140375409104640] [client ip.lan.6.71:59926] AH01964: Connection to child 193 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.093387 2022] [ssl:info] [pid 11620:tid 140375117240064] [client ip.lan.3.11:9251] AH01964: Connection to child 203 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.197262 2022] [ssl:info] [pid 11620:tid 140374588761856] [client ip.lan.3.11:9252] AH01964: Connection to child 216 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.249588 2022] [ssl:info] [pid 11620:tid 140375142418176] [client ip.lan.3.11:9253] AH01964: Connection to child 200 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.264227 2022] [ssl:info] [pid 11620:tid 140374932698880] [client ip.lan.6.71:59928] AH01964: Connection to child 208 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.843373 2022] [ssl:info] [pid 11395:tid 140374446151424] [client ip.lan.7.63:57699] AH01964: Connection to child 82 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:49.966565 2022] [ssl:info] [pid 11395:tid 140375033378560] [client ip.lan.7.63:57700] AH01964: Connection to child 69 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.098427 2022] [ssl:info] [pid 11620:tid 140374622332672] [client ip.lan.7.63:57701] AH01964: Connection to child 212 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.103237 2022] [ssl:info] [pid 11396:tid 140375033378560] [client ip.lan.12.42:65003] AH01964: Connection to child 133 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.163407 2022] [ssl:info] [pid 11396:tid 140375417497344] [client ip.lan.7.63:57702] AH01964: Connection to child 128 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.181040 2022] [ssl:info] [pid 11620:tid 140375150810880] [client ip.lan.7.66:53756] AH01964: Connection to child 199 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.200257 2022] [ssl:info] [pid 11620:tid 140375417497344] [client ip.lan.12.42:65004] AH01964: Connection to child 192 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.308358 2022] [ssl:info] [pid 11620:tid 140374630725376] [client ip.lan.7.66:53757] AH01964: Connection to child 211 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.310417 2022] [ssl:info] [pid 11620:tid 140374597154560] [client ip.lan.12.42:65005] AH01964: Connection to child 215 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.359355 2022] [ssl:info] [pid 11396:tid 140373951244032] [client ip.lan.12.42:65006] AH01964: Connection to child 148 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.425288 2022] [ssl:info] [pid 11395:tid 140375383926528] [client ip.lan.7.66:53758] AH01964: Connection to child 68 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.471785 2022] [ssl:info] [pid 11395:tid 140375392319232] [client ip.lan.7.66:53759] AH01964: Connection to child 67 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:50.904093 2022] [ssl:info] [pid 11620:tid 140374949484288] [client ip.lan.1.23:58916] AH01964: Connection to child 206 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.091156 2022] [ssl:info] [pid 11620:tid 140374605547264] [client ip.lan.1.23:58918] AH01964: Connection to child 214 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.303362 2022] [ssl:info] [pid 11620:tid 140374924306176] [client ip.lan.1.23:58920] AH01964: Connection to child 209 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.361652 2022] [ssl:info] [pid 11620:tid 140375117240064] [client ip.lan.12.64:57158] AH01964: Connection to child 203 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.465884 2022] [ssl:info] [pid 11620:tid 140374966269696] [client ip.lan.1.23:58922] AH01964: Connection to child 204 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.473077 2022] [ssl:info] [pid 11620:tid 140375409104640] [client ip.lan.12.64:57159] AH01964: Connection to child 193 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.502463 2022] [ssl:info] [pid 11396:tid 140374488114944] [client ip.lan.1.29:59768] AH01964: Connection to child 141 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.570921 2022] [ssl:info] [pid 11396:tid 140374479722240] [client ip.lan.12.64:57160] AH01964: Connection to child 142 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.616658 2022] [ssl:info] [pid 11395:tid 140374320326400] [client ip.lan.12.64:57161] AH01964: Connection to child 88 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.680510 2022] [ssl:info] [pid 11394:tid 140374832051968] [client ip.lan.1.47:48536] AH01964: Connection to child 4 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.686009 2022] [ssl:info] [pid 11620:tid 140374613939968] [client ip.lan.1.29:59770] AH01964: Connection to child 213 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.790779 2022] [ssl:info] [pid 11620:tid 140374932698880] [client ip.lan.12.25:40653] AH01964: Connection to child 208 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.850588 2022] [ssl:info] [pid 11620:tid 140374915913472] [client ip.lan.1.47:48538] AH01964: Connection to child 210 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:51.921201 2022] [ssl:info] [pid 11620:tid 140375400711936] [client ip.lan.1.29:59772] AH01964: Connection to child 194 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.055722 2022] [ssl:info] [pid 11620:tid 140375417497344] [client ip.lan.1.47:48540] AH01964: Connection to child 192 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.106505 2022] [ssl:info] [pid 11620:tid 140374597154560] [client ip.lan.1.29:59774] AH01964: Connection to child 215 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.127947 2022] [ssl:info] [pid 11620:tid 140375392319232] [client ip.lan.1.112:42162] AH01964: Connection to child 195 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.230496 2022] [ssl:info] [pid 11620:tid 140375167596288] [client ip.lan.1.47:48542] AH01964: Connection to child 197 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.366956 2022] [ssl:info] [pid 11620:tid 140374605547264] [client ip.lan.1.112:42164] AH01964: Connection to child 214 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.548723 2022] [ssl:info] [pid 11620:tid 140375117240064] [client ip.lan.7.64:51037] AH01964: Connection to child 203 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.573199 2022] [ssl:info] [pid 11395:tid 140375409104640] [client ip.lan.3.12:1971] AH01964: Connection to child 65 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.612464 2022] [ssl:info] [pid 11620:tid 140374924306176] [client ip.lan.3.12:1972] AH01964: Connection to child 209 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.612819 2022] [ssl:info] [pid 11620:tid 140374588761856] [client ip.lan.1.10:50180] AH01964: Connection to child 216 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.660924 2022] [ssl:info] [pid 11620:tid 140375159203584] [client ip.lan.1.112:42166] AH01964: Connection to child 198 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.686165 2022] [ssl:info] [pid 11620:tid 140375142418176] [client ip.lan.7.64:51038] AH01964: Connection to child 200 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.692994 2022] [ssl:info] [pid 11620:tid 140374613939968] [client ip.lan.3.12:1973] AH01964: Connection to child 213 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.746637 2022] [ssl:info] [pid 11620:tid 140374932698880] [client ip.lan.3.12:1974] AH01964: Connection to child 208 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.807891 2022] [ssl:info] [pid 11620:tid 140375400711936] [client ip.lan.1.10:50182] AH01964: Connection to child 194 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.820621 2022] [ssl:info] [pid 11620:tid 140375134025472] [client ip.lan.6.202:59422] AH01964: Connection to child 201 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.821309 2022] [ssl:info] [pid 11620:tid 140375417497344] [client ip.lan.7.64:51039] AH01964: Connection to child 192 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.896778 2022] [ssl:info] [pid 11620:tid 140375392319232] [client ip.lan.7.64:51040] AH01964: Connection to child 195 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:52.939490 2022] [ssl:info] [pid 11620:tid 140375383926528] [client ip.lan.6.202:59423] AH01964: Connection to child 196 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.000952 2022] [ssl:info] [pid 11396:tid 140374999807744] [client ip.lan.7.64:51041] AH01964: Connection to child 137 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.022801 2022] [ssl:info] [pid 11620:tid 140375117240064] [client ip.lan.1.10:50184] AH01964: Connection to child 203 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.057884 2022] [ssl:info] [pid 11620:tid 140374605547264] [client ip.lan.7.64:51042] AH01964: Connection to child 214 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.059036 2022] [ssl:info] [pid 11620:tid 140375409104640] [client ip.lan.6.202:59424] AH01964: Connection to child 193 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.083903 2022] [ssl:info] [pid 11620:tid 140374924306176] [client ip.lan.1.112:42168] AH01964: Connection to child 209 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.123412 2022] [ssl:info] [pid 11396:tid 140375392319232] [client ip.lan.6.202:59425] AH01964: Connection to child 131 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.186530 2022] [ssl:info] [pid 11620:tid 140375142418176] [client ip.lan.1.10:50186] AH01964: Connection to child 200 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.336855 2022] [ssl:info] [pid 11620:tid 140374932698880] [client ip.lan.1.112:42170] AH01964: Connection to child 208 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.622871 2022] [ssl:info] [pid 11620:tid 140374941091584] [client ip.lan.1.112:42172] AH01964: Connection to child 207 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.855829 2022] [ssl:info] [pid 11620:tid 140374630725376] [client ip.lan.1.112:42174] AH01964: Connection to child 211 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:53.937131 2022] [ssl:info] [pid 11394:tid 140374823659264] [client ip.lan.1.64:36478] AH01964: Connection to child 5 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:54.109148 2022] [ssl:info] [pid 11620:tid 140374597154560] [client ip.lan.1.64:36480] AH01964: Connection to child 215 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:54.310399 2022] [ssl:info] [pid 11620:tid 140374949484288] [client ip.lan.1.64:36482] AH01964: Connection to child 206 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:54.481079 2022] [ssl:info] [pid 11620:tid 140375167596288] [client ip.lan.1.64:36484] AH01964: Connection to child 197 established (server ip.lan.4.1:443)
      [Fri Jan 14 08:46:55.657860 2022] [ssl:info] [pid 11394:tid 140373817026304] [client ip.lan.7.62:52485] AH01964: Connection to child 19 established (server ip.lan.4.1:443)
      
      

      And I steel have a lot of waiting waiting process:
      [root@fogus ~]# netstat -nat |grep 9000 |wc -l
      850

      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      Il have allways too many time wait on port 9000

      [root@fogus ~]# netstat -nat |grep 9000 |wc -l
      855
      

      and php-fpm is allways high

      top - 17:08:40 up 6 days,  3:39,  2 users,  load average: 0,69, 0,65, 0,79
      Tasks: 339 total,   2 running, 337 sleeping,   0 stopped,   0 zombie
      %Cpu(s):  6,5 us,  2,6 sy,  0,0 ni, 90,8 id,  0,0 wa,  0,1 hi,  0,1 si,  0,0 st
      MiB Mem :  15328,7 total,    571,3 free,   1274,2 used,  13483,2 buff/cache
      MiB Swap:   7812,0 total,   7138,7 free,    673,2 used.  13484,4 avail Mem 
      
        PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND                                                                                                                                                             
       8776 mysql     20   0 3256016 464360  35664 S  17,9   3,0   2:31.14 mysqld                                                                                                                                                              
      11704 apache    20   0  257736  21844  13380 S  14,6   0,1   0:04.37 php-fpm                                                                                                                                                             
      11375 apache    20   0  257812  21868  13372 S  13,3   0,1   0:05.11 php-fpm                                                                                                                                                             
      11608 apache    20   0  257816  21868  13376 S  13,0   0,1   0:05.32 php-fpm                                                                                                                                                             
      11737 apache    20   0  257724  21840  13380 R  12,6   0,1   0:03.22 php-fpm                                                                                                                                                             
      11376 apache    20   0  257736  21840  13372 S  12,0   0,1   0:05.33 php-fpm                                                                                                                                                             
      11374 apache    20   0  257716  21276  12860 S  11,6   0,1   0:05.09 php-fpm                                                                                                                                                             
      11377 apache    20   0  254816  21496  13052 S  11,6   0,1   0:05.17 php-fpm                                                                                                                                                             
      11772 apache    20   0  254816  21436  12992 S  11,6   0,1   0:02.24 php-fpm                                                                                                                                                             
      11373 apache    20   0  257724  21900  13372 S  11,3   0,1   0:05.16 php-fpm                                                                                                                                                             
      11396 apache    20   0 2599116  17408   8900 S   5,0   0,1   0:01.30 httpd                                                                                                                                                               
      11620 apache    20   0 2599116  17840   8948 S   5,0   0,1   0:02.10 httpd                                                                                                                                                               
      11395 apache    20   0 2599116  19356   8920 S   1,7   0,1   0:00.63 httpd                                                                                                                                                               
      11394 apache    20   0 2795788  23072   8948 S   0,7   0,1   0:00.33 httpd                                                                                                                                                               
          1 root      20   0  244492  12360   7816 S   0,3   0,1  19:50.18 systemd                                                                                                                                                             
       1173 root      20   0  200068  98172  23916 S   0,3   0,6   7:26.78 systemd-journal                                                                                                                                                     
       3269 root      20   0  289304  16636   9884 S   0,3   0,1   7:34.19 php                                                                                                                                                                 
      11823 root      20   0   64176   5080   4152 R   0,3   0,0   0:00.03 top
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      and now:

      mysql> SELECT TABLE_NAME,ENGINE
          -> FROM information_schema.TABLES
          -> WHERE TABLE_SCHEMA = 'fog'
          -> ;
      +------------------------+--------+
      | TABLE_NAME             | ENGINE |
      +------------------------+--------+
      | clientUpdates          | InnoDB |
      | dirCleaner             | InnoDB |
      | globalSettings         | InnoDB |
      | greenFog               | InnoDB |
      | groupMembers           | InnoDB |
      | groups                 | InnoDB |
      | history                | InnoDB |
      | hookEvents             | InnoDB |
      | hostAutoLogOut         | InnoDB |
      | hostMAC                | InnoDB |
      | hostScreenSettings     | InnoDB |
      | hosts                  | InnoDB |
      | imageGroupAssoc        | InnoDB |
      | imagePartitionTypes    | InnoDB |
      | imageTypes             | InnoDB |
      | images                 | InnoDB |
      | imagingLog             | InnoDB |
      | inventory              | InnoDB |
      | ipxeTable              | InnoDB |
      | keySequence            | InnoDB |
      | moduleStatusByHost     | InnoDB |
      | modules                | InnoDB |
      | multicastSessions      | InnoDB |
      | multicastSessionsAssoc | InnoDB |
      | nfsFailures            | InnoDB |
      | nfsGroupMembers        | InnoDB |
      | nfsGroups              | InnoDB |
      | notifyEvents           | InnoDB |
      | os                     | InnoDB |
      | oui                    | InnoDB |
      | plugins                | InnoDB |
      | powerManagement        | InnoDB |
      | printerAssoc           | InnoDB |
      | printers               | InnoDB |
      | pxeMenu                | InnoDB |
      | scheduledTasks         | InnoDB |
      | schemaVersion          | InnoDB |
      | snapinAssoc            | InnoDB |
      | snapinGroupAssoc       | InnoDB |
      | snapinJobs             | InnoDB |
      | snapinTasks            | InnoDB |
      | snapins                | InnoDB |
      | supportedOS            | InnoDB |
      | taskLog                | InnoDB |
      | taskStates             | InnoDB |
      | taskTypes              | InnoDB |
      | tasks                  | InnoDB |
      | userCleanup            | InnoDB |
      | userTracking           | InnoDB |
      | users                  | InnoDB |
      | virus                  | InnoDB |
      +------------------------+--------+
      51 rows in set (0.00 sec)
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421

      mysql> use fog;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Database changed
      mysql> ALTER TABLE groups ENGINE=InnoDB;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ENGINE=InnoDB' at line 1
      mysql> ALTER TABLE `groups` ENGINE=InnoDB;
      Query OK, 69 rows affected (0.02 sec)
      Records: 69  Duplicates: 0  Warnings: 0
      
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421

      [root@fogus ~]# mysql -u root -p
      Enter password: 
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 1852964
      Server version: 8.0.17 Source distribution
      
      Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
      
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      
      mysql> ALTER TABLE groups ENGINE=InnoDB;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ENGINE=InnoDB' at line 1
      mysql> use fog;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
      
      Database changed
      mysql> ALTER TABLE groups ENGINE=InnoDB;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups ENGINE=InnoDB' at line 1
      mysql> 
      
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421
      I got one error with the groups table:

      mysql> ALTER TABLE clientUpdates      ENGINE=InnoDB;
      Query OK, 0 rows affected (0.03 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE dirCleaner         ENGINE=InnoDB;
      Query OK, 0 rows affected (0.01 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE globalSettings     ENGINE=InnoDB;
      Query OK, 180 rows affected (0.03 sec)
      Records: 180  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE greenFog           ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE groupMembers       ENGINE=InnoDB;
      Query OK, 760 rows affected (0.04 sec)
      Records: 760  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE groups             ENGINE=InnoDB;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups             ENGINE=InnoDB' at line 1
      mysql> ALTER TABLE history            ENGINE=InnoDB;
      Query OK, 1969 rows affected (0.13 sec)
      Records: 1969  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE hookEvents         ENGINE=InnoDB;
      Query OK, 237 rows affected (0.02 sec)
      Records: 237  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE hostAutoLogOut     ENGINE=InnoDB;
      Query OK, 238 rows affected (0.02 sec)
      Records: 238  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE hostMAC            ENGINE=InnoDB;
      Query OK, 1495 rows affected (0.09 sec)
      Records: 1495  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE hostScreenSettings ENGINE=InnoDB;
      Query OK, 13 rows affected (0.02 sec)
      Records: 13  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE hosts              ENGINE=InnoDB;
      Query OK, 518 rows affected (0.06 sec)
      Records: 518  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE imageGroupAssoc    ENGINE=InnoDB;
      Query OK, 55 rows affected (0.01 sec)
      Records: 55  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE imagePartitionTypes ENGINE=InnoDB;
      Query OK, 12 rows affected (0.02 sec)
      Records: 12  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE imageTypes         ENGINE=InnoDB;
      Query OK, 4 rows affected (0.01 sec)
      Records: 4  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE images             ENGINE=InnoDB;
      Query OK, 55 rows affected (0.02 sec)
      Records: 55  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE imagingLog         ENGINE=InnoDB;
      Query OK, 2415 rows affected (0.04 sec)
      Records: 2415  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE inventory          ENGINE=InnoDB;
      Query OK, 490 rows affected (0.05 sec)
      Records: 490  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE ipxeTable          ENGINE=InnoDB;
      Query OK, 740 rows affected (0.02 sec)
      Records: 740  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE keySequence        ENGINE=InnoDB;
      Query OK, 35 rows affected (0.01 sec)
      Records: 35  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE moduleStatusByHost ENGINE=InnoDB;
      Query OK, 5300 rows affected (0.12 sec)
      Records: 5300  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE modules            ENGINE=InnoDB;
      Query OK, 13 rows affected (0.01 sec)
      Records: 13  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE multicastSessions  ENGINE=InnoDB;
      Query OK, 1 row affected (0.02 sec)
      Records: 1  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE multicastSessionsAssoc ENGINE=InnoDB;
      Query OK, 0 rows affected (0.01 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE nfsFailures        ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE nfsGroupMembers    ENGINE=InnoDB;
      Query OK, 1 row affected (0.02 sec)
      Records: 1  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE nfsGroups          ENGINE=InnoDB;
      Query OK, 1 row affected (0.02 sec)
      Records: 1  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE notifyEvents       ENGINE=InnoDB;
      Query OK, 5 rows affected (0.01 sec)
      Records: 5  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE os                 ENGINE=InnoDB;
      Query OK, 12 rows affected (0.01 sec)
      Records: 12  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE oui                ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE plugins            ENGINE=InnoDB;
      Query OK, 0 rows affected (0.01 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE powerManagement    ENGINE=InnoDB;
      Query OK, 187 rows affected (0.02 sec)
      Records: 187  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE printerAssoc       ENGINE=InnoDB;
      Query OK, 0 rows affected (0.01 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE printers           ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE pxeMenu            ENGINE=InnoDB;
      Query OK, 13 rows affected (0.02 sec)
      Records: 13  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE scheduledTasks     ENGINE=InnoDB;
      Query OK, 9 rows affected (0.02 sec)
      Records: 9  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE schemaVersion      ENGINE=InnoDB;
      Query OK, 1 row affected (0.01 sec)
      Records: 1  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE snapinAssoc        ENGINE=InnoDB;
      Query OK, 354 rows affected (0.02 sec)
      Records: 354  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE snapinGroupAssoc   ENGINE=InnoDB;
      Query OK, 10 rows affected (0.01 sec)
      Records: 10  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE snapinJobs         ENGINE=InnoDB;
      Query OK, 1629 rows affected (0.03 sec)
      Records: 1629  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE snapinTasks        ENGINE=InnoDB;
      Query OK, 3109 rows affected (0.08 sec)
      Records: 3109  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE snapins            ENGINE=InnoDB;
      Query OK, 8 rows affected (0.01 sec)
      Records: 8  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE supportedOS        ENGINE=InnoDB;
      Query OK, 8 rows affected (0.02 sec)
      Records: 8  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE taskLog            ENGINE=InnoDB;
      Query OK, 8899 rows affected (0.06 sec)
      Records: 8899  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE taskStates         ENGINE=InnoDB;
      Query OK, 5 rows affected (0.01 sec)
      Records: 5  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE taskTypes          ENGINE=InnoDB;
      Query OK, 21 rows affected (0.01 sec)
      Records: 21  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE tasks              ENGINE=InnoDB;
      Query OK, 2048 rows affected (0.11 sec)
      Records: 2048  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE userCleanup        ENGINE=InnoDB;
      Query OK, 6 rows affected (0.01 sec)
      Records: 6  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE userTracking       ENGINE=InnoDB;
      Query OK, 88983 rows affected (1.32 sec)
      Records: 88983  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE users              ENGINE=InnoDB;
      Query OK, 4 rows affected (0.02 sec)
      Records: 4  Duplicates: 0  Warnings: 0
      
      mysql> ALTER TABLE virus              ENGINE=InnoDB;
      Query OK, 0 rows affected (0.02 sec)
      Records: 0  Duplicates: 0  Warnings: 0
      
      

      and this error

      mysql> SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = fog;
      ERROR 1054 (42S22): Unknown column 'fog' in 'where clause'
      
      
      posted in FOG Problems
      L
      lebrun78
    • RE: FOG Multicast Not starting anymore

      @george1421

      Now :

      [root@fogus ~]# cat /etc/my.cnf.d/mysql-server.cnf 
      #
      # This group are read by MySQL server.
      # Use it for options that only the server (but not clients) should see
      #
      # For advice on how to change settings please see
      # http://dev.mysql.com/doc/refman/en/server-configuration-defaults.html
      
      # Settings user and group are ignored when systemd is used.
      # If you need to run mysqld under a different user or group,
      # customize your systemd unit file for mysqld according to the
      # instructions in http://fedoraproject.org/wiki/Systemd
      
      [mysqld]
      sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
      datadir=/var/lib/mysql
      socket=/var/lib/mysql/mysql.sock
      log-error=/var/log/mysql/mysqld.log
      pid-file=/run/mysqld/mysqld.pid
      
      
      
      [root@fogus ~]# systemctl status mysqld.service 
      ● mysqld.service - MySQL 8.0 database server
         Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
         Active: active (running) since Tue 2022-01-11 15:56:00 CET; 1min 15s ago
        Process: 5245 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS)
        Process: 5387 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
        Process: 5308 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS)
        Process: 5283 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
       Main PID: 5345 (mysqld)
         Status: "Server is operational"
          Tasks: 46 (limit: 26213)
         Memory: 471.4M
         CGroup: /system.slice/mysqld.service
                 └─5345 /usr/libexec/mysqld --basedir=/usr
      
      janv. 11 15:55:59 fogus.istic.univ-rennes1.fr systemd[1]: Starting MySQL 8.0 database server...
      janv. 11 15:56:00 fogus.istic.univ-rennes1.fr systemd[1]: Started MySQL 8.0 database server.
      
      posted in FOG Problems
      L
      lebrun78