[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