Posts made by adukes40

@Roger-Saffle I am having something similar. Posted here. https://forums.fogproject.org/topic/7848/sqlstate-42s22/1

upgraded this morning

Just updated to 8187. I get this error when trying to set the Location on a host. I can set Snapins, and images.

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘locationAssoc.’ in ‘where clause’ SQL: [145] SELECT laID FROM locationAssoc WHERE locationAssoc.laLocationID=‘2’ AND locationAssoc.``=‘hostID’ ORDER BY locationAssoc.laID ASC Params: 0

Also receive error after PXE boot. Chainloading error, but also calls the SQLSTATE error.

@Wayne-Workman yea basically I could search for individual hosts, but not click List all, it would just bomb to the 500 error. When I would click Membership in group mgmt, just came up with a blank white page. I don;t know why I thought about the memory limit, but figure WTH, and it turns out it worked for my case. Now that I can add to groups in mass, I will now push an Inventory task to everything so that get all updated.

@Wayne-Workman I got the page to go away. all 3072 hosts now load when I click List all Hosts. Takes a few seconds, but it loads. I ended up going to to FOG Settings > General Settings > FOG_MEMORY_LIMIT. Every time I bumped it up higher the faster it loaded. Going from 128 to 512 at least let the page load. bumping it to 1024, just made it better. Testing at 2048 even better. (Memory isn’t an issue here)

Subsequently I couldn’t add multiple members to groups because the page would never load. It now lets me browse hosts not part of a group and add them.

@Wayne-Workman Works nicely.

@Wayne-Workman 10mb. I copied the csv over to the local site and tried, but was still having to click upload multiple times. It seems importing them 100 at a time is making the import look better, but now sitting at 3000 hosts… I can’t click on the Lists all Hosts. Instantly goes to 500 error. I was checking it every so often. It would load closer to 2000, but now it does not.

Also click Lists all Hosts, while remoted into a machine at the server site, instantly returns 500. I can search for them and it works, but just not list all.

@Wayne-Workman Manually. I only have 2 fields. the first field in the MAC and the second is the machine name. I have dropped down to uploading 100 at a time, and seems to be cooperating better. Still a bit more than a 1000 to go.

although I did do a machine export to verify the field order.

When trying to reimport back in, it looks like it timesout during the upload. I get the http 500, then i try to reupload the same file. Sometimes it takes a few tries to get them all. They finally go through. I tried breaking them down into 500 host segments, and 250 host segments. Only once has it gone through all the way doing a successful 250/250, all times it timesout.

I just imported a couple thousand hosts to FOG and now when I go to list them all I get is:

Oh and this is what shows in the Apache log viewer:

Version 8159

Is there a way to have a report of all the snap-in ID numbers? They don’t show up during the export.

@Tom-Elliott AHH, Ok. thanks Tom. I did not know that it was caching that. I was baffled at why it was always maxed, when actually it is not. Basically, adding more memory would just allow for more cached processes to be kept?

Also what is up with Zombie Processes?

When I log in via putty and the statistics page comes up it says the memory usage is about 10%. Yet when I run TOP, it was 4046992 Total, 381886 Used, xxxxx Free.

Can someone explain why one says on 10% and the other basically maxed? I am trying to figure if I need to add more RAM or not.

Thanks.

OK, so I ended up bypassing the HNC and EHNC all together. Being we need a reboot to occur before joining the domain, I created a powershell script to run on that first auto logon to take care of the name change. So the unattend names it with the * variable, then PS runs and pulls the current computer name, the asset from the bios, and serial from the bios and mashes them together and is working perfectly. Here is the script if it helps someone else gets started with their PS script:

#Rename the Workstation
$CurrerntComputerName = (Get-WmiObject -Class Win32_ComputerSystem -Property Name).Name
$SerialNumber = (Get-WmiObject -Class Win32_BIOS | Select-Object SerialNumber).SerialNumber
$AssetTag = (Get-WmiObject -Class Win32_SystemEnclosure | Select-Object SMBiosAssetTag).SMBiosAssetTag

$OSDComputerName = “$($AssetTag)-$($SerialNumber)”

Rename-Computer -ComputerName $CurrerntComputerName -NewName $OSDComputerName

@Wayne-Workman seems very plausible. I will update the image to remove the setting from the xml tomorrow.

Is that where you were going with the (*) George? the unattend overwriting the EHNC?

just verified that for you. indeed:

<ComputerName>*</ComputerName>

@george1421 Without looking I do not know for certain. But now that you say it I think it is just an * which is why it names it TECHNOL-blahblah

@george1421 nah, the unattend doesn’t touch the hostname.

@Wayne-Workman Win7 32bit, Enterprise, Machine is sysprep’d, FOG service disabled on master image, then re-enabled during the setupcomplete.cmd

@Wayne-Workman correct, but it didn’t seem to be changing the name unless they were both enabled, and I do believe it is causing an unwanted reboot. I came back to a machine that was waiting for the local admin account to logon, insinuating that the 2 autologons occurred, which would mean HNC burnt one. While it was turned off, and Early was checked, it wasn’t naming it, but also wasn’t burning a reboot, only after i reenabled the client HNC version. I can check again tomorrow. Just now sure why it is being a issue now.