Posts made by lebrun78

lebrun78

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 ?

lebrun78

Thank you for your answer.
Your document is complete.

lebrun78

Hello,
I have a kernel panic problem when I try to install linux OS using ipxe in UEFI mode.
I have not problem to install using ipxe boot in legacy mode or to point my MDT server.

Should I have differents entries for UEFI ?
Which parameter should I modify ?

Here is my Advanced Menu settings

:MENU
menu
item --gap -- ---------------- iPXE boot menu ----------------
item Centos7 Install mini Centos7
item Centos8 Installation Centos8
item Ubuntu20 Installation Ubuntu20
item WIN10MDT1903 Boot MDT-Win10-1903
item shell ipxe shell
item return return to previous menu
choose --default WIN10MDT1903 --timeout 10000 target && goto ${target}
:Centos7
kernel https://192.168.122.2/linuxboot/vmlinuz-CentOS7 ks=https://mdt.istic.univ-rennes1.fr/Centos7/anaconda-ks.cfg
initrd https://192.168.122.2/linuxboot/initrd.img-CentOS7
boot
:Centos8
kernel https://192.168.122.2/linuxboot/vmlinuz-CentOS8 ks=https://mdt.istic.univ-rennes1.fr/Centos8/anaconda-ks.cfg
initrd https://192.168.122.2/linuxboot/initrd.img-CentOS8
boot
:Ubuntu20
kernel https://192.168.122.2/linuxboot/linux-Ub20 ks=https://mdt.istic.univ-rennes1.fr/Ubuntu20/anaconda-ub20-ks.cfg
initrd https://192.168.122.2/linuxboot/initrd-Ub20.gz
boot
:WIN10MDT1903
cpuid --ext 29 && set arch x64 || set arch x86
kernel http://${next-server}/wimboot
initrd http://${next-server}/mdtboot/${arch}/media/Boot/BCD BCD
initrd http://${next-server}/mdtboot/${arch}/media/Boot/boot.sdi boot.sdi
initrd -n boot.wim http://${next-server}/mdtboot/${arch}/LiteTouchPE_1903.wim boot.wim
boot
:shell
shell ||
goto MENU

Here is the error trying to install Ubuntu 2004:
text alternatif
Here is the error trying to install Centos:

Thank you for your help.

lebrun78

Hello
On my testing server, centos8 up to date, fog 1.5.9-RC2,
I try to use local certificates.
I placed my certificates in /etc/httpd/cert path.
I first tried to install with the private key using this command:

sslprivkey='/etc/httpd/cert/star.istic.univ-rennes1.fr.key' ./installfog.sh -y

No success

I have reinstall forcing certificates generation ```
./installfog.sh -C -K

I modified /etc/httpd/conf.d/fog.conf with:
```    #SSLCertificateFile /var/www/html/fog/management/other/ssl/srvpublic.crt
    #SSLCertificateKeyFile /opt/fog/snapins/ssl//.srvprivate.key
    #SSLCACertificateFile /var/www/html/fog//management/other/ca.cert.pem
    SSLCertificateKeyFile /etc/httpd/cert/star.istic.univ-rennes1.fr.key
    SSLCertificateFile /etc/httpd/cert/star_istic_univ-rennes1_fr.crt
    SSLCertificateChainFile /etc/httpd/cert/DigiCertCA.crt

Web console works fine, no more certificat warnings.
But I have problem on pxe boot.

I get
“https://148.60.4.2/fog/service/ipxe/boot.php… No such file or directory (http://ipxe.org/2d0c613b)”

I tried to generate a new ipxe configuration
cd /opt/fogproject-1.5.9-RC2/utils/FOGiPXE/
./buildipxe.sh
But iI don’t understand where the configuration obtained is put ?

Any help would be greatly appreciated.

lebrun78

@Sebastian-Roth
Yes class and host are now declarated in groups, not in subnets.
So now, I declare all subnets first and after all groups.
Here is my new dhcpd.conf file:

# dhcpd.conf  
#
ddns-update-style standard;
authoritative;

#log-facility local7;
set vendor-string = option vendor-class-identifier;
log (info, option vendor-class-identifier);


##############################################
# rajoute pour les telephones IP IFSIC/ISTIC
# C'est pour pouvoir utiliser le prise LAN
# derriere le telephone dans l'un des reseau ESIR/ISTIC
##################################################
option space Tel-Sip;
option Tel-Sip.cfg-server-address code 2 = text;
option Tel-Sip.contact-rcs code 3 = boolean;

