Empty stats page

Moderator: crythias

Locked
wsouto
Znuny newbie
Posts: 6
Joined: 21 Oct 2013, 19:20
Znuny Version: 3.3.0beta4
Real Name: Walter Souto
Company: Secretaria de Estado de Saúde de Goiás

Empty stats page

Post by wsouto »

Hi,

From time to time the stats page gets empty until I run the:

Code: Select all

bin/otrs.DeleteCache.pl
After cleaning the cache the stats list shows again normally. I have no clue what can be happen. I'm using nginx and could be something related to its configuration. Maybe somebody have saw this happens before and might have some clue.

Here is my nginx configuration:

Code: Select all

server {
    server_name otrs.my-company.net;

    # These 2 lines were necessary to prevent buffer problems in OTRS
    fastcgi_buffers 128 64k;
    fastcgi_buffer_size 64k;

    root /opt/otrs/var/httpd/htdocs;
    access_log /var/log/nginx/otrs-access.log;
    error_log /var/log/nginx/otrs-error.log;

    location = /favicon.ico {
        access_log     off;
        log_not_found  off;
    }
    location ~ ^/$ {
        rewrite ^(.*)$ http://otrs.my-company.net/otrs/index.pl redirect;
    }
    location /otrs-web {
        gzip on;
        alias /opt/otrs/var/httpd/htdocs;
    }
    location ~ ^/otrs/(.*\.pl)(/.*)?$ {
        gzip off;
        fastcgi_pass  unix:/var/run/fcgiwrap.socket;
        fastcgi_index index.pl;
        fastcgi_param SCRIPT_FILENAME /opt/otrs/bin/fcgi-bin/$1;
        include /etc/nginx/fastcgi_params;
    }
}
And the fastcgi_params:

Code: Select all

fastcgi_param   QUERY_STRING            $query_string;
fastcgi_param   REQUEST_METHOD          $request_method;
fastcgi_param   CONTENT_TYPE            $content_type;
fastcgi_param   CONTENT_LENGTH          $content_length;

fastcgi_param   SCRIPT_FILENAME         $request_filename;
fastcgi_param   SCRIPT_NAME             $fastcgi_script_name;
fastcgi_param   REQUEST_URI             $request_uri;
fastcgi_param   DOCUMENT_URI            $document_uri;
fastcgi_param   DOCUMENT_ROOT           $document_root;
fastcgi_param   SERVER_PROTOCOL         $server_protocol;

fastcgi_param   GATEWAY_INTERFACE       CGI/1.1;
fastcgi_param   SERVER_SOFTWARE         nginx/$nginx_version;

fastcgi_param   REMOTE_ADDR             $remote_addr;
fastcgi_param   REMOTE_PORT             $remote_port;
fastcgi_param   SERVER_ADDR             $server_addr;
fastcgi_param   SERVER_PORT             $server_port;
fastcgi_param   SERVER_NAME             $server_name;

fastcgi_param   HTTPS                   $https;

# PHP only, required if PHP was built with --enable-force-cgi-redirect
fastcgi_param   REDIRECT_STATUS         200;
The fastcgi_params are separated because it's how ubuntu installs it. I just put what is needed in the nginx configuration.
I'm using OTRS 3.3.2.

Any insight will be much appreciated.
TIA,
--
Walter.
yuri0001
Znuny superhero
Posts: 630
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: Empty stats page

Post by yuri0001 »

Hi!
First insight is to upgrade to 3.3.4 :?
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: Empty stats page

Post by reneeb »

what do the logs (nginx-log and OTRS log) say?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
wsouto
Znuny newbie
Posts: 6
Joined: 21 Oct 2013, 19:20
Znuny Version: 3.3.0beta4
Real Name: Walter Souto
Company: Secretaria de Estado de Saúde de Goiás

Re: Empty stats page

Post by wsouto »

yuri0001 wrote:Hi!
First insight is to upgrade to 3.3.4 :?
Right. I'll do that and see if the problem persists.
wsouto
Znuny newbie
Posts: 6
Joined: 21 Oct 2013, 19:20
Znuny Version: 3.3.0beta4
Real Name: Walter Souto
Company: Secretaria de Estado de Saúde de Goiás

Re: Empty stats page

Post by wsouto »

reneeb wrote:what do the logs (nginx-log and OTRS log) say?
I have no errors on error log.
I can't identify anything related, or better, that I can relate to this on access log.

I trying to determine when this happen and why, I mean if have something that I do using the system that cause this. Until now I can't relate anything to this. The stats list is there now, and if look sometime after, it could be there or not...

I better upgrade to 3.3.4 first and go from there. I just need to carry some customizations that I made, including some translations what could take a little time and I'll report back here if I find something.

Thanks.
yuri0001
Znuny superhero
Posts: 630
Joined: 17 Mar 2011, 14:40
Znuny Version: 5.0.6
Real Name: Yuri Kolesnikov
Location: Russia

Re: Empty stats page

Post by yuri0001 »

In addition. Try to execute DeleteCache, when they not displayed and try again. In some cases it work.
Best regards Yuri Kolesnikov
OTRS 5.0.14, ITSM 5.0.14
SUSE 13.2, MariaDB 10.0.22(productive)
OTRS 5.0.14, ITSM 5.0.14(test)
Locked