• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.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.
  • S
    Sebastian Roth Moderator
    last edited by Oct 21, 2015, 10:57 PM

    @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
    • R
      Raymond Bell Testers
      last edited by Oct 22, 2015, 12:59 PM

      @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
      • C
        ch3i Moderator @Raymond Bell
        last edited by Oct 22, 2015, 1:36 PM

        @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
        • R
          Raymond Bell Testers
          last edited by Oct 22, 2015, 1:41 PM

          @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
          • R
            Raymond Bell Testers
            last edited by Oct 22, 2015, 1:46 PM

            @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

            C 1 Reply Last reply Oct 22, 2015, 2:37 PM Reply Quote 0
            • C
              ch3i Moderator @Raymond Bell
              last edited by Oct 22, 2015, 2:37 PM

              @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
              • R
                Raymond Bell Testers
                last edited by Raymond Bell Oct 22, 2015, 8:43 AM Oct 22, 2015, 2:39 PM

                @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 Oct 22, 2015, 3:12 PM

                  @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

                  R 1 Reply Last reply Oct 22, 2015, 3:14 PM Reply Quote 0
                  • R
                    Raymond Bell Testers @Sebastian Roth
                    last edited by Oct 22, 2015, 3:14 PM

                    @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
                    • R
                      Raymond Bell Testers
                      last edited by Oct 26, 2015, 8:23 PM

                      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
                      • W
                        Wayne Workman
                        last edited by Oct 26, 2015, 9:40 PM

                        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
                        2 / 2
                        • First post
                          28/31
                          Last post

                        155

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project