class "telephones-ip" {
	# voir man dhcp-eval
	match if substring(hardware,1,3) = 00:08:5d;
	option server.min-lease-time 40;
        option ntp-servers 129.20.251.1;
        #option tftp-server-name "129.20.131.108";
	option server.vendor-option-space Tel-Sip;
      	option server.boot-unknown-clients true;
      	option Tel-Sip.contact-rcs true;
      	option Tel-Sip.cfg-server-address "ftp://connexio994:xa3SGXZE74@10.21.7.8";
}

# sacker un peu les smartphones ...
class "android" {
  match if substring(option host-name,0,7) = "android";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "iPhone" {
  match if substring(option host-name,0,6) = "iPhone";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "iPad" {
  match if substring(option host-name,0,4) = "iPad";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "Windows-Phone" {
  match if substring(option host-name,0,13) = "Windows-Phone";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "Galaxy" {
  match if substring(option host-name,0,6) = "Galaxy";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "HUAWEI" {
  match if substring(option host-name,0,6) = "HUAWEI";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "Samsung" {
  match if substring(option host-name,0,7) = "Samsung";
  default-lease-time 900 ;
  max-lease-time 900 ;
}
class "Honor" {
  match if substring(option host-name,0,5) = "Honor";
  default-lease-time 900 ;
  max-lease-time 900 ;
}


#
# machines recevant une IP dynamique dans le vlan2 (lan-free).
#

include "/etc/dhcp/vip.conf";

subnet 145.55.0.0 netmask 255.255.248.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.7.254 ;
option subnet-mask 255.255.248.0 ;
default-lease-time 86400 ;
max-lease-time 172800 ;

pool {
                allow members of "vip";
                range 145.55.7.200 145.55.7.230;
}




	####################################################
        # pool d'adresse dynamique reserve aux telephones IP
	# masque de 255.255.255.240 pour le firewall
        pool {
                allow members of "telephones-ip";
                range 145.55.0.224 145.55.0.239;
        }
}


#subnet 145.55.8.0 netmask 255.255.255.0 {
##########################################                                                
#option domain-name-servers 145.55.15.109,145.55.15.106 ;
#option domain-name "monuniversite1.fr" ;
#option routers 145.55.8.254 ;
#option subnet-mask 255.255.255.0 ;
#default-lease-time 6000 ;
#max-lease-time 12000 ;
#group {
#}
#}

subnet 145.55.10.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.10.254 ;
option subnet-mask 255.255.255.0 ;
default-lease-time 600 ;
max-lease-time 1200 ;



	pool {
		deny members of "telephones-ip";
		range 145.55.10.180 145.55.10.220;
		next-server 145.55.4.1;
        	#filename "pxelinux.0";
	}

	####################################################
	# pool d'adresse dynamique reserve aux telephones IP
	# testsip
	pool {
		allow members of "telephones-ip";
		range 145.55.10.224 145.55.10.239; #avec un masque de 255.255.255.240 pour erebus
	}
}

subnet 145.55.11.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.11.254 ;
option subnet-mask 255.255.255.0 ;
default-lease-time 86400 ;
max-lease-time 172800 ;
range 145.55.11.1 145.55.11.9 ;


}

subnet 145.55.12.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.12.254 ;
option subnet-mask 255.255.255.0 ;
default-lease-time 86400 ;
max-lease-time 172800 ;
#

range 145.55.12.101 145.55.12.140 ;
#range 145.55.12.100 145.55.12.199 ;
}

subnet 145.55.13.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.13.254 ;
option subnet-mask 255.255.255.0 ;
option ntp-servers 129.20.128.22;
default-lease-time 3600 ;
max-lease-time 3600 ;
adaptive-lease-time-threshold 80;
min-lease-time 900;
range 145.55.13.1 145.55.13.247 ;
}

subnet 145.55.14.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.14.254 ;
option subnet-mask 255.255.255.0 ;
option ntp-servers 129.20.128.22;
default-lease-time 3600 ;
max-lease-time 3600 ;
adaptive-lease-time-threshold 80;
min-lease-time 900;
range 145.55.14.16 145.55.14.253 ;
}

subnet 145.55.15.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 145.55.15.254 ;
option subnet-mask 255.255.255.0 ;
default-lease-time 2592000 ;
max-lease-time 5184000 ;
}

subnet 129.20.15.0 netmask 255.255.255.0 {
##########################################
option domain-name-servers 145.55.15.109,145.55.15.106 ;
option domain-name "monuniversite1.fr" ;
option routers 129.20.15.254 ;
option subnet-mask 255.255.255.0 ;
default-lease-time 2592000 ;
max-lease-time 172800 ;
#

	####################################################
	# pool d'adresse dynamique reserve aux telephones IP
	# testsip
	pool {
		allow members of "telephones-ip";
		range 129.20.15.224 129.20.15.239; #avec un masque de 255.255.255.240 pour erebus
	}
}

