@Mike-Fahey Which mysql command do you use to connect to the database?

The installer uses the following command to login and check if it was successful:

mysql --host=localhost --user=root --password="yoursecurepassword" --execute="quit" [[ $? -ne 0 ]] && echo "Connection failed" || echo "Connection succeeded"

@sebastian-roth Thanks to your suggestions I took a deeper look at the host server I was provided for this project, and there was a lot of driver packages missing. Once I installed those drivers, everything loads at a good speed now.

In the end it was my mistake not looking over the host server my colleague prepared for me, but I learned a lot more about FOG in the process so it wasn’t all time wasted.

I appreciate the help though, sorry if I confused you there

@sebastian-roth No problem i can create separate images for same sized disk but first milestone is to make sure it is possible. I will give it a try and share here.

@george1421 said in Dell Optiplex 3080 - UEFI - PXE Boot E-21: Remote boot cancelled.:

Side note: If your network doesn’t have a dhcp server I would personally use isc-dhcp server on your fog server over dnsmasq. I would use dnsmasq if you have a dhcp server run by someone else and can’t update settings. In this case dnsmasq would supplement your unchangeable dhcp server.

THANK YOU!

I set up isc-dhcp and it’s working like a charm.

For any future people reading:
I modified /etc/dhcp/dhcp.conf with the below config.
I disabled dnsmasq. systemctl stop dnsmasq.service
I started isc-dhcp service dhcpd start
I tsuccessfully PXE booted with my Dell 3080 a few times.
I permanently disabled dnsmasq. systemctl disable dnsmasq
I set isc-dhcp to start automatically. systemctl enable dhcpd

option space PXE; option PXE.mtftp-ip code 1 = ip-address; option PXE.mtftp-cport code 2 = unsigned integer 16; option PXE.mtftp-sport code 3 = unsigned integer 16; option PXE.mtftp-tmout code 4 = unsigned integer 8; option PXE.mtftp-delay code 5 = unsigned integer 8; option arch code 93 = unsigned integer 16; # RFC4578 use-host-decl-names on; ddns-update-style interim; ignore client-updates; next-server 192.x.x.7; authoritative; subnet 192.x.x.0 netmask 255.255.255.0 { option subnet-mask 255.255.255.0; range dynamic-bootp 192.x.x.200 192.x.x.254; default-lease-time 21600; max-lease-time 43200; option domain-name-servers 192.x.x.7; option routers 192.x.x.7; class "UEFI-32-1" { match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00006"; filename "i386-efi/ipxe.efi"; } class "UEFI-32-2" { match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00002"; 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"; } class "Legacy" { match if substring(option vendor-class-identifier, 0, 20) = "PXEClient:Arch:00000"; filename "undionly.kkpxe"; } }

@mmethe Not sure what’s wrong but you might try setting the ownership: chown fog:root /images/dev/postinitscripts/fog.postinit (note: the user fog exists in older versions only. After the update to 1.5.9 it will be called fogproject)

@mapaga said in Windows 7 Deployment Error:

Just for curiosity, why is it important to caputre all partitions?.

Because only with all partitions it will also capture and deploy the partition table. If you set this to a single partition, it will only capture/deploy this partition and won’t touch the partition layout. This is ok if you have the correct layout on the destination system already but will fail otherwise.

@cammykool said in Unable to restore GPT partition tables on one image:

this is the stuff that broke after that init move.

That has nothing to do with the init change. The version information in the FOG web UI is pulled from the fogproject.org server and I would guess either there was a connection issue or your network admin restricted access to this URL.

@tom-elliott I tested on another computer and its working.

on this particular pc its not working. I will try and uninstall fog client from the pc and reinstall it again and will see if it works.

IF it still doesnt work will try to remove from fog server and re add

@sebastian-roth Thank you ! That does it perfectly. I didn’t know that command. Have a good day !

@george1421 I ended up looking for FOG 1.4.4 kernel update issues and found the permissions missing issue and followed what the guy did there. I’m not getting an error anymore.

@fargat There is far too little information to accurately assist you.

Here’s the details we have, so far:
You have FOG Server running on Ubuntu 20.04.
You have Sophos Firewall as DHCP server.
You have tried DNSmasq but it did not work.
You have tried FOG using a Lenovo laptop.
Based on the picture, the laptop is attempting to boot using UEFI stack.

That’s all we have.

We would need:
What version of FOG are you running?
What configuration did you use for DNSmasq?
What DHCP options 66/67 are defined on your Sophos Firewall DHCP Server?
What model of Lenovo laptop are you using? (There are many different models.)
Have you disabled Secure Boot?

There’s most likely going to be many more questions, but a picture and “Firewall is …” doesn’t really help us. Neither are any of the follow up responses you’ve given.

Here’s some resources:
https://wiki.fogproject.org/wiki/index.php?title=BIOS_and_UEFI_Co-Existence
https://wiki.fogproject.org/wiki/index.php?title=ProxyDHCP_with_dnsmasq

As @EduardoTSeoane has told you, based on the picture your machine is using UEFI stack for booting, but it’s calling the legacy boot file (undionly.kpxe should be ipxe.efi).

Hi

what is solution of the problem

@yeet said in Error trying to restore GPT Partition tables (restorepartitionTablesAndBootLoaders) on different sized drives:

Is this due to the drive being 6gb smaller than the one the image was built on?

Yes, if your Windows 10 is 2004 or a newer build and your are using FOG 1.5.9 or older. That’s because with those versions of Win 10 they put a new recovery partition at the end of the disk and we have updated inits that can handle this in the latest dev-branch version.

Is there a setting I’m missing? I have the image set to single disk, resizable.

That setting is correct but as mentioned above you need the latest inits. Manually download inits (64 bit and 32 bit) and put into /var/www/html/fog/service/ipxe/ on your FOG server. Rename the existing files as backup instead of overwriting!

Now you need to re-capture the image. Maybe even create a new image definition for this to not overwrite your existing image files as a backup. Assign the new image to the host you capture from and schedule the task.

This image captured with the new inits should deploy to devices with smaller disk fine. If not, let us know here.

@george1421 Thanks. My gut feeling was that there were two partitions, one with Windows 7 and the other Windows 10. Just to be on the safe side we just put a whole new image on the new computer and copied everything over and then took a new image of that drive. Thank you for getting back to me.

@brico said in Two HDD - 3 OS Win 10 - Multiboot:

Then we’ll restore on the first disk ! And destroy /dev/sda !

YES! You really need to be careful when deploying. While single partitions are even more tricky you have to be alert when deploying anyhow. Deploy will overwrite whatever is on disk. Thinks can go wrong if you don’t take care of what exactly you do.

So, we’ll try to create 2 hosts (for the same PC)

As you have seen, this is not possible. The basic concepts of FOG don’t allow for more than one host object in the database with the same MAC address.

@greg-plamondon Rejoice too early! Tried to replicate the issue with SubnetGroup plugin installed at first because from the code it looked like this could be it. But exit type settings stayed. Also made the iPXE hidden but same result. Then installed HostStatus plugin but again exit type settings don’t get reset.

I am wondering if it’s possible this was due to an issue in the database that was cleaned out by removing those plugins?!

I see you have used the FOG 1.6.0-alpha version as well. Is this on a different server or do you switch between 1.5.x and 1.6.x on the same server?

@Greg-Plamondon Oh yeah, good point! Block size can be an issue when you connect across routers with different MTU configured.