[rt-users] Please help: RT3.4.4 running really slow
Raed El-hames
r at elhames.co.uk
Thu Nov 9 17:15:51 EST 2006
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
>
>
More information about the rt-users
mailing list