3 messages in com.mysql.lists.perlRe: trouble making DBD files for Perl
FromSent OnAttachments
Richard Newell28 Sep 2002 16:58 
Richard Newell28 Sep 2002 19:45 
Jochen Wiedmann05 Oct 2002 13:49 
Subject:Re: trouble making DBD files for Perl
From:Richard Newell (grne@earthlink.net)
Date:09/28/2002 07:45:29 PM
List:com.mysql.lists.perl

To all,

After a number of false starts (recompile perl, etc.) I downloaded DBD-mysql-2.1020 (earlier I was using Msql-Mysql-modules-1.2219) and tried to install it. The result was the same, but this time, the message was more helpful:

"An error occurred while linking the DBD::mysql driver. The error message seems to indicate that you don't have a libz.a, libgz.a, libz.so or libgz.so. This is typically resolved by:

1.) You may try to remove the -lz or -lgz flag from the libs list by using the --libs switch for "perl Makefile.PL". 2.) On Red Hat Linux install libz-devel 3.) On other systems, please contact the mailing list

Msql@lists.mysql.com"

Option #1 given in the message seems to have worked for me, so the issue is closed.

Thanks to all who read this.

Rich Newell

Richard Newell wrote:

Hi,

I'm trying to do some mysql updates and queries from Perl. I have installed the DBI module, which appeared to go OK, and am trying to do the DBD one, but I get the messages included below. Not being a C programmer, I do not understand what they mean or what to do for corrective action. I would greatly appreciate any hints.

Rich Newell rich@newell.org

---------

perl Makefile.PL Which drivers do you want to install?

1) MySQL only 2) mSQL only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL (either of mSQL 1 or mSQL 2)

4) mSQL 1 and mSQL 2 5) MySQL, mSQL 1 and mSQL 2

Enter the appropriate number: [3] 1

Do you want to install the MysqlPerl emulation? You might keep your old Mysql module (to be distinguished from DBD::mysql!) if you are concerned about compatibility to existing applications! [y] Note (probably harmless): No library found for -lgz Using DBI 1.30 installed in /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules

[root@rh1 ~richardn/Msql-Mysql-modules-1.2219]#make make[1]: Entering directory `/home/richardn/Msql-Mysql-modules-1.2219/mysql' cc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5.6.0/i386-linux -fno-strict-aliasing -O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fpic -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYSQL dbdimp.c cc -c -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI -I/usr/lib/perl5/5.6.0/i386-linux -fno-strict-aliasing -O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math -DVERSION=\"2.0419\" -DXS_VERSION=\"2.0419\" -fpic -I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs LD_RUN_PATH="/usr/lib/mysql:/usr/lib/gcc-lib/i586-mandrake-linux/2.96" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql -L/usr/lib/mysql -lmysqlclient -lm -lz -L/usr/lib/gcc-lib/i586-mandrake-linux/2.96 -lgcc /usr/bin/ld: cannot find -lz collect2: ld returned 1 exit status make[1]: *** [../blib/arch/auto/DBD/mysql/mysql.so] Error 1 make[1]: Leaving directory `/home/richardn/Msql-Mysql-modules-1.2219/mysql' make: *** [subdirs] Error 2

--------------