[Fog] Can't add host to the system

[slipp3d]

I have been having issues adding clients to my fog install. I can't add them from the web side or from the windows client. I have found that the ability for the fog clients to add themselves to the system has been removed from version .29, but this doesn't explain why I can't manually add new hosts.

I'm wondering if it's an issues with MYSQL.

a little back ground....
The server started it's life with Fog as a CentOS server. Then this summer I moved it to a Ubuntu 10.04 install. After following the guide on the Fog Wiki I backed up the database and the clients images and moved them into the new install. This summer I didn't have any 'new' computers that I had to setup. Now that I have new computers for the fog system I'm finding this error. Does anyone have an idea of what is wrong and how to fix it?

Thanks

[slipp3d]

just a bump to get some help...

[morganw]

Does it work if you try and add a host though the PXE boot menu, using either quick registration or full registration?

You could try setting up the server from scratch with a blank database, do an export of the hostnames and mac addresses from the old system and then import into the new one. Depending on what parts of FOG you are using then you might now have much else to set up other than that. I would recommend moving it to a virtual machine anyway so you'll never have to do a database transfer again and also if an upgrade goes wrong you can just roll it back using a VM snapshot.

[ssx4life]

agreed...

not only does the VM allow for more security and flexability... but it also does things such as NIC bonding to reduce overhead.

[glennda]

I can't remember setting it up it was so long ago but are all the permissions set correctly on all the fog files? maybe it can't read some files that it needs.

Although it could just be that it can't write to the Sql database properly.

Has the appropriate user been given the correct permissions over the DB?

[morganw]

You could try switching to using the mysql root account in the fog configuration and see if that makes a difference. As a last resort I have re-run the installer over the top of an installation before and reset all the passwords.

[slipp3d]

morganw,
the short answer is no ... any way that I try to add a host to the system fails.
If I move it to a vm should I use something like proxmox for the vm or play in the vmware server or is there something better to use?

glennda,
How can i check to see who has rights to the sql DB?

Morganw,
If i try to rerun the installer i get an error because foginstaller can't find the correct packages

[morganw]

I'm using Debian on XenServer to run it but I'm probably in the minority. If you want to stick with Ubuntu then just use something that officially supports it as a guest so you don't get any IO issues. It wouldn't have to be a high spec system as you can offload the imaging through disposable physical storage nodes rather than pull images directly from the VM.

To check the database user rights you can run this when logged into mysql:

show grants for 'user'@'host'

Are running the installer behind a proxy?

[glennda]

I can't remember the command of the top of my head but you could try just setting the permissions again using the commands mentioned here

[slipp3d]

I'm using Debian on XenServer to run it but I'm probably in the minority. If you want to stick with Ubuntu then just use something that officially supports it as a guest so you don't get any IO issues. It wouldn't have to be a high spec system as you can offload the imaging through disposable physical storage nodes rather than pull images directly from the VM.

To check the database user rights you can run this when logged into mysql:

show grants for 'user'@'host'

Are running the installer behind a proxy?

No i'm not running behind a proxy...

and when i run that command ... see quoted text for the copy / paste of the commands.....

mysql> show grants for administrator@fogsystem;
ERROR 1141 (42000): There is no such grant defined for user 'administrator' on host 'fogsystem'
mysql> show grants for fog@fogsystem;
ERROR 1141 (42000): There is no such grant defined for user 'fog' on host 'fogsystem'
mysql> show grants for fog@localhost;
ERROR 1141 (42000): There is no such grant defined for user 'fog' on host 'localhost'
mysql> show grants for administrator@localhost;
ERROR 1141 (42000): There is no such grant defined for user 'administrator' on host 'localhost'

[slipp3d]

so i'm guessing that I lost access to that mysql data base for my fog user and my administrator user ... what can i do to get it back?

should I install mysqladmin or is there a better way?

[slipp3d]

the error that i'm getting when I try to reinstall the fog system on that server ....

Confirming package installation.

* Checking package: httpd...Failed!

while digging for this error I have noticed that the apache2 package has been renamed in the apt-get to ....

apache2-mpm-itk 2.2.14-5ubuntu8.4
apache2-mpm-worker 2.2.14-5ubuntu8.4
apache2-mpm-prefork 2.2.14-5ubuntu8.4
apache2-mpm-event 2.2.14-5ubuntu8.4

I'm betting that this is the reason that i'm not able to re-run the install package...

[slipp3d]

when I change the FOG_STORAGENODE_MYSQLUSER to root with a blank pass it starts working ...

[morganw]

Does your root mysql account not have a password?

[slipp3d]

I'm guessing so ...