Solved Database Reset Option

[Joe Gill]

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

[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

[Tom Elliott]

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.

[Joe Gill]

@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

[Joe Gill]

@Tom-Elliott

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

[Tom Elliott]

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

[Joe Gill]

@Tom-Elliott

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

[Tom Elliott]

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

[Joe Gill]

@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.

[Tom Elliott]

What version are you runnign?