group { #######################################VLAN2 > FOG ########################################
	next-server 145.55.4.1;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }

host admin01 { hardware ethernet 74:e6:e2:d9:dd:cf; fixed-address admin01; option Host-name "admin01";} # 
host admin02 { hardware ethernet b8:85:84:ac:89:fa; fixed-address admin02; option Host-name "admin02";} # proto windows salles istic
..........................................................................
host imp-b42-001 { hardware ethernet 78:e3:b5:fb:31:da; fixed-address imp-b42-001; option Host-name "imp-b42-001";}
host imp-b42-002 { hardware ethernet 10:1F:74:47:1E:4E; fixed-address imp-b42-002; option Host-name "imp-b42-002";}
# Gateway LORA F.Bodin le 11/12/2019


##module niusrp
host niusrp6 { hardware ethernet 00:80:2f:17:b4:e3; fixed-address niusrp6; option Host-name "niusrp6";}

### Salle machines virtuelles
#

host virt01m01 { hardware ethernet aa:bb:aa:bb:aa:aa; fixed-address virt01m01; option Host-name "virt01m01";}
host virt01m02 { hardware ethernet aa:bb:aa:bb:aa:ab; fixed-address virt01m02; option Host-name "virt01m02";}

host w10 { hardware ethernet 9c:8e:99:f5:1a:a9; fixed-address w10; option Host-name "w10";}

# marque debut pour dhcp-vm vlan 2, pas touche SVP.

# marque fin pour dhcp-vm vlan 2, pas touche SVP.

}

group {  #######################################VLAN2 > COSINUS ########################################
# Groupe pointant vers le pxe du Fog de test                                                                                                                                    
  	option domain-name-servers 145.55.15.109,145.55.15.106;
        next-server 145.55.4.2;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }
#
#Machine test cosinus

#host centos7-6 { hardware ethernet 52:54:00:b3:30:b5; fixed-address centos7-6; option Host-name "centos7-6";} # VM sur admin11
..................................................................................................................
#host b06-013m01 { hardware ethernet 9c:8e:99:f5:69:2a; fixed-address b06-013m01; option Host-name "b06-013m01";}



}


group {  ###################################### VLAN2 IMPRIMANTES ########################################
host imp-2a-020 { hardware ethernet 00:11:85:FA:28:9A; fixed-address imp-2a-020; option Host-name "imp-2a-020";} # 
h
host d262m03 { hardware ethernet 00:11:43:2C:11:8D; fixed-address d262m03; option Host-name "d262m03";} # gx280 carte acquisition
host e114m01 { hardware ethernet 00:13:72:0D:55:B7; fixed-address e114m01; option Host-name "e114m01";} # F Lamarche
#host imp-b05-001 { hardware ethernet 00:1f:29:1f:23:c9; fixed-address imp-b05-001; option Host-name "imp-b05-001";} 

}
group {  #######################################VLAN2 COMMUT ########################################
#
# groupe  : commut
#
host c12eb { hardware ethernet ; fixed-address c12eb; option Host-name "c12eb";} # 
host c12ea { hardware ethernet ; fixed-address c12ea; option Host-name "c12ea";} # 
host c12ee { hardware ethernet ; fixed-address c12ee; option Host-name "c12ee";} # 
host c2ba { hardware ethernet ; fixed-address c2ba; option Host-name "c2ba";} # 
.................................................................................
host c12dt { hardware ethernet ; fixed-address c12dt; option Host-name "c12dt";} # 
host c12du { hardware ethernet ; fixed-address c12du; option Host-name "c12du";} # 
}


group { ####################################################VLAN10################################################
# On commente les deux lignes suivantes pour eviter le menu de Fog
 	next-server 145.55.4.1;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }

host arrakis { hardware ethernet 00:23:AE:6A:83:FA; fixed-address arrakis; option Host-name "arrakis";} # Gx360 Gentoo AD
host admin11 { hardware ethernet 9c:8e:99:f5:68:ca; fixed-address admin11; option Host-name "admin11";} #linux test 8300 AD
......................................................................................................................
#host miage-dell6 { hardware ethernet 10:65:30:83:5c:4b; fixed-address miage-dell6; option Host-name "miage-dell6";} #   
# marque debut pour dhcp-vm vlan 10, pas touche SVP.
host winrm10 {hardware ethernet 00:11:E2:61:00:03; fixed-address winrm10; option Host-name "winrm10";}     # Ajout par dhcp-vm le 22/08/2016 (11:32:32)
# marque fin pour dhcp-vm vlan 10, pas touche SVP.

}

