• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    mySql help - query to set a storage node max clients to '1' instead of 0

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    2
    3
    457
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • B
      bgeorge
      last edited by bgeorge

      Hi All,
      Massive fan, first time poster -be gentle.
      In a horrible rush (aren’t we all these days) and I’m hoping someone with MySQL query experience can help me avoid some serious rework I can’t afford mid-project.
      I’m running 1.5.1 on a main server, with 10 storage nodes connected on sites with horrible bandwidth. The main server only provides pxe boot, using location plugin & wolbroadcast plugins to utilize node inits/kernals.
      Anyway - after a server crash I rebuilt on 1.5.1 (I suspected 1.5.2 created some trouble for me - my bad - rushing).
      I also was seeing some ‘odd’ behavior with location plugin - which resolved itself fine and I’m not concerned about.
      However - my real issue is due to the odd behavior I witnessed, I thought - lets just make the default storage node not able to support any client connections for imaging, just in case - thus I set its max clients to 0.
      Pretty certain I’ve now run into this issue here: https://forums.fogproject.org/topic/11725/storage-node-vanished-after-upgrading-to-1-5-2

      My question - can anyone supply me with a MySQL query to run to change my "default’ storage node max clients back from 0 to 2 (or some real number) so I can then view my storage nodes again?

      I realize upgrading to 1.5.2 working branch would fix, however I’m too time poor to do that mid-project across all my nodes… I’m imaging machines at night in my spare time outside work as it is…

      Any help much appreciated for the MySQL noobie.
      Cheers

      1 Reply Last reply Reply Quote 0
      • george1421G
        george1421 Moderator
        last edited by

        OK lets see if we can get you going.

        1. SU to root and then log into mysql using mysql -u root fog
        2. Issue this mysql command to list out your storage nodes.
          select ngmID, ngmMemberName, ngmMaxClients from nfsGroupMembers;
        3. You should see a results list this:
        MariaDB [fog]> select ngmID, ngmMemberName, ngmMaxClients from nfsGroupMembers; +-------+-----------------+---------------+
        | ngmID | ngmMemberName   | ngmMaxClients |
        +-------+-----------------+---------------+
        |     1 | ATL StorageNode |            10 |
        +-------+-----------------+---------------+
        1 row in set (0.00 sec)
        
        
        1. Collect and record the ID value of storage node in question. In this case we’ll use 1
        2. Update the following query with the proper values.
          update nfsGroupMembers set ngmMaxClients=1 where ngmID=1;
        3. Confirm that the value was set using the previous query.
          select ngmID, ngmMemberName, ngmMaxClients from nfsGroupMembers;
        4. If the number are now correct exit mysql
          exit
        5. Done.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

        1 Reply Last reply Reply Quote 2
        • B
          bgeorge
          last edited by

          Legend - exactly what I needed.
          Nodes are visible and I can continue the project 😄

          Where do I mark this as solved and buy you a virtual beer!

          1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            Last post

          194

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project