brycen has asked for the wisdom of the Perl Monks concerning the following question:

Wow, we're really stuck here: 
install_driver(mysql) failed: Can't load '/opt/perl-5.8.8/lib/site_per
+l/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-lin
+ux/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 expecte
+d
 at /vol0/deployed/cron_scripts/ccs_ridefinder.pl line 55

[download]

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. Re-installing DBDL:mysql did nothing.

Replies are listed 'Best First'.
Re: DBD::mysql fails after mysql upgrade
by cLive ;-) (Prior) on Jul 13, 2006 at 06:15 UTC

    Err, if your mysql has changed, surely you'll need to recompile the DBD drivers to use the new mysql libraries, no?

    "Google search returned no good solutions."

    You have to know how to search to find what you need :) Try the first result returned.

    "It is a good idea to rebuild and reinstall the DBD::mysql distribution whenever you install a new release of MySQL, particularly if you notice symptoms such as that all your DBI scripts fail after you upgrade MySQL."

[reply]
      Well, indeed, the above error happens when we reinstall the DBD::mysql distribution after upgrading mysql. So: we did that. Any other smart answers?
[reply]
Re: DBD::mysql fails after mysql upgrade
by jdtoronto (Prior) on Jul 13, 2006 at 06:02 UTC
[reply]

Back to Seekers of Perl Wisdom