group { ####################################################VLAN11################################################
# marque debut pour dhcp-vm vlan 11, pas touche SVP.
host pret13 {hardware ethernet 00:11:E7:61:00:10; fixed-address pret13; option Host-name "pret13";}     # Ajout par dhcp-vm le 24/5/2013 (11:21:05)
...........................................................................................................
host palme02 { hardware ethernet 00:23:ae:74:66:85; fixed-address palme02; option Host-name "palme02";} # poste asso Palme d193 Maxime Lambert 12006967
}


group { ##########################################VLAN12#######################################
	next-server 145.55.4.1;

class "Legacy" {
      match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }
#
### Salle_i204
#
host i204m01 { hardware ethernet 14:b3:1f:19:81:02; fixed-address i204m01; option Host-name "i204m01";}
.........................................................................................................
host i204m10 { hardware ethernet 14:b3:1f:19:80:20; fixed-address i204m10; option Host-name "i204m10";}

### Salle_i206
#
host i206m01 { hardware ethernet b8:85:84:b9:68:49; fixed-address i206m01; option Host-name "i206m01";}
...........................................................................................................
host i206m10 { hardware ethernet b8:85:84:b9:5e:9f; fixed-address i206m10; option Host-name "i206m10";}
#

### Salle_i207
#
host i207m01 { hardware ethernet 78:ac:c0:b1:aa:f6; fixed-address i207m01; option Host-name "i207m01";} # 
............................................................................................................
host i207m22 { hardware ethernet 00:11:43:14:42:11; fixed-address i207m22; option Host-name "i207m22";} #

}
group {
host psyche { hardware ethernet 00:13:72:08:e1:93; fixed-address psyche; option Host-name "psyche";} # 
# host psyche { hardware ethernet 00:13:72:0D:70:D8; fixed-address psyche; option Host-name "psyche";} # 
host anubis { hardware ethernet 00:14:22:75:AF:18; fixed-address anubis; option Host-name "anubis";} # 
}


group { ##############################################VLAN15################################################
#
        next-server 145.55.4.1;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }

#
host wifsic1 { hardware ethernet 00:42:68:44:79:18; fixed-address wifsic1; option Host-name "wifsic1";} #
h....................................................................................................
host satus {hardware ethernet 78:2B:CB:6D:38:C3; fixed-address satus; option Host-name "satus";} 
}


group { ######################################## VLAN3 Personnels ############################
# On commente les deux lignes suivantes pour eviter le menu de Fog 
 	next-server 145.55.4.1;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
	filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }
                                                                                                                                                                               #
host ad-istic1 { hardware ethernet 00:15:5d:0f:fb:00; fixed-address ad-istic1; option Host-name "ad-istic1";}
.....................................................................................................
host b06-014m01 { hardware ethernet 8c:04:ba:5d:81:cc; fixed-address b06-014m01; option Host-name "b06-014m01";} # portable Samuel Crand 2019-06
host bug { hardware ethernet 9c:8e:99:f5:9c:2e; fixed-address bug; option Host-name "bug";} # HP 8300 
}
group {  ######################################## VLAN3 Personnels > COSINUS############################
# boot cosinus pour 129.20.15
    next-server 145.55.4.2;

class "Legacy" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000";
        filename "undionly.kkpxe";
    }
    class "UEFI-32-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-32-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006";
        filename "i386-efi/ipxe.efi";
    }
    class "UEFI-64-1" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00007";
        filename "ipxe.efi";
    }
    class "UEFI-64-2" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00008";
        filename "ipxe.efi";
    }
    class "UEFI-64-3" {
        match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00009";
        filename "ipxe.efi";
    }
#host d000m02 { hardware ethernet c8:1f:66:aa:26:b2; fixed-address d000m02; option Host-name "d000m02";}
#host b42-015m01new {hardware ethernet b8:85:84:b5:ea:9c; fixed-address b42-015m01new;option Host-name "b42-015m01new";}

}

lebrun78

@george1421

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

lebrun78

I found the solution of the problem
After a post on dhcp-users-request@lists.isc.org, Niall O’Reilly proposed to declare hosts out of the subnet.
And effectivly , now, hosts are declared in group but not in the subnet and it works .

Thank you very much for your help, Sebastian and George.

lebrun78

