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

FOG Inventory Blank

Scheduled Pinned Locked Moved Solved
FOG Problems
inventory blank
3
15
5.4k
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
    Scott B @Wayne Workman
    last edited by Nov 10, 2015, 2:56 PM

    @Wayne-Workman said:

    @Scott-B I’ve just confirmed that SVN 4323 Cloud 5293 exports correctly. I’m marking this as solved.

    Okay, but its still broken for me.

    W 1 Reply Last reply Nov 10, 2015, 2:58 PM Reply Quote 0
    • W
      Wayne Workman @Scott B
      last edited by Wayne Workman Nov 10, 2015, 9:00 AM Nov 10, 2015, 2:58 PM

      @Scott-B Are the apache errors the same or have they changed?

      Can you run this command before you do the export, and then export while watching the output of the command?

      tail -f /var/log/apache2/error.log

      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/

      S 1 Reply Last reply Nov 10, 2015, 4:17 PM Reply Quote 0
      • S
        Scott B @Wayne Workman
        last edited by Nov 10, 2015, 4:17 PM

        @Wayne-Workman said:

        @Scott-B Are the apache errors the same or have they changed?

        Can you run this command before you do the export, and then export while watching the output of the command?

        tail -f /var/log/apache2/error.log

        Done. Those errors don’t match up with the workstation I’m using so they are errors from something other then the inventory?

        
        [Tue Nov 10 11:16:27.009667 2015] [:error] [pid 6329] [client 10.195.82.135:49774] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6329 in /var/www/fog/lib/db/MySQL.class.php on line 56
        [Tue Nov 10 11:16:32.932891 2015] [:error] [pid 6329] [client 10.195.82.135:49774] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6329 in /var/www/fog/lib/db/MySQL.class.php on line 56
        [Tue Nov 10 11:16:36.833697 2015] [:error] [pid 6708] [client 10.195.65.61:50551] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6708 in /var/www/fog/lib/db/MySQL.class.php on line 56
        [Tue Nov 10 11:16:38.388949 2015] [:error] [pid 6708] [client 10.195.65.61:50551] PHP Warning:  Error while sending STMT_PREPARE packet. PID=6708 in /var/www/fog/lib/db/MySQL.class.php on line 56
        
        
        1 Reply Last reply Reply Quote 0
        • S
          Scott B
          last edited by Nov 12, 2015, 3:50 PM

          The apache errors are gone with SVN 5313, but the report is still blank. The hosts do show up when you click on inventory, before choosing csv or pdf so at least the data is there. Same for just doing a hosts report.

          T 1 Reply Last reply Nov 12, 2015, 4:40 PM Reply Quote 0
          • T
            Tom Elliott @Scott B
            last edited by Nov 12, 2015, 4:40 PM

            @Scott-B are there any error logs in regards to the blank page? My guess is memory?

            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

            S 1 Reply Last reply Nov 12, 2015, 8:22 PM Reply Quote 0
            • S
              Scott B @Tom Elliott
              last edited by Nov 12, 2015, 8:22 PM

              @Tom-Elliott said:

              @Scott-B are there any error logs in regards to the blank page? My guess is memory?

              The apache errors are back, but otherwise im not seeing any other errors.

              apache log

              E packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
              [Thu Nov 12 15:21:14.097505 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
              [Thu Nov 12 15:21:15.033770 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
              [Thu Nov 12 15:21:16.357790 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
              [Thu Nov 12 15:21:18.014239 2015] [:error] [pid 27454] [client 10.195.82.135:50734] PHP Warning:  Error while sending STMT_PREPARE packet. PID=27454 in /var/www/fog/lib/db/MySQL.class.php on line 56
              
              
              T S 2 Replies Last reply Nov 12, 2015, 8:23 PM Reply Quote 0
              • T
                Tom Elliott @Scott B
                last edited by Nov 12, 2015, 8:23 PM

                @Scott-B I’m going to try my best to reach out tomorrow if that’s okay so I can teamviewer in to try to figure out what’s going on.

                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

                S 1 Reply Last reply Nov 12, 2015, 8:24 PM Reply Quote 1
                • S
                  Scott B @Tom Elliott
                  last edited by Nov 12, 2015, 8:24 PM

                  @Tom-Elliott said:

                  @Scott-B I’m going to try my best to reach out tomorrow if that’s okay so I can teamviewer in to try to figure out what’s going on.

                  That would be great, thanks!

                  1 Reply Last reply Reply Quote 0
                  • S
                    Scott B @Scott B
                    last edited by Nov 17, 2015, 7:21 PM

                    @Tom-Elliott

                    I wanted to post an update to this topic. As suggested it seems it was a memory issue in regards to just the white page. I was seeing errors similar to the one below in my apache log.

                    [Tue Nov 17 09:59:55.127379 2015] [:error] [pid 14071] [client xx.xx.xx.xx.xx:60299] PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 339292729 bytes) in /var/www/fog/commons/init.php on line 175
                    

                    So I upped the amount of memory and time PHP is allowed to use. After doing so I was able to run the inventory report (as well ask config save), but there is always a catch. The report has several hundred rows of “\\\\\\\\\\\\\\\\\\\\\…” and some of the rows are shifted one row to the left. My fear this is or will create a corrupt DB.

                    0_1447788029807_invexample.PNG

                    If I watch the apache logs I am still getting the errors below.

                    [Tue Nov 17 13:01:23.304484 2015] [:error] [pid 5672] [client 10.195.65.61:55864] PHP Warning:  Error while sending STMT_PREPARE packet. PID=5672 in /var/www/fog/lib/db/MySQL.class.php on line 56
                    [Tue Nov 17 13:01:31.145496 2015] [:error] [pid 5919] [client 10.195.65.148:50685] PHP Warning:  Error while sending STMT_PREPARE packet. PID=5919 in /var/www/fog/lib/db/MySQL.class.php on line 56
                    
                    W 1 Reply Last reply Nov 17, 2015, 7:36 PM Reply Quote 0
                    • W
                      Wayne Workman @Scott B
                      last edited by Wayne Workman Nov 17, 2015, 1:36 PM Nov 17, 2015, 7:36 PM

                      @Scott-B Just get rid of those…

                      Backup your DB first. FOG Configuration -> Configuration Save -> Export

                      For an individual:

                      update inventory set iOtherTag='' where iID=1972;
                      

                      For everything:

                      update inventory set iOtherTag='' where iOtherTag like '%\\\\\\\\\\\\\\%';
                      

                      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/

                      S 1 Reply Last reply Nov 17, 2015, 8:37 PM Reply Quote 1
                      • S
                        Scott B @Wayne Workman
                        last edited by Nov 17, 2015, 8:37 PM

                        @Wayne-Workman said:

                        @Scott-B Just get rid of those…

                        Backup your DB first. FOG Configuration -> Configuration Save -> Export

                        For an individual:

                        update inventory set iOtherTag='' where iID=1972;
                        

                        For everything:

                        update inventory set iOtherTag='' where iOtherTag like '%\\\\\\\\\\\\\\%';
                        

                        Thank you, that cleaned up the list very well.

                        1 Reply Last reply Reply Quote 1
                        • 1 / 1
                        1 / 1
                        • First post
                          14/15
                          Last post

                        137

                        Online

                        12.1k

                        Users

                        17.3k

                        Topics

                        155.3k

                        Posts
                        Copyright © 2012-2024 FOG Project