FOG Multicast Not starting anymore

george1421 · Jan 11, 2022, 1:01 PM

@lebrun78 Thank you this information is very helpful. It will help us develop several indexes for the database that will speed up the responsiveness of the database. Just for my knowledge the time span was 30 minutes of data collection?

OK to work on your performance issue. We are going to use this thread as the background of the fix: https://forums.fogproject.org/topic/14254/high-cpu-usage

The first thing I need you to check is to see if your installation of mysql/mariadb has several default values that will cause us troubles during the upgrade. The upgrade itself is pretty quick.

In the mysql console run this command and post the results here: SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session

This query will respond with something that looks like this:

mysql> 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_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

Please post the text of the query because we may need to copy some text back into a new command.

george1421 · Jan 11, 2022, 1:01 PM

@george1421 based on the previous query this is what we will need to change. But don’t do that until we check the server default parameters and make a backup first.

ALTER TABLE clientUpdates      ENGINE=InnoDB;
ALTER TABLE dirCleaner         ENGINE=InnoDB;
ALTER TABLE globalSettings     ENGINE=InnoDB;
ALTER TABLE greenFog           ENGINE=InnoDB;
ALTER TABLE groupMembers       ENGINE=InnoDB;
ALTER TABLE groups             ENGINE=InnoDB;
ALTER TABLE history            ENGINE=InnoDB;
ALTER TABLE hookEvents         ENGINE=InnoDB;
ALTER TABLE hostAutoLogOut     ENGINE=InnoDB;
ALTER TABLE hostMAC            ENGINE=InnoDB;
ALTER TABLE hostScreenSettings ENGINE=InnoDB;
ALTER TABLE hosts              ENGINE=InnoDB;
ALTER TABLE imageGroupAssoc    ENGINE=InnoDB;
ALTER TABLE imagePartitionTypes ENGINE=InnoDB;
ALTER TABLE imageTypes         ENGINE=InnoDB;
ALTER TABLE images             ENGINE=InnoDB;
ALTER TABLE imagingLog         ENGINE=InnoDB;
ALTER TABLE inventory          ENGINE=InnoDB;
ALTER TABLE ipxeTable          ENGINE=InnoDB;
ALTER TABLE keySequence        ENGINE=InnoDB;
ALTER TABLE moduleStatusByHost ENGINE=InnoDB;
ALTER TABLE modules            ENGINE=InnoDB;
ALTER TABLE multicastSessions  ENGINE=InnoDB;
ALTER TABLE multicastSessionsAssoc ENGINE=InnoDB;
ALTER TABLE nfsFailures        ENGINE=InnoDB;
ALTER TABLE nfsGroupMembers    ENGINE=InnoDB;
ALTER TABLE nfsGroups          ENGINE=InnoDB;
ALTER TABLE notifyEvents       ENGINE=InnoDB;
ALTER TABLE os                 ENGINE=InnoDB;
ALTER TABLE oui                ENGINE=InnoDB;
ALTER TABLE plugins            ENGINE=InnoDB;
ALTER TABLE powerManagement    ENGINE=InnoDB;
ALTER TABLE printerAssoc       ENGINE=InnoDB;
ALTER TABLE printers           ENGINE=InnoDB;
ALTER TABLE pxeMenu            ENGINE=InnoDB;
ALTER TABLE scheduledTasks     ENGINE=InnoDB;
ALTER TABLE schemaVersion      ENGINE=InnoDB;
ALTER TABLE snapinAssoc        ENGINE=InnoDB;
ALTER TABLE snapinGroupAssoc   ENGINE=InnoDB;
ALTER TABLE snapinJobs         ENGINE=InnoDB;
ALTER TABLE snapinTasks        ENGINE=InnoDB;
ALTER TABLE snapins            ENGINE=InnoDB;
ALTER TABLE supportedOS        ENGINE=InnoDB;
ALTER TABLE taskLog            ENGINE=InnoDB;
ALTER TABLE taskStates         ENGINE=InnoDB;
ALTER TABLE taskTypes          ENGINE=InnoDB;
ALTER TABLE tasks              ENGINE=InnoDB;
ALTER TABLE userCleanup        ENGINE=InnoDB;
ALTER TABLE userTracking       ENGINE=InnoDB;
ALTER TABLE users              ENGINE=InnoDB;
ALTER TABLE virus              ENGINE=InnoDB;

