Hi all, Please help, I'm still stuck. Anyone have any further thoughts on this one?
Thanks very much, 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: 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, donFrom: "don garbage" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [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 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.logIt 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, DonFrom: "Raed El-hames" <[EMAIL PROTECTED]> To: "don garbage" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> CC: <rt-users@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" <[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 slowOk, 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, DonFrom: "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, donFrom: 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 +0000I 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, DonFrom: 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 LoggingSet($LogToFile , 'debug'); Set($LogDir, '/var/log/rt3'); Set($LogToFileNamed , "rt.log"); #log to rt.logmake 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, DonFrom: 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 fastcgisudo 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, DonFrom: "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.loadHere'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_mutexSSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULLSetEnvIf 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 LimitOptions MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec</Directory> </IfModule> :::::::::::::: userdir.load ::::::::::::::LoadModule userdir_module /usr/lib/apache2/modules/mod_userdir.soThanks so very much for your help, DonFrom: "Barry L. Kline" <[EMAIL PROTECTED]> To: don garbage <[EMAIL PROTECTED]> CC: rt-users@lists.bestpractical.comSubject: Re: [rt-users] Please help: RT3.4.4 running really slowDate: 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 > Ido 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 andlook 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
<< apache2.conf >>
<< apache2-modperl2.conf >>
<< RT_SiteConfig.pm >>
<< ssl >>
_______________________________________________ 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