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

User Tracking search not working

Scheduled Pinned Locked Moved Solved
FOG Problems
2
10
709
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.
  • A
    altitudehack
    last edited by Dec 1, 2021, 11:01 PM

    Updated to Version 1.5.9.113 but behavior is still the same. Page never loads, just shows blank.

    URL:
    https://fogserver.my-domain.com/fog/management/index.php?node=report&sub=file&f=dXNlciB0cmFja2luZw%3D%3D

    tail /var/log/php-fpm/error.log shows nothing since I restarted it (the above search was performed after 14:43):

    [01-Dec-2021 14:43:58] NOTICE: exiting, bye-bye!
    [01-Dec-2021 14:43:58] NOTICE: fpm is running, pid 27319
    [01-Dec-2021 14:43:58] NOTICE: ready to handle connections
    [01-Dec-2021 14:43:58] NOTICE: systemd monitor interval set to 10000ms
    
    A 1 Reply Last reply Dec 2, 2021, 5:45 PM Reply Quote 0
    • A
      altitudehack @altitudehack
      last edited by Dec 2, 2021, 6:23 PM

      I ended up searching for memory_limit in /etc/php*:

      grep -r memory_limit /etc/php*
      

      The two active files were /etc/php.ini and /etc/php-fpm.d/www.conf:

      /etc/php-fpm.d/www.conf:php_admin_value[memory_limit] = 1024M
      /etc/php-fpm.d/www.conf:;php_admin_value[memory_limit] = 256M
      /etc/php.ini:memory_limit = 512M
      /etc/php.ini:;memory_limit = 128M
      

      I duplicated the lines, commented out the original with ;, then quadrupled the values. Restarted the services with:

      systemctl restart httpd
      systemctl restart php-fpm.service
      

      User Tracking queries now work as expected.

      1 Reply Last reply Reply Quote 0
      • A
        altitudehack @altitudehack
        last edited by Dec 2, 2021, 5:45 PM

        The data’s there, and it’s less than 5000 rows, so doesn’t seem like an excessive query:

        MariaDB [fog]> select * from userTracking;
        +------+----------+-------------+----------+---------------------+--------+------------+---------+
        | utID | utHostID | utUserName  | utAction | utDateTime          | utDesc | utDate     | utAnon3 |
        +------+----------+-------------+----------+---------------------+--------+------------+---------+
        ...
        ...
        | 4816 |       41 | jesie          | 1        | 2021-12-02 08:52:08 |        | 2021-12-02 |         |
        | 4817 |        6 | magpie         | 1        | 2021-12-02 08:59:26 |        | 2021-12-02 |         |
        | 4818 |       20 | lennard           | 1        | 2021-12-02 09:02:32 |        | 2021-12-02 |         |
        | 4819 |       57 | albatros         | 1        | 2021-12-02 10:19:25 |        | 2021-12-02 |         |
        +------+----------+----------------+----------+---------------------+--------+------------+---------+
        4819 rows in set (0.003 sec)
        

        It returns a blank page even when I specify a user and the machine they’re assigned to.

        G 1 Reply Last reply Dec 2, 2021, 5:49 PM Reply Quote 0
        • G
          george1421 Moderator @altitudehack
          last edited by Dec 2, 2021, 5:49 PM

          @altitudehack First let me say I don’t have an answer to this issue. But i can tell you that php-fpm will only throw an error If there is either a task timeout or there is a problem with the php programming code. I would also inspect the apache error log to see if php-fpm is working like it should but apache is unhappy with the report.

          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!

          A 1 Reply Last reply Dec 2, 2021, 6:00 PM Reply Quote 1
          • A
            altitudehack @george1421
            last edited by Dec 2, 2021, 6:00 PM

            @george1421
            You’re right. Thanks for the tip!

            tail /var/log/httpd/ssl_error_log
            ...
            [Thu Dec 02 11:44:24.766930 2021] [php7:error] [pid 24293] [client my_IP:38154] PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 16384 bytes) in /var/www/html/fog/lib/fog/fogcontroller.class.php on line 260, 
            
            G A 2 Replies Last reply Dec 2, 2021, 6:15 PM Reply Quote 0
            • G
              george1421 Moderator @altitudehack
              last edited by Dec 2, 2021, 6:15 PM

              @altitudehack said in User Tracking search not working:

              So the question is where is there a limit of 134MB? Each php-fpm worker should have a 256MB limit. The issue is the size of what is being reported in the report is larger than a defined buffer. Let me look.

              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!

              G 1 Reply Last reply Dec 2, 2021, 6:26 PM Reply Quote 1
              • A
                altitudehack @altitudehack
                last edited by Dec 2, 2021, 6:23 PM

                I ended up searching for memory_limit in /etc/php*:

                grep -r memory_limit /etc/php*
                

                The two active files were /etc/php.ini and /etc/php-fpm.d/www.conf:

                /etc/php-fpm.d/www.conf:php_admin_value[memory_limit] = 1024M
                /etc/php-fpm.d/www.conf:;php_admin_value[memory_limit] = 256M
                /etc/php.ini:memory_limit = 512M
                /etc/php.ini:;memory_limit = 128M
                

                I duplicated the lines, commented out the original with ;, then quadrupled the values. Restarted the services with:

                systemctl restart httpd
                systemctl restart php-fpm.service
                

                User Tracking queries now work as expected.

                1 Reply Last reply Reply Quote 0
                • G
                  george1421 Moderator @george1421
                  last edited by george1421 Dec 2, 2021, 12:28 PM Dec 2, 2021, 6:26 PM

                  @george1421 On the fog server linux console lets do this.

                  cd /etc
                  find ./ -name www.conf
                  

                  Find should return with some path to the config file
                  ./php-fpm.d/www.conf

                  Lets edit that file. I can’t give you the exact path because the config file moves depending on the version of php that’s installed.

                  Search for php_admin_value[memory_limit] and make sure its set to 256MB

                  php_admin_value[memory_limit] = 256M
                  

                  Make the change and reboot the server (easy) or restart php-fpm (slightly harder)

                  Edit: OK I’m too slow between telephone calls and users stopping by. Looks like you hit the right area. Just watch out for RAM exhaustion if you bump the values up too high. The php-fpm process has up to 35 workers defined.

                  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!

                  A 1 Reply Last reply Dec 2, 2021, 8:01 PM Reply Quote 1
                  • A
                    altitudehack @george1421
                    last edited by Dec 2, 2021, 8:01 PM

                    @george1421 How the heck do I mark the answer as solved on the forum?

                    G 1 Reply Last reply Dec 2, 2021, 10:52 PM Reply Quote 0
                    • G
                      george1421 Moderator @altitudehack
                      last edited by george1421 Dec 2, 2021, 4:53 PM Dec 2, 2021, 10:52 PM

                      @altitudehack The forum is a bit strange. You have to go into the forum post settings (little gear on original post) then set to ask as question. Once that is done you can mark the entire thread solved or pick the post with the right answer. I don’t know why the forum doesn’t default to every OP needs to be asked as a question. But it is what it is. I took care of it for you.

                      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!

                      A 1 Reply Last reply Dec 2, 2021, 11:19 PM Reply Quote 1
                      • A
                        altitudehack @george1421
                        last edited by Dec 2, 2021, 11:19 PM

                        @george1421 said in User Tracking search not working:

                        little gear on original post

                        I see no gear or settings on the original post, leading me to believe this is a moderator-only feature. Thank you for marking the solution!

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        1 / 1
                        • First post
                          4/10
                          Last post

                        206

                        Online

                        12.0k

                        Users

                        17.3k

                        Topics

                        155.2k

                        Posts
                        Copyright © 2012-2024 FOG Project