lebrun78 · Jan 11, 2022, 7:37 AM

@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)

george1421 · Jan 11, 2022, 8:23 AM

@lebrun78 said in FOG Multicast Not starting anymore:

OK these two settings are going to cause us trouble.

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,  >>NO_ZERO_IN_DATE,NO_ZERO_DATE<<  ,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

We need to find the mysql settings file. Lets use this search string to see if we can find the right file.

grep -r -e "[mysqld]" /etc

We are looking for a file that has the mysqld section heading.

Just under that section heading we need to insert the corrected parameters.

[mysqld]
sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Once that config file has been updated restart the mysql database. If the database comes back online then we can proceed to the next steps. We are almost done.

lebrun78 · Jan 11, 2022, 2:59 PM

@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.

george1421 · Jan 11, 2022, 3:53 PM

@lebrun78 Great it looks like the db restarted after the service parameters update.

Access the mysql database and run these commands. They should complete without an error.

ALTER TABLE clientUpdates      ENGINE=InnoDB;
ALTER TABLE dirCleaner         ENGINE=InnoDB;
ALTER TABLE globalSettings     ENGINE=InnoDB;
ALTER TABLE greenFog           ENGINE=InnoDB;
ALTER TABLE groupMembers       ENGINE=InnoDB;
ALTER TABLE groups             ENGINE=InnoDB;
ALTER TABLE history            ENGINE=InnoDB;
ALTER TABLE hookEvents         ENGINE=InnoDB;
ALTER TABLE hostAutoLogOut     ENGINE=InnoDB;
ALTER TABLE hostMAC            ENGINE=InnoDB;
ALTER TABLE hostScreenSettings ENGINE=InnoDB;
ALTER TABLE hosts              ENGINE=InnoDB;
ALTER TABLE imageGroupAssoc    ENGINE=InnoDB;
ALTER TABLE imagePartitionTypes ENGINE=InnoDB;
ALTER TABLE imageTypes         ENGINE=InnoDB;
ALTER TABLE images             ENGINE=InnoDB;
ALTER TABLE imagingLog         ENGINE=InnoDB;
ALTER TABLE inventory          ENGINE=InnoDB;
ALTER TABLE ipxeTable          ENGINE=InnoDB;
ALTER TABLE keySequence        ENGINE=InnoDB;
ALTER TABLE moduleStatusByHost ENGINE=InnoDB;
ALTER TABLE modules            ENGINE=InnoDB;
ALTER TABLE multicastSessions  ENGINE=InnoDB;
ALTER TABLE multicastSessionsAssoc ENGINE=InnoDB;
ALTER TABLE nfsFailures        ENGINE=InnoDB;
ALTER TABLE nfsGroupMembers    ENGINE=InnoDB;
ALTER TABLE nfsGroups          ENGINE=InnoDB;
ALTER TABLE notifyEvents       ENGINE=InnoDB;
ALTER TABLE os                 ENGINE=InnoDB;
ALTER TABLE oui                ENGINE=InnoDB;
ALTER TABLE plugins            ENGINE=InnoDB;
ALTER TABLE powerManagement    ENGINE=InnoDB;
ALTER TABLE printerAssoc       ENGINE=InnoDB;
ALTER TABLE printers           ENGINE=InnoDB;
ALTER TABLE pxeMenu            ENGINE=InnoDB;
ALTER TABLE scheduledTasks     ENGINE=InnoDB;
ALTER TABLE schemaVersion      ENGINE=InnoDB;
ALTER TABLE snapinAssoc        ENGINE=InnoDB;
ALTER TABLE snapinGroupAssoc   ENGINE=InnoDB;
ALTER TABLE snapinJobs         ENGINE=InnoDB;
ALTER TABLE snapinTasks        ENGINE=InnoDB;
ALTER TABLE snapins            ENGINE=InnoDB;
ALTER TABLE supportedOS        ENGINE=InnoDB;
ALTER TABLE taskLog            ENGINE=InnoDB;
ALTER TABLE taskStates         ENGINE=InnoDB;
ALTER TABLE taskTypes          ENGINE=InnoDB;
ALTER TABLE tasks              ENGINE=InnoDB;
ALTER TABLE userCleanup        ENGINE=InnoDB;
ALTER TABLE userTracking       ENGINE=InnoDB;
ALTER TABLE users              ENGINE=InnoDB;
ALTER TABLE virus              ENGINE=InnoDB;

