FOG Multicast Not starting anymore


  • @george1421
    I got one error with the groups table:

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

    and this error

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

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


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

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


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

    @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;
    
  • Moderator

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


  • 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
    
    
    
  • Moderator

    @lebrun78 Thank you for the feedback . Your install is suffering from having the database engine for the tables in ISAM format instead of INNODB. We can fix this no problem.

    OK now my needs. I want to use your mysql database with many fog clients to record how many queries take long than 1 second to complete. With your slow database it probably will be all of them. I want to do a before and after test to see the improvements and then once we get the improvements the after scan will give us hints how to make the database go even faster.

    The following commands will turn on global query logging (note it might even make your database slower so we will only let it run for 30 minutes).

    Log into mysql database as root and run these commands.

    SET GLOBAL slow_query_log = 'ON';
    SET GLOBAL slow_query_log_file = '/var/log/mysql/slowquery.log';
    SET GLOBAL log_queries_not_using_indexes = 'ON';
    SET GLOBAL long_query_time = 1;
    FLUSH LOGS;
    

    Let this run for 30 minutes at the time of day where you would have the most computers on line and pinging the FOG server.

    Then after 30 minutes log back into mysql and run this command to turn off logging.

    SET GLOBAL slow_query_log = 'OFF';
    

    The last part is to make a report of the log file and post it in this thread or via a file sharing site. From the linux command prompt run this command to make the report

    mysqldumpslow -a /var/log/mysql/slowquery.log >/tmp/slowreport.txt
    

    Download the /tmp/slowreport.txt from the FOG server and post it here, please.


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

    @lebrun78 How many computers in your environment that has the fog client installed on it?

    On the fog server log into mysql client tool with mysql -u root -p

    Then run this command in the mysql client

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

    Does it return results that look like this?

    +------------------------+--------+
    | TABLE_NAME             | ENGINE |
    +------------------------+--------+
    | LDAPServers            | MyISAM |
    | 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 |
    | location               | MyISAM |
    | locationAssoc          | 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 |
    | wolbroadcast           | MyISAM |
    +------------------------+--------+
    55 rows in set (0.00 sec)
    

    If so I have a fix for your, but I also need your help first because we are looking at performance tuning the mysql database. I need to collect some info from a fog site that has over 100 target computers running FOG.


  • 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       
    
  • Moderator

    @lebrun78 I think port 9000 is php-fpm listening port. Apache talks to the php engine over the loopback adapter (127.0.0.1). Can you check to see if php-fpm is running ps aux| grep php

    I think if php-fpm is not running the fog web ui should also be broken.

    You might want to look into /var/log/apache2 and /var/log/php-fpm for the error logs to see if there is any helpful errors. Also in /opt/fog/logs there should be a multicast log too. See if they give any help with the problem.

342
Online

9.1k
Users

15.7k
Topics

145.9k
Posts