Route66 software

Trying to install the stuff. After running the perl script per the
following:

http://www.wizardskeep.org/mainhall/tutor/route66.html altho I'm using
Mandrake 8 distro.


How I set up Route 66 using Mandrake 7.1

First, change directory to your /usr/local/src directory

[root@simba jrk]# cd /usr/local/src

Copy the route66 file from the CD into the current working directory:

[root@simba src]# cp /mnt/cdrom/Route-66/route66* ./
[root@simba src]# ls
route66-0.5.3.tar.gz*

First, unzip the route66 file:
[root@simba src]# gunzip route66-0.5.3.tar.gz

Now, untar it:
[root@simba src]# tar -xvf route66-0.5.3.tar

Change directory into the route66 directory:
[root@simba src]# cd route66-0.5.3

Copy the MySql stuff into the current directory:
[root@simba route66-0.5.3]# cp /mnt/cdrom/Route-66/Msql-Mysql-modules/*
./
[root@simba route66-0.5.3]# ls
Msql-Mysql-modules-1.2215.tar.gz*

Unzip the Mysql file:
[root@simba route66-0.5.3]# gunzip Msql-Mysql-modules-1.2215.tar.gz
[root@simba route66-0.5.3]# ls
Msql-Mysql-modules-1.2215.tar*

Untar the Mysql file:
[root@simba route66-0.5.3]# tar -xvf Msql-Mysql-modules-1.2215.tar

Run the makefile through perl. Select MySQL only.
[root@timon Msql-Mysql-modules-1.2215]# 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]

Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr]

Which database should I use for testing the MySQL drivers? [test]

On which host is database test running (hostname, ip address or
host:port) [localhost]

User name for connecting to database test? [undef] root
Password for connecting to database test? [undef]

Creating files for MySQL ....................
Checking if your kit is complete...
Looks good
Note (probably harmless): No library found for -lgz
Using DBI 1.13 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

Run make
[root@timon Msql-Mysql-modules-1.2215]# make    <<<<<<<<<<< this is
where I start to break
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/Msql-Mysql-modules
mkdir blib/lib/auto
mkdir blib/lib/auto/Msql-Mysql-modules
mkdir blib/man1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i386-linux \
-I/usr/lib/perl5/5.6.0 -Ilib -MExtUtils::PerlPP \
-e ppp "dbd/dbimon.in" "dbimon" "lib/DBD/mysql/Install/Config.pm"
/usr/bin/pod2text mysql/lib/DBD/mysql.pm >README
make[1]: Entering directory
`/usr/local/src/route66/Msql-Mysql-modules-1.2215/my
sql'
mkdir ../blib/lib/DBD
mkdir ../blib/arch/auto/DBD
mkdir ../blib/arch/auto/DBD/mysql
mkdir ../blib/lib/auto/DBD
mkdir ../blib/lib/auto/DBD/mysql
mkdir ../blib/man3
cp lib/DBD/mysql.pm ../blib/lib/DBD/mysql.pm
cp lib/Bundle/DBD/mysql.pm ../blib/lib/Bundle/DBD/mysql.pm
cp lib/Mysql/Statement.pm ../blib/lib/Mysql/Statement.pm
cp lib/Mysql.pm ../blib/lib/Mysql.pm
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 -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O3 -fomit-frame-pointer -fno-exceptions
-fno-rtti -pipe -s
-mpentium -mcpu=pent ium -march=pentium -ffast-math
-fexpensive-optimizations -DVERSION=\"2.0415\ " -DXS_VERSION=\"2.0415\"
-fpic
-I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYS QL dbdimp.c
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" <
/usr/lib/perl5/site_perl/5.6.0/i386-l inux/auto/DBI/Driver.xst >
mysql.xsi
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0
/usr/lib/ perl5/5.6.0/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.6.0/ExtUtils/typemap mysq l.xs >
mysql.xsc && mv mysql.xsc mysql.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 -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O3 -fomit-frame-pointer -fno-exceptions
-fno-rtti -pipe -s
-mpentium -mcpu=pent ium -march=pentium -ffast-math
-fexpensive-optimizations -DVERSION=\"2.0415\ " -DXS_VERSION=\"2.0415\"
-fpic
-I/usr/lib/perl5/5.6.0/i386-linux/CORE -DDBD_MYS QL mysql.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs

HERE"S WHAT I SHOULD GET:
LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i586-mandrake-linux/2
.95.3" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared
-L/usr/local/lib dbdi
mp.o mysql.o -L/usr/lib/mysql -L/usr/lib/mysql -lmysqlclient -lm -lz
-L/usr/l ib/gcc-lib/i586-mandrake-linux/2.95.3 -lgcc
chmod 755 ../blib/arch/auto/DBD/mysql/mysql.so
cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs
Manifying ../blib/man3/DBD::mysql.3
Manifying ../blib/man3/Bundle::DBD::mysql.3
Manifying ../blib/man3/Mysql.3
make[1]: Leaving directory
`/usr/local/src/route66/Msql-Mysql-modules-1.2215/mys
ql'
mkdir blib/script
cp dbimon blib/script/dbimon
/usr/bin/perl -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0
-MExtUtil
s::MakeMaker -e "MY->fixin(shift)" blib/script/dbimon
Manifying blib/man1/dbimon.1

Here's what I got after the second try:

[root@rotor Msql-Mysql-modules-1.2215]# make
make[1]: Entering directory
`/usr/local/src/route66-0.5.3/Msql-Mysql-modules-1.2215/mysql'
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
`/usr/local/src/route66-0.5.3/Msql-Mysql-modules-1.2215/mysql'
make: *** [subdirs] Error 2

I'm too dumb to find the -lz flag. Not in the ld man page. Or is that
the -lar flag that is really being used? Haven't used this in many
moons, even decades!! Am I missing something I should have installed?

pete