slipp3d Posted January 17, 2011 Posted January 17, 2011 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
morganw Posted January 23, 2011 Posted January 23, 2011 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 Posted January 23, 2011 Posted January 23, 2011 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 Posted January 24, 2011 Posted January 24, 2011 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 Posted January 24, 2011 Posted January 24, 2011 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 Posted January 26, 2011 Author Posted January 26, 2011 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 Posted January 27, 2011 Posted January 27, 2011 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 Posted January 27, 2011 Posted January 27, 2011 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 Posted February 7, 2011 Author Posted February 7, 2011 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 Posted February 7, 2011 Author Posted February 7, 2011 (edited) 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? Edited February 7, 2011 by slipp3d
slipp3d Posted February 8, 2011 Author Posted February 8, 2011 (edited) 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... Edited February 8, 2011 by slipp3d
slipp3d Posted February 8, 2011 Author Posted February 8, 2011 when I change the FOG_STORAGENODE_MYSQLUSER to root with a blank pass it starts working ...
morganw Posted February 9, 2011 Posted February 9, 2011 Does your root mysql account not have a password?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now