Finally run this query to make sure everything has been switched over to INNODB.

SELECT TABLE_NAME,ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ‘fog’

All of the table should now use the INNODB db engine. You will not need to do anything else it should start working right away better. I would reboot the FOG server though just to ensure everything works OK after the reboot. Once that happens you should see lower CPU usage as well as mysql and php-fpm services levels should return to normal.

lebrun78 · Jan 13, 2022, 2:12 PM

@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'

george1421 · Jan 13, 2022, 9:39 AM

@lebrun78 Well I guess I get an D- on this test.

OK
on this one

ALTER TABLE groups             ENGINE=InnoDB;

There might be an artifact in there like a tab character because of the way I created the file. Try running that again like this:

ALTER TABLE groups ENGINE=InnoDB;

In the case of this one:

mysql> SELECT TABLE_NAME,ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = fog;
ERROR 1054 (42S22): Unknown column 'fog' in 'where clause'

I think you are missing the single ticks around the fog value. It should look like this

SELECT TABLE_NAME,ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'fog'

All this query does is prints out all of the tables in the fog database to confirm they are now all innodb format. All of the other tables converted correctly except the groups table. You should see a drop in cpu usage for by mysql and php-fpm already.

lebrun78 · Jan 13, 2022, 3:37 PM

@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>

lebrun78 · Jan 13, 2022, 3:41 PM

@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

lebrun78 · Jan 13, 2022, 3:42 PM

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)

george1421 · Jan 13, 2022, 3:47 PM

@lebrun78 Excellent. I forgot that group was a keyword AND a table name. Good find to escape the table name.

And for the table engines good, that is exactly what we need.

george1421 · Jan 13, 2022, 3:52 PM

@lebrun78 You might ask, why did I have you change the engine and how will that help with performance?

The simple answer is MyISAM uses table level locking when something is updated. INNODB engine uses row level locking on an update. Under table level locking when someone goes to update a table, that processing updating the a row causes all other processes to stop updating until the write is complete. Under row level locking, only the database row that is being changed is locked all other tables and rows are free to be updated by other processes. The table level locking of MyISAM will create a back log of processes waiting their turn to update the database.

You will see this backlog by higher than normal cpu percent on the mysql process and many (many) php-fpm processes waiting their turn to update the database.

lebrun78 · Jan 13, 2022, 4:09 PM

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

george1421 · Jan 13, 2022, 4:47 PM

@lebrun78 Well that didn’t seem to fix the issue. It should have, but you still have a long waiting list. How many client computers do you have in your network where the fog client is installed?

george1421 · Jan 13, 2022, 5:07 PM

@lebrun78 looking at top screen it looks like you are using quite a bit of RAM and even dipping into swap space. Did you increase the number of php-fpm workers or increase the per worker memory limit at one time. These changes would have been made to the php-fpm config file.

Sebastian Roth · Jan 14, 2022, 7:51 AM

@lebrun78 I can imagine the php-fpm processes being under some heavy load some time after things were kind of offline because many clients try to check in again in a short time. But if things are fine this should “cool down” after an hour (even earlier but surely after that much time).

So if it’s still high load in php-fpm processes I suggest you also look at the Apache logs (see my signatur) and maybe even fog-client logs on machines (C:\fog.log). Post log information here so we can help interpret it.

lebrun78 · Jan 14, 2022, 7:51 AM

@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

Sebastian Roth · Jan 14, 2022, 1:12 PM

@lebrun78 Also take a look at the Apache access.log. Check if you see clients constantly trying to download an update (SmartInstaller.exe).

lebrun78 · Jan 14, 2022, 1:43 PM

@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 "-" "-"

FOG Multicast Not starting anymore

137

12.0k

17.3k

155.1k