perl+mysql+debian box

["alexis bory" <abory@g2ms.com>]

hello, dear ISPs

I'm trying to install perl DBD::mysql on a Debian potato box.

mySQL is compiled from sources v 3.23.39
perl updated to 5.6.1 from CPAN
DBI installed from CPAN
DBD-mysql-2.0902 fetched with CPAN

and I'have the famous problem with DBD::mysql while running make test :

     t/00base............install_driver(mysql) failed: Can't load
'blib/arch/auto/DBD/mysql/mysql.so'
     for module DBD::mysql: blib/arch/auto/DBD/mysql/mysql.so: undefined
symbol: mysql_store_result
     at /usr/local/lib/perl5/5.6.1/i686-linux/DynaLoader.pm line 206.
     at (eval 1) line 3
     Compilation failed in require at (eval 1) line 3.
     Perhaps a required shared library or dll isn't installed where expected
      at t/00base.t line 38
     .....

I say famous because I spent 2 days browsing the doc and several lists,
plenty of 'relevant' messages, zero result.

I use the commande :

     $ perl
Makefile.PL  --cflags=-I/usr/local/mysql/include/mysql/ --libs=-L/usr/local/
mysql/lib/mysql/

I'm trying to link ligcc.a but can get anything adding :

     -l/usr/lib/gcc-lib/i386-linux/2.95.2/ -lgcc

I tried also :

     $ perl Makefile.PL -static and -config

but they seems not to be valid options...

gcc...gcc..?!? I'm not very experienced whit it.

I also put aliases for mysqlclient.so in some strategics directories...

HELP_HELP_HELP_HELP_HELP_HELP_HELP_


If someone have experienced this problem AND know how to fix it....

thanks

Alexis