[rt-users] RT 3.8 on Ubuntu Hardy

[Steven Christou]

Go to this website and read the Continuous login part:
http://wiki.bestpractical.com/view/TroubleShooting
Probably can explain it 1000x better than I can, but basically its a
table issue converting from a longtext to longblob. The command below
does exactly that.

Do you still get the 2nd error?

Shawn Smith wrote:
> Interesting, I can't reproduce the error anymore after following your
> instructions.  Thanks a lot!  Would you mind offering a quick
> explanation as to why you think this fixes the problem?  I'm a little
> confused about what it's doing and what it's fixing.  Thanks again.
>
> On Tue, Mar 10, 2009 at 2:28 PM, Steven Christou <christ66 at uwm.edu
> <mailto:christ66 at uwm.edu>> wrote:
>
>     Fix for: Out of memory! Callback called exit.
>
>     First login to your mysql database
>
>     Mysql –p –u root –D rtdb
>
>     This will log you in as root(-u) in the rtdb database(-D) with a
>     prompt for a password(-p). Next, we want to change the session
>     tables. Type in this exact command when you get to the
>
>     mysql> prompt (note capitalization areas and DO NOT include the ""s):
>
>     "ALTER TABLE sessions CHANGE a_session a_session LONGBLOB;"
>
>
>
>     Shawn Smith wrote:
>     > Hi, I've installed RT 3.8 on an Ubuntu Hardy server from the Debian
>     > package at
>     >
>     >
>     http://svn.debian.org/wsvn/pkg-request-tracker/packages/request-tracker3.8/trunk/debian/
>     >
>     >
>     > It works totally fine aside from the fact that it's got a
>     significant
>     > visual bug.  Here's how it's produced:
>     >
>     > 1. Click on queue in the Quick Search menu on the right hand side.
>     > 2. Click on a ticket in that queue.
>     > 3. Go back to the list of tickets.
>     > 4. Refresh the page.
>     >
>     > The error that occurs is that nothing gets rendered properly, so
>     it's
>     > just a white background with a bunch of blue links for the
>     tickets and
>     > text for the different fields of each ticket.  In
>     > /var/log/apache2/error.log I see stuff like:
>     >
>     > [Tue Mar 10 13:38:48 2009] [notice] child pid 24484 exit signal
>     > Segmentation fault (11)
>     > Out of memory!
>     > Callback called exit.
>     >
>     > and:
>     >
>     > [Tue Mar 10 18:02:36 2009] [crit]: Apache2::RequestIO::print: (104)
>     > Connection reset by peer at
>     > /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 1034
>     > (/usr/share/request-tracker3.8/libexec/webmux.pl:150)
>     >
>     >
>     > My boss suggested changing MaxRequestsPerChild in
>     > /etc/apache2/apache2.conf to a low number other than 0, but that
>     still
>     > did not fix the error.  If anyone has any suggestions I would
>     greatly
>     > appreciate any advice you can provide.
>     >
>     > --
>     > Shawn
>     >
>     ------------------------------------------------------------------------
>     >
>     > _______________________________________________
>     > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>     >
>     > Community help: http://wiki.bestpractical.com
>     > Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
>     >
>     >
>     > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     > Buy a copy at http://rtbook.bestpractical.com
>
>
>     --
>     Steve Christou
>     UWM Information Security
>     Phone: 414-229-1100
>     Email: Osa-list at uwm.edu <mailto:Osa-list at uwm.edu>
>
>
>
>
> -- 
> Shawn


-- 
Steve Christou
UWM Information Security
Phone: 414-229-1100
Email: Osa-list at uwm.edu