@Tom-Elliott
Ok, thank you for you answer.
L
Posts made by lebrun78
-
RE: Mysql groups table corrupted, other table problems ?posted in FOG Problems
-
RE: Mysql groups table corrupted, other table problems ?posted in FOG Problems
I drop the database and restore it from dump file, I get the same error.
-
Mysql groups table corrupted, other table problems ?posted in FOG Problems
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 1I 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 --optimizegive 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 ?
-
RE: PXE boot to install linux OS in UEFIposted in Linux Problems
Thank you for your answer.
Your document is complete. -
PXE boot to install linux OS in UEFIposted in Linux Problems
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 MENUHere is the error trying to install Ubuntu 2004:
Here is the error trying to install Centos:
Thank you for your help.
-
https, with home certificates and boot.php… No such file or directory (http://ipxe.org/2d0c613b)posted in FOG Problems
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 -yNo success
I have reinstall forcing certificates generation ```
./installfog.sh -C -KI 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.crtWeb 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.
-
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@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";} } -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
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.
-
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@Sebastian-Roth
Thank you very much for your work ! -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@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 -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@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"; -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@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 -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@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… -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
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 foundThe 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
-
RE: UEFI pxe boot problem from a networkposted in Windows Problems
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 dhcpHere is what I get on the same machine on vlan 148.60.10.0/24 when windows is loaded:
It’s crazy, no ?
-
RE: UEFI pxe boot problem from a networkposted in Windows Problems
Yes, we don’t have dhcp relay, the dhcp server have several virtual network interface, one on each vlan.
-
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@george1421
I’m the infrastructure manager, the dhcpd.conf is the one in the first post … -
RE: UEFI pxe boot problem from a networkposted in Windows Problems
@Sebastian-Roth
Yes ipconfig is good.