Undefined symbol: PL_perl_destruct_level after upgrading....

[Yoav Felberbaum <de...@mrdini.com>]

Hi,

I realise this issue isn't "new", but my main problem is finding out  
how to resolve the issue, short of upgrading from Woody to Sarge,  
which is something that I need to plan carefully (cloning HDD for a  
"test upgrade" and all that).

Basically, I recently upgraded apache, mysql & php using http:// 
www.dotdeb.org. However, the upgrade of apache broke a script which  
relied on DBI, which in turn relies on mod_perl.

---
install_driver(mysql) failed: Can't load '/usr/lib/perl5/auto/DBD/ 
mysql/mysql.so' for module DBD::mysql: /usr/lib/perl5/auto/DBD/mysql/ 
mysql.so: undefined symbol: PL_perl_destruct_level at /usr/lib/perl/ 
5.8.0/DynaLoader.pm line 225.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./transferleads_updated.pl line 19
---
Line 19:-
my $dbh = DBI->connect("DBI:mysql:$db_name:$db_hostname",  
$db_username, $db_password)
     or die "Couldn't connect to database: " . DBI->errstr;
------

Investigating this issue, it seems that _somehow_ Perl 5.8.0 was  
installed on the Woody server I admin. (we took over this server from  
previous owners, and I don't think the server was wiped clean - this  
was before my time so..). Checking around, I'm frankly puzzled as to  
how Perl 5.8.0 was installed. Anyway, since Perl 5.8.0 is installed,  
it would cause too much problems to downgrade back to 5.6.0 (broken  
scripts and all that).

The main problem is that I cannot simply do a "dselect" & reinstall  
"libapache-mod-perl", because as far as I can tell, the woody stable  
version of "libapache-mod-perl" requires Perl 5.6, whilst I somehow  
have Perl 5.8...

Any thoughts & suggestions as to how I can get DBI to work without  
errors for now, till I do a proper upgrade to Sarge?

Deepest thanks,

Yoav

Miscellaneous info...
--------------
$ dpkg -l | grep perl
rc  apache-perl    1.3.27-0.1-1.2 Versatile, high-performance HTTP  
server with
ii  dpkg-perl      0.1-3.0        Perl interface modules for dpkg
ii  libdbi-perl    1.35-1         The Perl5 Database Interface by Tim  
Bunce
ii  libdevel-symdu 2.03-3         Perl module for inspecting perl's  
symbol tab
ii  libgd-gd1-perl 1.41-7         Perl module wrapper for libgd (old  
version a
ii  libgd-perl     1.41-7         Perl module wrapper for libgd
ii  libmd5-perl    2.02-3.1       backwards-compatible wrapper for  
Digest::MD5
ii  libnet-perl    1.12-1         Implementation of Internet  
protocols for Per
ii  libperl5.6     5.6.1-8.9      Shared Perl library.
ii  libplrpc-perl  0.2016-1       Perl extensions for writing PlRPC  
servers an
ii  liburi-perl    1.23-1         Manipulates and accesses URI strings
ii  libwww-perl    5.69-2         WWW client/server library for Perl  
(aka LWP)
ii  perl           5.8.0-17       Larry Wall's Practical Extraction  
and Report
ii  perl-5.005     6.3            Transitional package.
ii  perl-5.005-bas 6.3            Transitional package.
ii  perl-5.005-doc 6.3            Transitional package.
ii  perl-base      5.8.0-17       The Pathologically Eclectic Rubbish  
Lister.
ii  perl-doc       5.8.0-17       Perl documentation.
ii  perl-modules   5.8.0-17       Core Perl modules.
--------------
$ dpkg -l | grep apache
ii  apache         1.3.27.0-2     Versatile, high-performance HTTP  
server
ii  apache-common  1.3.27.0-2     Support files for all Apache  
webservers
rc  apache-perl    1.3.27-0.1-1.2 Versatile, high-performance HTTP  
server with
ii  apache-ssl     1.3.27.0-2     Versatile, high-performance HTTP  
server with
rc  libapache-mod- 3.3a-4woody1   Apache connector for Tomcat servlet  
engine
ii  libapache-mod- 4.4.1-0.dotdeb server-side, HTML-embedded  
scripting languag
ii  libapache-mod- 2.8.7-1        Strong cryptography (HTTPS support)  
for Apac
---------------
$ uname -a
Linux pod-107 2.4.20-3-686 #1 Sun May 18 20:26:19 EST 2003 i686 GNU/ 
Linux
----------------