'transactions not supported' error

Greetings

I have had (& reported) this problem before and managed work arounds, but now I've got no choice but to get transactions working through DBI. The following simple script always fails:

#!/usr/bin/perl -w

use DBI;
my $user = 'root';
my $pw = '';
DBI->trace(4);
my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw, { AutoCommit => 0, RaiseError => 0 });
die DBI::errstr unless $dbh;
$dbh->disconnect;

I am using perl 5.8.5 and mysql 5.0.21 on a Dell PE 6850 with qual dual-core Xeons and Red Hat Enterprise v4. I cleaned and rebuilt DBI per the instructions and cleaned and rebuild DBD-mysql per the instructions. I've checked the logs for mysqld and innodb is starting normally. I can create tables, start transactions, commit, rollback, etc etc from the command line.

I've tried to include the logs per the README, but they won't pass the 50K input size limit on the list. I can send them separately if anyone is interested in taking this up.

Any help will be gratefully appreciated.

Thanks

Mike


Relevant Pages

  • Re: transactions not supported error
    ... I have had this problem before and managed work arounds, ... now I've got no choice but to get transactions working through DBI. ... Where is it failing / what is the output of the script? ...
    (perl.dbi.users)
  • [rt.cpan.org #36972] SELECT DISTINCT with ORDER BY and an empty field
    ... Queue: DBI ... SELECT DISTINCT with ORDER BY and an empty field ... I have attached both my test code and a dump of the MySQL test database. ... CREATE TABLE `logs` ( ...
    (perl.dbi.users)
  • RE: use DBI in perl cgi script
    ... I didn't see anything unusual in my apache logs... ... statement use DBI at the top because I am doing some database stuff. ... the status bar at the bottom of the web browser. ...
    (perl.dbi.users)
  • DB2 error
    ... my logs, and trying to work out what it is ... this seems to be a db2 problem more than a dbi problem. ... IBM code, but i'd like to rule out the DBI and/or DB2.pm as a cause ...
    (perl.dbi.users)