[rt-users] working RT3.8.8 since Nov-2010 now fails login with blank page

[o.nash at cs.ucc.ie]

Hi Kevin, yes thanks for your reply.
The log in /var/log/mysql has:-
120104  8:21:24 [ERROR] /usr/sbin/mysqld: Table './rt3/sessions' is marked 
as crashed and last (automatic?) repair failed
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 21225.
InnoDB: You may have to recover from a backup.
120104  8:22:52  InnoDB: Page dump in ascii and hex (16384 bytes):
  len 16384; hex f6c2475b000052e9000052eaffffffff000000006366b80f45b
..... cut big hex dump file.

the apache log has:-
[Tue Jan 03 09:44:59 2012] [notice] Apache/2.2.17 (Unix) mod_perl/2.0.4 
Perl/v5.10.1 configured -- resuming normal operations
[Tue Jan 03 09:45:07 2012] [notice] child pid 1646 exit signal 
Segmentation fault (11)
[Tue Jan 03 09:57:34 2012] [error] [client 143.239.74.160] Connect Failed 
Can't connect to local MySQL server through socket '/var/run/mysqld/
mysqld.sock' (111)\n at /opt/rt3/bin/../lib/RT.pm line 206

Running:
/opt/rt3/sbin# ./rt-validator --check
it runs for several minutes and returns nothing.

The RT Db is accessible via mysql cmd line tools ok.
But I did not try to read every table.

thanks
oliver


On Tue, 3 Jan 2012, Kevin Falcone wrote:

> On Tue, Jan 03, 2012 at 12:47:25PM +0000, o.nash at cs.ucc.ie wrote:
>> Dear all,
>> I am hoping this is a known issue and can be fixed easily.
>> Our working installation started to fail to login and returns a blank page
>> instead of the default queues page.
>>
>> we have:-
>> Ubuntu linux 10.0.4 LTS
>> 2.6.32-21-generic-pae #32-Ubuntu SMP Fri Apr 16 09:39:35 UTC 2010
>> i686 GNU/Linux
>> Apache-2.2.17 bullt from source
>> RT3.8.8 manually installed
>> mod_perl-2.0.4 - just built 2.0.5 and tested same problem.
>>
>> I also tried changing the httpd.conf line:
>> SetHandler perl-scrpt
>> to
>> SetHandler modperl
>> This resulted in a blank page being downloaded instead of displayed
>> in browser.
>>
>> Any advice/hints much appreciated
>
> Without the errors in your apache error log it's hard to offer
> suggestions.  Usually this happens because your distribution upgraded
> a perl module package and broke things.
>
> -kevin
>

--
Oliver Nash
CSSG Computer Science UCC
-------------------------