[rt-users] Please help: RT3.4.4 running really slow

Roy El-Hames rfh at pipex.net
Thu Nov 9 13:33:58 EST 2006


I think debug is the most verbose you get, in my case the home page 
alone scroll the screen like a fruit machine when logging set to debug.
BTW "Connection reset by peer" does not sound very healthy and again it 
suggest me a network or TCP/IP stack issue, ahh or your sql server 
(postgress) is giving up on you,
have you checked the the state of the sql server, restarted it ??
Roy

don garbage wrote:
> Roy,
>
> Are there more logging "levels" for $LogToFile other than 'debug'? All 
> I see in the rt.log file are occassional "Connection reset by peer" 
> messages. Or, is there a way to make RT be more verbose about what its 
> doing?
>
> Thanks,
> Don
>
>
>> From: Roy El-Hames <rfh at pipex.net>
>> To: don garbage <dongarbage at hotmail.com>
>> CC: blkline at attglobal.net, rt-users at lists.bestpractical.com
>> Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>> Date: Thu, 09 Nov 2006 17:26:40 +0000
>>
>> Don;
>> If you have n't already done so, set up your RT logging to debug; (in 
>> RT_SiteConfig under Logging
>> Set($LogToFile      , 'debug');
>> Set($LogDir, '/var/log/rt3');
>> Set($LogToFileNamed , "rt.log");    #log to rt.log
>> make sure the web user and group have write access to that file, and 
>> restart the web server)
>> then you can tail -f  /var/log/rt3/rt.log to see whats happening in 
>> RT as requests are coming through.
>> I also suggest you enabled full logging on your database server, 
>> sorry I am not sure how to do that for postgress , once you done that 
>> again tail -f the sql logging file ..
>> If these do n't help start using tcpdump to check whats happening to 
>> the traffic, also I think you can enable full logging on apache.
>> Good luck;
>> Roy
>>
>> don garbage wrote:
>>> Roy,
>>>
>>> I thought the same. So, I created several web pages (some copied 
>>> exactly from RT tickets). And, remote users have no problems loading 
>>> those pages. I tested it remotely by clicking on those pages over 
>>> and over without ever seeing a page stall.
>>>
>>> It seems as though RT is sending just some of the data for a ticket, 
>>> then stalling since only part of the page loads. Its like some part 
>>> of the query didn't happen or stalled or got lost. Are the RT pages 
>>> sent in pieces? How can I track what happens on the RT server end as 
>>> a query comes in (a ticket is clicked on)?
>>>
>>> Thanks,
>>> Don
>>>
>>>
>>>
>>>
>>>> From: Roy El-Hames <rfh at pipex.net>
>>>> To: don garbage <dongarbage at hotmail.com>
>>>> CC: blkline at attglobal.net, rt-users at lists.bestpractical.com
>>>> Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>> Date: Thu, 09 Nov 2006 16:14:52 +0000
>>>>
>>>> Don;
>>>> That suggest to me that you may have network issues?? have you 
>>>> checked your NIC and did a traceroute or ping to your RT web server .
>>>> Roy
>>>>
>>>> don garbage wrote:
>>>>> I'm still having the problem and getting desparate.
>>>>>
>>>>> I determined that I did not have fastcgi enabled. So, I did the 
>>>>> following:
>>>>>
>>>>>    sudo apt-get install libapache2-mod-fastcgi
>>>>>    sudo apt-get install libcgi-fast-perl
>>>>>    sudo a2enmod fastcgi
>>>>>    sudo ln -s /etc/request-tracker3.4/apache-fastcgi.conf 
>>>>> /etc/apache2/conf.d/
>>>>>    edit /etc/request-tracker3.4/apache-fastcgi.conf:
>>>>>        #FastCgiIpcDir /var/run/fastcgi
>>>>>        RedirectMatch ^/rt$ /rt/
>>>>>    sudo chown www-data: /etc/request-tracker3.4/RT_SiteConfig.pm
>>>>>
>>>>> this has enabled fastcgi. I also restarted apache2 and postgres.
>>>>> But, I still have the same problem. For more than half of the 
>>>>> tickets that remote users try to access, the page stalls half way 
>>>>> through loading. I notice that when I access RT from localhost, 
>>>>> its very fast and pages never stall.
>>>>>
>>>>> Any help is so very appreciated,
>>>>> Don
>>>>>
>>>>>
>>>>>
>>>>>> From: "don garbage" <dongarbage at hotmail.com>
>>>>>> To: blkline at attglobal.net
>>>>>> CC: rt-users at lists.bestpractical.com
>>>>>> Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>> Date: Wed, 08 Nov 2006 15:23:46 +0000
>>>>>>
>>>>>> Barry,
>>>>>>
>>>>>> I know fcgi is installed, I'm not sure fcgi is enabled. At the 
>>>>>> moment, I'm trying to get server-info working, and will report 
>>>>>> back as soon as it is.
>>>>>>
>>>>>> Also, there are a bunch of symbolic links in 
>>>>>> /etc/apache2/mods-enabled/:
>>>>>>
>>>>>>   /etc/apache2/mods-enabled/ssl.conf -> 
>>>>>> /etc/apache2/mods-available/ssl.conf
>>>>>>   /etc/apache2/mods-enabled/ssl.load -> 
>>>>>> /etc/apache2/mods-available/ssl.load
>>>>>>   /etc/apache2/mods-enabled/rewrite.load -> 
>>>>>> ../mods-available/rewrite.load
>>>>>>   /etc/apache2/mods-enabled/perl.conf -> 
>>>>>> /etc/apache2/mods-available/perl.conf
>>>>>>   /etc/apache2/mods-enabled/perl.load -> 
>>>>>> /etc/apache2/mods-available/perl.load
>>>>>>   /etc/apache2/mods-enabled/cgid.conf -> 
>>>>>> /etc/apache2/mods-available/cgid.conf
>>>>>>   /etc/apache2/mods-enabled/cgid.load -> 
>>>>>> /etc/apache2/mods-available/cgid.load
>>>>>>   /etc/apache2/mods-enabled/userdir.conf -> 
>>>>>> /etc/apache2/mods-available/userdir.conf
>>>>>>   /etc/apache2/mods-enabled/userdir.load -> 
>>>>>> /etc/apache2/mods-available/userdir.load
>>>>>>
>>>>>> Here's the cat of those files:
>>>>>> ::::::::::::::
>>>>>> cgid.conf
>>>>>> ::::::::::::::
>>>>>> # Socket thingy for CGI.
>>>>>> ScriptSock /var/run/apache2/cgisock
>>>>>> ::::::::::::::
>>>>>> cgid.load
>>>>>> ::::::::::::::
>>>>>> LoadModule cgid_module /usr/lib/apache2/modules/mod_cgid.so
>>>>>> ::::::::::::::
>>>>>> perl.conf
>>>>>> ::::::::::::::
>>>>>> # This file is a placeholder; you can safely ignore or delete it.
>>>>>> ::::::::::::::
>>>>>> perl.load
>>>>>> ::::::::::::::
>>>>>> LoadModule perl_module /usr/lib/apache2/modules/mod_perl.so
>>>>>> ::::::::::::::
>>>>>> rewrite.load
>>>>>> ::::::::::::::
>>>>>> LoadModule rewrite_module /usr/lib/apache2/modules/mod_rewrite.so
>>>>>> ::::::::::::::
>>>>>> ssl.conf
>>>>>> ::::::::::::::
>>>>>> <IfModule mod_ssl.c>
>>>>>> SSLRandomSeed startup builtin
>>>>>> SSLRandomSeed connect builtin
>>>>>> AddType application/x-x509-ca-cert .crt
>>>>>> AddType application/x-pkcs7-crl    .crl
>>>>>> SSLPassPhraseDialog  builtin
>>>>>> SSLSessionCache         dbm:/var/run/apache2/ssl_scache
>>>>>> SSLSessionCacheTimeout  300
>>>>>>
>>>>>> SSLMutex  file:/var/run/apache2/ssl_mutex
>>>>>> SSLCipherSuite 
>>>>>> ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL
>>>>>>
>>>>>> SetEnvIf User-Agent ".*MSIE.*" \
>>>>>>         nokeepalive ssl-unclean-shutdown \
>>>>>>         downgrade-1.0 force-response-1.0
>>>>>> </IfModule>
>>>>>> ::::::::::::::
>>>>>> ssl.load
>>>>>> ::::::::::::::
>>>>>> LoadModule ssl_module /usr/lib/apache2/modules/mod_ssl.so
>>>>>> ::::::::::::::
>>>>>> userdir.conf
>>>>>> ::::::::::::::
>>>>>> <IfModule mod_userdir.c>
>>>>>>        UserDir public_html
>>>>>>        UserDir disabled root
>>>>>>
>>>>>>        <Directory /home/*/public_html>
>>>>>>                AllowOverride FileInfo AuthConfig Limit
>>>>>>                Options MultiViews Indexes SymLinksIfOwnerMatch 
>>>>>> IncludesNoExec
>>>>>>        </Directory>
>>>>>> </IfModule>
>>>>>> ::::::::::::::
>>>>>> userdir.load
>>>>>> ::::::::::::::
>>>>>> LoadModule userdir_module /usr/lib/apache2/modules/mod_userdir.so
>>>>>>
>>>>>>
>>>>>> Thanks so very much for your help,
>>>>>> Don
>>>>>>
>>>>>>
>>>>>>> From: "Barry L. Kline" <blkline at attglobal.net>
>>>>>>> To: don garbage <dongarbage at hotmail.com>
>>>>>>> CC: rt-users at lists.bestpractical.com
>>>>>>> Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>>> Date: Tue, 07 Nov 2006 14:14:27 -0500
>>>>>>>
>>>>>>> -----BEGIN PGP SIGNED MESSAGE-----
>>>>>>> Hash: SHA1
>>>>>>>
>>>>>>> don garbage wrote:
>>>>>>> > Hey Barry,
>>>>>>> >
>>>>>>> > Wow, that was fast, thanks so much.
>>>>>>> >
>>>>>>> > I actually did respond to your email. Here was my reply:
>>>>>>> >     Hi Barry,
>>>>>>> >
>>>>>>> >     I just checked again for mod_fastcgi, and, it appears that 
>>>>>>> I do have
>>>>>>> > it. In ubuntu, it is called
>>>>>>> >           libfcgi-perl
>>>>>>> >
>>>>>>> >     So, back to the drawing board. :)
>>>>>>> >
>>>>>>> >     Have you had the chance to check out my config files?
>>>>>>> >
>>>>>>> >     Thanks for any further help,
>>>>>>> >     Don
>>>>>>> >
>>>>>>> > Perhaps the problem is in my config files. Any thoughts?
>>>>>>>
>>>>>>> I also see this in your file:
>>>>>>>
>>>>>>> Include /etc/apache2/mods-enabled/*.load
>>>>>>> Include /etc/apache2/mods-enabled/*.conf
>>>>>>>
>>>>>>> What files are in this directory?
>>>>>>>
>>>>>>> Are you *sure* that the fcgi is enabled?  The easiest way I know 
>>>>>>> for you
>>>>>>> to check is to enable /server-status & /server-info in the 
>>>>>>> configuration
>>>>>>> file.  You can then check it via:  
>>>>>>> http://yourrtserver/server-info and
>>>>>>> look for the appropriate modules.
>>>>>>>
>>>>>>> Barry
>>>>>>> -----BEGIN PGP SIGNATURE-----
>>>>>>> Version: GnuPG v1.2.6 (GNU/Linux)
>>>>>>>
>>>>>>> iD8DBQFFUNsTCFu3bIiwtTARAumMAJwPBfRVFFD1/6hv3wbIROkICSI+yQCeMLKn
>>>>>>> /wGZejCJG9dZIVXLOjvr430=
>>>>>>> =Oi4y
>>>>>>> -----END PGP SIGNATURE-----
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>>
>>>>>> Community help: http://wiki.bestpractical.com
>>>>>> Commercial support: sales at bestpractical.com
>>>>>>
>>>>>>
>>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly 
>>>>>> Media. Buy a copy at http://rtbook.bestpractical.com
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>
>>>>> Community help: http://wiki.bestpractical.com
>>>>> Commercial support: sales at bestpractical.com
>>>>>
>>>>>
>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly 
>>>>> Media. Buy a copy at http://rtbook.bestpractical.com
>>>>>
>>>>
>>>
>>>
>>>
>>
>
>
>




More information about the rt-users mailing list