@Duncan There are SQL queries that can list duplicate data in a specific field. Once you have the select statement prepared, you can then put it in parentheses into the WHERE clause for a delete command.

So…
select duplicates from hostMac.mac address; (or whatever it is)

delete from hostMac where (select duplicates from hostMac.mac address);

get it? It’s been a hot second since I’ve used SQL heavily so I don’t quite remember the syntax but I’m sure you can figure it out.

Please post the command you come up with, this is one way you can GIVE BACK to an open source project. 🙂

PLEASE PLEASE export your DB before you delete anything!
FOG Configuration -> Configuration Save -> Export

@Tom-Elliott Thanks Tom for all your help. Tom fixed quickly note to self check services…

Sorry for the delay. It was logging an error in the event log that the fog service hung I set it to delayed startup and that seems to be a reasonable workaround for the issue.

@Wayne-Workman No, I full register. I’ll look at Fog Trunk, I thought I’d tried everything already.

@nhaws Look at this: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_NFS

Double Check your storage node settings, your /etc/exports file, and make sure NFS and RPC services are running. Info on those things are in the article above.

We might be able to help you make FOG run with you Lenovos but you’ll have to provide more information first.

What kind of Lenovo is it? Model number? or at least the exact name/number and model of the network card used in those machines?

And please provide more information about what is problem or error you see? We cannot help you if we don’t know what exactly is going wrong!

Which topic did you read? URL?

@Jbob Thanks

To ensure you don’t have to do this on every update/install of FOG, you may want to edit the /opt/fog/.fogsettings specifically the snmysqlhost, snmysqluser, and snmysqlpass fields to contain the information relevant for your MySQL setup.

@b.martin English please. 🙂

@Lesso Nice article. 🙂

Feel free to request access to the FOG Project’s WiKi. 🙂 We need more people that are good technical writers.

Issue looks like it is resolved. (web interface slow)

Upgraded VM server to svn 4469 ubuntu 12.04
Upgraded/Rebuilt storage node to svn 4469 ubuntu 12.04

Now i am getting this in the Apache Error Log any ideals?

FYI - you guys have been awesome help…

[Fri Aug 21 15:21:34.512243 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.513252 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.513890 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.514301 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.514866 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.515173 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63 [Fri Aug 21 15:21:34.515689 2015] [:error] [pid 2863] [client 10.24.28.18:51087] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 63```

@Tom-Elliott

I run the versions:

Version: 4469
bzImage Version: 4.1.6
bzImage32 Version: 4.1.6

@Tom-Elliott Is the console.h file an actual image? Where is it located?

@Tom-Elliott For future readers, I’ll add that if you HAVE to do an export in this fashion - you probably have much larger issues…

FOG has a built in DB export tool; this is how you get to it:
FOG Configuration -> Configuration Save -> Export
That copies everything from the DB - literally everything.

The Import tool is in the same spot and it does work.

If for some reason the FOG front-end is broke and you can’t use it to import/export - you can do the same thing manually. Examples are here in the WiKi: https://wiki.fogproject.org/wiki/index.php/Troubleshoot_MySQL

@TRex You might not be permanently up though.

There’s a known issue with FOG 1.2.0 on Ubuntu 14 and higher - and you just experienced it.

This issue is solved in FOG Trunk.

@Tom-Elliott Yeah, will try to make a video tomorrow or on Friday. So far I have an Acer Laptop and a bunch of PCs based on Asus P5G41T-M which have the same behavior.

@Wayne-Workman I did end up figuring it out. It turns out that our data had left over data from a previous export/import. So that’s why not all of our entries in the both tables had corresponding entry’s while some did.

@Wayne-Workman Not to worried about it now… I am pretty sure even on the 4425 trunk version, the web ui did prompt me to do this and I let it go. In some ways, it was good it did it this way as I inadvertantly revved the production server and had to back track.

check for a bios update and/or use undionly.kkpxe instead of undionly.kpxe (undionly.kkpxe works better with buggy bios/pxe rom configurations)

SOLVED: Had to delete the /var/lib/dhcp/dhcpd.leases file. Started working again like a charm. Thanks again!