Wow, we're really stuck here: install_driver(mysql) failed: Can't load '/opt/perl-5.8.8/lib/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /opt/perl-5.8.8/lib/site_perl/5.8.8/i686-linux/auto/DBD/mysql/mysql.so: undefined symbol: __pure_virtual at /opt/perl-5.8.8/lib/5.8.8/i686-linux/DynaLoader.pm line 230. at (eval 80) line 3 Compilation failed in require at (eval 80) line 3. Perhaps a required shared library or dll isn't installed where expected at /vol0/deployed/cron_scripts/ccs_ridefinder.pl line 55 This seems to be some issue between DBD:mysql 3.0006 and our newly recompiled mysql 5.0.22-standard. Has anyone had and solved this? Google search returned no good solutions.

I found this workaround on another site... http://www.mail-archive.com/dbi-users@perl.org/msg27851.html Simply adding -lmygcc to the --libs argument worked for me.

Goodness. This has to be the one piece of software that causes the most headaches! It is so horrible and virtually impossible to install! Please - someone do a re-write and make it useable! Please, please, please, for the love of God, please!

The following changes make the compilation of DBD-mysql-4.005 work with no problems on my Debian Etch servers using MySQL 5.0.[27|41]:

Edit /usr/local/mysql/bin/mysql_config.

Fix old arch declarations to new form. Change any occurance of "-mcpu" to "-march".

Add -lmygcc declaration. Change the line that contains:

libs=" $ldflags -L$pkglibdir -lmysqlclient -lz -lcrypt -lnsl -lm "

To: libs=" $ldflags -L$pkglibdir -lmysqlclient -lz -lcrypt -lnsl -lm -lmygcc "

Remove erroneous extra "/mysql" from libdir. Change the line that contains:

pkglibdir='/usr/local/mysql/lib/mysql'

To: pkglibdir='/usr/local/mysql/lib'

Remove erroneous extra "/mysql" from includedir. Change the line that contains:

pkgincludedir='/usr/local/mysql/include/mysql'

To: pkgincludedir='/usr/local/mysql/include'

Then everything works as expected wiht a standard compile.

perl Makefile.PL --testuser=[testuser] --testdb=test --testpassword=[testpassword]

make

make test

make install