@Sebastian-Roth
Thank you very much for your work !

lebrun78

@george1421
So here is a capture with 2 request, on pxe at time 0 and at time 196 a usb boot ubuntu.
When ubuntu loaded, ip a give good IP adress, good router and good netwask
capturedhcp.pcap

lebrun78

@Sebastian-Roth
Hello
I have blanked the lease file. At the reboot of the client, same problem.
Here is the actual lease file:

cat dhcpd.leases
# The format of this file is documented in the dhcpd.leases(5) manual page.
# This lease file was written by isc-dhcp-4.2.5

server-duid "\000\001\000\001&\036\337\215P\232L\202P~";

lease 148.60.10.180 {
  starts 2 2020/04/07 06:53:04;
  ends 3 2020/04/08 06:53:04;
  cltt 2 2020/04/07 06:53:04;
  binding state active;
  next binding state free;
  rewind binding state free;
  hardware ethernet 10:65:30:83:5c:4b;
  set vendor-string = "PXEClient:Arch:00007:UNDI:003016";

lebrun78

@george1421
I have just done the search of extra curly brace with notepadd++, I didn’t see the problem.

The file in first post is an extract, you can view the production file here:
https://filesender.renater.fr/?s=download&token=11cc357f-4663-41c8-830b-71938d2d2aa7

lebrun78

@george1421
Hello Geoge
this morning I made a test by reversing the places of the declarations of the subnet.
In fact the client recovers the mask and router of the first declared subnet…

lebrun78

I have made 2 boot on the windows machine, UEFi pxe boot and hard drive boot.
I get this logs in my dhcp server:

Apr  6 09:46:02 sybille2 dhcpd: PXEClient:Arch:00007:UNDI:003016
Apr  6 09:46:02 sybille2 dhcpd: DHCPDISCOVER from 10:65:30:83:5c:4b via em2.10
Apr  6 09:46:03 sybille2 dhcpd: DHCPOFFER on 148.60.10.198 to 10:65:30:83:5c:4b via em2.10
Apr  6 09:46:05 sybille2 dhcpd: PXEClient:Arch:00007:UNDI:003016
Apr  6 09:46:05 sybille2 dhcpd: DHCPREQUEST for 148.60.10.198 (148.60.10.252) from 10:65:30:83:5c:4b via em2.10
Apr  6 09:46:05 sybille2 dhcpd: DHCPACK on 148.60.10.198 to 10:65:30:83:5c:4b via em2.10
Apr  6 09:46:41 sybille2 dhcpd: MSFT 5.0
Apr  6 09:46:41 sybille2 dhcpd: DHCPDISCOVER from 10:65:30:83:5c:4b via em2.10
Apr  6 09:46:42 sybille2 dhcpd: DHCPOFFER on 148.60.10.190 to 10:65:30:83:5c:4b (MININT-S9D1BSU) via em2.10
Apr  6 09:46:42 sybille2 dhcpd: MSFT 5.0
Apr  6 09:46:42 sybille2 dhcpd: DHCPREQUEST for 148.60.10.190 (148.60.10.252) from 10:65:30:83:5c:4b (MININT-S9D1BSU) via em2.10
Apr  6 09:46:42 sybille2 dhcpd: DHCPACK on 148.60.10.190 to 10:65:30:83:5c:4b (MININT-S9D1BSU) via em2.10
Apr  6 09:46:42 sybille2 dhcpd: Unable to add forward map from MININT-S9D1BSU.istic.univ-rennes1.fr to 148.60.10.190: not found

The same machine gets to differents IP, 148.60.10.190 and 148.60.10.198 at 09:46:03 (pxe booot) and at 09:46:40

lebrun78

@george1421

So I’ll ask you the same question again in a different way. Is dhcp server 148.60.10.252 and 148.60.4.3 the same computer?
YES
I have only one dhcpd.conf file, sone only one instance of dhcp

Here is what I get on the same machine on vlan 148.60.10.0/24 when windows is loaded:

It’s crazy, no ?

lebrun78

@george1421

Yes, we don’t have dhcp relay, the dhcp server have several virtual network interface, one on each vlan.

lebrun78

@george1421
I’m the infrastructure manager, the dhcpd.conf is the one in the first post …

lebrun78

@Sebastian-Roth
Yes ipconfig is good.

lebrun78

@george1421
“At this time the problem is infrastructure related and not FOG.” I agree.
I don’t understand the boot dhcp response on vlan 10.
The ip configuration is good when loaded !

lebrun78

@george1421
Here is the capture from fog server, client in uefi mode
uefi.pcap