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

don garbage dongarbage at hotmail.com
Tue Nov 14 08:26:22 EST 2006


Hi all,

Please help, I'm still stuck.
Anyone have any further thoughts on this one?

Thanks very much,
Don


>From: "don garbage" <dongarbage at hotmail.com>
>To: dongarbage at hotmail.com
>CC: rt-users at lists.bestpractical.com
>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>Date: Sat, 11 Nov 2006 16:01:19 +0000
>
>Still need some help from rt-user land. Please :)
>
>Here's the state of affairs for my problem:
>- Remote users are having problems with remote access to RT system. Most 
>accesses stall with only a third of the page loading. From what I can tell, 
>this happens for all types of accesses, whether its just clicking on a 
>ticket or updating, or creating.
>- I installed and enabled fastcgi.
>- My postgres sql log file is identical for a successful access as it is 
>for a stalled access. So, the problem has to be on the return trip of the 
>data.
>- What happens in RT after the postgres data has been queried? And, how can 
>I track it?
>- Note, that I'd like to track the simplest case of clicking on a ticket 
>and then having it display (the RT log will not display this info).
>
>For your convenience, I am attaching my conf files.
>
>Thanks so much for any help,
>don
>
>
>>From: "don garbage" <dongarbage at hotmail.com>
>>To: r at elhames.co.uk, rfh at pipex.net
>>CC: rt-users at lists.bestpractical.com
>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>Date: Thu, 09 Nov 2006 23:29:46 +0000
>>
>>hi Roy,
>>
>>Yep. In RT_SiteConfig.pm, I added this line:
>>     Set($LogToFile      , 'debug');
>>RT_Config.pm has these values already set:
>>     Set($LogToSyslog    , 'debug');
>>     Set($LogToScreen    , 'error');
>>     Set($LogToFile      , undef);
>>     Set($LogDir, '/var/log/request-tracker3.4');
>>     Set($LogToFileNamed , "rt.log");    #log to rt.log
>>It is my understanding that RT_SiteConfig.pm settings override those set 
>>in RT_Config.pm. I get nothing other than user login messages in the 
>>rt.log file.
>>There has to be another setting somewhere. Any suggestions?
>>
>>And, yes, I also logged queries. The postgres log is identical for both 
>>the successful ticket access and the stalled ticket access. So, the 
>>problem has to be somewhere between the query being made and the data 
>>being sent to the remote user.
>>
>>How can I track this?
>>
>>We must be getting closer :)
>>
>>thanks,
>>Don
>>
>>
>>>From: "Raed El-hames" <r at elhames.co.uk>
>>>To: "don garbage" <dongarbage at hotmail.com>,<rfh at pipex.net>
>>>CC: <rt-users at lists.bestpractical.com>
>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>Date: Thu, 9 Nov 2006 22:15:51 -0000
>>>
>>>Don;
>>>Thats odd , the 3 lines in RT_SiteConfig is all you needed to change, you 
>>>did restart apache??
>>>Also have you started logging the sql queries??
>>>Roy
>>>
>>>----- Original Message ----- From: "don garbage" <dongarbage at hotmail.com>
>>>To: <dongarbage at hotmail.com>; <rfh at pipex.net>
>>>Cc: <rt-users at lists.bestpractical.com>
>>>Sent: Thursday, November 09, 2006 7:34 PM
>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>
>>>
>>>>Ok, after googling, I got the fruit machine analogy :).
>>>>
>>>>My rt log is obviously not spitting out much info.
>>>>Are there other settings I have to configure in order to see the log 
>>>>file scroll like a fruit machine? (note that I don't see any messages in 
>>>>the log file when I access RT locally with no access problems)
>>>>
>>>>Thanks,
>>>>Don
>>>>
>>>>
>>>>>From: "don garbage" <dongarbage at hotmail.com>
>>>>>To: rfh at pipex.net
>>>>>CC: rt-users at lists.bestpractical.com
>>>>>Subject: Re: [rt-users] Please help: RT3.4.4 running really slow
>>>>>Date: Thu, 09 Nov 2006 19:22:40 +0000
>>>>>
>>>>>Roy,
>>>>>
>>>>>The "connection reset by peer" messages come from me clicking the X 
>>>>>button in my browser.
>>>>>
>>>>>I don't get the "fruit machine" analogy" .. what do you mean?
>>>>>
>>>>>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 18:33:58 +0000
>>>>>>
>>>>>>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
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>_______________________________________________
>>>>>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
>>>>
>>>>
>>>>--
>>>>No virus found in this incoming message.
>>>>Checked by AVG Free Edition.
>>>>Version: 7.1.409 / Virus Database: 268.14.1/527 - Release Date: 
>>>>11/9/2006
>>>>
>>>>
>>>
>>
>>
>>_______________________________________________
>>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
>


><< apache2.conf >>


><< apache2-modperl2.conf >>


><< RT_SiteConfig.pm >>


><< ssl >>





More information about the rt-users mailing list