DBI setup issue

hi,

I signed up to ask for a little help getting the mysql module working in
Perl. I have a Linux/Alpha machine running Redhat 7.2 for Alphas. This
is running versions 2.4.9-32.5 of the kernel and 2.96 of gcc.

I got the latest binaries for Linux Alpha of mysql, v4.0.16. I
installed the latest version of Perl (5.8.2) from source using the gcc
v2.96 above. I then installed DBI and then DBD::mysql, v2.9003, from
source as well. Everything seemed to work without issue.

Both Perl as mysql work just fine if I run them independently. I also
seem to be getting access to DBI fine in Perl. If I run the following
script command in Perl, for example,

use strict;
use DBI;
my @drivers = DBI->available_drivers();
foreach(@drivers) {
print "$_ \n";
}

I get the following output:
$ perl testdbi.pl
ExampleP
Proxy
Sponge
mysql

However, when I try to initialize the mysql database, I get an error
from the DBD/mysql.so shared library. So, when I run:

use strict;
use DBI;
#connect to the database
my $dbh = DBI->connect('DBI:mysql:database','username','password');
$dbh->disconnect();

The following happens:

perl: relocation error:
/home/apache/perl-5.8.2/lib/site_perl/5.8.2/alpha-linux/auto /DBD/mysql/mysql.so: undefined symbol: _OtsZero

I'm hoping that someone might know what the problem might be? I must
have some version incompatibility or something...

Thanks in advance!

--
Matthew MacLean, Ph.D.
Calspan-UB Research Center (CUBRC)
maclean@cubrc.org
4455 Genesee Street
Buffalo, NY 14225
P: 716/631-6798
F: 716/631-4117


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org