I am getting this following error in my redhat 9.0 linux box when i am trying to connect to the mysql server using the dbi.
==============
install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 2) line 3
Compilation failed in require at (eval 2) line 3.
Perhaps a required shared library or dll isn't installed where expected
=================
This is the script that i have used for test purpose
============ #!/usr/bin/perl -w
use strict; use DBI;
my @arr = DBI->available_drivers();
foreach (@arr) {
print $_,"\n";
next if $_ =~ /proxy/i;
my @datasources = DBI->data_sources($_);
foreach my $val(@datasources) {
print "\tData Source is $val\n";
}
print "\n";
}exit; ===================
There were no error or problem before my upgradation to redhat 9.0 from 8.0. Here are the softwares and their corresponding version that i have in my system.
MySQL-devel-3.23.55-1 MySQL-3.23.55-1 MySQL-client-3.23.55-1 MySQL-shared-3.23.55-1 MySQL-Max-3.23.55-1 glibc-2.3.2-27.9 perl-DBI-1.32-5
I don't know exactly the DBD::mysql version installed in my system. But the driver is present as i am getting the man pages wiht 'perldoc DBD::mysql and the driver name as available drivers.
Any idea how to solve this problem. And why this happening.
Thanks in advance.
-siddhartha
