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:
context:
…
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: }
1669:
…
code stack:
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/DBI.pm:1665
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:720
/opt/rt3/lib/RT/Queue_Overlay.pm:371
/opt/rt3/share/html/Admin/Queues/Modify.html:130
/opt/rt3/share/html/Admin/autohandler:49
/opt/rt3/share/html/autohandler:291