+ Post New Thread
Results 1 to 15 of 15
O/S Deployment Thread, Can't add host to the system in Technical; I have been having issues adding clients to my fog install. I can't add them from the web side or ...
  1. #1

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Can't add host to the system

    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

  2. #2

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    just a bump to get some help...

  3. #3
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    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.

  4. #4
    ssx4life's Avatar
    Join Date
    Sep 2009
    Posts
    106
    Thank Post
    0
    Thanked 12 Times in 12 Posts
    Rep Power
    12
    agreed...

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

  5. #5

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    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?

  6. #6
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    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.

  7. #7

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  8. #8
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    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:
    Code:
    show grants for 'user'@'host'
    Are running the installer behind a proxy?

  9. #9

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    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

  10. #10

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by morganw View Post
    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:
    Code:
    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'

  11. #11

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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?
    Last edited by slipp3d; 7th February 2011 at 05:25 PM.

  12. #12

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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...
    Last edited by slipp3d; 8th February 2011 at 07:05 PM.

  13. #13

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    when I change the FOG_STORAGENODE_MYSQLUSER to root with a blank pass it starts working ...

  14. #14
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    Does your root mysql account not have a password?

  15. #15

    Join Date
    Jan 2011
    Location
    Montana
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I'm guessing so ...

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 2nd November 2010, 02:05 PM
  2. Microsoft Office Add-in: Microsoft Outlook SMS Add-in (MOSA)
    By faza in forum How do you do....it?
    Replies: 0
    Last Post: 16th November 2009, 02:05 PM
  3. Add an IP address to local host
    By FN-GM in forum Windows
    Replies: 12
    Last Post: 22nd January 2008, 08:29 PM
  4. Add VirusScan to Explorer system tasks
    By thom in forum Windows
    Replies: 4
    Last Post: 17th October 2006, 08:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •