[rt-users] RT cannot open database

[Stephen Carr]

Dear Chaim

phpMyAdmin did not request a root password - I installed it to manage 
the DSPAM database.

I am getting the following in rt.log (the time is incorrect) see below.

I upgraded to DBI-1.53 I indicated to another post I eill rool back to 
an earlier version. Also the data is in ibdata1 but the sessions are 
stored in rt3/sessions.MY*

Thanks
Stephen Carr

[Mon Nov  6 07:40:05 2006] [warning]: Use of uninitialized value in 
substitution (s///) at /opt/rt3/lib/RT/Interface/Web.pm line 617. 
(/opt/rt3/lib/RT/Interface/Web.pm:617)
[Mon Nov  6 07:40:05 2006] [warning]: rollback ineffective with 
AutoCommit enabled at 
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758. 
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov  6 07:40:05 2006] [warning]: Rollback ineffective while 
AutoCommit is on at 
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758. 
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov  6 07:40:05 2006] [warning]: DBD::mysql::db rollback failed: 
Rollback ineffective while AutoCommit is on at 
/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 758. 
(/usr/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm:758)
[Mon Nov  6 07:40:05 2006] [crit]: Transaction not committed. Usually 
indicates a software fault.Data loss may have occurred 
(/opt/rt3/lib/RT/Interface/Web/Handler.pm:194)

Regards
Stephen Carr
Chaim Rieger wrote:
> Stephen Carr wrote:
>> Dear All
>>
>> After restarting apache I am having trouble with the TR database - it is
>> not any SQL type database. The only modification was to add phpMyAdmin to
>> httpd.conf
>>
>> The initial screen appears as per normal but when I click on Take an 
>> error
>> occurs - see below.
>>
>> I can view tickets but cannot update / modify them. I tend to leave RT
>> running for days.
>>
>> Version of RT is 3.6.1
>>
>> Thanks
>> Stephen Carr
>>   
> is mysql running, does ~/rt/var/log/rt.log show anything, are 
> permissions set properly in the rt dir,
> 
> let me make a stab at the following secnario
> 
> you installed phpmyadmin, it warned you that there is no root password, 
> so you created one ?
> 

-- 
Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr at civeng.adelaide.edu.au

CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s) and
contains information that may be confidential and/or copyright.
If you are not the intended recipient please notify the sender
by reply email and immediately delete this email. Use, disclosure
or reproduction of this email by anyone other than the intended
recipient(s) is strictly prohibited. No representation is made
that this email or any attachments are free of viruses. Virus
scanning is recommended and is the responsibility of the recipient.