Database Reset Option



  • Whenever I perform a multicast on a new batch of machines, I end up having to reset my database settings and manually stop and restart the FOGMulticastManager.

    Is it possible to add an administrative function within the front end to do the following:

    Run this on server and FOG Storage Node:

    service FOGMulticastManager stop
    service FOGMulticastManager start
    

    Run this on the server…

    Sudo -i
    mysql -p #PWD for root user
    use fog
    DELETE FROM `multicastSessions` WHERE 1;
    DELETE FROM `multicastSessionsAssoc` WHERE 1;
    DELETE FROM `tasks` WHERE `taskTypeID` = 8;
    quit
    

    Thanks!

    Cheers,

    Joe Gill



  • Thanks @Tom-Elliott!

    I updated this afternoon. I’ll be pushing more images out this evening and tomorrow. I’ll let you know how it goes. I appreciate all of your help!

    Cheers,

    Joe


  • Senior Developer

    This should all be fixed now.

    Remember @Joe-Gill, the logs you need to view should be those of the “master” nodes. That doesn’t mean you shouldn’t see anything, but I found earlier today (23-JUL-2016) that the “halt” is because the node is not a master. I’ve fixed it in the RC-2 and all appears to be working properly now.



  • @Tom-Elliott

    Updated to:
    Thu Jul 21, 2016 9:58 am
    Running Version 1.3.0-RC-1
    SVN Revision: 5936

    Now I cannot multicast at all. My multicast service is running. I stopped and restarted the service. Cleared out the DB and it’s stuck on the particlone screen.

    All I get in the log file is this…

    
    [07-21-16 9:57:16 am]
            ___           ___           ___
           /\  \         /\  \         /\  \
          /::\  \       /::\  \       /::\  \
         /:/\:\  \     /:/\:\  \     /:/\:\  \
        /::\-\:\  \   /:/  \:\  \   /:/  \:\  \
       /:/\:\ \:\__\ /:/__/ \:\__\ /:/__/_\:\__\
       \/__\:\ \/__/ \:\  \ /:/  / \:\  /\ \/__/
            \:\__\    \:\  /:/  /   \:\ \:\__\
             \/__/     \:\/:/  /     \:\/:/  /
                        \::/  /       \::/  /
                         \/__/         \/__/
    
      ###########################################
      #     Free Computer Imaging Solution      #
      #     Credits:                            #
      #     http://fogproject.org/credits       #
      #     GNU GPL Version 3                   #
      ###########################################
    
    [07-21-16 9:57:16 am] Interface Ready with IP Address: 65.117.90.194
    [07-21-16 9:57:16 am] Interface Ready with IP Address: 172.16.1.17
    [07-21-16 9:57:16 am] Interface Ready with IP Address: Fog
    [07-21-16 9:57:16 am]  * Starting MulticastManager Service
    [07-21-16 9:57:16 am]  * Checking for new items every 10 seconds
    [07-21-16 9:57:16 am]  * Starting service loop
    

    Any advice is most appreciated! I’ll be around until 4PM MST if you’d like to remote in.

    Cheers,

    Joe



  • @Tom-Elliott

    I’ll update and check it out. I’ll let you know what I find out. Thanks!


  • Senior Developer

    @Joe-Gill Yes. Trunk and GIT are both currently at RC-1.



  • @Tom-Elliott

    Do I do that the same way I update with SVN in trunk version?


  • Senior Developer

    Can you try updating to the RC-1 and see if this is still required?



  • @Tom-Elliott

    Wed Jul 20, 2016 10:54 am
    Running Version 8655
    SVN Revision: 5932

    and the same for the FOG storage node I believe. I updated them the same day.


  • Senior Developer

    What version are you runnign?


Log in to reply
 

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.