@sebastian-roth
Hello Sebastian,
Tried with your proposed modifications on a 1.5.9.63 testing server.
I have got this error with an existing image on the server
Remove the image files on the server, it worked.
Arnaud
@sebastian-roth
Hello Sebastian,
Tried with your proposed modifications on a 1.5.9.63 testing server.
I have got this error with an existing image on the server
Remove the image files on the server, it worked.
Arnaud
@sebastian-roth
It’s still working for me.
Here is the content of the fog_snapin_inst.ps1 script which mounts the share and which launches either a batch script or a powershell script
param (
[String] $programme
)
$user = "fog"
$pwd = "EncriptpasswordwBiADEAZA="
$serveur = "\\wolala.univ-rennes1.fr\snapins$"
[Byte[]] $key = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
$password = ConvertTo-SecureString -key $key -string $pwd
$credential = New-Object -TypeName system.management.Automation.PSCredential -ArgumentList $user, $password
if (!(Test-Path -Path Q:)){
$net = new-object -ComObject WScript.Network
$net.MapNetworkDrive("p:", $serveur, $false, $credential.GetNetworkCredential().UserName,$credential.GetNetworkCredential().password)
}
#lorsque l'on lance un script powershell, si il y avait des espaces dans le nom, cela ne passait pas
#lorsque l'on faisait un start-process et ce nom en argument. Donc on utilise plutot le nom court
$prog_court = (New-Object -ComObject Scripting.FileSystemObject).GetFile($programme).ShortPath
write-host "$(hostname):Dossier de l'installer $($dossier_installer)"
write-host ""
write-host "$(hostname):lancement de $($programme)"
write-host "$(hostname):lancement de $($prog_court)"
#start-process -FilePath $programme -wait -NoNewWindow
$dossier_installer = $((get-item -path $programme).DirectoryName)
if (!(Test-Path -Path "$dossier_installer\logs_fog_install")){New-Item -ItemType directory -Path "$dossier_installer\logs_fog_install"}
$extension = (get-item -path $programme).Extension
if ($extension -eq ".bat" -or $extension -eq ".cmd") {
write-host "$env:COMPUTERNAME:C'est un script bat"
start-process -FilePath $prog_court -wait -NoNewWindow -RedirectStandardOutput ${dossier_installer}\logs_fog_install\${env:COMPUTERNAME}_log.txt -RedirectStandardError ${dossier_installer}\logs_fog_install\${env:COMPUTERNAME}_error.txt
}
if ($extension -eq ".ps1") {
write-host "$env:COMPUTERNAME:C'est un script powershell"
$policy = Get-ExecutionPolicy
Set-ExecutionPolicy AllSigned
start-process -FilePath PowerShell -Arg $prog_court -wait -NoNewWindow -RedirectStandardOutput ${dossier_installer}\logs_fog_install\${env:COMPUTERNAME}_log.txt -RedirectStandardError ${dossier_installer}\logs_fog_install\${env:COMPUTERNAME}_error.txt
Set-ExecutionPolicy $policy
}
$net.RemoveNetworkDrive("p:")
Remove-SmbMapping -RemotePath $serveur -Force
# SIG # Begin signature block
# MIIECAYJKoZIhvcNAQcCoIID+TCCA/UCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB
So I get this Snapin Command read-only:
powershell.exe -ExecutionPolicy Bypass -NoProfile -File fog_snapin_inst.ps1 -programme P:\officepro2010\inst_office2010.bat
Hello
Do you have any suggestions or examples of snapins running powershell scripts for installing programs hosted on an authenticated share?
I am unable to do an authenticated samba mount with the system account used by the fog client.
@sebastian-roth
No actually, the share is only accessible to administrators.
I use a powershell script which mount with a samba share account the share and launch the installer.
but the script seems not working when run as system.
I’m investigating
@sebastian-roth
Yes, I now unterdstand the problem, fog client is running with local\install account, not system.
We use install account for a long time to access samba share with snapin scripts. Have you example to access samba share with client running under system account ?
I have No error 2691 running fogservice with system account
@sebastian-roth
(currentIP.Intersect(targetIP).Any()) = true
@sebastian-roth
I 've just run the script as a domain-admin.
domain as value ur.local (the ad domain name)
targetIP and targetIP contain the same address (the AD controler addresses )
@sebastian-roth
Yes I ran this script as administrator. But administrator is not member of the AD domain.
I tried disabling IPv6.
[admin07]: PS C:\Users\Administrateur\Documents> $o = [System.Net.Dns]::GetHostAddresses("admin07")
[admin07]: PS C:\Users\Administrateur\Documents> $o
Address :
AddressFamily : InterNetworkV6
ScopeId : 0
IsIPv6Multicast : False
IsIPv6LinkLocal : False
IsIPv6SiteLocal : False
IsIPv6Teredo : False
IsIPv4MappedToIPv6 : False
IPAddressToString : ::1
Address : xxxx724
AddressFamily : InterNetwork
ScopeId :
IsIPv6Multicast : False
IsIPv6LinkLocal : False
IsIPv6SiteLocal : False
IsIPv6Teredo : False
IsIPv4MappedToIPv6 : False
IPAddressToString : *.*.6.250
And with IPV6 disabled, I have error 2691
@sebastian-roth
Hello, thank you for your answer
Here is the result of this C# script:
// Main Method
using System;
using System.Collections.Generic;
using System.DirectoryServices.ActiveDirectory;
using System.Linq;
using System.Net;
using System.Runtime.InteropServices;
//using Zazzles;
class test
{
static public void Main(String[] args)
{
string idealDomain = "ur.local";
Console.WriteLine("Main Method");
var domain = Domain.GetComputerDomain();
Console.WriteLine(domain);
var currentIP = Dns.GetHostAddresses(domain.Name);
Console.WriteLine(currentIP);
var targetIP = Dns.GetHostAddresses(idealDomain);
Console.WriteLine(targetIP);
var result = currentIP.Intersect(targetIP).Any();
Console.WriteLine(result);
}
}
Exception levée : ‘System.Security.Authentication.AuthenticationException’ dans System.DirectoryServices.dll
Une exception non gérée du type ‘System.Security.Authentication.AuthenticationException’ s’est produite dans System.DirectoryServices.dll
User or password incorrect
Which user is used in the script ?
[admin07]: PS C:\Users\Administrateur\Documents> $o = [System.Net.Dns]::GetHostAddresses("admin07")
[admin07]: PS C:\Users\Administrateur\Documents> $o
Address :
AddressFamily : InterNetworkV6
ScopeId : 5
IsIPv6Multicast : False
IsIPv6LinkLocal : True
IsIPv6SiteLocal : False
IsIPv6Teredo : False
IsIPv4MappedToIPv6 : False
IPAddressToString : fe80::7164:xxxxxxxx:7d52%5
Address : xxxx724
AddressFamily : InterNetwork
ScopeId :
IsIPv6Multicast : False
IsIPv6LinkLocal : False
IsIPv6SiteLocal : False
IsIPv6Teredo : False
IsIPv4MappedToIPv6 : False
IPAddressToString : xxx.xx.6.250
@sebastian-roth
How could I create a small script in C to test this function ?
Have you a procedure ?
i used to use powershell
private bool IsJoinedToDomain(string idealDomain)
{
try
{
using (var domain = Domain.GetComputerDomain())
{
var currentIP = Dns.GetHostAddresses(domain.Name);
var targetIP = Dns.GetHostAddresses(idealDomain);
return (currentIP.Intersect(targetIP).Any());
}
}
catch (Exception)
{
}
return false;
}
@sebastian-roth
(Get-WmiObject Win32_ComputerSystem).Name
win10-3
(Get-WmiObject Win32_ComputerSystem).Domain
ur.local
How the client check the host is registred in the AD ?
What could I change to avert this DNS conflict ?
@sebastian-roth
No, the native windows domain of the university, but the dns (runninx over linux) is local to the tic department.
Hello
I have a problem with machines integrated into the ad.
The machine is well integrated into the AD. No connection hassles for users.
But the fog client gives me error 2691.
Same error in the eventslogs
Here are the sids for two machines deployed from the same image, they have a different sid.
Here are the fog client logs on the host:
23/11/2020 08:53:27 Main Overriding exception handling
23/11/2020 08:53:27 Main Bootstrapping Zazzles
23/11/2020 08:53:27 Controller Initialize
23/11/2020 08:53:27 Controller Start
23/11/2020 08:53:27 Service Starting service
23/11/2020 08:53:30 Bus Became bus server
23/11/2020 08:53:30 Bus Emmiting message on channel: Status
23/11/2020 08:53:30 Service Invoking early JIT compilation on needed binaries
------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:30 Client-Info Version: 0.11.19
23/11/2020 08:53:30 Client-Info OS: Windows
23/11/2020 08:53:30 Middleware::Authentication Waiting for authentication timeout to pass
23/11/2020 08:53:30 Middleware::Communication Download: https://fogus/fog/management/other/ssl/srvpublic.crt
23/11/2020 08:53:31 Data::RSA FOG Server CA cert found
23/11/2020 08:53:31 Middleware::Authentication Cert OK
23/11/2020 08:53:31 Middleware::Authentication No token found at C:\Program Files (x86)\FOG\token.dat, this is expected if the client has not authenticated before
23/11/2020 08:53:31 Middleware::Authentication ERROR: Could not get security token
23/11/2020 08:53:31 Middleware::Authentication ERROR: Le fichier 'C:\Program Files (x86)\FOG\token.dat' est introuvable.
23/11/2020 08:53:31 Middleware::Communication POST URL: https://fogus/fog/management/index.php?sub=requestClientInfo&authorize&newService
23/11/2020 08:53:31 Middleware::Response Success
23/11/2020 08:53:31 Middleware::Authentication Authenticated
23/11/2020 08:53:31 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 08:53:31 Middleware::Response Success
23/11/2020 08:53:31 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 08:53:31 Middleware::Response Success
23/11/2020 08:53:31 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 08:53:31 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 08:53:31 Service Creating user agent cache
23/11/2020 08:53:32 Middleware::Response Success
23/11/2020 08:53:32 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:53:32 Middleware::Response Success
23/11/2020 08:53:32 Service Initializing modules
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:34 Client-Info Client Version: 0.11.19
23/11/2020 08:53:34 Client-Info Client OS: Windows
23/11/2020 08:53:34 Client-Info Server Version: 1.5.8
23/11/2020 08:53:34 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:34 Client-Info Client Version: 0.11.19
23/11/2020 08:53:34 Client-Info Client OS: Windows
23/11/2020 08:53:34 Client-Info Server Version: 1.5.8
23/11/2020 08:53:34 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:34 Client-Info Client Version: 0.11.19
23/11/2020 08:53:34 Client-Info Client OS: Windows
23/11/2020 08:53:34 Client-Info Server Version: 1.5.8
23/11/2020 08:53:34 Middleware::Response Success
23/11/2020 08:53:34 HostnameChanger Checking Hostname
23/11/2020 08:53:34 HostnameChanger Renaming host to Win10-3-ad
23/11/2020 08:53:34 HostnameChanger Joining domain
23/11/2020 08:53:38 HostnameChanger Unknown Return Code: 1722
23/11/2020 08:53:39 Power Creating shutdown command in 60 seconds
23/11/2020 08:53:39 Bus Emmiting message on channel: Power
------------------------------------------------------------------------------
------------------------------------------------------------------------------
---------------------------------SnapinClient---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:39 Client-Info Client Version: 0.11.19
23/11/2020 08:53:39 Client-Info Client OS: Windows
23/11/2020 08:53:39 Client-Info Server Version: 1.5.8
23/11/2020 08:53:39 Middleware::Response Module is disabled on the host
23/11/2020 08:53:39 SnapinClient A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PrinterManager--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:39 Client-Info Client Version: 0.11.19
23/11/2020 08:53:39 Client-Info Client OS: Windows
23/11/2020 08:53:39 Client-Info Server Version: 1.5.8
23/11/2020 08:53:39 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:53:39 PrinterManager A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PowerManagement-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:39 Client-Info Client Version: 0.11.19
23/11/2020 08:53:39 Client-Info Client OS: Windows
23/11/2020 08:53:39 Client-Info Server Version: 1.5.8
23/11/2020 08:53:39 Middleware::Response Success
23/11/2020 08:53:39 PowerManagement Calculating tasks to unschedule
23/11/2020 08:53:39 PowerManagement Calculating tasks to schedule
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:53:39 Client-Info Client Version: 0.11.19
23/11/2020 08:53:39 Client-Info Client OS: Windows
23/11/2020 08:53:39 Client-Info Server Version: 1.5.8
23/11/2020 08:53:39 Middleware::Response Success
23/11/2020 08:53:39 Middleware::Communication URL: https://fogus/fog/service/usertracking.report.php?action=login&user=DESKTOP-IFL3FDT\defaultuser0&mac=52:54:00:CE:A1:DD&newService&json
------------------------------------------------------------------------------
23/11/2020 08:53:39 Service Sleeping for 68 seconds
23/11/2020 08:54:39 Power Creating shutdown request
23/11/2020 08:54:39 Power Parameters: /r /c "Universite Rennes 1 needs to rename your computer" /t 0
23/11/2020 08:54:39 Bus Emmiting message on channel: Power
23/11/2020 08:54:39 Power Attempt 1/6 to shutdown computer
23/11/2020 08:54:39 Power --> API call returned 1, will re-attempt in 5 minutes
23/11/2020 08:54:47 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 08:54:47 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 08:54:47 Service Creating user agent cache
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:54:47 Middleware::Response Success
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 TaskReboot A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 HostnameChanger A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
---------------------------------SnapinClient---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Module is disabled on the host
23/11/2020 08:54:47 SnapinClient A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PrinterManager--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:54:47 PrinterManager A power operation is pending, aborting module
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PowerManagement-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 PowerManagement Calculating tasks to unschedule
23/11/2020 08:54:47 PowerManagement Calculating tasks to schedule
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:54:47 Client-Info Client Version: 0.11.19
23/11/2020 08:54:47 Client-Info Client OS: Windows
23/11/2020 08:54:47 Client-Info Server Version: 1.5.8
23/11/2020 08:54:47 Middleware::Response Success
23/11/2020 08:54:47 Middleware::Communication URL: https://fogus/fog/service/usertracking.report.php?action=logout&user=DESKTOP-IFL3FDT\defaultuser0&mac=52:54:00:CE:A1:DD&newService&json
------------------------------------------------------------------------------
23/11/2020 08:54:48 Service Sleeping for 73 seconds
23/11/2020 08:55:30 Main Overriding exception handling
23/11/2020 08:55:31 Main Bootstrapping Zazzles
23/11/2020 08:55:31 Controller Initialize
23/11/2020 08:55:31 Controller Start
23/11/2020 08:55:31 Service Starting service
23/11/2020 08:55:40 Bus Became bus server
23/11/2020 08:55:40 Bus Emmiting message on channel: Status
23/11/2020 08:55:40 Service Invoking early JIT compilation on needed binaries
------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:40 Client-Info Version: 0.11.19
23/11/2020 08:55:40 Client-Info OS: Windows
23/11/2020 08:55:40 Middleware::Authentication Waiting for authentication timeout to pass
23/11/2020 08:55:40 Middleware::Communication Download: https://fogus/fog/management/other/ssl/srvpublic.crt
23/11/2020 08:55:41 Data::RSA FOG Server CA cert found
23/11/2020 08:55:41 Middleware::Authentication Cert OK
23/11/2020 08:55:41 Middleware::Communication POST URL: https://fogus/fog/management/index.php?sub=requestClientInfo&authorize&newService
23/11/2020 08:55:41 Middleware::Response Success
23/11/2020 08:55:41 Middleware::Authentication Authenticated
23/11/2020 08:55:41 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 08:55:41 Middleware::Response Success
23/11/2020 08:55:41 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 08:55:41 Middleware::Response Success
23/11/2020 08:55:41 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 08:55:41 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 08:55:41 Service Creating user agent cache
23/11/2020 08:55:41 Middleware::Response Success
23/11/2020 08:55:41 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:55:41 Middleware::Response Success
23/11/2020 08:55:41 Service Initializing modules
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:42 Client-Info Client Version: 0.11.19
23/11/2020 08:55:42 Client-Info Client OS: Windows
23/11/2020 08:55:42 Client-Info Server Version: 1.5.8
23/11/2020 08:55:42 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:42 Client-Info Client Version: 0.11.19
23/11/2020 08:55:42 Client-Info Client OS: Windows
23/11/2020 08:55:42 Client-Info Server Version: 1.5.8
23/11/2020 08:55:42 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:42 Client-Info Client Version: 0.11.19
23/11/2020 08:55:42 Client-Info Client OS: Windows
23/11/2020 08:55:42 Client-Info Server Version: 1.5.8
23/11/2020 08:55:42 Middleware::Response Success
23/11/2020 08:55:42 HostnameChanger Checking Hostname
23/11/2020 08:55:42 HostnameChanger Hostname is correct
23/11/2020 08:55:42 HostnameChanger Attempting to join domain
23/11/2020 08:55:46 HostnameChanger Unknown Return Code: 1722
------------------------------------------------------------------------------
------------------------------------------------------------------------------
---------------------------------SnapinClient---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:46 Client-Info Client Version: 0.11.19
23/11/2020 08:55:46 Client-Info Client OS: Windows
23/11/2020 08:55:46 Client-Info Server Version: 1.5.8
23/11/2020 08:55:46 Middleware::Response Module is disabled on the host
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PrinterManager--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:46 Client-Info Client Version: 0.11.19
23/11/2020 08:55:46 Client-Info Client OS: Windows
23/11/2020 08:55:46 Client-Info Server Version: 1.5.8
23/11/2020 08:55:46 Middleware::Response Module is disabled globally on the FOG server
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PowerManagement-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:46 Client-Info Client Version: 0.11.19
23/11/2020 08:55:46 Client-Info Client OS: Windows
23/11/2020 08:55:46 Client-Info Server Version: 1.5.8
23/11/2020 08:55:46 Middleware::Response Success
23/11/2020 08:55:46 PowerManagement Calculating tasks to unschedule
23/11/2020 08:55:46 PowerManagement Calculating tasks to schedule
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:55:46 Client-Info Client Version: 0.11.19
23/11/2020 08:55:46 Client-Info Client OS: Windows
23/11/2020 08:55:46 Client-Info Server Version: 1.5.8
23/11/2020 08:55:46 Middleware::Response Success
------------------------------------------------------------------------------
23/11/2020 08:55:46 Service Sleeping for 114 seconds
23/11/2020 08:57:40 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 08:57:40 Middleware::Response Success
23/11/2020 08:57:40 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 08:57:40 Middleware::Response Success
23/11/2020 08:57:40 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 08:57:40 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 08:57:40 Service Creating user agent cache
23/11/2020 08:57:40 Middleware::Response Success
23/11/2020 08:57:40 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:57:40 Middleware::Response Success
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:57:40 Client-Info Client Version: 0.11.19
23/11/2020 08:57:40 Client-Info Client OS: Windows
23/11/2020 08:57:40 Client-Info Server Version: 1.5.8
23/11/2020 08:57:40 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 08:57:40 Client-Info Client Version: 0.11.19
23/11/2020 08:57:40 Client-Info Client OS: Windows
23/11/2020 08:57:40 Client-Info Server Version: 1.5.8
23/11/2020 08:57:40 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:57:40 Client-Info Client Version: 0.11.19
23/11/2020 08:57:40 Client-Info Client OS: Windows
23/11/2020 08:57:40 Client-Info Server Version: 1.5.8
23/11/2020 08:57:40 Middleware::Response Success
23/11/2020 08:57:40 HostnameChanger Checking Hostname
23/11/2020 08:57:40 HostnameChanger Hostname is correct
23/11/2020 08:57:40 HostnameChanger Attempting to join domain
23/11/2020 08:57:44 HostnameChanger Success, code = 0
23/11/2020 08:57:44 Power Creating shutdown request
23/11/2020 08:57:44 Power Parameters: /r /c "Host joined to Active Directory, restart required" /t 0
23/11/2020 08:57:44 Bus Emmiting message on channel: Power
23/11/2020 08:57:44 Power Attempt 1/6 to shutdown computer
23/11/2020 08:57:44 Power --> API call returned 1, will re-attempt in 5 minutes
23/11/2020 08:58:41 Main Overriding exception handling
23/11/2020 08:58:42 Main Bootstrapping Zazzles
23/11/2020 08:58:42 Controller Initialize
23/11/2020 08:58:42 Controller Start
23/11/2020 08:58:42 Service Starting service
23/11/2020 08:58:49 Bus Became bus server
23/11/2020 08:58:49 Bus Emmiting message on channel: Status
23/11/2020 08:58:49 Service Invoking early JIT compilation on needed binaries
------------------------------------------------------------------------------
--------------------------------Authentication--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:49 Client-Info Version: 0.11.19
23/11/2020 08:58:49 Client-Info OS: Windows
23/11/2020 08:58:49 Middleware::Authentication Waiting for authentication timeout to pass
23/11/2020 08:58:49 Middleware::Communication Download: https://fogus/fog/management/other/ssl/srvpublic.crt
23/11/2020 08:58:50 Data::RSA FOG Server CA cert found
23/11/2020 08:58:50 Middleware::Authentication Cert OK
23/11/2020 08:58:50 Middleware::Communication POST URL: https://fogus/fog/management/index.php?sub=requestClientInfo&authorize&newService
23/11/2020 08:58:50 Middleware::Response Success
23/11/2020 08:58:50 Middleware::Authentication Authenticated
23/11/2020 08:58:50 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 08:58:50 Middleware::Response Success
23/11/2020 08:58:50 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 08:58:50 Middleware::Response Success
23/11/2020 08:58:50 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 08:58:50 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 08:58:50 Service Creating user agent cache
23/11/2020 08:58:50 Middleware::Response Success
23/11/2020 08:58:50 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 08:58:50 Middleware::Response Success
23/11/2020 08:58:50 Service Initializing modules
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Success
23/11/2020 08:58:51 HostnameChanger Checking Hostname
23/11/2020 08:58:51 HostnameChanger Hostname is correct
23/11/2020 08:58:51 HostnameChanger Attempting to join domain
23/11/2020 08:58:51 HostnameChanger The machine is already joined to the domain, code = 2691
------------------------------------------------------------------------------
------------------------------------------------------------------------------
---------------------------------SnapinClient---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Module is disabled on the host
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PrinterManager--------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Module is disabled globally on the FOG server
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------PowerManagement-------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Success
23/11/2020 08:58:51 PowerManagement Calculating tasks to unschedule
23/11/2020 08:58:51 PowerManagement Calculating tasks to schedule
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------UserTracker---------------------------------
------------------------------------------------------------------------------
23/11/2020 08:58:51 Client-Info Client Version: 0.11.19
23/11/2020 08:58:51 Client-Info Client OS: Windows
23/11/2020 08:58:51 Client-Info Server Version: 1.5.8
23/11/2020 08:58:51 Middleware::Response Success
------------------------------------------------------------------------------
23/11/2020 08:58:51 Service Sleeping for 118 seconds
23/11/2020 09:00:49 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&configure&newService&json
23/11/2020 09:00:49 Middleware::Response Success
23/11/2020 09:00:49 Middleware::Communication URL: https://fogus/fog/management/index.php?sub=requestClientInfo&mac=52:54:00:CE:A1:DD&newService&json
23/11/2020 09:00:49 Middleware::Response Success
23/11/2020 09:00:49 Middleware::Communication URL: https://fogus/fog/service/getversion.php?clientver&newService&json
23/11/2020 09:00:49 Middleware::Communication URL: https://fogus/fog/service/getversion.php?newService&json
23/11/2020 09:00:49 Service Creating user agent cache
23/11/2020 09:00:49 Middleware::Response Success
23/11/2020 09:00:49 Middleware::Response Module is disabled globally on the FOG server
23/11/2020 09:00:49 Middleware::Response Success
------------------------------------------------------------------------------
---------------------------------ClientUpdater--------------------------------
------------------------------------------------------------------------------
23/11/2020 09:00:49 Client-Info Client Version: 0.11.19
23/11/2020 09:00:49 Client-Info Client OS: Windows
23/11/2020 09:00:49 Client-Info Server Version: 1.5.8
23/11/2020 09:00:49 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
----------------------------------TaskReboot----------------------------------
------------------------------------------------------------------------------
23/11/2020 09:00:49 Client-Info Client Version: 0.11.19
23/11/2020 09:00:49 Client-Info Client OS: Windows
23/11/2020 09:00:49 Client-Info Server Version: 1.5.8
23/11/2020 09:00:49 Middleware::Response Success
------------------------------------------------------------------------------
------------------------------------------------------------------------------
--------------------------------HostnameChanger-------------------------------
------------------------------------------------------------------------------
23/11/2020 09:00:49 Client-Info Client Version: 0.11.19
23/11/2020 09:00:49 Client-Info Client OS: Windows
23/11/2020 09:00:49 Client-Info Server Version: 1.5.8
23/11/2020 09:00:49 Middleware::Response Success
23/11/2020 09:00:49 HostnameChanger Checking Hostname
23/11/2020 09:00:49 HostnameChanger Hostname is correct
23/11/2020 09:00:49 HostnameChanger Attempting to join domain
23/11/2020 09:00:50 HostnameChanger The machine is already joined to the domain, code = 2691
------------------------------------------------------------------------------
Hello
I manage public works rooms, until now my Windows machines were not in the domain.
With containment, I want to enable remote access to my machines, for this I have to put them in the domain.
The fog client does the job very well, so I’d like to keep this functionality.
The problem comes from sysprep, apparently incompatible with the client installed and activated.
I saw in the “Windows 10 Pro OEM Sysprep & Imaging” tutorial that you had to deactivate the client before launching sysprep.
How to activate the client once the oobe has been executed ?
Arnaud
@george1421 said in Windows 10 Pro OEM Sysprep & Imaging:
Hello
I don’t understand the articulation between sysprep and the activation / deactivation of the fog client.
I have a deployment procedure via MDT which installs Windows, creates my users with their password and installs the applications. And ends up installing the fog client.
I would like to do a sysprep. Do I just have to enable sysprep in MDT? Or do it by hand?
How do I get the fog client to activate automatically when or after the image is deployed?
@Tom-Elliott
Ok, thank you for you answer.
I drop the database and restore it from dump file, I get the same error.
Hello
I found several machine groups empty, with no image associated.
So i try to check mysql table and I get an error on the table ‘groups’.
mysql -u root -p -D fog -e "select * from groups"
Enter password:
ERROR 1064 (42000) at line 1: 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' at line 1
I check all the other tables, with no error.
mysqlcheck -u root -p fog --verbose --check
mysqlcheck -u root -p fog --verbose --analyze
mysqlcheck -u root -p fog --verbose --optimize
give me no error.
mysqldump -uroot -p --allow-keywords -x -v fog > fogbackup200619.sql
Enter password:
-- Connecting to localhost...
-- Retrieving table structure for table clientUpdates...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table dirCleaner...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table globalSettings...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table greenFog...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table groupMembers...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table groups...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table history...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table hookEvents...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table hostAutoLogOut...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table hostMAC...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table hostScreenSettings...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table hosts...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table imageGroupAssoc...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table imagePartitionTypes...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table imageTypes...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table images...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table imagingLog...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table inventory...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table ipxeTable...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table keySequence...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table moduleStatusByHost...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table modules...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table multicastSessions...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table multicastSessionsAssoc...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table nfsFailures...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table nfsGroupMembers...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table nfsGroups...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table notifyEvents...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table os...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table oui...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table plugins...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table powerManagement...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table printerAssoc...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table printers...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table pxeMenu...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table scheduledTasks...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table schemaVersion...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table snapinAssoc...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table snapinGroupAssoc...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table snapinJobs...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table snapinTasks...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table snapins...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table supportedOS...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table taskLog...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table taskStates...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table taskTypes...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table tasks...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table userCleanup...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table userTracking...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table users...
-- Sending SELECT query...
-- Retrieving rows...
-- Retrieving table structure for table virus...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...
the backup file obtenaied seems ok:
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `groups` (
`groupID` int(11) NOT NULL AUTO_INCREMENT,
`groupName` varchar(50) NOT NULL,
`groupDesc` longtext NOT NULL,
`groupDateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`groupCreateBy` varchar(50) NOT NULL,
`groupBuilding` int(11) NOT NULL,
`groupKernel` varchar(255) NOT NULL,
`groupKernelArgs` varchar(255) NOT NULL,
`groupPrimaryDisk` varchar(255) NOT NULL,
PRIMARY KEY (`groupID`),
UNIQUE KEY `groupName` (`groupName`),
UNIQUE KEY `groupName_2` (`groupName`),
KEY `new_index` (`groupName`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (1,'0-linux','Tous les postes Linux','2017-03-23 14:59:41','fog',0,'','',''),(2,'atelier','','2009-12-09 15:01:14','fog',0,'','',''),(3,'atelier-lin','Postes Linux','2017-03-20 18:41:01','fog',0,'','',''),(4,'b05-929','Bat 5 salle
929','2011-06-07 15:12:16','fog',0,'','',''),(5,'b06-002','','2012-06-05 21:15:27','fog',0,'','',''),(6,'b06-008','','2012-06-05 21:03:55','fog',0,'','',''),(7,'b06-013','','2019-09-03 18:28:15','fog',0,'','',''),(8,'b06-013-1','','2012-06-05 15:51:56','fog',
0,'','',''),(9,'b06-013-2','','2012-06-05 20:29:32','fog',0,'','',''),(10,'b06-016','','2012-06-05 21:22:58','fog',0,'','',''),(11,'b06-019','','2014-07-08 15:32:00','fog',0,'','',''),(12,'b06-019-1','','2012-06-05 21:03:30','fog',0,'','',''),(13,'b06-019-2',
'','2011-06-07 15:10:23','fog',0,'','',''),(14,'b06-937','','2011-06-07 15:11:49','fog',0,'','',''),(15,'b06-938','','2014-01-10 14:42:47','fog',0,'','',''),(16,'b06-HP5800','','2014-07-07 20:06:44','fog',0,'','',''),(17,'b06-SansImages','','2012-06-05 21:31:
21','fog',0,'','',''),(18,'b41','','2018-08-29 12:51:23','fog',0,'','',''),(19,'b41-101','','2011-06-06 16:20:05','fog',0,'','',''),(20,'b41-104','Dell 7440 ESIR','2012-07-12 17:29:08','fog',0,'','',''),(21,'b41-conf','','2018-06-07 21:08:26','fog',0,'','',''
),(22,'b41-pr','','2011-10-04 21:36:34','fog',0,'','',''),(23,'batO-windows','','2019-02-06 17:05:14','fog',0,'','',''),(24,'conf','','2017-03-28 21:02:42','fog',0,'','',''),(25,'conf_autres','','2010-05-11 13:04:03','fog',0,'','',''),(26,'conf_i05','','2017-
08-29 20:19:44','fog',0,'','',''),(27,'d020','','2010-04-26 13:31:43','fog',0,'','',''),(28,'d022','','2010-04-26 13:32:13','fog',0,'','',''),(29,'d024','','2010-04-26 13:32:37','fog',0,'','',''),(30,'d026','','2010-04-26 13:33:01','fog',0,'','',''),(31,'d028
','','2010-04-26 13:33:23','fog',0,'','',''),(32,'d122','','2010-04-26 13:33:47','fog',0,'','',''),(33,'deployb06','','2017-05-04 14:10:44','fog',0,'','',''),(34,'deployb06-bis','','2017-05-04 19:24:23','fog',0,'','',''),(35,'e003','','2010-04-22 18:38:46','f
og',0,'','',''),(36,'e005','','2010-02-22 14:55:42','fog',0,'','',''),(37,'e007','','2010-04-22 19:38:59','fog',0,'','',''),(38,'e008','','2010-04-22 19:39:22','fog',0,'','',''),(39,'e010','','2010-04-21 18:06:43','fog',0,'','',''),(40,'e103','','2010-04-22 1
9:42:24','fog',0,'','',''),(41,'e105','','2010-04-22 19:42:43','fog',0,'','',''),(42,'e107','','2010-04-22 19:43:04','fog',0,'','',''),(43,'e206','','2010-04-22 19:43:25','fog',0,'','',''),(44,'e212','','2010-04-22 19:43:54','fog',0,'','',''),(45,'e214','','2
010-04-22 19:44:12','fog',0,'','',''),(46,'esir','salles TP b41-101 b41-102 b41-103 b41-104','2017-08-21 15:19:15','fog',0,'','',''),(47,'i054','','2010-04-01 14:02:09','fog',0,'','',''),(48,'i055','','2017-09-01 18:14:10','fog',0,'','',''),(49,'i203','','201
0-05-04 14:51:49','fog',0,'','',''),(50,'i204','','2018-01-17 14:26:01','fog',0,'','',''),(51,'i206','','2014-07-07 21:14:52','fog',0,'','',''),(52,'i207','','2011-06-16 19:11:42','fog',0,'','',''),(53,'i207clients','','2011-07-06 20:31:58','fog',0,'','',''),
(54,'i207serveurs','','2011-07-06 20:31:20','fog',0,'','',''),(55,'i214','','2010-05-20 19:56:52','fog',0,'','',''),(56,'miage','','2015-04-28 19:39:20','fog',0,'','',''),(57,'parc_peda_windows','ensemble des machines peda sous windows','2017-03-30 15:33:00',
'fog',0,'','',''),(58,'sec-esir','','2019-04-12 15:32:34','fog',0,'','',''),(59,'secretaires','','2014-04-22 16:20:31','fog',0,'','',''),(61,'temporaire','','2017-04-28 18:25:08','fog',0,'','',''),(62,'b06','','2019-11-26 13:03:18','fog',0,'','',''),(63,'Exti
nction-Week-end','E107, E212, E214, I54, I55 B41-104, B41-101 pour extinction','2020-01-17 14:07:59','fog',0,'','','');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
Could you advise on what to do ?