[rt-users] Please help: RT3.4.4 running really slow
don garbage
dongarbage at hotmail.com
Thu Nov 9 18:29:46 EST 2006
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
>>
>>
>
More information about the rt-users
mailing list