@sebastian-roth
Here is the photo of the error I get on first boot.:(
Il have no raid configuration neither on source or destination machine.
So I don’t understant why I get errors with mdadm files.
If I edit the /etc/fstab file, I always have the error “ALERT! /dev/nvme0n1p2 does not exist”
@sebastian-roth
Hello Sebastian,
The distrib is ubuntu 20.04.
I tried to edit the fstab from
/dev/nvme0n1p2 / ext3 errors=remount-ro 0 1
/dev/nvme0n1p3 /lereste ext2 defaults 1 2
to
/dev/sda2 / ext3 errors=remount-ro 0 1
#/dev/nvme0n1p3 /lereste ext2 defaults 1 2
It was not enough.
Boot repair did the job but it is a complex process difficult to reproduce.
Hello,
Fog is able to deploy an image captured on an nvme disk to a machine with a sata disk.
But on restart, the fstab is not good and the machine remains stuck in the busy box.
Do you have any advice to solve this problem?
Hello,
I have a problem with the process /opt/fog-service/FOGUserService.exe launched by mono on an Ubuntu20.
The process still exists after the user logs off.
As a result, the user’s samba mount still exists and this causes issues when the user try a new session.
How is this process launched ?
Do you have any idea why it does not close.
The problem didn’t exist when we used an nfs mount instead of a samba mount.
Arnaud
@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
Geoges, should I use this topic as a reference ?
https://forums.fogproject.org/topic/10717/can-php-fpm-make-fog-web-gui-fast/2
@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 "-" "-"
@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
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
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)
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
[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>
@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'
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.
@george1421 said in FOG Multicast Not starting anymore:
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session
-> ;
+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| global | session |
+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
+-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Here is the logfile:
Count: 4 Time=0.01s (0s) Lock=0.00s (0s) Rows=517.0 (2068), fogmaster[fogmaster]@localhost
SELECT `hostIP` FROM `hosts` LEFT OUTER JOIN `hostMAC` ON `hostMAC`.`hmHostID`=`hosts`.`hostID` LEFT OUTER JOIN `images` ON `images`.`imageID`=`hosts`.`hostImage` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` LEFT OUTER JOIN `hostScreenSettings` ON `hostScreenSettings`.`hssHostID`=`hosts`.`hostID` LEFT OUTER JOIN `hostAutoLogOut` ON `hostAutoLogOut`.`haloHostID`=`hosts`.`hostID` LEFT OUTER JOIN `inventory` ON `inventory`.`iHostID`=`hosts`.`hostID` WHERE `hosts`.`hostID` IN ('576','1','78','3','4','5','6','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','581','38','39','40','41','42','570','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','2','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','577','578','105','106','107','108','109','110','518','517','519','520','521','522','523','524','525','526','527','528','563','529','562','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','566','546','547','548','549','550','551','552','553','554','555','556','557','558','564','565','560','559','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','596','149','150','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','595','582','233','234','499','568','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','580','585','587','139','588','589','575','590','591','592','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','583','500','501','502','503','509','488','571','586','489','594','579','573','512','466','569','567','514','593','504','490','498','574','516','505','492','493','494','495','497') AND `hosts`.`hostName` IN ('a44cc8138256','accueil','admin01','admin02','admin07','admin08','admin09','admin12','admin13','admin14','admin15','admin16','agot','arrakis','b05-929m01','b05-929m02','b05-929m03','b05-929m04','b05-929m05','b05-929m06','b05-929m07','b05-929m08','b05-929m09','b05-929m10','b06-002m01','b06-002m02','b06-002m03','b06-002m04','b06-002m05','b06-002m06','b06-002m07','b06-002m08','b06-002m09','b06-002m10','b06-002m11','b06-006m01','b06-008fraise','b06-008m01','b06-008m02','b06-008m03','b06-008m04','b06-008m05','b06-010m02','b06-013m01','b06-013m02','b06-013m03','b06-013m04','b06-013m05','b06-013m06','b06-013m07','b06-013m08','b06-013m09','b06-013m10','b06-013m11','b06-013m12','b06-013m13','b06-013m14','b06-013m15','b06-013m16','b06-013m17','b06-013m18','b06-013m19','b06-013m20','b06-016m01','b06-016m02','b06-016m03','b06-016m04','b06-016m05','b06-016m06','b06-016m07','b06-016m08','b06-016m09','b06-016m10','b06-019-1m01','b06-019-1m02','b06-019-1m03','b06-019-1m04','b06-019-1m05','b06-019-1m06','b06-019-1m07','b06-019-1m08','b06-019-1m09','b06-019-1m10','b06-019-2m01','b06-019-2m02','b06-019-2m02par','b06-019-2m03','b06-019-2m04','b06-021m01','b06-022m01','b06-936m01','b06-937m01','b06-937m02','b06-937m03','b06-937m04','b06-937m05','b06-937m06','b06-937m07','b06-937m08','b06-937m09','b06-937m10','b06-938m01','b06-938m02','b06-938m03','b06-938m04','b06-938m05','b06-938m06','b06-pxi1','b06-pxi2','b06-pxi3','b06-pxi4','b06-pxi5','b06-pxi6','b40-011m01','b40-011m02','b40-011m03','b40-011m04','b40-011m05','b40-011m06','b40-011m07','b40-011m08','b40-011m09','b40-011m10','b40-011m11','b40-011m12','b40-011m13','b40-011m14','b40-011m15','b40-011m16','b40-011m17','b40-011m18','b40-011m19','b40-011m20','b40-011m21','b40-011m22','b40-011m23','b40-011m24','b40-011m25','b40-013m01','b40-013m02','b40-013m03','b40-013m04','b40-013m05','b40-013m06','b40-013m07','b40-013m08','b40-013m09','b40-013m10','b40-013m11','b40-013m12','b40-013m13','b40-013m14','b40-013m15','b40-013m16','b40-013m17','b40-013m18','b40-013m19','b40-013m20','b40-013m21','b40-013m22','b40-013m23','b40-013m24','b41-101m01','b41-101m02','b41-101m03','b41-101m04','b41-101m05','b41-101m06','b41-101m07','b41-101m08','b41-101m09','b41-101m10','b41-101m11','b41-102m01','b41-103m01','b41-104m01','b41-104m02','b41-104m03','b41-104m04','b41-104m05','b41-104m06','b41-104m07','b41-104m08','b41-104m09','b41-104m10','b41-104m11','b41b-009m01','b42-104m01','b42-hallm01','centos7-tp','d000m01','d000m02','d001m01','d020m01','d020m02','d020m03','d020m04','d020m05','d020m06','d020m07','d020m08','d020m09','d020m10','d022m01','d022m02','d022m03','d022m04','d022m05','d022m06','d022m07','d022m08','d022m09','d022m10','d024m01','d024m02','d024m03','d024m04','d024m05','d024m06','d024m07','d024m08','d024m09','d024m10','d026m01','d026m02','d026m03','d026m04','d026m05','d026m06','d026m07','d026m08','d026m09','d026m10','d028m01','d028m02','d028m03','d028m04','d028m05','d028m06','d028m07','d028m08','d028m09','d028m10','d122m01','d122m02','d122m03','d122m04','d122m05','d122m06','d122m07','d122m08','d122m09','d122m10','d180m01','d181m01','d181m02','d182m01','d183m01','d193m03','d265m01','d266m01','d270m01','d270m02','d272m01','d279m01','d279m02','d281m01','d282m01','d284m02','d288m01','d481d7fed37a','d4bed922bad8','d901m01','d903m01','deepml','DESKTOP-T7256EF','e003m01','e003m02','e003m03','e003m04','e003m05','e003m06','e003m07','e003m08','e003m09','e003m10','e005m01','e005m02','e005m03','e005m04','e005m05','e005m06','e005m07','e005m08','e005m09','e005m10','e007m01','e007m02','e007m03','e007m04','e007m05','e007m06','e007m07','e007m08','e007m09','e007m10','e008m01','e008m02','e008m03','e008m04','e008m05','e008m06','e008m07','e008m08','e008m09','e008m10','e010m01','e010m02','e010m03','e010m04','e010m05','e010m06','e010m07','e010m08','e010m09','e010m10','e103m01','e103m02','e103m03','e103m04','e103m05','e103m06','e103m07','e103m08','e103m09','e103m10','e105m01','e105m02','e105m03','e105m04','e105m05','e105m06','e105m07','e105m08','e105m09','e105m10','e107m01','e107m02','e107m03','e107m04','e107m05','e107m06','e107m07','e107m08','e107m09','e107m10','e108m01','e206m01','e206m02','e206m03','e206m04','e206m05','e206m06','e206m07','e206m08','e206m09','e206m10','e212m01','e212m02','e212m03','e212m04','e212m05','e212m06','e212m07','e212m08','e212m09','e212m10','e214m01','e214m02','e214m03','e214m04','e214m05','e214m06','e214m07','e214m08','e214m09','e214m10','fedora24','frioul','i050m01','i051m01','i052m01','i054m01','i054m02','i054m03','i054m04','i054m05','i054m06','i054m07','i054m08','i054m09','i054m10','i054m11','i055m01','i055m02','i055m03','i055m04','i055m05','i055m06','i055m07','i055m08','i055m09','i055m10','i055m11','i058m01','i059m01','i060m01','i203m01','i203m02','i203m03','i203m04','i203m05','i203m06','i203m07','i203m08','i203m09','i203m10','i204m01','i204m02','i204m03','i204m04','i204m05','i204m06','i204m07','i204m08','i204m09','i205m01','i205m02','i205m03','i205m04','i205m05','i205m06','i205m07','i205m08','i205m09','i205m10','i206m01','i206m02','i206m03','i206m04','i206m05','i206m06','i206m07','i206m08','i206m09','i206m10','i207m01','i207m02','i207m03','i207m04','i207m05','i207m06','i207m07','i207m08','i207m09','i207m10','i207m11','i207m12','i207m13','i207m14','i207m15','i207m16','i207m17','i207m18','i207m19','i207m20','i207m21','i207m22','i213m01','i225m01','i225m02','i225m03','i225m04','i227m01','i227m02','i227m03','i227m04','linux','maquette-secret','miage-dell','miage-dell2','miage-dell3','miage-dell4','montevideo','MX2','nimbus','ouessant','port-sec-esir','portable-HP-etu','portable-sec','PortableGilles','probookG1','probookG2','sec-esir-port1','tp-istic','tp-linux','travail-windows','virus','win10','win10-1','win10-2','Win10-3','win10-4','win10-5','win10-6','win10-client-ad','win10test') AND `hostMAC`.`hmPrimary` = '1' ORDER BY LOWER(`hosts`.`hostName`) ASC
Count: 4 Time=0.01s (0s) Lock=0.00s (0s) Rows=517.0 (2068), fogmaster[fogmaster]@localhost
SELECT `hostID` FROM `hosts` LEFT OUTER JOIN `hostMAC` ON `hostMAC`.`hmHostID`=`hosts`.`hostID` LEFT OUTER JOIN `images` ON `images`.`imageID`=`hosts`.`hostImage` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` LEFT OUTER JOIN `hostScreenSettings` ON `hostScreenSettings`.`hssHostID`=`hosts`.`hostID` LEFT OUTER JOIN `hostAutoLogOut` ON `hostAutoLogOut`.`haloHostID`=`hosts`.`hostID` LEFT OUTER JOIN `inventory` ON `inventory`.`iHostID`=`hosts`.`hostID` WHERE `hostMAC`.`hmPrimary` = '1' ORDER BY LOWER(`hosts`.`hostName`) ASC
Count: 4 Time=0.01s (0s) Lock=0.00s (0s) Rows=517.0 (2068), fogmaster[fogmaster]@localhost
SELECT `hostName` FROM `hosts` LEFT OUTER JOIN `hostMAC` ON `hostMAC`.`hmHostID`=`hosts`.`hostID` LEFT OUTER JOIN `images` ON `images`.`imageID`=`hosts`.`hostImage` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` LEFT OUTER JOIN `hostScreenSettings` ON `hostScreenSettings`.`hssHostID`=`hosts`.`hostID` LEFT OUTER JOIN `hostAutoLogOut` ON `hostAutoLogOut`.`haloHostID`=`hosts`.`hostID` LEFT OUTER JOIN `inventory` ON `inventory`.`iHostID`=`hosts`.`hostID` WHERE `hosts`.`hostID` IN ('576','1','78','3','4','5','6','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','581','38','39','40','41','42','570','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','2','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','577','578','105','106','107','108','109','110','518','517','519','520','521','522','523','524','525','526','527','528','563','529','562','530','531','532','533','534','535','536','537','538','539','540','541','542','543','544','545','566','546','547','548','549','550','551','552','553','554','555','556','557','558','564','565','560','559','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','596','149','150','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','595','582','233','234','499','568','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','580','585','587','139','588','589','575','590','591','592','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','583','500','501','502','503','509','488','571','586','489','594','579','573','512','466','569','567','514','593','504','490','498','574','516','505','492','493','494','495','497') AND `hostMAC`.`hmPrimary` = '1' ORDER BY LOWER(`hosts`.`hostName`) ASC
Count: 31963 Time=0.00s (142s) Lock=0.00s (1s) Rows=1.0 (31963), fogmaster[fogmaster]@localhost
SELECT COUNT(`hosts`.`hostID`) AS `total` FROM `hosts` WHERE `hostPending` = '1' LIMIT 1
Count: 3718 Time=0.00s (11s) Lock=0.00s (0s) Rows=1494.0 (5554692), fogmaster[fogmaster]@localhost
SELECT `hmMAC` FROM `hostMAC` ORDER BY `hostMAC`.`hmID` ASC
Count: 31963 Time=0.00s (87s) Lock=0.00s (1s) Rows=1.0 (31963), fogmaster[fogmaster]@localhost
SELECT COUNT(`hostMAC`.`hmID`) AS `total` FROM `hostMAC` WHERE `hmPending` = '1' LIMIT 1
Count: 19 Time=0.00s (0s) Lock=0.00s (0s) Rows=518.0 (9842), fogmaster[fogmaster]@localhost
SELECT `hmMAC` FROM `hostMAC` WHERE `hostMAC`.`hmPrimary`='1' ORDER BY `hostMAC`.`hmID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT `ipxeID` FROM `ipxeTable` WHERE `ipxeTable`.`ipxeFilename`='undionly.kkpxe' AND `ipxeTable`.`ipxeProduct`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeManufacturer`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeMAC`='14:b3:1f:02:8a:f9' ORDER BY `ipxeTable`.`ipxeID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT `ipxeID` FROM `ipxeTable` WHERE `ipxeTable`.`ipxeFilename`='undionly.kkpxe' AND `ipxeTable`.`ipxeProduct`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeManufacturer`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeMAC`='14:b3:1f:02:7e:ac' ORDER BY `ipxeTable`.`ipxeID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT `ipxeID` FROM `ipxeTable` WHERE `ipxeTable`.`ipxeFilename`='undionly.kkpxe' AND `ipxeTable`.`ipxeProduct`='HP Compaq 8100 Elite CMT PC' AND `ipxeTable`.`ipxeManufacturer`='HP Compaq 8100 Elite CMT PC' AND `ipxeTable`.`ipxeMAC`='78:ac:c0:af:be:2f' ORDER BY `ipxeTable`.`ipxeID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT `ipxeID` FROM `ipxeTable` WHERE `ipxeTable`.`ipxeFilename`='undionly.kkpxe' AND `ipxeTable`.`ipxeProduct`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeManufacturer`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeMAC`='14:b3:1f:02:4e:f6' ORDER BY `ipxeTable`.`ipxeID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT `ipxeID` FROM `ipxeTable` WHERE `ipxeTable`.`ipxeFilename`='undionly.kkpxe' AND `ipxeTable`.`ipxeProduct`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeManufacturer`='OptiPlex 7440 AIO' AND `ipxeTable`.`ipxeMAC`='14:b3:1f:02:47:fc' ORDER BY `ipxeTable`.`ipxeID` ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=51.0 (255), fogmaster[fogmaster]@localhost
SELECT * FROM `images` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` WHERE `images`.`imageID` IN ('6','9','10','12','13','14','15','16','17','20','22','25','26','27','28','29','30','31','32','36','37','38','39','40','41','42','43','46','47','48','49','52','53','54','56','57','58','60','61','62','63','64','65','66','67','68','69','70','71','72','73') AND 1 ORDER BY LOWER(`images`.`imageName`) ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=51.0 (255), fogmaster[fogmaster]@localhost
SELECT `igaImageID` FROM `imageGroupAssoc` LEFT OUTER JOIN `images` ON `images`.`imageID`=`imageGroupAssoc`.`igaImageID` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` LEFT OUTER JOIN `nfsGroups` ON `nfsGroups`.`ngID`=`imageGroupAssoc`.`igaStorageGroupID` WHERE `imageGroupAssoc`.`igaStorageGroupID`='1' AND `imageGroupAssoc`.`igaImageID` IN ('65','43','38','17','27','30','37','46','31','25','28','41','47','48','49','53','58','66','67','73','36','69','60','54','6','9','68','14','32','63','62','64','15','22','57','71','12','16','72','13','26','20','70','29','42','39','40','56','10','52','61') ORDER BY `imageGroupAssoc`.`igaID` ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=51.0 (255), fogmaster[fogmaster]@localhost
SELECT `imageID` FROM `images` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` WHERE `images`.`imageEnabled`='1' AND `images`.`imageReplicate`='1' AND 1 ORDER BY LOWER(`images`.`imageName`) ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=55.0 (275), fogmaster[fogmaster]@localhost
SELECT `imageID` FROM `images` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` WHERE 1 ORDER BY LOWER(`images`.`imageName`) ASC
Count: 42 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (42), fogmaster[fogmaster]@localhost
SELECT * FROM `powerManagement` WHERE `powerManagement`.`pmAction`='wol' AND `powerManagement`.`pmOndemand` IN ('0','') ORDER BY `powerManagement`.`pmID` ASC
Count: 42 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (42), fogmaster[fogmaster]@localhost
SELECT COUNT(`powerManagement`.`pmID`) AS `total` FROM `powerManagement` WHERE `pmAction` = 'wol' AND `pmOndemand` = '0' LIMIT 1
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), fogmaster[fogmaster]@localhost
SELECT `igaImageID` FROM `imageGroupAssoc` LEFT OUTER JOIN `images` ON `images`.`imageID`=`imageGroupAssoc`.`igaImageID` LEFT OUTER JOIN `os` ON `os`.`osID`=`images`.`imageOSID` LEFT OUTER JOIN `imagePartitionTypes` ON `imagePartitionTypes`.`imagePartitionTypeID`=`images`.`imagePartitionTypeID` LEFT OUTER JOIN `imageTypes` ON `imageTypes`.`imageTypeID`=`images`.`imageTypeID` LEFT OUTER JOIN `nfsGroups` ON `nfsGroups`.`ngID`=`imageGroupAssoc`.`igaStorageGroupID` WHERE `imageGroupAssoc`.`igaImageID` NOT IN ('65','43','38','1','3','4','17','27','30','37','46','31','25','28','41','47','48','49','53','58','66','67','73','36','69','60','54','6','9','68','14','32','63','62','64','15','22','57','71','12','16','72','13','26','20','70','29','42','39','40','56','5','10','52','61') ORDER BY `imageGroupAssoc`.`igaID` ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (5), fogmaster[fogmaster]@localhost
SELECT COUNT(`imageGroupAssoc`.`igaID`) AS `total` FROM `imageGroupAssoc` WHERE `igaStorageGroupID` = '1' AND `igaImageID` IN ('65','43','38','17','27','30','37','46','31','25','28','41','47','48','49','53','58','66','67','73','36','69','60','54','6','9','68','14','32','63','62','64','15','22','57','71','12','16','72','13','26','20','70','29','42','39','40','56','10','52','61') LIMIT 1
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (8), fogmaster[fogmaster]@localhost
SELECT * FROM `snapins` WHERE `snapins`.`sID` IN ('1','2','3','4','5','6','7','8','9','10') AND `snapins`.`sEnabled`='1' AND 1 ORDER BY LOWER(`snapins`.`sName`) ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=13.0 (65), fogmaster[fogmaster]@localhost
SELECT * FROM `pxeMenu` ORDER BY `pxeMenu`.`pxeID` ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (40), fogmaster[fogmaster]@localhost
SELECT * FROM `pxeMenu` WHERE `pxeMenu`.`pxeRegOnly` IN ('1','2','5') ORDER BY `pxeMenu`.`pxeID` ASC
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (1), fogmaster[fogmaster]@localhost
SELECT COUNT(`snapins`.`sID`) AS `total` FROM `snapins` WHERE `sID` IN ('1','2','3','4','5','6','7','8','9','10') AND `sEnabled` = '1' AND 1 LIMIT 1
Count: 23678 Time=0.00s (1s) Lock=0.00s (0s) Rows=13.0 (307814), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','5','8','9','13','10','6','11','2','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 3452 Time=0.00s (0s) Lock=0.00s (0s) Rows=12.0 (41424), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','5','8','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 9295 Time=0.00s (0s) Lock=0.00s (0s) Rows=10.0 (92950), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','8','9','13','6','11','2','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 361 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (2527), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','13','6','11','9','5','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 2959 Time=0.00s (0s) Lock=0.00s (0s) Rows=13.0 (38467), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','5','8','9','13','10','6','11','2','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 1984 Time=0.00s (0s) Lock=0.00s (0s) Rows=9.0 (17856), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','8','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 711 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (4977), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 129 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (903), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','9','13','11','12','6') ORDER BY LOWER(`modules`.`name`) ASC
Count: 3008 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (24064), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','5','9','13','6','11','12','8') ORDER BY LOWER(`modules`.`name`) ASC
Count: 1856 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (12992), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','9','6','11','13','10','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 264 Time=0.00s (0s) Lock=0.00s (0s) Rows=10.0 (2640), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 128 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (1024), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 3665 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (25655), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 431 Time=0.00s (0s) Lock=0.00s (0s) Rows=12.0 (5172), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','5','8','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 9625 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (67375), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','9','13','6','11','12','5') ORDER BY LOWER(`modules`.`name`) ASC
Count: 161 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (1127), fogmaster[fogmaster]@localhost
SELECT `id` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','13','6','11') ORDER BY LOWER(`modules`.`name`) ASC
Count: 1161 Time=0.00s (0s) Lock=0.00s (0s) Rows=10.0 (11610), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','8','9','13','6','11','2','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 248 Time=0.00s (0s) Lock=0.00s (0s) Rows=9.0 (2232), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','8','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 33 Time=0.00s (0s) Lock=0.00s (0s) Rows=10.0 (330), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','7','1','3','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 376 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (3008), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','5','8','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 16 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (112), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 101 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (707), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 690 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (4830), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','9','13','10','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 1248 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (8736), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','5','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 23 Time=0.00s (0s) Lock=0.00s (0s) Rows=7.0 (161), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','13','6','11') ORDER BY LOWER(`modules`.`name`) ASC
Count: 16 Time=0.00s (0s) Lock=0.00s (0s) Rows=8.0 (128), fogmaster[fogmaster]@localhost
SELECT `short_name` FROM `modules` WHERE `modules`.`id` IN ('4','3','5','9','13','6','11','12') ORDER BY LOWER(`modules`.`name`) ASC
Count: 5 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (5), fogmaster[fogmaster]@localhost
SELECT `pxeID` FROM `pxeMenu` WHERE `pxeMenu`.`pxeDefault`='1' ORDER BY LOWER(`pxeMenu`.`pxeName`) ASC
Count: 42 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), fogmaster[fogmaster]@localhost
SELECT * FROM `scheduledTasks` WHERE `scheduledTasks`.`stActive`='1' ORDER BY LOWER(`scheduledTasks`.`stName`) ASC
Count: 42 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (42), fogmaster[fogmaster]@localhost
SELECT COUNT(`scheduledTasks`.`stID`) AS `total` FROM `scheduledTasks` WHERE `stActive` = '1' LIMIT 1
@george1421 said in FOG Multicast Not starting anymore:
SELECT TABLE_NAME,ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ‘fog’ and ENGINE = ‘MyISAM’;
Hello
I have a result that look like your, but I get only 51 rows .
I have more than 300 computer deployed with Fog so I collect info that you need.
mysql> SELECT TABLE_NAME,ENGINE
-> FROM information_schema.TABLES
-> WHERE TABLE_SCHEMA = 'fog' and ENGINE = 'MyISAM';
+------------------------+--------+
| TABLE_NAME | ENGINE |
+------------------------+--------+
| clientUpdates | MyISAM |
| dirCleaner | MyISAM |
| globalSettings | MyISAM |
| greenFog | MyISAM |
| groupMembers | MyISAM |
| groups | MyISAM |
| history | MyISAM |
| hookEvents | MyISAM |
| hostAutoLogOut | MyISAM |
| hostMAC | MyISAM |
| hostScreenSettings | MyISAM |
| hosts | MyISAM |
| imageGroupAssoc | MyISAM |
| imagePartitionTypes | MyISAM |
| imageTypes | MyISAM |
| images | MyISAM |
| imagingLog | MyISAM |
| inventory | MyISAM |
| ipxeTable | MyISAM |
| keySequence | MyISAM |
| moduleStatusByHost | MyISAM |
| modules | MyISAM |
| multicastSessions | MyISAM |
| multicastSessionsAssoc | MyISAM |
| nfsFailures | MyISAM |
| nfsGroupMembers | MyISAM |
| nfsGroups | MyISAM |
| notifyEvents | MyISAM |
| os | MyISAM |
| oui | MyISAM |
| plugins | MyISAM |
| powerManagement | MyISAM |
| printerAssoc | MyISAM |
| printers | MyISAM |
| pxeMenu | MyISAM |
| scheduledTasks | MyISAM |
| schemaVersion | MyISAM |
| snapinAssoc | MyISAM |
| snapinGroupAssoc | MyISAM |
| snapinJobs | MyISAM |
| snapinTasks | MyISAM |
| snapins | MyISAM |
| supportedOS | MyISAM |
| taskLog | MyISAM |
| taskStates | MyISAM |
| taskTypes | MyISAM |
| tasks | MyISAM |
| userCleanup | MyISAM |
| userTracking | MyISAM |
| users | MyISAM |
| virus | MyISAM |
+------------------------+--------+
51 rows in set (0.00 sec)
Hello, I have cleaned the database:
mysql> DELETE FROM multicastSessions WHERE 1;
mysql> DELETE FROM multicastSessionsAssoc WHERE 1;
mysql> DELETE FROM tasks WHERE taskTypeID = 8;
And restarted the server, I had urgent deply to taunch, and the multicast worked…
I have a high cpu level for mysqld about 20%
in /var/log/php-fpm/www-error.log I have
[05-Jan-2022 07:39:40 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogmanagercontroller.class.php on line 1243
[05-Jan-2022 07:39:41 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 260
[05-Jan-2022 08:25:07 UTC] PHP Warning: array_diff(): Argument #2 is not an array in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1084
[05-Jan-2022 08:25:07 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1085
[05-Jan-2022 08:25:07 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1104
[05-Jan-2022 08:25:07 UTC] PHP Warning: array_diff(): Argument #2 is not an array in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1084
[05-Jan-2022 08:25:07 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1085
[05-Jan-2022 08:25:07 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1104
[05-Jan-2022 08:25:07 UTC] PHP Warning: array_diff(): Argument #2 is not an array in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1084
[05-Jan-2022 08:25:07 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1085
[05-Jan-2022 08:25:07 UTC] PHP Warning: Invalid argument supplied for foreach() in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 1104
[07-Jan-2022 08:58:45 UTC] PHP Warning: trim() expects parameter 1 to be string, array given in /var/www/html/fog/lib/fog/fogbase.class.php on line 1386
[07-Jan-2022 09:31:56 UTC] PHP Warning: trim() expects parameter 1 to be string, array given in /var/www/html/fog/lib/fog/fogbase.class.php on line 1386
[07-Jan-2022 09:32:36 UTC] PHP Warning: trim() expects parameter 1 to be string, array given in /var/www/html/fog/lib/fog/fogbase.class.php on line 1386
[07-Jan-2022 09:58:02 UTC] PHP Warning: trim() expects parameter 1 to be string, array given in /var/www/html/fog/lib/fog/fogbase.class.php on line 1386
[07-Jan-2022 10:03:33 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogmanagercontroller.class.php on line 1243
[07-Jan-2022 10:03:34 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /var/www/html/fog/lib/fog/fogbase.class.php on line 2408
[07-Jan-2022 10:03:35 UTC] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/fog/lib/fog/fogmanagercontroller.class.php on line 1243
Should I increase php memory allocation ?
in /var/log/httpd/error_log I have maybe too many connections !
[Fri Jan 07 13:34:38.470356 2022] [ssl:info] [pid 2823:tid 139958815811328] [client 148.60.6.219:33456] AH01964: Connection to child 205 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.550903 2022] [ssl:info] [pid 2823:tid 139959677421312] [client 148.60.1.49:46882] AH01964: Connection to child 192 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.576333 2022] [ssl:info] [pid 3000:tid 139959419791104] [client 148.60.3.30:10629] AH01964: Connection to child 262 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.650352 2022] [ssl:info] [pid 3000:tid 139959669028608] [client 148.60.1.111:56182] AH01964: Connection to child 257 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.665799 2022] [ssl:info] [pid 3001:tid 139958622877440] [client 148.60.3.30:10630] AH01964: Connection to child 339 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.730196 2022] [ssl:info] [pid 2823:tid 139958178260736] [client 148.60.1.49:46884] AH01964: Connection to child 216 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.773104 2022] [ssl:info] [pid 3000:tid 139958790633216] [client 148.60.3.30:10631] AH01964: Connection to child 272 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.829425 2022] [ssl:info] [pid 3000:tid 139959652243200] [client 148.60.3.30:10632] AH01964: Connection to child 259 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.947370 2022] [ssl:info] [pid 3000:tid 139958648022784] [client 148.60.1.111:56184] AH01964: Connection to child 280 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:38.963974 2022] [ssl:info] [pid 3001:tid 139958614484736] [client 148.60.1.49:46886] AH01964: Connection to child 340 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:39.125635 2022] [ssl:info] [pid 3001:tid 139959411398400] [client 148.60.1.49:46888] AH01964: Connection to child 327 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:39.161997 2022] [ssl:info] [pid 3000:tid 139958656415488] [client 148.60.3.64:56942] AH01964: Connection to child 279 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:39.194609 2022] [ssl:info] [pid 3000:tid 139958689986304] [client 148.60.1.111:56186] AH01964: Connection to child 275 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:39.340765 2022] [ssl:info] [pid 3001:tid 139958580913920] [client 148.60.3.64:56944] AH01964: Connection to child 344 established (server 148.60.4.1:443)
[Fri Jan 07 13:34:39.400908 2022] [ssl:info] [pid 2191:tid 139958748702464] [client 148.60.3.86:51618] AH01964: Connection to child 12 established (server 148.60.4.1:443)
top
Tasks: 344 total, 3 running, 341 sleeping, 0 stopped, 0 zombie
%Cpu(s): 3,5 us, 1,9 sy, 0,0 ni, 94,6 id, 0,0 wa, 0,0 hi, 0,0 si, 0,0 st
MiB Mem : 15328,7 total, 181,5 free, 1147,8 used, 13999,4 buff/cache
MiB Swap: 7812,0 total, 7671,2 free, 140,8 used. 13821,7 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12733 apache 20 0 257736 20040 13356 S 33,3 0,1 1:14.67 php-fpm
12712 apache 20 0 257744 20016 13356 S 26,7 0,1 1:16.17 php-fpm
2268 mysql 20 0 3163384 386068 18932 S 13,3 2,5 13:30.89 mysqld
2192 apache 20 0 2601264 20676 9576 S 6,7 0,1 0:12.93 httpd
3001 apache 20 0 2535728 24772 9784 S 6,7 0,2 1:51.32 httpd
1 root 20 0 242360 9600 7368 S 0,0 0,1 0:09.15 systemd
2 root 20 0 0 0 0 S 0,0 0,0 0:00.00 kthreadd
3 root 0 -20 0 0 0 I 0,0 0,0 0:00.00 rcu_gp
4 root 0 -20 0 0 0 I 0,0 0,0 0:00.00 rcu_par_gp
6 root 0 -20 0 0 0 I 0,0 0,0 0:00.00 kworker/0:0H-kblockd
8 root 0 -20 0 0 0 I 0,0 0,0 0:00.00 mm_percpu_wq
Hello
Multicast does not start anymore
I didn’t change anything on the server configuration.
So I restarted the server.
I have a service that listens on port 9000 with a lot of lines (1193 lines)
I don’t know where I could have a look ?
tcp 0 0 127.0.0.1:9000 127.0.0.1:50380 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50736 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52706 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50388 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52350 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50758 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52534 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51140 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52260 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51100 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51414 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51394 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50290 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50498 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52752 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51030 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52590 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50418 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52324 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50416 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51384 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51654 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51170 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52756 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52532 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52476 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51660 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50622 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50326 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51458 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52610 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52666 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51768 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50894 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51186 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50364 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51230 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50704 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50412 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52370 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50828 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51060 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50110 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:52928 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50838 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:51298 TIME_WAIT -
tcp 0 0 127.0.0.1:9000 127.0.0.1:50852 TIME_WAIT -
@sebastian-roth
Yes Youare right.
I focused on the "corrupted size vs. and did not see previous message.
A scan disk on the master and it works.
Thanks.