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

    Multi-Task Problem

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    3
    34
    5.0k
    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.
    • F
      Fernando Gietz Developer
      last edited by

      And in the database appears?
      See the multicastSessions and MulticastSessionAssoc

      If you go to the Active Tasks page, the multicast tasks appears?

      J 1 Reply Last reply Reply Quote 0
      • J
        Joe Gill @Fernando Gietz
        last edited by

        @Fernando-Gietz

        MariaDB [fog]> SELECT * FROM multicastSessions;
        Empty set (0.00 sec)
        
        MariaDB [fog]> SELECT * FROM multicastAssoc;
        ERROR 1146 (42S02): Table 'fog.multicastAssoc' doesn't exist
        MariaDB [fog]> 
        
        
        J 1 Reply Last reply Reply Quote 0
        • J
          Joe Gill @Joe Gill
          last edited by

          @Fernando-Gietz

          Screenshot from 2019-06-12 10-51-45.png

          1 Reply Last reply Reply Quote 0
          • S
            Sebastian Roth Moderator
            last edited by

            @Joe-Gill First make sure the multicast service is actually running: systemctl status FOGMulticastManager

            You are on the right track here. Try this: SELECT * FROM multicastSessionsAssoc;

            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

            J 1 Reply Last reply Reply Quote 0
            • J
              Joe Gill @Sebastian Roth
              last edited by

              @Sebastian-Roth

              [jgill@fogserver log]$ systemctl status FOGMulticastManager
              ● FOGMulticastManager.service - FOGMulticastManager
                 Loaded: loaded (/usr/lib/systemd/system/FOGMulticastManager.service; enabled; vendor preset: disabled)
                 Active: active (running) since Wed 2019-06-12 09:22:41 MDT; 1h 31min ago
               Main PID: 5610 (FOGMulticastMan)
                 CGroup: /system.slice/FOGMulticastManager.service
                         ├─5610 /usr/bin/php -q /opt/fog/service/FOGMulticastManager/FOGMulticastManager &
                         └─5613 /usr/bin/php -q /opt/fog/service/FOGMulticastManager/FOGMulticastManager &
              
              Jun 12 09:22:41 fogserver.bhs.tn systemd[1]: Started FOGMulticastManager.
              [jgill@fogserver log]$ 
              
              1 Reply Last reply Reply Quote 0
              • J
                Joe Gill
                last edited by

                @Sebastian-Roth

                MariaDB [fog]> SELECT * FROM multicastSessionsAssoc;
                +-------+------+-----+
                | msaID | msID | tID |
                +-------+------+-----+
                |    57 |    0 |  87 |
                |    56 |    0 |  86 |
                |    55 |    0 |  85 |
                |    54 |    0 |  84 |
                |    53 |    0 |  83 |
                |    52 |    0 |  82 |
                |    51 |    0 |  81 |
                |    50 |    0 |  80 |
                |    49 |    0 |  79 |
                |    48 |    0 |  78 |
                |    47 |    0 |  77 |
                |    46 |    0 |  76 |
                |    45 |    0 |  75 |
                |    44 |    0 |  74 |
                |    43 |    0 |  73 |
                |    42 |    0 |  72 |
                |    41 |    0 |  71 |
                |    40 |    0 |  70 |
                |    39 |    0 |  69 |
                |    38 |    0 |  68 |
                |    37 |    0 |  67 |
                |    36 |    0 |  66 |
                |    35 |    0 |  65 |
                |    34 |    0 |  64 |
                |    33 |    0 |  63 |
                |    32 |    0 |  62 |
                |    31 |    0 |  61 |
                |    30 |    0 |  60 |
                +-------+------+-----+
                28 rows in set (0.00 sec)
                
                MariaDB [fog]> 
                
                1 Reply Last reply Reply Quote 0
                • F
                  Fernando Gietz Developer
                  last edited by

                  The problem is that the multicastSession is not created ( I am very clever boy XD) but we dont know the reason of this behaviour.

                  Any errors in the php log?

                  J 1 Reply Last reply Reply Quote 0
                  • J
                    Joe Gill @Fernando Gietz
                    last edited by

                    @Fernando-Gietz

                    Which files would you like me to pull for you?

                    1 Reply Last reply Reply Quote 0
                    • F
                      Fernando Gietz Developer
                      last edited by

                      • /var/log/httpd/ssl_error_log
                      • /var/log/httpd/error_log

                      Try to see if when tou create a multicast tasks appears any error.

                      J 1 Reply Last reply Reply Quote 0
                      • J
                        Joe Gill @Fernando Gietz
                        last edited by

                        @Fernando-Gietz

                        Will do. I’ll tail those files and see what happens when I create a new task. I’ll report back! Thanks!

                        J 1 Reply Last reply Reply Quote 0
                        • J
                          Joe Gill @Joe Gill
                          last edited by

                          @Fernando-Gietz

                          OK. So now it’s saying:

                          “Invalid MultiCast Session” on the hosts. Nothing new in the log. I have the /etc/httpd/logs/error_log pulled tail -f and nothing new is showing up there.

                          1 Reply Last reply Reply Quote 0
                          • S
                            Sebastian Roth Moderator
                            last edited by

                            @Joe-Gill Unfortunately don’t have enough time to do another debug session with you. But maybe I can give you enough hints so you can dig it up yourself.

                            Remember that I enabled mysql query logging yesterday?! First you login to the web UI, clear all the old tasks there and select the group you want to schedule a multicast task for. Prepare this as far as possible but don’t hit the button to create it yet but enable database query logging (and clear the log we created yesterday):

                            shell> echo -n "" >/var/log/mariadb/query.log
                            shell> mysql -u root -p
                            Password:
                            ...
                            mysql> SET GLOBAL general_log_file='/var/log/mariadb/query.log';
                            ...
                            mysql> SET GLOBAL general_log=1;
                            

                            Now click create multicast task and then stop query logging again:

                            mysql> SET GLOBAL general_log=0;
                            

                            Now take a look at the query.log file. What you are looking for is probably something like INSERT INTO multicastSessions .... Just use search function of the text editor to find that part. Now when you find this you just copy the whole SQL command and try to execute that in the mysql shell manually. Most probably you’ll get an error from that and we might find out why.

                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                            J 1 Reply Last reply Reply Quote 0
                            • J
                              Joe Gill @Sebastian Roth
                              last edited by

                              @Sebastian-Roth

                              Awesome! That gives me a place to start. Thanks! I’ll do some digging. I’ll be tied up here in a couple hours for the rest of the day. I’ll post what I find out before I head out though. Thanks again!

                              J 1 Reply Last reply Reply Quote 0
                              • J
                                Joe Gill @Joe Gill
                                last edited by

                                @Sebastian-Roth
                                @Fernando-Gietz

                                Here’s an error!

                                MariaDB [fog]> INSERT INTO `multicastSessions` (`msName`,`msBasePort`,`msLogPath`,`msImage`,`msClients`,`msSessClients`,`msInterface`,`msStartDateTime`,`msPercent`,`msState`,`msCompleteDateTime`,`msIsDD`,`msNFSGroupID`,`msAnon3`,`msAnon4`,`msAnon5`) VALUES ('Multi-Cast Task - Elem-Lab','62250','WIN10Base_SSD','40','','','eth0','2019-06-12 15:05:26','0','0','','1','3','','','') ON DUPLICATE KEY UPDATE `msName`=VALUES(`msName`),`msBasePort`=VALUES(`msBasePort`),`msLogPath`=VALUES(`msLogPath`),`msImage`=VALUES(`msImage`),`msClients`=VALUES(`msClients`),`msSessClients`=VALUES(`msSessClients`),`msInterface`=VALUES(`msInterface`),`msStartDateTime`=VALUES(`msStartDateTime`),`msPercent`=VALUES(`msPercent`),`msState`=VALUES(`msState`),`msCompleteDateTime`=VALUES(`msCompleteDateTime`),`msIsDD`=VALUES(`msIsDD`),`msNFSGroupID`=VALUES(`msNFSGroupID`),`msAnon3`=VALUES(`msAnon3`),`msAnon4`=VALUES(`msAnon4`),`msAnon5`=VALUES(`msAnon5`);
                                ERROR 1054 (42S22): Unknown column 'msAnon3' in 'field list'
                                MariaDB [fog]> 
                                

                                Any ideas? I’ll be around all day today if you guys want to take a look at it.

                                Thanks!

                                1 Reply Last reply Reply Quote 0
                                • F
                                  Fernando Gietz Developer
                                  last edited by

                                  Hi @Joe-Gill
                                  And the msAnon3 column, does exist in the database?

                                  #desc multicastSessions;
                                  
                                  J 1 Reply Last reply Reply Quote 0
                                  • S
                                    Sebastian Roth Moderator
                                    last edited by

                                    @Joe-Gill Sounds like your DB has more issues that what we have fixed last time. But this one sounds really strange! Please run DESC multicastSessions in the mysql command line and post output here.

                                    Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                    Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                                    1 Reply Last reply Reply Quote 0
                                    • J
                                      Joe Gill @Fernando Gietz
                                      last edited by

                                      @Fernando-Gietz

                                      MariaDB [fog]> desc multicastSessions;
                                      +--------------------+---------------+------+-----+---------+----------------+
                                      | Field              | Type          | Null | Key | Default | Extra          |
                                      +--------------------+---------------+------+-----+---------+----------------+
                                      | msID               | int(11)       | NO   | PRI | NULL    | auto_increment |
                                      | msName             | varchar(250)  | NO   |     | NULL    |                |
                                      | msBasePort         | int(11)       | NO   |     | NULL    |                |
                                      | msLogPath          | longtext      | NO   |     | NULL    |                |
                                      | msImage            | longtext      | NO   |     | NULL    |                |
                                      | msClients          | int(11)       | NO   |     | NULL    |                |
                                      | msSessClients      | int(11)       | NO   |     | NULL    |                |
                                      | msInterface        | varchar(250)  | NO   |     | NULL    |                |
                                      | msStartDateTime    | datetime      | NO   |     | NULL    |                |
                                      | msPercent          | int(11)       | NO   |     | NULL    |                |
                                      | msState            | int(11)       | NO   |     | NULL    |                |
                                      | msCompleteDateTime | datetime      | NO   |     | NULL    |                |
                                      | msIsDD             | int(11)       | NO   |     | NULL    |                |
                                      | msNFSGroupID       | int(11)       | NO   | MUL | NULL    |                |
                                      | msShutdown         | enum('0','1') | NO   |     | 0       |                |
                                      | msMaxwait          | int(11)       | NO   |     | NULL    |                |
                                      | msAnon5            | varchar(250)  | NO   |     | NULL    |                |
                                      +--------------------+---------------+------+-----+---------+----------------+
                                      17 rows in set (0.01 sec)
                                      
                                      MariaDB [fog]> 
                                      
                                      1 Reply Last reply Reply Quote 0
                                      • F
                                        Fernando Gietz Developer
                                        last edited by

                                        Your database is … strange!!! XD

                                        MariaDB [fog]> desc multicastSessions;
                                        +--------------------+--------------+------+-----+---------+----------------+
                                        | Field              | Type         | Null | Key | Default | Extra          |
                                        +--------------------+--------------+------+-----+---------+----------------+
                                        | msID               | int(11)      | NO   | PRI | NULL    | auto_increment |
                                        | msName             | varchar(250) | NO   |     | NULL    |                |
                                        | msBasePort         | int(11)      | NO   |     | NULL    |                |
                                        | msLogPath          | longtext     | NO   |     | NULL    |                |
                                        | msImage            | longtext     | NO   |     | NULL    |                |
                                        | msClients          | int(11)      | NO   |     | NULL    |                |
                                        | msSessClients      | int(11)      | NO   |     | NULL    |                |
                                        | msInterface        | varchar(250) | NO   |     | NULL    |                |
                                        | msStartDateTime    | datetime     | NO   |     | NULL    |                |
                                        | msPercent          | int(11)      | NO   |     | NULL    |                |
                                        | msState            | int(11)      | NO   |     | NULL    |                |
                                        | msCompleteDateTime | datetime     | NO   |     | NULL    |                |
                                        | msIsDD             | int(11)      | NO   |     | NULL    |                |
                                        | msNFSGroupID       | int(11)      | NO   | MUL | NULL    |                |
                                        | msAnon3            | varchar(250) | NO   |     | NULL    |                |
                                        | msAnon4            | varchar(250) | NO   |     | NULL    |                |
                                        | msAnon5            | varchar(250) | NO   |     | NULL    |                |
                                        +--------------------+--------------+------+-----+---------+----------------+
                                        17 rows in set (0.012 sec)
                                        
                                        J 1 Reply Last reply Reply Quote 0
                                        • J
                                          Joe Gill @Fernando Gietz
                                          last edited by

                                          @Fernando-Gietz

                                          I blame @Tom-Elliott ! Ha! He helped me with it last year and the past few years.

                                          1 Reply Last reply Reply Quote 0
                                          • S
                                            Sebastian Roth Moderator
                                            last edited by

                                            @Joe-Gill You can manually add the coloumns to match the schema Fernando posted.

                                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

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

                                            158

                                            Online

                                            12.0k

                                            Users

                                            17.3k

                                            Topics

                                            155.2k

                                            Posts
                                            Copyright © 2012-2024 FOG Project