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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <rt-users@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" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: rt-users@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 <[EMAIL PROTECTED]>
To: don garbage <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], rt-users@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 <[EMAIL PROTECTED]>
To: don garbage <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], rt-users@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 <[EMAIL PROTECTED]>
To: don garbage <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], rt-users@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" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: rt-users@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" <[EMAIL PROTECTED]>
To: don garbage <[EMAIL PROTECTED]>
CC: rt-users@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com