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

    Attempting To Send Inventory - Invalid Host? SVN 4193

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    5
    31
    12.2k
    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.
    • Tom ElliottT
      Tom Elliott @Sebastian Roth
      last edited by

      @Uncle-Frank of course I can’t. I believe you’re on the right track though as I only have one or two clients connecting to my system. And most of the time they are off to begin with. So it isn’t a surprise to me if it is related to sheer numbers of clients connecting and disconnecting. I’m of the mind though that it’s my attempt to use the real connect after initializing the mysqli object in lib/db/MySQL.class.php and missing some check somewhere as this is a fairly new issue, not one people have been experiencing the whole time.

      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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      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
      • S
        Sebastian Roth Moderator
        last edited by

        Searching through the forums I saw that Raymond Bell and Joseph Hales both mentioned those errors in apache log some time ago. For example see here: https://forums.fogproject.org/topic/5661/web-interface-slow-svn-4333

        Browsing the code history around that time I found this: http://sourceforge.net/p/freeghost/code/3971/

        Why a connect call (in the query function) which wasn’t there before?

        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

        Tom ElliottT 1 Reply Last reply Reply Quote 0
        • Tom ElliottT
          Tom Elliott @Sebastian Roth
          last edited by

          @Uncle-Frank The reasoning is that in some cases the connection just appears to go dead. So on the construct (which is already called) it automatically makes the link, rather than implicitly making it do so.

          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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

          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
          • S
            Sebastian Roth Moderator
            last edited by

            @Raymond-Bell And while you are at it. Please run the same command using port 80 again. My guess is that you see a lot of apache processes in the first listing (port 3306) and it would be interesting to see “who” is calling all these (connections from your clients is my guess): lsof -i :80

            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
            • Raymond BellR
              Raymond Bell Testers
              last edited by

              @Uncle-Frank Nothing show up running
              Ubuntu 12.04

              fog@fog-virtual-machine2:~$ lsof -i :3306
              fog@fog-virtual-machine2:~$```

              Raymond Bell
              WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

              1 Reply Last reply Reply Quote 0
              • ch3iC
                ch3i Moderator @Raymond Bell
                last edited by

                @Raymond-Bell Hi, is it new hosts or hosts that are disappeared that you want to register ? I’ve a same problem with my FOG server, some mac address are missing in the mac address table, I’ve to delete all hosts which are not in the mac address table to register it.

                1 Reply Last reply Reply Quote 0
                • Raymond BellR
                  Raymond Bell Testers
                  last edited by

                  @ch3i This is a host that was reg and then was missing from fog a week later. I will check the mac address table

                  Raymond Bell
                  WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                  1 Reply Last reply Reply Quote 0
                  • Raymond BellR
                    Raymond Bell Testers
                    last edited by

                    @ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users

                    Raymond Bell
                    WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                    ch3iC 1 Reply Last reply Reply Quote 0
                    • ch3iC
                      ch3i Moderator @Raymond Bell
                      last edited by

                      @Raymond-Bell said:

                      @ch3i I can see the host in the Host Listing Export and it does not have a mac address but when i do a search under host i can not find it. How would i delete it out of the Host Listing Export? Also i get a blank page when i try to look at report Hosts and Users

                      You have the same bug than me, some mac address disappeard and I can’t view it in the host view… can you post the result of

                      SELECT hostName 
                      FROM hosts 
                      WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
                      
                      1 Reply Last reply Reply Quote 1
                      • Raymond BellR
                        Raymond Bell Testers
                        last edited by Raymond Bell

                        @ch3i And all are missing from fog Host Search

                        mysql> SELECT hostName 
                            -> FROM hosts 
                            -> WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
                        +---------------+
                        | hostName      |
                        +---------------+
                        | es-54-01      |
                        | es-33-t       |
                        | jh-18-t2      |
                        | es-53-04      |
                        | es-53-01      |
                        | es-53-02      |
                        | es-53-06      |
                        | es-53-09      |
                        | es-53-08      |
                        | es-53-t       |
                        | es-53-10      |
                        | 0023ae5a3b86  |
                        | es-52-08      |
                        | es-52-05      |
                        | es-52-04      |
                        | es-52-03      |
                        | es-52-02      |
                        | es-52-01      |
                        | es-08-t       |
                        | ad-bmace-2015 |
                        | HS-104-08-Lap |
                        +---------------+
                        21 rows in set (0.01 sec)
                        

                        Raymond Bell
                        WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

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

                          @Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way! 🙂

                          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

                          Raymond BellR 1 Reply Last reply Reply Quote 0
                          • Raymond BellR
                            Raymond Bell Testers @Sebastian Roth
                            last edited by

                            @Uncle-Frank said:

                            @Raymond-Bell Have you updated to current trunk since yesterday? I really wonder why you do not see any mysql connections on your FOG server. Maybe this issue was solved just by itself. Well then you might want to head for your initial problem and I think ch3i is pointing you the correct way! 🙂

                            Yes i have updated to 4199
                            Hopefully @ch3i can help me delete these out of here and then i can re-register them

                            Raymond Bell
                            WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                            1 Reply Last reply Reply Quote 0
                            • Raymond BellR
                              Raymond Bell Testers
                              last edited by

                              I have deleted all that where in the list and got the host to register.

                              Raymond Bell
                              WiKi: https://wiki.fogproject.org/wiki/index.php/Main_Page

                              1 Reply Last reply Reply Quote 1
                              • Wayne WorkmanW
                                Wayne Workman
                                last edited by

                                For future readers, the select statement that @ch3i posted can be converted into a delete statement like so:

                                DELETE hostName 
                                FROM hosts 
                                WHERE hostID NOT IN ( SELECT hmHostID FROM hostMAC );
                                

                                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!
                                Daily Clean Installation Results:
                                https://fogtesting.fogproject.us/
                                FOG Reporting:
                                https://fog-external-reporting-results.fogproject.us/

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

                                192

                                Online

                                12.0k

                                Users

                                17.3k

                                Topics

                                155.2k

                                Posts
                                Copyright © 2012-2024 FOG Project