RT Transactions Failing with mod_php5 installed

Hi all,

I’ve been setting up RT all day, and I’ve got it mostly functioning
properly. I installed all perl modules, installed mod_perl, configured rt
to work, and it does… except…

When I try to create a new queue, I get the following error:

“error: Transactions not supported by database at
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm line 1665.”

Research on this indicated that I needed to reinstall DBD::mysql. This
did not help. What DID help; however, was disabling mod_php5. If i
comment the loadmodule for mod_php5 out of the httpd.conf file (and hence,
causes php scripts to stop functioning), then RT functions fine and I can
create queues.

Does anyone know why this may be the case? I’d consider the option of
conflicting mysql client libraries…

More information from the error is below:


1661: sub begin_work {
1662: my $dbh = shift;
1663: return $dbh->set_err(1, “Already in a transaction”)
1664: unless $dbh->FETCH(‘AutoCommit’);
1665: $dbh->STORE(‘AutoCommit’, 0); # will croak if driver doesn’t
support it
1666: $dbh->STORE(‘BegunWork’, 1); # trigger post commit/rollback action
1667: return 1;
1668: }

code stack: