To: jeff...@hotmail.com Subject: Misc Question, US, n/a Date: 17 Feb 2003 11:12:06 -0000

The following information was sent by you to MySQL AB:

Name: jeffry wallace

Email address: jeff...@hotmail.com

Phone number: 908-281-0276

Company: n/a

Position/Title:

Type of interest: for educational use

State or province: New Jersey

Country: US

Support contract: no

Enter Your Questions, Comments, Feedback or Your Message here:

i am trying to get the PERL mysql DBD installed on my home linux machine. when i create the makefile and compile it i recieve an error.

/usr/bin/ld: cannot find -lz

i believe this has something to do with the compression library. and i recieve subsequent errors based upon my removing this option.

undefined symbol: uncompress at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.

what must i do to correct this problem?

see exactly what i did below.

thanks

====================

[root@wallace Msql-Mysql-modules-1.2216]# 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! [n] WARNING: CAPI is not a known parameter. WARNING: PL_FILES takes a hash reference not a array reference. Please inform the author. Warning: prerequisite Data::ShowTable 0 not found. Note (probably harmless): No library found for -lgz Using DBI 1.32 installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI Writing Makefile for DBD::mysql Writing Makefile for Msql-Mysql-modules [root@wallace Msql-Mysql-modules-1.2216]# make make[1]: Entering directory `/root/Msql-Mysql-modules-1.2216/mysql' gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0416\" -DXS_VERSION=\"2.0416\" -fpic "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DDBD_MYSQL dbdimp.c gcc -c -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI -I/usr/lib/perl5/5.8.0/i386-linux-thread-multi -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -march=i386 -mcpu=i686 -DVERSION=\"2.0416\" -DXS_VERSION=\"2.0416\" -fpic "-I/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE" -DDBD_MYSQL mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f ../blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH="/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/3.2" gcc -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql -o ../blib/arch/auto/DBD/mysql/mysql.so /usr/lib/mysql/libmysqlclient.a -lm -lz -L/usr/lib/gcc-lib/i386-redhat-linux/3.2 -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 `/root/Msql-Mysql-modules-1.2216/mysql' make: *** [subdirs] Error 2 [root@wallace Msql-Mysql-modules-1.2216]#

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

if i remove the -lk option from the make file the makefile succeeds but i recieve errors when i run with the compiled modlule. running tests after that fail

[root@wallace Msql-Mysql-modules-1.2216]# make test make[1]: Entering directory `/root/Msql-Mysql-modules-1.2216/mysql' make[1]: Leaving directory `/root/Msql-Mysql-modules-1.2216/mysql' make[1]: Entering directory `/root/Msql-Mysql-modules-1.2216/mysql' PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, '../blib/lib', '../blib/arch')" t/*.t t/00base...........install_driver(mysql) failed: Can't load

'/root/Msql-Mysql-modules-1.2216/mysql/../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:

/root/Msql-Mysql-modules-1.2216/mysql/../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229. at (eval 1) line 3

Newsletter: 1