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

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Error in Mysql+Perl
by Corion (Patriarch) on Jun 26, 2007 at 10:19 UTC

    I already told you the following in the CB, but you must have missed it:

    Most likely you didn't install the MySQL libraries or you moved the MySQL libraries or the MySQL libraries are the wrong version for DBD::mysql.

    If you provide us with more details on how you installed DBD::mysql and how you installed the MySQL libraries, and what your Perl and Linux distribution is (perl -V tells you one half of that information), maybe we can help you with better tips. Have you tried using Google with the exact error message?

      One should never forget to consult the Google Oracle!

      Look what I found at Mysql Forum:

      Sean O'Donnell wrote: Sean, Do you have mysql_config on your system? If you do, it may not be in your patch, and Makefile.PL can find it. DBD::mysql 'perl Makefile.PL' + needs this to find the client libs and headers. Kind regards, Patrick >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >I had a problem installing DBD::mysql due to the dbdimp.c file, but I >was able to get it installed with the following command: > >$ perl Makefile.PL --cflags=-I/usr/local/mysql/include >- --libs=/usr/local/mysql/lib; make; make install; > >It installed OK like that (rather than just 'perl Makefile.PL; make; >make install;'), but it doesn't appear to be working when I try to us +e >it via Perl Scripts. > >$ ./test.pl >/usr/bin/perl: relocation error: >/usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBD/mysql/mysql.s +o: >undefined symbol: mysql_server_init > >I've yet to find any decent solution via Google, so I figured I'd ask >here instead. > >I'm using DBD::mysql (v4.004) with MySQL (v4.1.9). > >Any suggestions? > >- -- > >Sean O'Donnell >South Pasadena, CA >

      CountZero

      A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Re: Error in Mysql+Perl
by CountZero (Bishop) on Jun 26, 2007 at 10:18 UTC
    What exactly were you doing when this error happened?

    As a guess it seems you were trying to install DBD::mysql (through CPAN / CPANPLUS or make ???) and the program could not find the mysql-libraries.

    CountZero

    "A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James