trouble making DBD files for Perl

am 29.09.2002 01:58:53 von Richard Newell

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
richard@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-l inux/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

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

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1934@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: trouble making DBD files for Perl

am 29.09.2002 04:45:51 von Richard Newell

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-Mysql-modules@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
> richard@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-l inux/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
>
> --------------

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1935@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: trouble making DBD files for Perl

am 29.09.2002 04:45:51 von Richard Newell

Re: trouble making DBD files for Perl

am 05.10.2002 22:49:36 von Jochen Wiedmann

Zitiere Richard Newell :

> LD_RUN_PATH="/usr/lib/mysql:/usr/lib/gcc-lib/i586-mandrake-l inux/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

Sigh. I really wonder whether people will start to read
the installation docs at any time? See

http://www.cpan.org/authors/id/J/JW/JWIED/DBD-mysql-2.1020.r eadme

This gives you some really useful hints, in particular that
you need to install the zlib-devel RPM.

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1948@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: trouble making DBD files for Perl

am 05.10.2002 22:49:36 von Jochen Wiedmann