https://rt-wiki.bestpractical.com/index.php?title=TroubleShooting&feed=atom&action=historyTroubleShooting - Revision history2024-03-28T11:19:35ZRevision history for this page on the wikiMediaWiki 1.37.2https://rt-wiki.bestpractical.com/index.php?title=TroubleShooting&diff=3986&oldid=prevAdmin: 6 revisions imported2016-04-06T20:39:34Z<p>6 revisions imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:39, 6 April 2016</td>
</tr>
<!-- diff cache key bestpractical_mediawiki1459887241:diff::1.12:old-3985:rev-3986 -->
</table>Adminhttps://rt-wiki.bestpractical.com/index.php?title=TroubleShooting&diff=3985&oldid=prev81.56.150.182: /* Continuous login */2013-04-16T14:50:50Z<p><span dir="auto"><span class="autocomment">Continuous login</span></span></p>
<p><b>New page</b></p><div>= Troubleshooting RT =<br />
<br />
== Introduction ==<br />
<br />
I'm starting this section on the wiki in order to try to gather some of the various troubleshooting information that I've been running across from various locations. The reason I want to regurgitate it here is that I am finding many of the links from the search engines are starting to get stale and many of them are dead-ending. Hopefully we can preserve them in this repository.<br />
<br />
- [[MichaelErana]]<br />
<br />
== Perl Related ==<br />
<br />
=== Can't locate object method "boot" via package "mod_perl" ===<br />
<br />
I recently ran into the following error:<br />
<br />
[Tue Jun 21 09:09:30 2005] [[error]] Can't locate object method "boot" via package "mod_perl" at /usr/lib/perl5/Apache/Constants.pm line 8. Compilation failed in require at /usr/lib/perl5/Apache.pm line 6. BEGIN failed--compilation aborted at /usr/lib/perl5/Apache.pm line 6. Compilation failed in require at /usr/share /perl/5.8/CGI.pm line 191. Compilation failed in require at /usr/share/request- tracker3.4/libexec/webmux.pl line 56. BEGIN failed--compilation aborted at /usr/share/request-tracker3.4/libexec/webmux.pl line 56. Compilation failed in require at (eval 3) line 1.<br />
<br />
[Tue Jun 21 09:09:30 2005] [[error]] Can't load Perl file: /usr/share/request-tracker3.4/libexec/webmux.pl for server rt.company.com:0, exiting...<br />
<br />
This was just after some updates to a Debian Stable installation. I read several posts about some problems with mod-perl2 on Apache2 and the suggested fix was to do a search and replace to change all occurances of "Apache::" to "Apache2::"<br />
<br />
I really wanted to avoid code mods so I went for the lowest common denominator. I renamed the old Apache.pm and then just linked /usr/lib/perl5/Apache.pm to /usr/lib/perl5/Apache2.pm. This got the server back up and working. I suspect that there will be issues with some module specifics later but I am hoping that the RT Dist will also come up with ways to cope with that internally.<br />
<br />
- [[MichaelErana]]<br />
<br />
Change occurrences in which files?<br />
<br />
=== Can't locate Apache/Response.pm in @INC ... Can't load Perl file: bin/webmux.pl for server localhost:0, exiting... ===<br />
<br />
Found this issue in Aurora SPARC Linux 2.0 (Fedora Core 3 for SPARC) when trying to install... turns out that after installing all the modules for rt, I '''still''' had an ancient verion of CGI.pm, which was not intended to correctly detect the mod_perl2 modules vs. regular mod_perl. Upgrading CGI via CPAN quickly resolved this problem after an embarrassing number of hours troubleshooting.<br />
<br />
If Apache refuses to start after you add [[PerlRequire]] bin/webmux.pl to your config and you're sure you've got a valid mod_perl2 installation, try upgrading CGI to the latest version.<br />
<br />
- Ben<br />
<br />
=== Can't locate Apache2.pm in @INC ... Can't load Perl module Apache2 for server localhost:0, exiting... ===<br />
<br />
A transitional version of <code>mod_perl2</code> (version 1.99) broke many things on its way to being stable. Some instructions scattered throughout this wiki (including some on this page) still refer to the <code>Apache2</code> package when configuring the Apache web server. This package has since become stable and usable, but compatibility options are no longer necessary if the applications that depend on them have been updated to use <code>Apache2</code> modules instead of <code>Apache</code> modules. RT versions since 3.4.4 (feel free to correct this if I'm mistaken) have been updated to take advantage of <code>Apache2</code> with <code>mod_perl2</code>, so references to it in the Apache configuration are no longer necessary.<br />
<br />
Making certain you '''avoid''' using the following lines in the RT section of your Apache configuration will eliminate this error.<br />
<br />
PerlModule Apache2<br />
PerlModule Apache::compat<br />
<br />
- Ed Eaglehouse<br />
<br />
=== Search Page Fails, Other Things Work, after Perl update ===<br />
<br />
After installing a Perl security upgrade (via RPM from "up2date" on RHEL 4), the RT search query builder fails with the following error:<br />
<br />
*Can't locate object method "new" via package "RT::Interface::Web::[[QueryBuilder]]::Tree" at /home/local/rt-3.4.4/share/html/Search/Build.html line 509.*<br />
<br />
Everything had previously been working, and the Perl version was 5.8.5 before and after the upgrade -- all that changed was the build number, so one would think that wouldn't break much.<br />
<br />
Reinstalling [[DBIx]]::[[SearchBuilder]] as recommended elsewhere in this Wiki for a similar problem did not help.<br />
<br />
It took a lot of digging, but the root cause of this problem was found to be an error in [[RedHat]]'s building of the Perl binary, in that they left out support for "weak references", a feature that had been in their previous build. The CPAN-installed Tree::Simple package, used by RT::Interface::Web::[[QueryBuilder]]::Tree, could not construct an instance of itself because it had previously been [http://www.annocpan.org/~STEVAN/Tree-Simple-1.15/lib/Tree/Simple.pm configured to support weak references]. The problem is also described in [http://qs321.pair.com/~monkads/?node_id=481322 another web article].<br />
<br />
I fixed the problem by deleting (from /usr/lib/perl/site_perl/5.8.5/) the "Tree" directory, then using CPAN to reinstall the packages therein. Apparently the reinstallation detected that weak references were no longer valid, and configured Tree::Simple appropriately. I then restarted Apache to make the change effective. You may have to reinstall more than just this one module; I'm not enough of a Perl expert to be sure, and I had already reinstalled other Perl packages in unsuccessful attempts to fix this problem. Thus, I can't be sure if the last change, had it been the '''only''' change, would have done the job by itself.<br />
<br />
- [[ScottCourtney]]<br />
<br />
Same problem, Red Hat Enterprise Linux AS release 4 (Nahant Update 4), same solution, excepting that after deletion of the module, I reinstalled it with:<br />
<br />
&lt;installdir&gt;/rt3/sbin/rt-test-dependencies --with-mysql --with-fastcgi --install<br />
<br />
(Adjust options to suit, obviously...)<br />
<br />
- Benji Wakely<br />
<br />
Same problem with Red Hat Enterprise Linux AS release 4 (Nahant Update 4) but using the script did not work. The solution is to go to cpan and download Tree-Simple-1.14.tar.gz. The newst Tree-simple-1.16 will not compile on RHEL4 with updates but 1.14 compiled and works no problem.<br />
<br />
--Piotr Misztal<br />
<br />
=== RT will not send mail ===<br />
<br />
This is related to the Search Page fails... problem above in that it is another case where missing weak references make RT crash.<br />
<br />
RT 3.6.1 would not send mail because of the references to Scalar::Util::weaken in the code. On a RH AS 4 system, the Scalar::Util module exists but the weaken() function is defined elsewhere in an XS library. The library could be installed via CPAN with<br />
<br />
perl -MCPAN -e 'install "G/GB/GBARR/Scalar-List-Utils-1.18.tar.gz"'<br />
<br />
--[[JasonLander]]<br />
<br />
=== Syslog error 'MDA returned nonzero status 75' when using fetchmail, procmail or similar ===<br />
<br />
Email was no longer being forwarded to the RT queue giving the above error in /var/adm/messages (logged by syslog). I had recently changed the name of one of the queues.<br />
<br />
This is because I had not updated the .fetchmailrc file to reflect the change in queue name. So when the rt-mailgate was called it was going to the old queue which no longer existed.<br />
<br />
If you are using a program such as fetchmail, procmail, maildrop etc. to deliver email to your queue, check the commandline arguments to see if they are still configured for the old queue.<br />
<br />
This may seeme to be a no-brainer for many of you but it was driving me crazy for hours!<br />
<br />
- [[BrendanArnold]]<br />
<br />
A good way to debug this is to run your rt-mailgate incant by hand from the terminal and pipe a single mail into it. By adding the <code>--debug</code> flag, you can get verbose output about what's going wrong. One cause of this can be Apache redirecting rt-mailgate's request somewhere.<br />
<br />
=== 'The page cannot be found' error in Internet Explorer when using SSL connections ===<br />
<br />
IE has problems with certain types of SSL connections, especially during POST and GET operations (i.e. updating a ticket). The following in the mod_ssl FAQ gives a solution.<br />
<br />
http://www.modssl.org/docs/2.8/ssl_faq.html#ToC49<br />
<br />
- [[BrendanArnold]]<br />
<br />
=== Initiation error when starting httpd service, Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98 ===<br />
<br />
--Setup on Centos 4.2 Server per...<br />
<br />
http://wiki.bestpractical.com/index.cgi?RPMInstall<br />
<br />
...using (see INSTALLATION PROCEDURE below)...<br />
<br />
yum install perl-DBD-Pg rt rt-mail-dispatcher mysql-server lynx<br />
<br />
--then after making local configuration changes (see FILE CHANGES and INSTALLATION PROCEUDURE below)...<br />
<br />
/usr/sbin/rt-setup-database --action init --dba root --dba-password contribs.org<br />
<br />
...results in error message...<br />
<br />
Possible unintended interpolation of @network in string at /etc/rt/RT_SiteConfig.pm line 34.<br />
<br />
...and...<br />
<br />
service httpd start<br />
<br />
...results in error message...<br />
<br />
Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98<br />
<br />
--then, after navigating to a private (local) ip and successfully logging on to...<br />
<br />
http://rt.mynetwork.us<br />
<br />
...all links (erroneously?) xref as if [[WebBaseURL]]="", example...<br />
<br />
Preferences links to...<br />
http://User/Prefs.html<br />
<br />
...versus...<br />
<br />
http://rt.mynetwork.us/User/Prefs.html<br />
<br />
--INSTALLATION PROCEDURE<br />
<br />
*** install from repository '''*'''<br />
<br />
0.-setup-from-rt-repo.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
yum update<br />
<br />
wget -nc -nd -S<br />
http://campus.fct.unl.pt/paulomatos/rt/repository/3.4.x/rt-3.4.x.repo<br />
<br />
/bin/mv --force rt-3.4.x.repo /etc/yum.repos.d/<br />
<br />
yum install perl-DBD-Pg rt rt-mail-dispatcher mysql-server lynx<br />
<br />
exit 0<br />
<br />
</nowiki><br />
<br />
1.-backup-files-before-editing.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
/bin/cp -p /etc/aliases{,.orig}<br />
/bin/cp -p /etc/hosts{,.orig}<br />
/bin/cp -p /etc/rt/RT_SiteConfig.pm{,.orig}<br />
/bin/cp -p /etc/httpd/conf.d/rt.conf{,.orig}<br />
/bin/cp -p /etc/httpd/conf/httpd.conf{,.orig}<br />
/bin/cp -p /etc/sysconfig/httpd{,.orig}<br />
/bin/cp -p /etc/mail/sendmail.mc{,.orig}<br />
/bin/cp -p /etc/mail/virtusertable{,.orig}<br />
/bin/cp -p /etc/mail/local-host-names{,.orig}<br />
/bin/cp -p /var/rt/home/.procmailrc{,.orig}<br />
<br />
exit 0<br />
</nowiki><br />
<br />
*** make file changes (make manual edits per FILE CHANGES listed below) '''*'''<br />
<br />
*** incorporate file changes (run following scripts) '''*'''<br />
<br />
2.-setup-users-sendmail-etc.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
pushd /etc/mail<br />
make<br />
popd<br />
<br />
service sendmail restart<br />
<br />
adduser -u 0 -o -g 0 -d /root -s /bin/bash -c admin admin<br />
echo contribs.org | passwd --stdin admin<br />
passwd -S admin<br />
<br />
ln -s /usr/bin/rt-mailgate /etc/smrsh<br />
<br />
newaliases<br />
<br />
</nowiki><br />
<br />
3.-setup-mysql-rt-database.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
service mysqld start<br />
mysqladmin -u root password contribs.org<br />
<br />
chkconfig mysqld on<br />
chkconfig --list | grep mysqld<br />
<br />
/usr/sbin/rt-setup-database --action init<br />
--dba root --dba-password contribs.org<br />
# /usr/sbin/rt-setup-database --action init<br />
# --dba root --prompt-for-dba-password<br />
<br />
</nowiki><br />
<br />
--HERE ARE SOME OTHER USEFUL SCRIPTS...<br />
<br />
90.-drop-rt-database.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
/usr/sbin/rt-setup-database --action drop --dba root --dba-password contribs.org<br />
<br />
</nowiki><br />
<br />
93.-make-patches.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
diff -uN /etc/aliases{.orig,} &gt; patch.aliases<br />
diff -uN /etc/hosts{.orig,} &gt; patch.hosts<br />
diff -uN /etc/rt/RT_SiteConfig.pm{.orig,} &gt; patch.RT_SiteConfig.pm<br />
diff -uN /etc/httpd/conf.d/rt.conf{.orig,} &gt; patch.rt.conf<br />
diff -uN /etc/httpd/conf/httpd.conf{.orig,} &gt; patch.httpd.conf<br />
diff -uN /etc/sysconfig/httpd{.orig,} &gt; patch.httpd<br />
diff -uN /etc/mail/sendmail.mc{.orig,} &gt; patch.sendmail.mc<br />
diff -uN /etc/mail/virtusertable{.orig,} &gt; patch.virtusertable<br />
diff -uN /etc/mail/local-host-names{.orig,} &gt; patch.local-host-names<br />
diff -uN /var/rt/home/.procmailrc{.orig,} &gt; patch..procmailrc<br />
<br />
<br />
</nowiki><br />
<br />
--FILE CHANGES: MADE AFTER BASE CENTOS 4.2 SERVER INSTALL...<br />
<br />
<nowiki>--- /etc/hosts.orig 2006-01-20 15:26:15.000000000 -0500<br />
+++ /etc/hosts 2006-01-20 00:23:45.000000000 -0500<br />
<br />
+192.168.62.21 rt.mynetwork.us rt<br />
+192.168.62.21 www.mynetwork.us www<br />
<br />
--- /etc/aliases.orig 2006-01-20 15:17:05.000000000 -0500<br />
+++ /etc/aliases 2006-01-20 15:15:07.000000000 -0500<br />
<br />
+<br />
+# specify a program to run when mail comes to address correspond<br />
+correspond: "|/usr/bin/rt-mailgate --queue General --action correspond --url http://rt.mynetwork.us/<br />
<br />
--- /etc/sysconfig/httpd.orig 2006-01-05 13:34:38.000000000 -0500<br />
+++ /etc/sysconfig/httpd 2006-01-19 11:31:49.000000000 -0500<br />
-#OPTIONS=<br />
+OPTIONS=-DPerlStatus<br />
<br />
--- /etc/httpd/conf/httpd.conf.orig 2006-01-05 13:34:38.000000000 -0500<br />
+++ /etc/httpd/conf/httpd.conf 2006-01-19 13:17:41.000000000 -0500<br />
<br />
+ServerName www.mynetwork.us:80<br />
<br />
--- /etc/mail/local-host-names.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/local-host-names 2006-01-20 14:38:25.000000000 -0500<br />
<br />
+rt.mynetwork.us<br />
+www.mynetwork.us<br />
<br />
--- /var/rt/home/.procmailrc.orig 2004-05-10 14:52:51.000000000 -0400<br />
+++ /var/rt/home/.procmailrc 2006-01-17 04:52:04.000000000 -0500<br />
<br />
-MAILDOMAIN=rt.yourdomain.com<br />
+MAILDOMAIN=rt.mynetwork.us<br />
<br />
-RT_URL="http://rt.yourdomain.com/"<br />
+RT_URL="http://rt.mynetwork.us/"<br />
<br />
--- /etc/httpd/conf.d/rt.conf.orig 2006-01-12 23:04:31.000000000 -0500<br />
+++ /etc/httpd/conf.d/rt.conf 2006-01-19 23:04:12.000000000 -0500<br />
<br />
-&lt;VirtualHost your.ip.address:80&gt;<br />
- ServerName your.rt.server.hostname<br />
+&lt;VirtualHost 192.168.62.21:80&gt;<br />
+ ServerName rt.mynetwork.us<br />
<br />
-&lt;VirtualHost your.ip.address:443&gt;<br />
- ServerName your.rt.server.hostname<br />
+&lt;VirtualHost 192.168.62.21:443&gt;<br />
+ ServerName rt.mynetwork.us<br />
<br />
--- /etc/rt/RT_SiteConfig.pm.orig 2006-01-12 23:04:30.000000000 -0500<br />
+++ /etc/rt/RT_SiteConfig.pm 2006-01-19 23:39:33.000000000 -0500<br />
<br />
-Set( $rtname, 'example.com');<br />
+Set($rtname, "network_us");<br />
<br />
+Set($Organization , "rt.mynetwork.us");<br />
+Set($Timezone, 'US/Eastern');<br />
+Set($WebBaseURL, "http://rt.mynetwork.us");<br />
+Set($WebPath, "/");<br />
+Set($WebURL , $WebBaseURL . $WebPath . "/");<br />
+<br />
+Set($CorrespondAddress, 'correspond@rt.mynetwork.us');<br />
+Set($CommentAddress, 'comment@rt.mynetwork.us');<br />
+Set($SendmailPath, "/usr/sbin/sendmail");<br />
+Set($SendmailArguments , "-oi -t");<br />
+<br />
+Set($LogToSyslog, '');<br />
+Set($LogToFile, 'debug');<br />
+Set($LogDir, '/var/log/rt');<br />
+Set($LogToFileNamed , "rt.log");<br />
+<br />
+Set($OwnerEmail, "admin@mynetwork.us");<br />
+Set($MyTicketsLength, 20);<br />
+<br />
+Set($DatabasePassword , 'contribs.org');<br />
+<br />
+Set($AmbiguousDayInPast , 0);<br />
+<br />
<br />
1;<br />
<br />
--- /etc/mail/sendmail.mc.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/sendmail.mc 2006-01-17 04:27:10.000000000 -0500<br />
<br />
-DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl<br />
+dnl DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl<br />
<br />
--- /etc/mail/virtusertable.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/virtusertable 2006-01-17 04:56:41.000000000 -0500<br />
<br />
+#<br />
+# This will handle all aliases for all queues. Note that this implies<br />
+# that all queue address are @rt.mynetwork.us<br />
+#<br />
+# Here put your exceptions. Next one made this domain RFC822 compliant.<br />
+postmaster@rt.mynetwork.us postmaster<br />
+<br />
+# leave root as 'root'<br />
+root@rt.mynetwork.us root<br />
+<br />
+# everything else goes to user 'rt'<br />
+@rt.mynetwork.us rt<br />
<br />
<br />
</nowiki><br />
<br />
-Hasan Muhammad<br />
<br />
=== Initiation error when starting httpd service, Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98 ===<br />
<br />
I just wanted to add to this. At least in my case (Linux OS, apache-perl, Apache1/modperl1), this error was being caused by the following line in webmux.pl:<br />
<br />
rmtree([ bsd_glob("$RT::MasonDataDir/obj/*") ], 0, 1);<br />
<br />
"$RT::[[MasonDataDir]]/obj" is a directory, in my case it is this:<br />
<br />
/var/cache/request-tracker3.4/mason_data/obj<br />
<br />
On startup, there are no non-hidden files/directories in this directory. Apparently bsd_glob returns the empty result, and rmtree chokes on that with the "No root path(s)" error. As a workaround, I edited webmux.pl to replace that rmtree line with this:<br />
<br />
my @adir = bsd_glob("$RT::MasonDataDir/obj/*");<br />
if (@adir) {<br />
rmtree([ @adir ], 0, 1);<br />
}<br />
<br />
That got rid of the "No root path(s)" error message.<br />
<br />
- [[MaryaDoery]]<br />
<br />
3.6.0RC3 has it fixed.<br />
<br />
=== Continuous login ===<br />
<br />
I encountered a problem with RT asking me to log in every time I clicked a link. After doing some research, it seemed that the cookie was being sent and set properly. There were two possibilities mentioned:<br />
<br />
* A [[MySQL]] 5.x issue: check your mysql error logs. The session module has been seen to try to connect as [mailto:rt_user@localhost rt_user@localhost] or [mailto:rt_user@127.0.0.1 rt_user@127.0.0.1]<nowiki> instead of rt_user@'' </nowiki><br />
* A table structure issue: take a look at the "sessions" table in the RT database. There should be a column named "a_session". This column must have the type "longblob" not "longtext". Also note that if there are any records in the table, the entire table should be emptied (either before or after making the change), otherwise the problem will persist.<br />
<br />
I personally hit the table structure problem while installing RT 3.6.3 on Gentoo Linux, but since fixing that, everything has been fine.<br />
<br />
- kwgagel<br />
<br />
I hit this problem after upgrading from 3.8.4 to 3.8.7. Kevin Falcone from Best Practical suggested the removal of my /local/html/autohandler file. I renamed the file and restarted the httpd service and the problem vanished.<br />
<br />
- [[DaveIngram]]<br />
<br />
I hit the table structure issue with 3.6.5 on Fedora 8, deleting the table and recreating as longblob fixed. Thanks Dave.<br />
<br />
I found the same thing after running the upgrade script from 3.6.1 &gt;&gt; 3.8.2, change the data type in the db and set the default value to NULL and now is working. Thanks Dave!<br />
<br />
-- [sorry the html goes nuts here: will fix shortly. Rob101]<br />
<br />
The [[MySQL]] SQL I used to correct this problem with RT 3.6.7 on Gentoo was:<br />
<br />
<nowiki>mysql&gt; desc sessions;<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| Field | Type | Null | Key | Default | Extra |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| id | char(32) | NO | PRI | NULL | |<br />
| a_session | longtext | YES | | NULL | |<br />
| LastUpdated | timestamp | NO | | CURRENT_TIMESTAMP | |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
3 rows in set (0.00 sec)<br />
<br />
mysql&gt; alter table sessions modify a_session longblob default NULL;<br />
Query OK, 215 rows affected (0.02 sec)<br />
Records: 215 Duplicates: 0 Warnings: 0<br />
<br />
mysql&gt; delete from sessions;<br />
Query OK, 215 rows affected (0.00 sec)<br />
<br />
mysql&gt; desc sessions;<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| Field | Type | Null | Key | Default | Extra |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| id | char(32) | NO | PRI | NULL | |<br />
| a_session | longblob | YES | | NULL | |<br />
| LastUpdated | timestamp | NO | | CURRENT_TIMESTAMP | |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
3 rows in set (0.00 sec)<br />
<br />
mysql&gt;<br />
<br />
</nowiki><br />
<br />
Sorry if dumping this here was too verbose!<br />
<br />
Rob101 --<br />
<br />
It sure wasn't Rob. I confirmed that this was the answer to a problem for me going from 3.6.x to 3.8.x ... it's feasible that something about my upgrade broke the database upgrade scripts. Either way -- if you are having problems with RT logins happening too much -- the above seems to be the fix! -- [[MGMead]] (PS - I cleaned up the MYSQL session so you can read it more easily)<br />
<br />
<br />
<br />
Happenned to me after restoring a (Postgres) dump from another computer (same RT version, same PG version). Restarting Apache was the solution. RT 4.0.7 on Postgres 9.1, apache2/modperl.<br />
<br />
-- JC Boggio<br />
<br />
=== The dreadful MySQL server has gone away error ===<br />
<br />
I was seeing this error almost every time I create a ticket in one of my queues. If I insisted at least 5 times, the ticket was finally created.<br />
<br />
Searching about this I discovered that the most common reason for this kind or error is data base corruption. I tried checking, repairing and optimizing the database using the mysqlcheck command, but none solved the problem. To be sure I dumped all rt3 database (using mysqldump) e recreated the whole database, but that too did not solve the problem. Nevertheless, some people really got rid of this error using those methods and those could work for you.<br />
<br />
After enabling debug logging on [[RT SiteConfig|RT_SiteConfig]], I saw that the error was occurring much sooner than I thought, because the web interface was only showing the error when the Apache::Session::Lock::[[MySQL]] object was being destroyed.<br />
<br />
Actually, the problem was occurring right after an Scrip [[SendMail]] action and in the logs I could see RT complain about sendmail exiting with status 16384. I checked the scrip saw that the template used had the following in it's first line: To: [mailto:someemail@somedomain.com someemail@somedomain.com];[mailto:otheremail@somedomain.com otheremail@somedomain.com]<br />
<br />
I removed the “;[mailto:otheremail@somedomain.com otheremail@somedomain.com]” part and the problem was gone. I found that to be super strange and totally unrelated, but if you got that error, don't forget to check your templates. I guess there is really a reason for the [[SendMail]] Scrip Action not being enabled by default.<br />
<br />
- dante.<br />
<br />
=== Config file /etc/request-tracker/RT_SiteConfig.pm is locked ===<br />
<br />
(BTW are _all_ of these Perl-related? Or are we just putting them under that heading by default?)<br />
<br />
Got this error ("Config file /etc/request-tracker/RT_SiteConfig.pm is locked") when I fired up request-tracker this morning. Since I had no idea what the cause could be, I asked Google. All the forum entries it pointed me to said that it's because request-tracker can't access MySQL. But on my system this wasn't the case -- MySQL was running fine.<br />
<br />
Checking the logs, I found this intriguing message:<br />
<pre>The WebBaseURL config option requires no trailing slash (/usr/lib/perl5/vendor_perl/5.16.0/RT/Config.pm:708)<br />
</pre><br />
<br />
I checked my <b>RT_SiteConfig.pm</b> and, sure enough, I had a trailing slash in the URL. After removing it and restarting Apache, the error went away.<br />
<br />
- smithfarm</div>81.56.150.182https://rt-wiki.bestpractical.com/index.php?title=TroubleShooting&diff=3980&oldid=prevBillCole at 17:38, 2 March 20102010-03-02T17:38:33Z<p></p>
<p><b>New page</b></p><div>= Troubleshooting RT =<br />
<br />
== Introduction ==<br />
<br />
I'm starting this section on the wiki in order to try to gather some of the various troubleshooting information that I've been running across from various locations. The reason I want to regurgitate it here is that I am finding many of the links from the search engines are starting to get stale and many of them are dead-ending. Hopefully we can preserve them in this repository.<br />
<br />
- [[MichaelErana]]<br />
<br />
== Perl Related ==<br />
<br />
=== Can't locate object method "boot" via package "mod_perl" ===<br />
<br />
I recently ran into the following error:<br />
<br />
[Tue Jun 21 09:09:30 2005] [[error]] Can't locate object method "boot" via package "mod_perl" at /usr/lib/perl5/Apache/Constants.pm line 8. Compilation failed in require at /usr/lib/perl5/Apache.pm line 6. BEGIN failed--compilation aborted at /usr/lib/perl5/Apache.pm line 6. Compilation failed in require at /usr/share /perl/5.8/CGI.pm line 191. Compilation failed in require at /usr/share/request- tracker3.4/libexec/webmux.pl line 56. BEGIN failed--compilation aborted at /usr/share/request-tracker3.4/libexec/webmux.pl line 56. Compilation failed in require at (eval 3) line 1.<br />
<br />
[Tue Jun 21 09:09:30 2005] [[error]] Can't load Perl file: /usr/share/request-tracker3.4/libexec/webmux.pl for server rt.company.com:0, exiting...<br />
<br />
This was just after some updates to a Debian Stable installation. I read several posts about some problems with mod-perl2 on Apache2 and the suggested fix was to do a search and replace to change all occurances of "Apache::" to "Apache2::"<br />
<br />
I really wanted to avoid code mods so I went for the lowest common denominator. I renamed the old Apache.pm and then just linked /usr/lib/perl5/Apache.pm to /usr/lib/perl5/Apache2.pm. This got the server back up and working. I suspect that there will be issues with some module specifics later but I am hoping that the RT Dist will also come up with ways to cope with that internally.<br />
<br />
- [[MichaelErana]]<br />
<br />
Change occurrences in which files?<br />
<br />
=== Can't locate Apache/Response.pm in @INC ... Can't load Perl file: bin/webmux.pl for server localhost:0, exiting... ===<br />
<br />
Found this issue in Aurora SPARC Linux 2.0 (Fedora Core 3 for SPARC) when trying to install... turns out that after installing all the modules for rt, I '''still''' had an ancient verion of CGI.pm, which was not intended to correctly detect the mod_perl2 modules vs. regular mod_perl. Upgrading CGI via CPAN quickly resolved this problem after an embarrassing number of hours troubleshooting.<br />
<br />
If Apache refuses to start after you add [[PerlRequire]] bin/webmux.pl to your config and you're sure you've got a valid mod_perl2 installation, try upgrading CGI to the latest version.<br />
<br />
- Ben<br />
<br />
=== Can't locate Apache2.pm in @INC ... Can't load Perl module Apache2 for server localhost:0, exiting... ===<br />
<br />
A transitional version of <code>mod_perl2</code> (version 1.99) broke many things on its way to being stable. Some instructions scattered throughout this wiki (including some on this page) still refer to the <code>Apache2</code> package when configuring the Apache web server. This package has since become stable and usable, but compatibility options are no longer necessary if the applications that depend on them have been updated to use <code>Apache2</code> modules instead of <code>Apache</code> modules. RT versions since 3.4.4 (feel free to correct this if I'm mistaken) have been updated to take advantage of <code>Apache2</code> with <code>mod_perl2</code>, so references to it in the Apache configuration are no longer necessary.<br />
<br />
Making certain you '''avoid''' using the following lines in the RT section of your Apache configuration will eliminate this error.<br />
<br />
PerlModule Apache2<br />
PerlModule Apache::compat<br />
<br />
<br />
- Ed Eaglehouse<br />
<br />
=== Search Page Fails, Other Things Work, after Perl update ===<br />
<br />
After installing a Perl security upgrade (via RPM from "up2date" on RHEL 4), the RT search query builder fails with the following error:<br />
<br />
*Can't locate object method "new" via package "RT::Interface::Web::[[QueryBuilder]]::Tree" at /home/local/rt-3.4.4/share/html/Search/Build.html line 509.*<br />
<br />
Everything had previously been working, and the Perl version was 5.8.5 before and after the upgrade -- all that changed was the build number, so one would think that wouldn't break much.<br />
<br />
Reinstalling [[DBIx]]::[[SearchBuilder]] as recommended elsewhere in this Wiki for a similar problem did not help.<br />
<br />
It took a lot of digging, but the root cause of this problem was found to be an error in [[RedHat]]'s building of the Perl binary, in that they left out support for "weak references", a feature that had been in their previous build. The CPAN-installed Tree::Simple package, used by RT::Interface::Web::[[QueryBuilder]]::Tree, could not construct an instance of itself because it had previously been [http://www.annocpan.org/~STEVAN/Tree-Simple-1.15/lib/Tree/Simple.pm configured to support weak references]. The problem is also described in [http://qs321.pair.com/~monkads/?node_id=481322 another web article].<br />
<br />
I fixed the problem by deleting (from /usr/lib/perl/site_perl/5.8.5/) the "Tree" directory, then using CPAN to reinstall the packages therein. Apparently the reinstallation detected that weak references were no longer valid, and configured Tree::Simple appropriately. I then restarted Apache to make the change effective. You may have to reinstall more than just this one module; I'm not enough of a Perl expert to be sure, and I had already reinstalled other Perl packages in unsuccessful attempts to fix this problem. Thus, I can't be sure if the last change, had it been the '''only''' change, would have done the job by itself.<br />
<br />
- [[ScottCourtney]]<br />
<br />
Same problem, Red Hat Enterprise Linux AS release 4 (Nahant Update 4), same solution, excepting that after deletion of the module, I reinstalled it with:<br />
<br />
&lt;installdir&gt;/rt3/sbin/rt-test-dependencies --with-mysql --with-fastcgi --install<br />
<br />
(Adjust options to suit, obviously...)<br />
<br />
- Benji Wakely<br />
<br />
Same problem with Red Hat Enterprise Linux AS release 4 (Nahant Update 4) but using the script did not work. The solution is to go to cpan and download Tree-Simple-1.14.tar.gz. The newst Tree-simple-1.16 will not compile on RHEL4 with updates but 1.14 compiled and works no problem.<br />
<br />
--Piotr Misztal<br />
<br />
=== RT will not send mail ===<br />
<br />
This is related to the Search Page fails... problem above in that it is another case where missing weak references make RT crash.<br />
<br />
RT 3.6.1 would not send mail because of the references to Scalar::Util::weaken in the code. On a RH AS 4 system, the Scalar::Util module exists but the weaken() function is defined elsewhere in an XS library. The library could be installed via CPAN with<br />
<br />
perl -MCPAN -e 'install "G/GB/GBARR/Scalar-List-Utils-1.18.tar.gz"'<br />
<br />
<br />
--[[JasonLander]]<br />
<br />
=== Syslog error 'MDA returned nonzero status 75' when using fetchmail, procmail or similar ===<br />
<br />
Email was no longer being forwarded to the RT queue giving the above error in /var/adm/messages (logged by syslog). I had recently changed the name of one of the queues.<br />
<br />
This is because I had not updated the .fetchmailrc file to reflect the change in queue name. So when the rt-mailgate was called it was going to the old queue which no longer existed.<br />
<br />
If you are using a program such as fetchmail, procmail, maildrop etc. to deliver email to your queue, check the commandline arguments to see if they are still configured for the old queue.<br />
<br />
This may seeme to be a no-brainer for many of you but it was driving me crazy for hours!<br />
<br />
- [[BrendanArnold]]<br />
<br />
=== 'The page cannot be found' error in Internet Explorer when using SSL connections ===<br />
<br />
IE has problems with certain types of SSL connections, especially during POST and GET operations (i.e. updating a ticket). The following in the mod_ssl FAQ gives a solution.<br />
<br />
http://www.modssl.org/docs/2.8/ssl_faq.html#ToC49<br />
<br />
- [[BrendanArnold]]<br />
<br />
=== Initiation error when starting httpd service, Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98 ===<br />
<br />
--Setup on Centos 4.2 Server per...<br />
<br />
http://wiki.bestpractical.com/index.cgi?RPMInstall<br />
<br />
...using (see INSTALLATION PROCEDURE below)...<br />
<br />
yum install perl-DBD-Pg rt rt-mail-dispatcher mysql-server lynx<br />
<br />
<br />
--then after making local configuration changes (see FILE CHANGES and INSTALLATION PROCEUDURE below)...<br />
<br />
/usr/sbin/rt-setup-database --action init --dba root --dba-password contribs.org<br />
<br />
...results in error message...<br />
<br />
Possible unintended interpolation of @network in string at /etc/rt/RT_SiteConfig.pm line 34.<br />
<br />
<br />
...and...<br />
<br />
service httpd start<br />
<br />
...results in error message...<br />
<br />
Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98<br />
<br />
<br />
--then, after navigating to a private (local) ip and successfully logging on to...<br />
<br />
http://rt.mynetwork.us<br />
<br />
...all links (erroneously?) xref as if [[WebBaseURL]]="", example...<br />
<br />
Preferences links to...<br />
http://User/Prefs.html<br />
<br />
...versus...<br />
<br />
http://rt.mynetwork.us/User/Prefs.html<br />
<br />
<br />
<br />
--INSTALLATION PROCEDURE<br />
<br />
*** install from repository '''*'''<br />
<br />
0.-setup-from-rt-repo.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
yum update<br />
<br />
wget -nc -nd -S<br />
http://campus.fct.unl.pt/paulomatos/rt/repository/3.4.x/rt-3.4.x.repo<br />
<br />
/bin/mv --force rt-3.4.x.repo /etc/yum.repos.d/<br />
<br />
yum install perl-DBD-Pg rt rt-mail-dispatcher mysql-server lynx<br />
<br />
exit 0<br />
<br />
</nowiki><br />
<br />
1.-backup-files-before-editing.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
/bin/cp -p /etc/aliases{,.orig}<br />
/bin/cp -p /etc/hosts{,.orig}<br />
/bin/cp -p /etc/rt/RT_SiteConfig.pm{,.orig}<br />
/bin/cp -p /etc/httpd/conf.d/rt.conf{,.orig}<br />
/bin/cp -p /etc/httpd/conf/httpd.conf{,.orig}<br />
/bin/cp -p /etc/sysconfig/httpd{,.orig}<br />
/bin/cp -p /etc/mail/sendmail.mc{,.orig}<br />
/bin/cp -p /etc/mail/virtusertable{,.orig}<br />
/bin/cp -p /etc/mail/local-host-names{,.orig}<br />
/bin/cp -p /var/rt/home/.procmailrc{,.orig}<br />
<br />
exit 0<br />
</nowiki><br />
<br />
*** make file changes (make manual edits per FILE CHANGES listed below) '''*'''<br />
<br />
*** incorporate file changes (run following scripts) '''*'''<br />
<br />
2.-setup-users-sendmail-etc.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
pushd /etc/mail<br />
make<br />
popd<br />
<br />
service sendmail restart<br />
<br />
adduser -u 0 -o -g 0 -d /root -s /bin/bash -c admin admin<br />
echo contribs.org | passwd --stdin admin<br />
passwd -S admin<br />
<br />
ln -s /usr/bin/rt-mailgate /etc/smrsh<br />
<br />
newaliases<br />
<br />
</nowiki><br />
<br />
3.-setup-mysql-rt-database.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
service mysqld start<br />
mysqladmin -u root password contribs.org<br />
<br />
chkconfig mysqld on<br />
chkconfig --list | grep mysqld<br />
<br />
/usr/sbin/rt-setup-database --action init<br />
--dba root --dba-password contribs.org<br />
# /usr/sbin/rt-setup-database --action init<br />
# --dba root --prompt-for-dba-password<br />
<br />
</nowiki><br />
<br />
--HERE ARE SOME OTHER USEFUL SCRIPTS...<br />
<br />
90.-drop-rt-database.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
/usr/sbin/rt-setup-database --action drop --dba root --dba-password contribs.org<br />
<br />
</nowiki><br />
<br />
93.-make-patches.sh<br />
<br />
<nowiki>#!/bin/bash<br />
<br />
diff -uN /etc/aliases{.orig,} &gt; patch.aliases<br />
diff -uN /etc/hosts{.orig,} &gt; patch.hosts<br />
diff -uN /etc/rt/RT_SiteConfig.pm{.orig,} &gt; patch.RT_SiteConfig.pm<br />
diff -uN /etc/httpd/conf.d/rt.conf{.orig,} &gt; patch.rt.conf<br />
diff -uN /etc/httpd/conf/httpd.conf{.orig,} &gt; patch.httpd.conf<br />
diff -uN /etc/sysconfig/httpd{.orig,} &gt; patch.httpd<br />
diff -uN /etc/mail/sendmail.mc{.orig,} &gt; patch.sendmail.mc<br />
diff -uN /etc/mail/virtusertable{.orig,} &gt; patch.virtusertable<br />
diff -uN /etc/mail/local-host-names{.orig,} &gt; patch.local-host-names<br />
diff -uN /var/rt/home/.procmailrc{.orig,} &gt; patch..procmailrc<br />
<br />
<br />
</nowiki><br />
<br />
--FILE CHANGES: MADE AFTER BASE CENTOS 4.2 SERVER INSTALL...<br />
<br />
<nowiki>--- /etc/hosts.orig 2006-01-20 15:26:15.000000000 -0500<br />
+++ /etc/hosts 2006-01-20 00:23:45.000000000 -0500<br />
<br />
+192.168.62.21 rt.mynetwork.us rt<br />
+192.168.62.21 www.mynetwork.us www<br />
<br />
--- /etc/aliases.orig 2006-01-20 15:17:05.000000000 -0500<br />
+++ /etc/aliases 2006-01-20 15:15:07.000000000 -0500<br />
<br />
+<br />
+# specify a program to run when mail comes to address correspond<br />
+correspond: "|/usr/bin/rt-mailgate --queue General --action correspond --url http://rt.mynetwork.us/<br />
<br />
--- /etc/sysconfig/httpd.orig 2006-01-05 13:34:38.000000000 -0500<br />
+++ /etc/sysconfig/httpd 2006-01-19 11:31:49.000000000 -0500<br />
-#OPTIONS=<br />
+OPTIONS=-DPerlStatus<br />
<br />
--- /etc/httpd/conf/httpd.conf.orig 2006-01-05 13:34:38.000000000 -0500<br />
+++ /etc/httpd/conf/httpd.conf 2006-01-19 13:17:41.000000000 -0500<br />
<br />
+ServerName www.mynetwork.us:80<br />
<br />
--- /etc/mail/local-host-names.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/local-host-names 2006-01-20 14:38:25.000000000 -0500<br />
<br />
+rt.mynetwork.us<br />
+www.mynetwork.us<br />
<br />
--- /var/rt/home/.procmailrc.orig 2004-05-10 14:52:51.000000000 -0400<br />
+++ /var/rt/home/.procmailrc 2006-01-17 04:52:04.000000000 -0500<br />
<br />
-MAILDOMAIN=rt.yourdomain.com<br />
+MAILDOMAIN=rt.mynetwork.us<br />
<br />
-RT_URL="http://rt.yourdomain.com/"<br />
+RT_URL="http://rt.mynetwork.us/"<br />
<br />
--- /etc/httpd/conf.d/rt.conf.orig 2006-01-12 23:04:31.000000000 -0500<br />
+++ /etc/httpd/conf.d/rt.conf 2006-01-19 23:04:12.000000000 -0500<br />
<br />
-&lt;VirtualHost your.ip.address:80&gt;<br />
- ServerName your.rt.server.hostname<br />
+&lt;VirtualHost 192.168.62.21:80&gt;<br />
+ ServerName rt.mynetwork.us<br />
<br />
-&lt;VirtualHost your.ip.address:443&gt;<br />
- ServerName your.rt.server.hostname<br />
+&lt;VirtualHost 192.168.62.21:443&gt;<br />
+ ServerName rt.mynetwork.us<br />
<br />
--- /etc/rt/RT_SiteConfig.pm.orig 2006-01-12 23:04:30.000000000 -0500<br />
+++ /etc/rt/RT_SiteConfig.pm 2006-01-19 23:39:33.000000000 -0500<br />
<br />
-Set( $rtname, 'example.com');<br />
+Set($rtname, "network_us");<br />
<br />
+Set($Organization , "rt.mynetwork.us");<br />
+Set($Timezone, 'US/Eastern');<br />
+Set($WebBaseURL, "http://rt.mynetwork.us");<br />
+Set($WebPath, "/");<br />
+Set($WebURL , $WebBaseURL . $WebPath . "/");<br />
+<br />
+Set($CorrespondAddress, 'correspond@rt.mynetwork.us');<br />
+Set($CommentAddress, 'comment@rt.mynetwork.us');<br />
+Set($SendmailPath, "/usr/sbin/sendmail");<br />
+Set($SendmailArguments , "-oi -t");<br />
+<br />
+Set($LogToSyslog, '');<br />
+Set($LogToFile, 'debug');<br />
+Set($LogDir, '/var/log/rt');<br />
+Set($LogToFileNamed , "rt.log");<br />
+<br />
+Set($OwnerEmail, "admin@mynetwork.us");<br />
+Set($MyTicketsLength, 20);<br />
+<br />
+Set($DatabasePassword , 'contribs.org');<br />
+<br />
+Set($AmbiguousDayInPast , 0);<br />
+<br />
<br />
1;<br />
<br />
--- /etc/mail/sendmail.mc.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/sendmail.mc 2006-01-17 04:27:10.000000000 -0500<br />
<br />
-DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl<br />
+dnl DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl<br />
<br />
--- /etc/mail/virtusertable.orig 2005-02-21 11:14:29.000000000 -0500<br />
+++ /etc/mail/virtusertable 2006-01-17 04:56:41.000000000 -0500<br />
<br />
+#<br />
+# This will handle all aliases for all queues. Note that this implies<br />
+# that all queue address are @rt.mynetwork.us<br />
+#<br />
+# Here put your exceptions. Next one made this domain RFC822 compliant.<br />
+postmaster@rt.mynetwork.us postmaster<br />
+<br />
+# leave root as 'root'<br />
+root@rt.mynetwork.us root<br />
+<br />
+# everything else goes to user 'rt'<br />
+@rt.mynetwork.us rt<br />
<br />
<br />
</nowiki><br />
<br />
-Hasan Muhammad<br />
<br />
=== Initiation error when starting httpd service, Starting httpd: No root path(s) specified at /usr/bin/webmux.pl line 98 ===<br />
<br />
I just wanted to add to this. At least in my case (Linux OS, apache-perl, Apache1/modperl1), this error was being caused by the following line in webmux.pl:<br />
<br />
rmtree([ bsd_glob("$RT::MasonDataDir/obj/*") ], 0, 1);<br />
<br />
<br />
"$RT::[[MasonDataDir]]/obj" is a directory, in my case it is this:<br />
<br />
/var/cache/request-tracker3.4/mason_data/obj<br />
<br />
On startup, there are no non-hidden files/directories in this directory. Apparently bsd_glob returns the empty result, and rmtree chokes on that with the "No root path(s)" error. As a workaround, I edited webmux.pl to replace that rmtree line with this:<br />
<br />
my @adir = bsd_glob("$RT::MasonDataDir/obj/*");<br />
if (@adir) {<br />
rmtree([ @adir ], 0, 1);<br />
}<br />
<br />
<br />
That got rid of the "No root path(s)" error message.<br />
<br />
- [[MaryaDoery]]<br />
<br />
3.6.0RC3 has it fixed.<br />
<br />
=== Continuous login ===<br />
<br />
I encountered a problem with RT asking me to log in every time I clicked a link. After doing some research, it seemed that the cookie was being sent and set properly. There were two possibilities mentioned:<br />
<br />
* A [[MySQL]] 5.x issue: check your mysql error logs. The session module has been seen to try to connect as [mailto:rt_user@localhost rt_user@localhost] or [mailto:rt_user@127.0.0.1 rt_user@127.0.0.1]<nowiki> instead of rt_user@'' </nowiki><br />
* A table structure issue: take a look at the "sessions" table in the RT database. There should be a column named "a_session". This column must have the type "longblob" not "longtext". Also note that if there are any records in the table, the entire table should be emptied (either before or after making the change), otherwise the problem will persist.<br />
<br />
I personally hit the table structure problem while installing RT 3.6.3 on Gentoo Linux, but since fixing that, everything has been fine.<br />
<br />
- kwgagel<br />
<br />
I hit this problem after upgrading from 3.8.4 to 3.8.7. Kevin Falcone from Best Practical suggested the removal of my /local/html/autohandler file. I renamed the file and restarted the httpd service and the problem vanished.<br />
<br />
- [[DaveIngram]]<br />
<br />
I hit the table structure issue with 3.6.5 on Fedora 8, deleting the table and recreating as longblob fixed. Thanks Dave.<br />
<br />
I found the same thing after running the upgrade script from 3.6.1 &gt;&gt; 3.8.2, change the data type in the db and set the default value to NULL and now is working. Thanks Dave!<br />
<br />
-- [sorry the html goes nuts here: will fix shortly. Rob101]<br />
<br />
The [[MySQL]] SQL I used to correct this problem with RT 3.6.7 on Gentoo was:<br />
<br />
<nowiki>mysql&gt; desc sessions;<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| Field | Type | Null | Key | Default | Extra |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| id | char(32) | NO | PRI | NULL | |<br />
| a_session | longtext | YES | | NULL | |<br />
| LastUpdated | timestamp | NO | | CURRENT_TIMESTAMP | |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
3 rows in set (0.00 sec)<br />
<br />
mysql&gt; alter table sessions modify a_session longblob default NULL;<br />
Query OK, 215 rows affected (0.02 sec)<br />
Records: 215 Duplicates: 0 Warnings: 0<br />
<br />
mysql&gt; delete from sessions;<br />
Query OK, 215 rows affected (0.00 sec)<br />
<br />
mysql&gt; desc sessions;<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| Field | Type | Null | Key | Default | Extra |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
| id | char(32) | NO | PRI | NULL | |<br />
| a_session | longblob | YES | | NULL | |<br />
| LastUpdated | timestamp | NO | | CURRENT_TIMESTAMP | |<br />
+-------------+-----------+------+-----+-------------------+-------+<br />
3 rows in set (0.00 sec)<br />
<br />
mysql&gt;<br />
<br />
</nowiki><br />
<br />
Sorry if dumping this here was too verbose!<br />
<br />
Rob101 --<br />
<br />
It sure wasn't Rob. I confirmed that this was the answer to a problem for me going from 3.6.x to 3.8.x ... it's feasible that something about my upgrade broke the database upgrade scripts. Either way -- if you are having problems with RT logins happening too much -- the above seems to be the fix! -- [[MGMead]] (PS - I cleaned up the MYSQL session so you can read it more easily)<br />
<br />
=== The dreadful MySQL server has gone away error ===<br />
<br />
I was seeing this error almost every time I create a ticket in one of my queues. If I insisted at least 5 times, the ticket was finally created.<br />
<br />
Searching about this I discovered that the most common reason for this kind or error is data base corruption. I tried checking, repairing and optimizing the database using the mysqlcheck command, but none solved the problem. To be sure I dumped all rt3 database (using mysqldump) e recreated the whole database, but that too did not solve the problem. Nevertheless, some people really got rid of this error using those methods and those could work for you.<br />
<br />
After enabling debug logging on [[RT SiteConfig|RT_SiteConfig]], I saw that the error was occurring much sooner than I thought, because the web interface was only showing the error when the Apache::Session::Lock::[[MySQL]] object was being destroyed.<br />
<br />
Actually, the problem was occurring right after an Scrip [[SendMail]] action and in the logs I could see RT complain about sendmail exiting with status 16384. I checked the scrip saw that the template used had the following in it's first line: To: [mailto:someemail@somedomain.com someemail@somedomain.com];[mailto:otheremail@somedomain.com otheremail@somedomain.com]<br />
<br />
I removed the “;[mailto:otheremail@somedomain.com otheremail@somedomain.com]” part and the problem was gone. I found that to be super strange and totally unrelated, but if you got that error, don't forget to check your templates. I guess there is really a reason for the [[SendMail]] Scrip Action not being enabled by default.<br />
<br />
- dante.</div>BillCole