Hosts think they are not registered

[Psycholiquid]

Wed Jul 27, 2016 7:52 am
Running Version 1.3.0-RC-2
SVN Revision: 5937

Tried the following wiki article suggestd by Wayne Workman but it doesnt do anything. Jsut acts like I am not logged in as root.

https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Hosts_think_they_are_not_registered_.2F_can.27t_register_.2F_other_weirdness

getting the following:

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

that is right after typing mysql

when deploying images I get failed to update DB and the task never drops out. When I register PCs they come back up as not registered but the information is in FOG just fine Inventory and all.

I did find this searching and made the change in teh taskqueues.class.php file didnt seem to help:

https://forums.fogproject.org/topic/8172/if-email-when-complete-is-enabled-the-database-is-unable-to-clear-the-task/2

As always any help is appreciated.

[Tom Elliott]

Is this a node?

[Psycholiquid]

@Tom-Elliott Nope this is the Master

[Tom Elliott]

Do you have a password set for the mysql root user? The message seems to suggest so.

[Psycholiquid]

@Tom-Elliott Not sure, I never did manually. Not good at the mysql personally so it is a struggle for me

[Psycholiquid]

@Tom-Elliott Finally got in, hadf to use my head for more than a hatrack this morning.:

mysql> use fog
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> DELETE FROM hostMAC WHERE hmHostID NOT IN (SELECT hostID from hosts);
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM hostMAC WHERE hmHostID=0;
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM hosts WHERE hostID=0;
Query OK, 0 rows affected (0.00 sec)

mysql> DELETE FROM hosts WHERE hostID NOT IN (SELECT hmHostID from hostMAC);
Query OK, 1 row affected (0.01 sec)

[Psycholiquid]

Running the sql commands did not help, hosts are still showing not registered when they are in fact in FOG. I checked the mac address and it is correct. At a little bit of a loss here.

[Psycholiquid]

Just ran the SVN up and it isn’t showing updating the version to 5941 either, I think my setup is trying to be hosed.

[Psycholiquid]

@Psycholiquid Had a blonde moment. needed to manually put the NIC from the dock in the host to get it to read correctly. Testing the deploy and DB update now

[Psycholiquid]

OK reinstalled the FOG sever again (over itself) and everything seems to have ironed itself out. I had to basically install it twice. But everything seems golden. Back to Windows 10 on a Surface image. Thank you guys.